關(guān)于數(shù)據(jù)庫外文翻譯2篇

1、<p><b>　　原文：</b></p><p>　　Structure of the Relational database</p><p>　　—《Database System Concepts》Part1: Relational Databases</p><p>　　The relational model is the

2、basis for any relational database management system (RDBMS).A relational model has three core components: a collection of objects or relations, operators that act on the objects or relations, and data integrity methods.

3、In other words, it has a place to store the data, a way to create and retrieve the data, and a way to make sure that the data is logically consistent.</p><p>　　A relational database uses relations, or two-di

4、mensional tables, to store the information needed to support a business. Let's go over the basic components of a traditional relational database system and look at how a relational database is designed. Once you have

5、 a solid understanding of what rows, columns, tables, and relationships are, you'll be well on your way to leveraging the power of a relational database.</p><p>　　Tables, Row, and Columns</p><

6、p>　　A table in a relational database, alternatively known as a relation, is a two-dimensional structure used to hold related information. A database consists of one or more related tables.</p><p>　　Note:

7、Don't confuse a relation with relationships. A relation is essentially a table, and a relationship is a way to correlate, join, or associate two tables.</p><p>　　A row in a table is a collection or insta

8、nce of one thing, such as one employee or one line item on an invoice. A column contains all the information of a single type, and the piece of data at the intersection of a row and a column, a field, is the smallest pie

9、ce of information that can be retrieved with the database's query language. For example, a table with information about employees might have a column called LAST_NAME that contains all of the employees' last name

10、s. Data is retrieved from a</p><p>　　Primary Keys, Datatypes, and Foreign Keys</p><p>　　The examples throughout this article will focus on the hypothetical work of Scott Smith, database develope

11、r and entrepreneur. He just started a new widget company and wants to implement a few of the basic business functions using the relational database to manage his Human Resources (HR) department.</p><p>　　Rel

12、ation: A two-dimensional structure used to hold related information, also known as a table.</p><p>　　Note: Most of Scott's employees were hired away from one of his previous employers, some of whom have

13、over 20 years of experience in the field. As a hiring incentive, Scott has agreed to keep the new employees' original hire date in the new database.</p><p>　　Row:A group of one or more data elements in a

14、 database table that describes a person, place, or thing.</p><p>　　Column:The component of a database table that contains all of the data of the same name and type across all rows.</p><p>　　You&

15、#39;ll learn about database design in the following sections, but let's assume for the moment that the majority of the database design is completed and some tables need to be implemented. Scott creates the EMP table

16、to hold the basic employee information, and it looks something like this:</p><p>　　Notice that some fields in the Commission (COMM) and Manager (MGR) columns do not contain a value; they are blank. A relatio

17、nal database can enforce the rule that fields in a column may or may not be empty. In this case, it makes sense for an employee who is not in the Sales department to have a blank Commission field. It also makes sense for

18、 the president of the company to have a blank Manager field, since that employee doesn't report to anyone.</p><p>　　Field:The smallest piece of information that can be retrieved by the database query lan

19、guage. A field is found at the intersection of a row and a column in a database table.</p><p>　　On the other hand, none of the fields in the Employee Number (EMPNO) column are blank. The company always wants

20、 to assign an employee number to an employee, and that number must be different for each employee. One of the features of a relational database is that it can ensure that a value is entered into this column and that it i

21、s unique. The EMPNO column, in this case, is the primary key of the table.</p><p>　　Primary Key:A column (or columns) in a table that makes the row in the table distinguishable from every other row in the sa

22、me table.</p><p>　　Notice the different datatypes that are stored in the EMP table: numeric values, character or alphabetic values, and date values.</p><p>　　As you might suspect, the DEPTNO col

23、umn contains the department number for the employee. But how do you know what department name is associated with what number? Scott created the DEPT table to hold the descriptions for the department codes in the EMP tabl

24、e. </p><p>　　The DEPTNO column in the EMP table contains the same values as the DEPTNO column in the DEPT table. In this case, the DEPTNO column in the EMP table is considered a foreign key to the same colum

25、n in the DEPT table.</p><p>　　A foreign key enforces the concept of referential integrity in a relational database. The concept of referential integrity not only prevents an invalid department number from be

26、ing inserted into the EMP table, but it also prevents a row in the DEPT table from being deleted if there are employees still assigned to that department.</p><p>　　Foreign Key:A column (or columns) in a tabl

