圖書館管理系統(tǒng)畢業(yè)設(shè)計(jì)外文翻譯

1、Access2000關(guān)系型數(shù)據(jù)庫(kù)原文：Access2000 Relational DatabaseMembers of the Office family, the people of Access2000 understanding, often limited in its interface, for the database management function is still at the establishment table, data entry, Use Form guide Reporting Wizard, Data Access2000Page Wizard and

2、 other simple applications. In fact, the functions of the Access2000 is a powerful and beyond your imagination. It is released from Microsoft Access2000functions since most comprehensive, Windows and the Internet more closely with the database software, is a very powerful, and simple, easy-to-use da

3、tabase management system (DBMS that the database storage, processing and management system. Access2000 relational database management system is Microsoft Office Public automation software as an integral part. It can effectively organize, manage and share the information in the database, and database

4、 information with the Web together. Through the Internet to share database information with the basic platform. With the development of information technology. Information technology platform is often the choice of establishing or re-establishing applications of the key issues, the database is part

5、of the need to make a choice as a key platform.Access2000 as a relational database management system small and medium- sized information management system ideal development environment, the current database in the field, there are more and more people use. It is a powerful database management system

6、 MIS development tools.The database is stored together a collection of relevant data, the data is structured. The database is a data storage and data operation of the tool. The role of the database is to organize and present information, in short, the database is a collection of information. Compute

7、r database can be divided into two categories: non-relational database (flat- and relational database (relational.Relational database contains a number of data tables, databases containing various parts of the terminology, like records. Relational database management system has the technological dom

8、inance of the mainstream, but this traditional database management systems by using two-dimensional data model, and there are inherent limitations and restrictions. It difficult to adapt to today's rapidly changing business needs, and the development of new technologies.With the rapid IT develop

9、ment, data processing, not only in quantity increasingly demanding, but also the quality of increasingly high demand, database management data has been a fundamental change. This change to the database technology has brought tremendous challenges, Object database management is no longer limited to t

10、ext data and other simple data types. And the description and the need to preserve a lot of complex unstructured multimedia data, and the relationship between the data. Furthermore, in the wake of popular websites surge in the number of visits to its own database storage mechanism, a large number of

11、 concurrent users to the demand, storage efficiency in the use of space, and data integrity and security, and other aspects of higher demand. These are not traditional relational database, the use of a simple two-dimensional table structure of the meet.Access2000 is the relational database developme

12、nt tools, database pooling information for the inquiry, Storage and retrieval. Access2000 the advantage lies in its ability to use data map or custom windows to collect information. Data provides a map similar to the Excel spreadsheet, database transparent. In addition, the Access2000 allows creatio

13、n of custom statements to print or export the information in the database.Access2000 also provides a data repository. Can use desktop database file to extend the database file at the network file server and other network users to share databases? Access2000 is a relational database tools, database d

14、evelopment, is the most common databases. As noted above, as an Access2000 database development possesses many advantages, in a data packet available at the same time facilitate the desktop database and a powerful relational database functions.In Access2000, with the user database access permissions

15、 are two types: Explicit and implicit powers authority. Explicit authority is granted a direct user account competence,which is the exclusive use of user accounts, has nothing to do with other users. Implicit authority is delegated the authority group account, the user added to the group was given b

16、y the group's mandate. If a user with the same time these two powers, the right set of user security database for a visit, then He had such authority is the intersection of the two powers. The Access20002000database, the group of users access to the database and the authority set up work, comple

17、ted only through the administrator. Set up the authority include: "Open/Run", read design, design modifications, management, read data, update data insertion and deletion of data.Relational database management system inherent limitations in the following three aspects:Relational database u

18、sed in the two-dimensional table data model, can not effectively handle the majority of business applications, Typical of multidimensional data. Its inevitable result is that in complex ways, the interaction of the dramatic increase in the number of tables, not very good but also to provide realisti

19、c simulation of the data model.Relational database as they use more data model, which might lead to a massive storage space and wasting a lot of increase, and cause the system to respond to the declining performance. Furthermore, the data in reality, there are many types of relational database is no

20、t well addressed.Static applications such as report generation, and the design of the relational database management system after no response and efficient business processing for the optimization process. The result is often some relational database products, in the GUI and Web Services processing,

21、 not achieved the desired results. Unless additional hardware investment, but it does not resolve the fundamental problem.Relations with the two-dimensional database table data model can deal with the majority of business application of a typical multi- dimensional data, but the results are often th

22、e establishment and use of a large amount of data forms, it is difficult to establish a simulation of real-world data model. And the need for data output statements when they, in turn, would have dispersed the large number of two-dimensional data tables. Reuse indexing technology linking the table i

23、n order to find all the necessary data, this, in turn, is bound toaffect the use of the response speed. Database various databases is currently the most important and the most popular database.Relational database system to support the relational model of database systems, relationships between data

24、model structure, relations operation and integrity constraint set is composed of three parts.Office Access2000 is the Chinese version of one of the components. Access2000 to the previous version, the Access2000 is not only a more friendly interface, but their functions have also been strengthened, e

25、specially network function was improved, Internet Access2000 so that it more closely connected.Access2000 is a small and medium-sized database management system, easy to use, powerful, and other databases have a good interface.Access2000 through powerful tool, users can facilitate the use and manage

26、ment of databases, such as the creation and editing of data tables, design and the use of various tools inquiries query operation, design and the use of windows, production and printing statements, the design and use of Acer, the design and use of such Web pages. May also be used in Visual Basic6.0A

27、(Visual Basic6.0 for ApplicationAdvanced Application Development procedures.Access2000 is a complete database application development tool, the user can design, modify, View a record of the basic data table; in the table data for various screen and query operation; design and use of Window to achiev

28、e data and operations; Data tables can design various print statements; design and use of Acer, a series of tables for specific operations.Access2000 with a strong operational guide, and to provide users with a rich database table basic template. Users only need a simple database operations can be e

29、stablished by using the basic form, Form and statements.In Access2000, can be set, to alter the basic correlation between the tables, thus achieving a number of related tables in the relationship between the inquiries. Access2000-The operation can achieve automation, the operator is more simple and

30、efficient. Access2000 to enhance the network function, users can complete the ease of web publication.Access2000 can not only deal with their own database files. Could also address some other database management software system established by the database files, the ability todistinguish Base. FoxBA

31、SE, FoxPro, Paradox, database formats, such as documents, and support the open database connectivity standard (ODBC SQL. Access2000 with workstations, servers or databases on the mainframe database interconnected and can be used for building client/server applications of the workstation. And other r

32、elational database management systems, Access2000 have the following advantages: Storage single document.Access2000 of a database file contains the database of all data tables, query, windows, all statements, and other data manageable.Support for long file names and file name can be added to the bla

33、nk, documents easily comprehensible search.Powerful network function can be transmitted through the network data.Easy to use, you do not need to understand the programming language can easily design and development of database applications.Can handle a variety of data and information, such as text f

34、iles and other databases of documents.lubenv Access2000 IEEE Software J. 卷次：14刊期：5 September 2007 .譯文： Access2000 關(guān)系型數(shù)據(jù)庫(kù) 在 Office 的家族成員當(dāng)中，人們最初對(duì)于 Access2000 的了解，往往只是局限在它 的操作界面中，對(duì)于數(shù)據(jù)庫(kù)的管理功能仍然只是停留在建立數(shù)據(jù)表、數(shù)據(jù)的輸入、使用 窗體向?qū)А⑹褂脠?bào)表向?qū)?、?shù)據(jù)訪問(wèn)的向?qū)У纫恍┫鄬?duì)比較簡(jiǎn)單的應(yīng)用上面。其實(shí) Access2000 的功能非常強(qiáng)大，而且超乎你的想象。它是微軟自發(fā)布 Access 以來(lái)功能最 全面、與 W

