計算機(jī)系畢業(yè)設(shè)計文獻(xiàn)翻譯--淺析access2007關(guān)系型數(shù)據(jù)庫

1、<p>　　淺析Access2007關(guān)系型數(shù)據(jù)庫</p><p><b>　　英文譯文</b></p><p>　　淺析Access 2007關(guān)系型數(shù)據(jù)庫</p><p>　　Paul Morrison</p><p>　　Access 2007關(guān)系型數(shù)據(jù)庫管理系統(tǒng)是Microsoft公司的Office辦公自動

2、化軟件的一個組成部分。它可以有效地組織、管理和共享數(shù)據(jù)庫的信息，并將數(shù)據(jù)庫信息與Web結(jié)合在一起并通過Internet共享數(shù)據(jù)庫信息提供了基礎(chǔ)平臺。隨著信息技術(shù)的發(fā)展，信息技術(shù)平臺的選擇常常是建立或重新建立應(yīng)用系統(tǒng)時的關(guān)鍵問題，而數(shù)據(jù)庫正是其中需要做出選擇的關(guān)鍵平臺。Access2007作為一種關(guān)系型數(shù)據(jù)庫管理系統(tǒng)，是中小型信息管理系統(tǒng)的理想開發(fā)環(huán)境，在當(dāng)前數(shù)據(jù)庫領(lǐng)域，已有越來越多的人使用。它是一個功能強(qiáng)大的數(shù)據(jù)庫管理系統(tǒng)的MIS系統(tǒng)開

3、發(fā)工具。</p><p>　　Access2007 就是關(guān)系數(shù)據(jù)庫開發(fā)工具，數(shù)據(jù)庫能匯集各種信息以供查詢、存儲和檢索。Access2007 的優(yōu)點(diǎn)在于它能使用數(shù)據(jù)表示圖或自定義窗體收集信息。數(shù)據(jù)表示圖提供了一種類似于 Excel 的電子表格，可以使數(shù)據(jù)庫一目了然。另外，Access2007允許創(chuàng)建自定義報表用于打印或輸出數(shù)據(jù)庫中的信息</p><p>　　關(guān)鍵詞：關(guān)系型數(shù)據(jù)，Access

4、2007</p><p><b>　　譯文：</b></p><p>　　在Office的家族成員當(dāng)中，人們最初對于Access2007的了解，往往只是局限在它的操作界面中，對于數(shù)據(jù)庫的管理功能仍然只是停留在建立數(shù)據(jù)表、數(shù)據(jù)的輸入、使用窗體向?qū)?、使用報表向?qū)А?shù)據(jù)訪問的向?qū)У纫恍┫鄬Ρ容^簡單的應(yīng)用上面。其實(shí)Access2007的功能非常強(qiáng)大，而且超乎你的想象。它是微軟

5、自發(fā)布Access以來功能最全面、與Windows和Internet結(jié)合最密切的數(shù)據(jù)庫軟件，是一個功能非常強(qiáng)大，且簡單易用的數(shù)據(jù)庫管理系統(tǒng)（DBMS），就是對數(shù)據(jù)庫進(jìn)行存儲、管理和處理的系統(tǒng)。</p><p>　　Access2007數(shù)據(jù)庫管理系統(tǒng)是Microsoft公司的Office辦公自動化軟件的一個組成部分。它可以有效地組織、管理和共享數(shù)據(jù)庫的信息，并且將數(shù)據(jù)庫的信息與Web結(jié)合在一起，并通過Interne

6、t共享數(shù)據(jù)信息提供了基礎(chǔ)的平臺。伴隨著信息技術(shù)的發(fā)展，信息技術(shù)平臺的選擇往往是建立或者是重新建立應(yīng)用系統(tǒng)的重要問題，而數(shù)據(jù)庫正是它們要做出選擇的關(guān)鍵平臺。Access2007是一種關(guān)系型數(shù)據(jù)庫管理系統(tǒng)，是中小型企業(yè)管理系統(tǒng)的最理想的開發(fā)環(huán)境，在當(dāng)前的數(shù)據(jù)庫領(lǐng)域，已經(jīng)有越來越多的人在使用。它是一個功能非常強(qiáng)大的數(shù)據(jù)庫管理系統(tǒng)的MIS系統(tǒng)開發(fā)工具。數(shù)據(jù)庫是存儲在一起的相關(guān)數(shù)據(jù)的集合，這些數(shù)據(jù)是結(jié)構(gòu)化的，數(shù)據(jù)庫是一種用來存儲數(shù)據(jù)并且對數(shù)據(jù)進(jìn)行