27、e that draws its values from a primary or unique key column in another table. A foreign key assists in ensuring the data integrity of a table. Referential IntegrityA method employed by a relational database system that e

28、nforces one-to-many relationships between tables.</p><p>　　Data Modeling</p><p>　　Before Scott created the actual tables in the database, he went through a design process known as data modeling.

29、 In this process, the developer conceptualizes and documents all the tables for the database. One of the common methods for modeling a database is called ERA, which stands for entities, relationships, and attributes. The

30、 database designer uses an application that can maintain entities, their attributes, and their relationships. In general, an entity corresponds to a table in the databa</p><p>　　Data Modeling:A process of de

31、fining the entities, attributes, and relationships between the entities in preparation for creating the physical database.</p><p>　　The data-modeling process involves defining the entities, defining the rela

32、tionships between those entities, and then defining the attributes for each of the entities. Once a cycle is complete, it is repeated as many times as necessary to ensure that the designer is capturing what is important

33、enough to go into the database. Let's take a closer look at each step in the data-modeling process.</p><p>　　Defining the Entities</p><p>　　First, the designer identifies all of the entities

34、 within the scope of the database application.The entities are the persons, places, or things that are important to the organization and need to be tracked in the database. Entities will most likely translate neatly to d

35、atabase tables. For example, for the first version of Scott's widget company database, he identifies four entities: employees, departments, salary grades, and bonuses. These will become the EMP, DEPT, SALGRADE, and B

36、ONUS tables.</p><p>　　Defining the Relationships Between Entities</p><p>　　Once the entities are defined, the designer can proceed with defining how each of the entities is related. Often, the d

37、esigner will pair each entity with every other entity and ask, "Is there a relationship between these two entities?" Some relationships are obvious; some are not.</p><p>　　In the widget company dat

38、abase, there is most likely a relationship between EMP and DEPT, but depending on the business rules, it is unlikely that the DEPT and SALGRADE entities are related. If the business rules were to restrict certain salary

39、grades to certain departments, there would most likely be a new entity that defines the relationship between salary grades and departments. This entity would be known as an associative or intersection table and would con

40、tain the valid combinations of sala</p><p>　　Associative Table:A database table that stores the valid combinations of rows from two other tables and usually enforces a business rule. An associative table res

41、olves a many-to-many relationship.</p><p>　　In general, there are three types of relationships in a relational database:</p><p>　　One-to-many The most common type of relationship is one-to-many.

42、 This means that for each occurrence in a given entity, the parent entity, there may be one or more occurrences in a second entity, the child entity, to which it is related. For example, in the widget company database, t

43、he DEPT entity is a parent entity, and for each department, there could be one or more employees associated with that department. The relationship between DEPT and EMP is one-to-many.</p><p>　　One-to-one In

44、a one-to-one relationship, a row in a table is related to only one or none of the rows in a second table. This relationship type is often used for subtyping. For example, an EMPLOYEE table may hold the information common

45、 to all employees, while the FULLTIME, PARTTIME, and CONTRACTOR tables hold information unique to full-time employees, part-time employees, and contractors, respectively. These entities would be considered subtypes of an

46、 EMPLOYEE and maintain a one-to-one relationsh</p><p>　　Many-to-many In a many-to-many relationship, one row of a table may be related to many rows of another table, and vice versa. Usually, when this relati

47、onship is implemented in the database, a third entity is defined as an intersection table to contain the associations between the two entities in the relationship. For example, in a database used for school class enrollm

48、ent, the STUDENT table has a many-to-many relationship with the CLASS table—one student may take one or more classes, and a given</p><p>　　Once the designer has defined the entity relationships, the next ste

49、p is to assign the attributes to each entity. This is physically implemented using columns, as shown here for the SALGRADE table as derived from the salary grade entity.</p><p>　　After the entities, relation

50、ships, and attributes have been defined, the designer may iterate the data modeling many more times. When reviewing relationships, new entities may be discovered. For example, when discussing the widget inventory table a

51、nd its relationship to a customer order, the need for a shipping restrictions table may arise.</p><p>　　Once the design process is complete, the physical database tables may be created. Logical database desi

52、gn sessions should not involve physical implementation issues, but once the design has gone through an iteration or two, it's the DBA's job to bring the designers "down to earth." As a result, the desig

53、n may need to be revisited to balance the ideal database implementation versus the realities of budgets and schedules.</p><p><b>　　譯文：</b></p><p><b>　　關(guān)系數(shù)據(jù)庫的結(jié)構(gòu)</b></p&