35、indows 和 Internet 結(jié)合最密切的數(shù)據(jù)庫(kù)軟件，是一個(gè)功能非常強(qiáng)大，且簡(jiǎn)單 易用的數(shù)據(jù)庫(kù)管理系統(tǒng)（DBMS） ，就是對(duì)數(shù)據(jù)庫(kù)進(jìn)行存儲(chǔ)、管理和處理的系統(tǒng)。 Access2000 數(shù)據(jù)庫(kù)管理系統(tǒng)是 Microsoft 公司的 Office 辦公自動(dòng)化軟件的一個(gè)組成 部分。它可以有效地組織、管理和共享數(shù)據(jù)庫(kù)的信息，并且將數(shù)據(jù)庫(kù)的信息與 Web 結(jié) 合在一起，并通過(guò) Internet 共享數(shù)據(jù)信息提供了基礎(chǔ)的平臺(tái)。伴隨著信息技術(shù)的發(fā)展， 信息技術(shù)平臺(tái)的選擇往往是建立或者是重新建立應(yīng)用系統(tǒng)的重要問(wèn)題，而數(shù)據(jù)庫(kù)正是它 們要做出選擇的關(guān)鍵平臺(tái)。Access2000 是一種關(guān)系型數(shù)據(jù)庫(kù)管理系統(tǒng)，是