7、管理的工具。數(shù)據(jù)庫的作用就在于組織和表達(dá)信息，簡單來說，數(shù)據(jù)庫就是不同信息的集合。計算機(jī)的數(shù)據(jù)庫可以分為兩大類：非關(guān)系型的數(shù)據(jù)庫（flat-file）和關(guān)系型的數(shù)據(jù)庫（relational）。關(guān)系型的數(shù)據(jù)庫中包含了多個數(shù)據(jù)表的信息，數(shù)據(jù)庫含有各個不同部分的術(shù)語，像記錄等。關(guān)系型的數(shù)據(jù)庫管理系統(tǒng)曾經(jīng)處于技術(shù)主流而且獨(dú)領(lǐng)風(fēng)騷，但是這種傳統(tǒng)的數(shù)據(jù)庫管理系統(tǒng)因?yàn)椴?lt;/p><p>　　Access2007 就是關(guān)系型的數(shù)

8、據(jù)庫開發(fā)工具，數(shù)據(jù)庫能夠匯集各種信息以供查詢、存儲和檢索。Access2007 的優(yōu)點(diǎn)在于它能使用數(shù)據(jù)表示圖或自定義窗體來收集信息。數(shù)據(jù)表示圖提供了一種類似于 Excel 的電子表格，可以使數(shù)據(jù)一目了然。Access2007也提供了數(shù)據(jù)儲存庫，可以使用桌面數(shù)據(jù)庫文件把數(shù)據(jù)庫文件置于網(wǎng)絡(luò)文件服務(wù)器中，與其他網(wǎng)絡(luò)用戶共享數(shù)據(jù)庫。Access2007 是一種關(guān)系型的數(shù)據(jù)庫工具，關(guān)系數(shù)據(jù)庫是已經(jīng)開發(fā)的最常用的數(shù)據(jù)庫之一。綜上所述，Access2

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

10、限就是兩種權(quán)限的交集。在Access數(shù)據(jù)庫中，對組和用戶訪問數(shù)據(jù)庫權(quán)限的設(shè)置工作，只</p><p>　　關(guān)系型數(shù)據(jù)庫管理系統(tǒng)本身固有的局限性，表現(xiàn)在以下三個方面： </p><p>　　關(guān)系數(shù)據(jù)庫所采用的兩維表數(shù)據(jù)模型，不能有效地處理在大多數(shù)事務(wù)處理應(yīng)用中，典型存在的多維數(shù)據(jù)。其不可避免的結(jié)果是，在復(fù)雜方式下，相互作用表的數(shù)量激增，而且還不能很好地提供模擬現(xiàn)實(shí)數(shù)據(jù)關(guān)系的模型。關(guān)系型的數(shù)據(jù)

11、庫由于它所用數(shù)據(jù)模型比較多，還可能會造成存儲空間的海量增加和大量的浪費(fèi)，并且還會導(dǎo)致系統(tǒng)的響應(yīng)性能不斷的下降。并且，在現(xiàn)實(shí)數(shù)據(jù)中，有許多類型是關(guān)系型的數(shù)據(jù)庫不能較好地處理的。偽靜態(tài)的應(yīng)用例如報表的生成，而設(shè)計的關(guān)系型數(shù)據(jù)庫管理系統(tǒng)，并沒有經(jīng)過針對高效事務(wù)處理而進(jìn)行的優(yōu)化過程。其結(jié)果通常是某些關(guān)系型數(shù)據(jù)庫產(chǎn)品，在對GUI和Web的事務(wù)處理過程中，沒有達(dá)到預(yù)期的效果。除非增加更多的硬件投資，但這不能從根本上解決問題。 </p>

12、<p>　　用關(guān)系型的數(shù)據(jù)庫的兩維表數(shù)據(jù)模型，可以處理在大多數(shù)事務(wù)處理應(yīng)用中的典型多維數(shù)據(jù)，但它的結(jié)果通常是建立和使用大量的數(shù)據(jù)表格，仍然很難建立起能夠模擬現(xiàn)實(shí)世界的數(shù)據(jù)模型。并且在數(shù)據(jù)需要作報表輸出的時候，又要反過來將已經(jīng)分散設(shè)置的大量的兩維數(shù)據(jù)表，再利用索引的技術(shù)進(jìn)行表的連接后，才能找到我們所需要的數(shù)據(jù)，而這又將會影響到應(yīng)用系統(tǒng)的響應(yīng)速度。 關(guān)系型的數(shù)據(jù)庫在目前是各類數(shù)據(jù)庫中最重要、最流行的數(shù)據(jù)庫。關(guān)系型的數(shù)據(jù)庫系統(tǒng)支持