54、gt;<p>　　—《數(shù)據(jù)庫系統(tǒng)結(jié)構(gòu)》第一章：關(guān)系數(shù)據(jù)庫</p><p>　　關(guān)系模型是任何關(guān)系數(shù)據(jù)庫管理系統(tǒng)（RDBMS）的基礎(chǔ)。一個關(guān)系模型有二個核心組件：對象或關(guān)系的集合，作用于對象或關(guān)系上的操作，以及數(shù)據(jù)完整性規(guī)則。換句話說，關(guān)系數(shù)據(jù)庫有一個存儲數(shù)據(jù)的地方，一種創(chuàng)建和檢索數(shù)據(jù)的方法，以及一種確認(rèn)數(shù)據(jù)的邏輯一致性的方法。</p><p>　　一個關(guān)系數(shù)據(jù)庫使用關(guān)系或二維

55、表來存儲支持某個事物所需的信息。讓我們了解一下一個傳統(tǒng)的關(guān)系數(shù)據(jù)庫系統(tǒng)的基本組件并目學(xué)習(xí)如何設(shè)計一個關(guān)系數(shù)據(jù)庫。一旦你對于行、列、表和關(guān)聯(lián)是什么有了深刻理解，你就能夠充分發(fā)揮關(guān)系數(shù)據(jù)庫的強大功能。</p><p><b>　　表，行和列</b></p><p>　　在關(guān)系數(shù)據(jù)庫中，一個表（或者說一個關(guān)系）是一個用于保存相關(guān)信息的二維結(jié)構(gòu)。一個數(shù)據(jù)庫由一個或者多個相關(guān)聯(lián)

56、的表組成。</p><p>　　注意：不要混淆了關(guān)系和關(guān)聯(lián)。一個關(guān)系實際上是一個表，而一個關(guān)聯(lián)指的是一種連接、結(jié)合或聯(lián)合兩個表的方式。</p><p>　　表中的一行是一種事物的集合或?qū)嵗?，比如一個員工或發(fā)票上的一項。表中的一列包含了一類信息；而且行列交叉點上的數(shù)據(jù)，字段，即是能夠用數(shù)據(jù)庫查詢語言檢索到的最小片信息。舉個例子來說，一個員工信息表可能有一個“名字”列，列中就包含所有員工的名字

57、。數(shù)據(jù)是通過對行、列進行過濾而從表中檢索出來的。</p><p>　　主碼、數(shù)據(jù)類型和外碼</p><p>　　本篇文章均以假設(shè)的斯科特·史密斯的工廠為例，他是數(shù)據(jù)庫的建立者和企業(yè)的主辦人。他剛開辦了一個飾品公司并目想要使用關(guān)系數(shù)據(jù)庫的幾項基本功能來管理人力資源部門。</p><p>　　關(guān)系：用來保存相關(guān)信息的一個二維結(jié)構(gòu)（也就是表）。</p>

58、;<p>　　注意：大多數(shù)斯科特的雇員都是雇自過去的從業(yè)者，他們中有些人在這個領(lǐng)域己經(jīng)有20年的經(jīng)驗了。出于雇用的目的，斯科特同意在新數(shù)據(jù)庫中維持新進員工最初的雇傭日期。</p><p>　　行：在一個數(shù)據(jù)庫表中的一組單數(shù)據(jù)或多數(shù)據(jù)元素，用于描述一個人、地方或事物。</p><p>　　列：列是數(shù)據(jù)庫表的組件，它包含所有行中同名和同類型的所有數(shù)據(jù)。</p>&l

59、t;p>　　你會在下面章節(jié)學(xué)到如何設(shè)計數(shù)據(jù)庫，現(xiàn)在讓我們假設(shè)數(shù)據(jù)庫大部分己經(jīng)設(shè)計完成并且有一些表需要被執(zhí)行。斯科特創(chuàng)建了EMP表來保存基本的員工信息，就像這樣：</p><p>　　你可能注意到傭金列和管理人列中有一些單元格中沒有值；它們是空值。一個關(guān)系數(shù)據(jù)庫能夠規(guī)定列中的一個單元格是否為空。如此，可以明確那些非銷售部的員工傭金單元為空。同樣也明確了公司董事長的管理人單元為空，因為這個員工不需要向任何人匯報