36、中小型企業(yè)管 理系統(tǒng)的最理想的開發(fā)環(huán)境，在當(dāng)前的數(shù)據(jù)庫(kù)領(lǐng)域，已經(jīng)有越來(lái)越多的人在使用。它是 一個(gè)功能非常強(qiáng)大的數(shù)據(jù)庫(kù)管理系統(tǒng)的 MIS 系統(tǒng)開發(fā)工具。 數(shù)據(jù)庫(kù)是存儲(chǔ)在一起的相關(guān) 數(shù)據(jù)的集合，這些數(shù)據(jù)是結(jié)構(gòu)化的，數(shù)據(jù)庫(kù)是一種用來(lái)存儲(chǔ)數(shù)據(jù)并且對(duì)數(shù)據(jù)進(jìn)行管理的 工具。數(shù)據(jù)庫(kù)的作用就在于組織和表達(dá)信息，簡(jiǎn)單來(lái)說(shuō)，數(shù)據(jù)庫(kù)就是不同信息的集合。 計(jì)算機(jī)的數(shù)據(jù)庫(kù)可以分為兩大類：非關(guān)系型的數(shù)據(jù)庫(kù)（ flat-file ）和關(guān)系型的數(shù)據(jù)庫(kù) （relational） 。 關(guān)系型的數(shù)據(jù)庫(kù)中包含了多個(gè)數(shù)據(jù)表的信息， 數(shù)據(jù)庫(kù)含有各個(gè)不同部分的 術(shù)語(yǔ)，像記錄等。關(guān)系型的數(shù)據(jù)庫(kù)管理系統(tǒng)曾經(jīng)處于技術(shù)主流而且獨(dú)領(lǐng)風(fēng)騷，但是這種

37、傳統(tǒng)的數(shù)據(jù)庫(kù)管理系統(tǒng)因?yàn)椴捎昧藘删S的數(shù)據(jù)模型，而且存在著本身固有的約束和限 制。難以適應(yīng)現(xiàn)在迅速變化的業(yè)務(wù)需求，以及新技術(shù)的發(fā)展。信息技術(shù)的飛速發(fā)展，數(shù) 據(jù)處理不僅在數(shù)量上需要越來(lái)越大，而且在質(zhì)量上也要求越來(lái)越高，數(shù)據(jù)庫(kù)所管理的數(shù) 據(jù)已經(jīng)發(fā)生了根本上的變化。這樣一個(gè)變化給數(shù)據(jù)庫(kù)技術(shù)帶來(lái)了巨大的挑戰(zhàn)，數(shù)據(jù)庫(kù)管 理的對(duì)象已經(jīng)不再局限于文本數(shù)據(jù)等一些簡(jiǎn)單的數(shù)據(jù)類型，而是需要描述和保存大量多 媒體非結(jié)構(gòu)化的復(fù)雜數(shù)據(jù)，以及數(shù)據(jù)之間的關(guān)系。 另外，隨著熱門網(wǎng)站訪問(wèn)數(shù)量的逐 漸增加，對(duì)數(shù)據(jù)庫(kù)本身的存儲(chǔ)機(jī)制、大量并發(fā)用戶的使用需求、存儲(chǔ)空間的使用效率、 以及數(shù)據(jù)的完整性和安全性等方面都提出了更高的要求。而這些