13、關(guān)系模型的數(shù)據(jù)庫系統(tǒng)，關(guān)系模型由關(guān)系數(shù)據(jù)結(jié)構(gòu)、關(guān)系操作集合和完整性約束三部分組成。Access2007是Office2007中文版的組件之一。與以前的Access版本相比，Access2007不僅界面更加友好，而且功能也有了加強(qiáng)，尤其是網(wǎng)絡(luò)功能有明顯的提高，使Access2007與互聯(lián)網(wǎng)的結(jié)合更加密切。</p><p>　　Access2007是一個中、小型數(shù)據(jù)庫管理系統(tǒng)，使用非常方便、功能非常強(qiáng)大，與其它的數(shù)據(jù)

14、庫有良好的接口。通過Access2007功能強(qiáng)大的工具，用戶可以方便的使用和管理數(shù)據(jù)庫，如創(chuàng)建和編輯數(shù)據(jù)表、設(shè)計和使用各種查詢工具進(jìn)行查詢操作、設(shè)計和使用窗體、制作和打印報表、設(shè)計和使用宏設(shè)計和使用Web頁等。還可使用Visual Basic6.0A（Visual Basic6.0 for Application）開發(fā)高級應(yīng)用程序。Access2007具有完整的數(shù)據(jù)庫應(yīng)用開發(fā)工具，用戶可以方便的設(shè)計、修改、瀏覽一條記錄數(shù)據(jù)的基本表；可以

15、在表數(shù)據(jù)中進(jìn)行各種篩選和查詢操作；可以設(shè)計和使用各種窗體以實(shí)現(xiàn)數(shù)據(jù)顯示和操作；可以根據(jù)表數(shù)據(jù)設(shè)計打印各種報表；可以設(shè)計和使用宏，對表進(jìn)行一系列特定的操作。Access2007內(nèi)有強(qiáng)大的操作向?qū)В瑸橛脩籼峁┝素S富的數(shù)據(jù)庫基本表模板。用戶只需要簡單的操作就可建立數(shù)據(jù)庫中所使用的各種基本表、窗體和報表。在Access2007中，可以設(shè)定、修改基本表之間的關(guān)聯(lián)，從而實(shí)現(xiàn)在多個相關(guān)表之間的關(guān)系查詢。 Access2007中的宏可以實(shí)現(xiàn)操作的自動化

16、，使操作更加簡單、快捷。 Ac</p><p>　　與其它的關(guān)系型數(shù)據(jù)庫管理系統(tǒng)相比，Access2007具有以下優(yōu)點(diǎn)：</p><p>　　存儲文件單一。Access2007的一個數(shù)據(jù)庫文件中包含了該數(shù)據(jù)庫中的全部數(shù)據(jù)表、查詢、窗體、報表等所有數(shù)據(jù)，易于管理。</p><p>　　支持長文件名，并且可以在文件名里面加空格，使文件便于理解、查找。具有強(qiáng)大的網(wǎng)絡(luò)功能，

17、可以通過網(wǎng)絡(luò)來傳送數(shù)據(jù)。使用簡單，用戶無需要了解編程語言，就可以輕松地設(shè)計和開發(fā)數(shù)據(jù)庫應(yīng)用程序。還可以處理多種數(shù)據(jù)信息，比如文本文件和其它數(shù)據(jù)庫文件。</p><p>　　摘自：保羅·莫里森.數(shù)據(jù)庫安全[M].英國：薩姆斯出版社出版，2002</p><p><b>　　附:英文原文</b></p><p>　　Access 2007

18、 Relational Database</p><p>　　Paul Morrison</p><p>　　Members of the Office family, the people of Access2007 understanding, often limited in its interface, for the database management function is

19、 still at the establishment table, data entry, Use Form guide Reporting Wizard, Data Access2007Page Wizard and other simple applications. In fact, the functions of the Access2007 is a powerful and beyond your imagination

20、. It is released from Microsoft Access2007functions since most comprehensive, Windows and the Internet more closely with the database softw</p><p>　　Access2007 as a relational database management system smal

21、l 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 MIS development tools. &

22、lt;/p><p>　　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 pres