60、工作。</p><p>　　單元格：是數(shù)據(jù)庫查詢語言所能夠檢索到的最小片信息。一個單元格就是一個數(shù)據(jù)庫表的行和列交叉形成的。</p><p>　　另一方面，沒有哪個員工的員工編號單元為空。公司總是希望為每個員工分配一個員工號，并目這個號碼必須是每個員工都不同的。關(guān)系數(shù)據(jù)庫的一個特性能夠確定某列的鍵入值必須為單值。如此，員工編號列便是這個表的主碼。</p><p>　

61、　主碼：主碼即是表中的一列（或多列），使每一行能夠區(qū)別于同表中的其他行。</p><p>　　留意一下EMP表中存儲的不同數(shù)據(jù)類型：數(shù)值型，字符型或字母型，以及日期型。</p><p>　　如你所想，部門成員列保存的是員工所在部門的編號。但是你如何知道哪個部門名稱對應(yīng)哪個部門編號呢？斯科特建立了DEPT表來具體描述EMP表中提到的部門編號的情況。</p><p>　

62、　EMP表中的部門編號列同DEPT表中的部門編號列有著相同的值。既然如此，EMP表中的部門編號列便被看作是與DEPT表中相同列對應(yīng)的外碼。</p><p>　　外碼加強了關(guān)系數(shù)據(jù)庫中參考完整性的概念。參考完整性的概念不只可以阻止無效的部門編號被插入EMP表中，而且在某部門仍有員工的情況下，可以防止DEPT表中該部門的信息被刪除。</p><p>　　外碼：表中的一列（或多列），它的值來自于

63、其他表的主碼列或單值列。一個外碼有助于確定表中數(shù)據(jù)的完整性。</p><p>　　參考完整性：是關(guān)系數(shù)據(jù)庫用來加強表間一對多關(guān)聯(lián)的一種方式。</p><p><b>　　數(shù)據(jù)建模</b></p><p>　　在斯科特于數(shù)據(jù)庫中創(chuàng)建真實表之前，他要經(jīng)過一個稱作數(shù)據(jù)建模的過程。在這個過程中，數(shù)據(jù)庫創(chuàng)建者定義和填寫數(shù)據(jù)庫中所有表。有一種為數(shù)據(jù)庫建模的

64、方式叫作ERA,它可以表示出實體、實體間的關(guān)聯(lián)和實體的屬性。數(shù)據(jù)庫設(shè)計者使用一個能夠支持實體、實體屬性和實體間關(guān)聯(lián)的應(yīng)用程序。通常，一個實體對應(yīng)數(shù)據(jù)庫中的一個表，而實體的屬性對應(yīng)于表中的列。</p><p>　　數(shù)據(jù)建模：一個定義實體、實體屬性和實體間關(guān)聯(lián)的過程，從而為建立物理數(shù)據(jù)庫做準(zhǔn)備。</p><p>　　數(shù)據(jù)建模過程包括定義實體、定義實體間關(guān)聯(lián)以及定義每個實體的屬性的過程。一旦一個

65、周期完成，就需要不斷重復(fù)直到設(shè)計者抓住了重點，足以開始建立數(shù)據(jù)庫。讓我們進一步了解為數(shù)據(jù)庫建模過程的步驟。</p><p><b>　　定義實體</b></p><p>　　首先，設(shè)計者確定數(shù)據(jù)庫應(yīng)用程序范圍內(nèi)的所有實體。實體是人、地方或事物，它們對于整個團體是重要的且需要被記錄在數(shù)據(jù)庫中。實體將被巧妙的轉(zhuǎn)化為數(shù)據(jù)表。比如，在第一版斯科特飾品公司數(shù)據(jù)庫中，他定義了四個

66、實體：員工、部門、工資水平和獎金。它們將稱為EMP（員工）表，DEPT（部門）表，SALGRADE（工資水平）表和BONUS（獎金）表。</p><p><b>　　定義實體間的關(guān)聯(lián)</b></p><p>　　一旦定義了實體，設(shè)計者就能夠繼續(xù)定義每個實體間是如何關(guān)聯(lián)的。通常，設(shè)計者通常將每個實體同其他實體配對，并目考慮：“兩者之間是否存在關(guān)聯(lián)呢？”實體間的某些關(guān)聯(lián)是

67、明顯的，某些不是。</p><p>　　在飾品公司數(shù)據(jù)庫中，員工實體和部門實體間極可能存在關(guān)聯(lián)，而依據(jù)事物間的關(guān)系原則，部門實體跟工資水平實體間似乎就沒有關(guān)聯(lián)了。如果事物間的關(guān)系原則是用來約束某個部門的工資水平的，就可能需要一個新的實體來說明工資水平和部門之間的關(guān)聯(lián)。這個實體被稱作關(guān)系表或交表，其中包含工資水平和部門之間的有效聯(lián)合。</p><p>　　關(guān)系表：是一個數(shù)據(jù)庫表，其中保存著另