38、都不是傳統(tǒng)關(guān)系數(shù)據(jù)庫(kù) 中，用二維表簡(jiǎn)單結(jié)構(gòu)就可以滿足需要的。 Access2000 就是關(guān)系型的數(shù)據(jù)庫(kù)開發(fā)工具，數(shù)據(jù)庫(kù)能夠匯集各種信息以供查詢、 存儲(chǔ)和檢索。Access2000 的優(yōu)點(diǎn)在于它能使用數(shù)據(jù)表示圖或自定義窗體來(lái)收集信息。 數(shù)據(jù)表示圖提供了一種類似于 Excel 的電子表格，可以使數(shù)據(jù)一目了然。而且， Access2000 允許創(chuàng)建自定義的報(bào)表用于打印或者是輸出數(shù)據(jù)庫(kù)中的信息。 Access2000 也 提供了數(shù)據(jù)儲(chǔ)存庫(kù)，可以使用桌面數(shù)據(jù)庫(kù)文件把數(shù)據(jù)庫(kù)文件置于網(wǎng)絡(luò)文件服務(wù)器中，與 其他網(wǎng)絡(luò)用戶共享數(shù)據(jù)庫(kù)。Access2000 是一種關(guān)系型的數(shù)據(jù)庫(kù)工具，關(guān)系數(shù)據(jù)庫(kù)是已 經(jīng)開發(fā)的最常用的

39、數(shù)據(jù)庫(kù)之一。綜上所述，Access2000 作為關(guān)系型的數(shù)據(jù)庫(kù)開發(fā)具備了 很多優(yōu)點(diǎn)， 可以在一個(gè)數(shù)據(jù)包中同時(shí)擁有桌面數(shù)據(jù)庫(kù)的便利和關(guān)系型的數(shù)據(jù)庫(kù)的強(qiáng)大功 能。在 Access2000 中，用戶具有的數(shù)據(jù)庫(kù)訪問(wèn)權(quán)限有兩種類型：顯式權(quán)限和隱式權(quán)限。 顯式權(quán)限是指直接賦予某一用戶賬號(hào)的權(quán)限， 這是該用戶賬號(hào)專用的， 與其他用戶無(wú)關(guān)。 隱式權(quán)限是指授予組賬號(hào)的權(quán)限，即用戶加入到該組中的同時(shí)被賦予的組的權(quán)限。假如 一個(gè)用戶同時(shí)具有上面兩種權(quán)限， 當(dāng)該用戶對(duì)設(shè)置了安全性的數(shù)據(jù)庫(kù)進(jìn)行訪問(wèn)時(shí)， 那么， 他所具有的權(quán)限就是兩種權(quán)限的交集。在 Access 數(shù)據(jù)庫(kù)中，對(duì)組和用戶訪問(wèn)數(shù)據(jù)庫(kù)權(quán) 限的設(shè)置工作，只能通過(guò)

40、管理員來(lái)完成。設(shè)置的權(quán)限包括： “打開 /運(yùn)行” ，讀取設(shè)計(jì)、 修改設(shè)計(jì)、管理、讀取數(shù)據(jù)，更新數(shù)據(jù)、插入數(shù)據(jù)和刪除數(shù)據(jù)。 關(guān)系型數(shù)據(jù)庫(kù)管理系統(tǒng)本身固有的局限性，表現(xiàn)在以下三個(gè)方面： 關(guān)系數(shù)據(jù)庫(kù)所采用的兩維表數(shù)據(jù)模型，不能有效地處理在大多數(shù)事務(wù)處理應(yīng)用中， 典型存在的多維數(shù)據(jù)。其不可避免的結(jié)果是，在復(fù)雜方式下，相互作用表的數(shù)量激增， 而且還不能很好地提供模擬現(xiàn)實(shí)數(shù)據(jù)關(guān)系的模型。關(guān)系型的數(shù)據(jù)庫(kù)由于它所用數(shù)據(jù)模型 比較多，還可能會(huì)造成存儲(chǔ)空間的海量增加和大量的浪費(fèi)，并且還會(huì)導(dǎo)致系統(tǒng)的響應(yīng)性 能不斷的下降。 并且， 在現(xiàn)實(shí)數(shù)據(jù)中， 有許多類型是關(guān)系型的數(shù)據(jù)庫(kù)不能較好地處理的。 偽靜態(tài)的應(yīng)用例如報(bào)表的生成，而設(shè)計(jì)的關(guān)系型數(shù)據(jù)庫(kù)管理系統(tǒng)，并沒(méi)有經(jīng)過(guò)針對(duì)高效 事務(wù)處理而進(jìn)行的優(yōu)化過(guò)程。其結(jié)果通常是某些關(guān)系型數(shù)據(jù)庫(kù)產(chǎn)品，在對(duì) GUI 和 Web 的事務(wù)處理過(guò)程中，沒(méi)有達(dá)到預(yù)期的效果。除非增加更多的硬件投資，但這不能從根本 上解決問(wèn)題