23、ent information, in short, the database is a collection of information. Computer database can be divided into two categories: non-relational database (flat-) and relational database (relational). </p><p>　　R

24、elational database contains a number of data tables, databases containing various parts of the terminology, like records. Relational database management system has the technological dominance of the mainstream, but this

25、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

26、of new technologies. </p><p>　　With the rapid IT development, data processing, not only in quantity increasingly demanding, but also the quality of increasingly high demand, database management data has been

27、 a fundamental change. This change to the database technology has brought tremendous challenges, Object database management is no longer limited to text data and other simple data types. And the description and the need

28、to preserve a lot of complex unstructured multimedia data, and the relationship between the data. Furthe</p><p>　　Access2007 is the relational database development tools, database pooling information for the

29、 inquiry, Storage and retrieval. Access2007 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 addit

30、ion, the Access2007 allows creation of custom statements to print or export the information in the database. </p><p>　　Access2007 also provides a data repository. Can use desktop database file to extend the

31、database file at the network file server and other network users to share databases? Access2007 is a relational database tools, database development, is the most common databases. As noted above, as an Access2007 databas

32、e development possesses many advantages, in a data packet available at the same time facilitate the desktop database and a powerful relational database functions.</p><p>　　In Access2007, with the user databa

33、se access permissions 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

34、. Implicit authority is delegated the authority group account, the user added to the group was given by the group's mandate. If a user with the same time these two powers, the right set of user security database for

35、a visit, then He had such aut</p><p>　　Relational database management system inherent limitations in the following three aspects: </p><p>　　Relational database used in the two-dimensional table

36、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 tab

37、les, not very good but also to provide realistic simulation of the data model. </p><p>　　Relational database as they use more data model, which might lead to a massive storage space and wasting a lot of incr

38、ease, and cause the system to respond to the declining performance. Furthermore, the data in reality, there are many types of relational database is not well addressed. </p><p>　　Static applications such as

39、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 t

40、he GUI and Web Services processing, not achieved the desired results. Unless additional hardware investment, but it does not resolve the fundamental problem.</p><p>　　Relations with the two-dimensional datab

41、ase table data model can deal with the majority of business application of a typical multi- dimensional data, but the results are often the establishment and use of a large amount of data forms, it is difficult to establ

42、ish 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 in

43、order to find all th</p><p>　　Relational database system to support the relational model of database systems, relationships between data model structure, relations operation and integrity constraint set is c

44、omposed of three parts. </p><p>　　Office Access2007 is the Chinese version of one of the components. Access2007 to the previous version, the Access2007 is not only a more friendly interface, but their functi

45、ons have also been strengthened, especially network function was improved, Internet Access2007 so that it more closely connected.</p><p>　　Access2007 is a small and medium-sized database management system, e

46、asy to use, powerful, and other databases have a good interface. </p><p>　　Access2007 through powerful tool, users can facilitate the use and management of databases, such as the creation and editing of data

47、 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 use

48、d in Visual Basic6.0A(Visual Basic6.0 for Application)Advanced Application Development procedures. </p><p>　　Access2007 is a complete database application development tool, the user can design, modify, View

49、a record of the basic data table; in the table data for various screen and query operation; design and use of Window to achieve data and operations; Data tables can design various print statements; design and use of Acer

50、, a series of tables for specific operations.</p><p>　　Access2007 with a strong operational guide, and to provide users with a rich database table basic template. Users only need a simple database operations

51、 can be established by using the basic form, Form and statements. </p><p>　　In Access2007, can be set, to alter the basic correlation between the tables, thus achieving a number of related tables in the rela

52、tionship between the inquiries. Access2007-The operation can achieve automation, the operator is more simple and efficient. Access2007 to enhance the network function, users can complete the ease of web publication. <

53、/p><p>　　Access2007 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 to distinguish Base. FoxBASE

54、, FoxPro, Paradox, database formats, such as documents, and support the open database connectivity standard (ODBC) SQL. Access2007 with workstations, servers or databases on the mainframe database interconnected and can

55、be used for building client/server applications of the workstation. And other r</p><p>　　Access2007 of a database file contains the database of all data tables, query, windows, all statements, and other data

56、 manageable. </p><p>　　Support for long file names and file name can be added to the blank, documents easily comprehensible search. </p><p>　　Powerful network function can be transmitted through

57、 the network data. </p><p>　　Easy to use, you do not need to understand the programming language can easily design and development of database applications. </p><p>　　Can handle a variety of dat