68、外兩個表的行（記錄）間的有效結(jié)合，并且通常強調(diào)了事物間的關(guān)系原則。關(guān)聯(lián)表處理的是一個多對多關(guān)聯(lián)。</p><p>　　通常，關(guān)系數(shù)據(jù)庫間有二種關(guān)聯(lián)方式：</p><p>　　一對多關(guān)聯(lián)：最常見的關(guān)聯(lián)是一對多關(guān)聯(lián)。意思是對于每個給出的現(xiàn)有實體（即父實體）都有一個或多個現(xiàn)有的另一個實體（即子實體）與之相關(guān)聯(lián)。舉個例子來說，在飾品公司數(shù)據(jù)庫中，部門實體是一個父實體，而每個部門中，都有一個或多個員

69、工屬于該部門。這樣，部門實體和員工實體間的關(guān)聯(lián)就是一對多關(guān)聯(lián)。</p><p>　　一對一關(guān)聯(lián)：在一個一對一關(guān)聯(lián)中，表中的一行只關(guān)聯(lián)另一個表中的一行甚至0行。這種關(guān)聯(lián)類型通常用于子類型數(shù)據(jù)中。例如，一個員工表可能保存了所有員工的信息，而全職表、兼職表和承包人表則分別保存全職員工、兼職員工和承包人的信息。這些實體被認(rèn)為是員工表的子表，并目同員工表維持一對一關(guān)聯(lián)。這種關(guān)系不像一對多關(guān)聯(lián)那么常見，因為如果一個實體與另一

70、個實體總有對應(yīng)行，在大多數(shù)情況下，兩個實體中的屬性只在一個實體內(nèi)出現(xiàn)就可以了。</p><p>　　多對多關(guān)聯(lián)：在多對多關(guān)聯(lián)中，表的一行可能對應(yīng)另一個表的許多行，反之亦然。通常，當(dāng)這些關(guān)聯(lián)在數(shù)據(jù)庫中被執(zhí)行時，往往再定義第三個實體用來保存前兩個實體間的所有關(guān)聯(lián)。例如，在一個學(xué)籍注冊數(shù)據(jù)庫中，學(xué)生表與班級表之間有一個多對多關(guān)聯(lián)——一個學(xué)生可能聽一門或多門課程，并目一個班級也可能有一個或多個學(xué)生。而學(xué)生_班級關(guān)系表中就

71、包含了學(xué)生和班級之間的關(guān)系，以表明哪個學(xué)生在哪個班。</p><p><b>　　指定實體屬性</b></p><p>　　一旦設(shè)計者定義了實體間關(guān)聯(lián)，下一步就是去指定每個實體的屬性。這是實現(xiàn)列的使用，如右圖所示由工資水平實體所建立的工資水平表。</p><p>　　重復(fù)步驟：我們?nèi)匀辉谠?lt;/p><p>　　在定義了

72、實體、關(guān)聯(lián)以及屬性之后，設(shè)計者往往要多重復(fù)幾次數(shù)據(jù)建模過程。當(dāng)我們在回顧關(guān)聯(lián)時，就會發(fā)現(xiàn)需要建立新的實體。比如，當(dāng)討論飾品庫存表和與它相關(guān)的客戶訂單時，就會發(fā)現(xiàn)需要制定一個送貨約束表。</p><p>　　一旦設(shè)計過程完成，下面將要建立實際的數(shù)據(jù)庫表。邏輯數(shù)據(jù)庫的設(shè)計過程不會牽涉實際執(zhí)行中的問題。然而，一旦設(shè)計進入到實際的運作，數(shù)據(jù)庫管理員就會很快讓設(shè)計者從理想回到現(xiàn)實中來。結(jié)果，設(shè)計就可能需要再次構(gòu)想以求得理想

73、的數(shù)據(jù)庫存運行與預(yù)算和進度之間的平衡。</p><p>　　Database Management System</p><p>　　Source：Database and Network Journal Author：David Anderson</p><p>　　You know that a data is a collection of logicall

74、y related data elements that may be structured in various ways to meet the multiple processing and retrieval needs of organizations and individuals. There’s nothing new about data base-early ones were chiseled in stone,

75、penned on scrolls, and written on index cards. But now database are commonly recorded on magnetically media, and computer programs are required to perform the necessary storage and retrieval operations.</p><p&

76、gt;　　The system software package that handles the difficult tasks associated with created, accessing, and maintaining database records is in a DBMS package establish an interface between the database itself and the users

77、 of the database. (These users may be applications programmers, managers and others with information needs, and various OS programmers.)</p><p>　　A DBMS can organize, process, and present selected data eleme

78、nts from the database. This capability enables decision makers to search. Probe, and query data contents in order to extract answers to nonrecurring and unplanned questions that aren’t available in regular reports. These

79、 questions might initially be vague and/or poorly defined, but people can “browse” through the database until they have the needed information. In short, the DBMS will “manage” the stored data items and assemble the nee&

80、lt;/p><p>　　Special, direct, and other file processing approaches ate used to organize and structure data in single files. But a DBMS is able to integrate data elements from several files to answer specific use

81、r inquiries fir information. This means that the DBMS is able to structure and tie together the logically related data from several large files.</p><p>　　Logical structures. Identifying these logical relatio

82、nships is a job of the data administrator. A data definition language is used for this purpose. The DBMS may then</p><p>　　Employ one of the following logical structuring techniques during storage access, an

83、d retrieval operation: list structures, hierarchical (tree) structures, and network structures, relational structures.</p><p>　　1. List structures. In this logical approach, records are linked together by th

84、e use of pointers. A pointer is a data item in one record that identifies the storage location of another logically related record. Records in a customer master file, for example, will contain the name and address of eac

85、h customer, and an account number identifies each record in this file. During an accounting period, a customer may maintain an invoice file to reflect these transactions. A list structure could be used</p><p&g

86、t;　　2. Hierarchical structures. In this logical approach, data units are structured in multiple levels that graphically resemble an “upside down” tree with the root at the top and the branches formed below, there’s a sup

87、erior-subordinate relationship in a hierarchical structure. Below the single-root data component are subordinate elements (or one) has only a single owner. Thus, as we see in figure, a customer owns an invoice, and the i

88、nvoice has subordinate items. The branches in a tree structure a</p><p>　　3. Network structures. Unlike the tree approach, which dose not permit the connection of branches, the network structure permits the

89、connection of the nodes in a multidirectional manner. Thus, each node may have several owners and may, in turn, own any number of other data units. Data, management software permits the extraction of the needed informati

90、on from such a structure by beginning with any record in a file.</p><p>　　4. Relational structures. A relational structure is made up of many tables. The data are stored in the form of “relations” in these t

91、ables. For example, relation tables could be established to link a college course with the instructor of the course, and with the location of the in order to find the name of the instructor and the location of the Englis

92、h class, the course/instructor relation is searched to get the name, and the course/location relation is searched to get the class location. Many o</p><p>　　5. Physical structure. People visualize or structu

93、re data in logical ways for there</p><p>　　Own purposes. Thus, records R1 and R2 may always be logically linked and processed in sequence in one particular application. However, in a computer system it’s qui

94、te possible that these records that are logically contiguous in one application are not physically stored together. Rather, the physical structure of the I/O and storage devices techniques used, but also on the different

95、 logical relationships that users may assign to the data found on R1 and R2. For example, R1 and R2 may be records o</p><p>　　During the past five years, Microsoft has promoted Data Access Objects (DAO), and

96、 then Remote Data Objects (RDO), and now ActiveX Data Objects (ADO) as the primary data access technology for Visual Basic developers. It seems that Microsoft has been pushing a different data access technology with each

97、 successive version of Microsoft Visual Studio. Today, new versions of ADO are available on Microsoft's Web site and ship with other products and technologies, such as Microsoft Windows 2000, Microso</p><p

98、>　　One of the goals of ADO is to simplify data access. ADO is built upon some fairly complex technologies—OLE DB and ODBC (open database connectivity)—and is designed to allow you to programmatically access and modify

99、 data stored in a wide variety of databases. This broad reach is a departure from previous data access technologies. For the sake of comparison, let's take a quick glance at ADO's predecessors: DAO and RDO.</p

100、><p>　　Data Access Objects</p><p>　　DAO was originally designed to interact with Microsoft Access databases. Although you can use DAO to access SQL Server and Oracle databases, many developers comp

101、lain about DAO's performance with these large database systems. Others complain that DAO doesn't permit programmers to access some of the richer, more powerful features of SQL Server and Oracle, such as output an