數(shù)據(jù)庫(kù)英文翻譯

1、.第 - 15 - 頁(yè) 共 15 頁(yè)databaseDatabase is in accordance with the data structure to organize, storage and management of data warehouse, which arises from fifty years ago, with the dating of information technology and the development of the market, especially since the 1990s, data management is no longer

2、merely data storage and management, and transformed into user needs of the various data management way. The database has a variety of types, from the most simple storage have various data form to can be carried out mass data storage of large database systems are obtained in each aspect has extensive

3、 application. The birth of data management Database's history can be traced back to fifty years ago, when the data management is very simple. Through a lot of classification, comparison and form rendering machine running millions of punched CARDS for data processing, its operation results on pap

4、er printed or punched card made new. While the data management is punched card for all these physical storage and handling. However, 1 9 5 1 year Remington Rand corporation (Remington Rand Inc.) an enzyme called Univac I computer launched a a second can input hundreds of recording tape drives, which

5、 has caused data management revolution. 1956 IBM produce the first disk drives - the RAMAC Model 305. This drives have 50 blanks, each blanks diameter is 2 feet, can store 5 MB of data. The biggest advantage is use disk can be randomly access data, and punched CARDS and tape can order access data.Da

6、tabase system appears in the 1960s the bud. When computer began to widely used in data management, the sharing of data put forward more and more high demand. The traditional file system already cannot satisfy people's needs. Manage and share data can unify the database management system (DBMS) c

7、ame into being. The data model is the core and foundation of database system, various DBMS software are based on a data model. So usually in accordance with the characteristics of the data model and the traditional database system into mesh database, the hierarchy database and relational database th

8、ree types. Structured query language (SQL) commercial database systems require a query language that is more user friendly. In this chapter,we study SQL, themost inuential commercially marketed query language, SQL. SQL uses a combination of relational-algebra and relational-calculus constructs.Altho

9、ugh we refer to the SQL language as a “query language,” it can do much more than just query a database. It can dene the structure of the data, modify data in the database, and specify security constraints.It is not our intention to provide a complete users guide for SQL.Rather,we present SQLs fundam

10、ental constructs and concepts. Individual implementations of SQL may differ in details, or may support only a subset of the full language.2.1 BackgroundIBM developed the original version of SQL at its San Jose Research Laboratory (nowthe Almaden Research Center). IBM implemented the language, origin

11、ally called Sequel, as part of the System R project in the early 1970s. The Sequel language hasevolved since then, and its name has changed to SQL (Structured Query Language).Many products now support the SQL language. SQL has clearly established itself asthe standard relational-database language.In

12、 1986, the American National Standards Institute (ANSI) and the International Organization for Standardization (ISO) published an SQL standard, called SQL-86.IBM published its own corporate SQL standard, the Systems Application Architecture Database Interface (SAA-SQL) in 1987. ANSI published an ext

13、ended standard forSQL, SQL-89, in 1989. The next version of the standard was SQL-92 standard, and the most recent version is SQL:1999. The bibliographic notes provide references to these standards.Chapter 4 SQLIn this chapter, we present a survey of SQL, based mainly on the widely implemented SQL-92

14、 standard. The SQL:1999 standard is a superset of the SQL-92 standard;we cover some features of SQL:1999 in this chapter, and provide more detailed coverage in Chapter 9. Many database systems support some of the new constructs in SQL:1999, although currently no database system supports all the new

15、constructs. You should also be aware that some database systems do not even support all the features of SQL-92, and that many databases provide nonstandard features that we donot cover here.The SQL language has several parts: Data-denition language (DDL). The SQL DDL provides commands for dening rel

16、ation schemas, deleting relations, and modifying relation schemas. Interactive data-manipulation language (DML). The SQL DML includes a query language based on both the relational algebra and the tuple relational calculus. It includes also commands to insert tuples into, delete tuples from,and modif

17、y tuples in the database. View denition.The SQL DDL includes commands for dening views. Transaction control. SQL includes commands for specifying the beginning and ending of transactions. Embedded SQL and dynamic SQL. Embedded and dynamic SQL dene how SQL statements can be embedded within general-pu

18、rpose programming languages, such as C, C+, Java, PL/I, Cobol, Pascal, and Fortran. Integrity.The SQL DDL includes commands for specifying integrity constraints that the data stored in the database must satisfy. Updates that violate integrity constraints are disallowed. Authorization.The SQL DDL inc

19、ludes commands for specifying access rights to relations and views.In this chapter, we cover the DML and the basic DDL features of SQL.Wealso briey outline embedded and dynamic SQL, including the ODBC and JDBC standards for interacting with a database from programs written in the C and Java language

20、s.SQL features supporting integrity and authorization are described in Chapter 6,while Chapter 9 outlines object-oriented extensions to SQL.The enterprise that we use in the examples in this chapter, and later chapters, is abanking enterprise with the following relation schemas:Branch-schema = (bran

21、ch-name, branch-city, assets)Customer-schema = (customer-name, customer-street, customer-city)Loan-schema = (loan-number, branch-name, amount)Borrower-schema = (customer-name, loan-number)Account-schema = (account-number, branch-name, balance)Depositor-schema = (customer-name, account-number)Note th

22、at in this chapter, as elsewhere in the text, we use hyphenated names for schema, relations, and attributes for ease of reading. In actual SQL systems, however,hyphens are not valid parts of a name (they are treated as the minus operator). A simple way of translating the names we use to valid SQL na

23、mes is to replace all hyphens by the underscore symbol (“ ”). For example, we use branch name in place ofbranch-name.2.2 Basic StructureA relational database consists of a collection of relations, each of which is assigned a unique name. Each relation has a structure similar to that presented in Cha

24、pter 3.SQL allows the use of null values to indicate that the value either is unknown or does not exist. It allows a user to specify which attributes cannot be assigned null values,as we shall discuss in Section 4.11.The basic structure of an SQL expression consists of three clauses: select, from,an

25、d where. The select clause corresponds to the projection operation of the relational algebra. It is used to list the attributes desired in the result of a query. The from clause corresponds to the Cartesian-product operation of the relational algebra. It lists the relations to be scanned in the eval

26、uation of the expression. The where clause corresponds to the selection predicate of the relational algebra. It consists of a predicate involving attributes of the relations that appear in the from clause.That the term select has different meaning in SQL than in the relational algebra is an unfortun

27、ate historical fact. We emphasize the different interpretations here to minimize potential confusion.A typical SQL query has the formselect A1,A2,.,Anfrom r1,r2,.,rmwhere PEach Ai represents an attribute, and each ri arelation. P is a predicate. The query isequivalent to the relational-algebra expre

28、ssionA1,A2,.,An(P (r1 × r2 × ··· × rm)If the where clause is omitted, the predicate P is true. However, unlike the result of a relational-algebra expression, the result of the SQL query may containmultiple copies of some tuples; we shall return to this issue in Section

29、4.2.8.SQL forms the Cartesian product of the relations named in the from clause,performs a relational-algebra selection using the where clause predicate, and then projects the result onto the attributes of the select clause. In practice, SQL may convert the expression into an equivalent form that ca

30、n be processed more efciently.However, we shall defer concerns about efciency to Chapters 13 and 14.In 1974, IBM's Ray Boyce and Don Chamberlin will Codd relational database 12 rule mathematical definition with simple keyword grammar expression comes out, put forward the landmark Structured Quer

31、y Language (SQL) Language. SQL language features include inquiry, manipulation, definition and control, is a comprehensive, general relational database language, and at the same time, a highly the process of language, only request users do not need pointed out how do pointed out. SQL integration ach

32、ieved database of all life cycle operation. SQL database provides and relations interact with the method, it can work with standard programming language. The date of the produce, SQL language became the touchstone of inspection relational database, and SQL standard every variation of guiding the rel

33、ational database product development direction. However, until the twentieth century, the mid 1970s to the theory of relation in commercial database Oracle and SQL used in DB2. In 1986, the SQL as ANSI relational database language American standards, that same year announced the standard SQL text. C

34、urrently SQL standard has three versions. ANSIX3135 - is defined as the basic SQL Database Language - 89, "Enhancement" SQL. A ANS89 , generally called SQL - 89. SQL - 89 defines the schema definition, data operation and the transaction. SQL - 89 and subsequent ANSIX3168-1989, "Langua

35、ge - Embedded SQL Database, constituted the first generation of SQL standard. ANSIX3135-1992 ANS92 describes a enhancements of SQL, now called SQL - 92 standards. SQL - 92 including mode operation, dynamic creation and SQL statements dynamic executive, network environment support enhancement. Upon c

36、ompletion of SQL - 92 ANSI and ISO standard, they started SQL3 standards development cooperation. The main features SQL3 abstract data types support, for the new generation of object relational database provides standard. The nature of database data 1. Data integrity: database is a unit or an applic

37、ation field of general data processing system, he storage is to belong to enterprise and business departments, organizations and individuals set of related data. Database data from a global view, he according to certain data model organization, description and storage. Based on the structure of data

38、 between natural relation, thus can provide all the necessary access route, and data no longer deal with a certain applications, but for total organization, with a whole structural features. 2. Data sharing: database data is for many users sharing their information and the establishment, got rid of

39、the specific procedures restrictions and restraint. Different users can use the database according to their respective usage the data; Multiple users can also Shared database data resource, i.e., different users can also access database in the same data. Data sharing each user not only meets the req

40、uirements of information, but also meet the various users of information communication between the requirements. Object-oriented database Along with the development of information technology and the market, people found relational database system, while technology is mature, but its limitations is o

41、bvious: it can be a very good treatment of so-called "form of data", but of dominating the more and more complex appear helpless type of data. Since the 1990s, technology has been studying and seek new database system. But in what is the development direction of the new database system, in

42、dustry once is quite confused. The influence of agitation by technology at the time, for quite some time, people put a lot of energy spent on research "object-oriented database system (object oriented database)" or simply as "OO database system". What is worth mentioning, the Uni

43、ted States Stonebraker professor proposed object-oriented RDS theory once favored by industry. And in Stonebraker himself Informix spend big money was then appointed technology director always. However, several years of development, spatio-temporal object-oriented relational database system product

44、market development situation is not good. Theoretically perfect sex didn't bring market warm response. The main reason of success, the main design thought database products with new database system is an attempt to replace the existing database system. This for many has been using database syste

45、m for years and accumulated the massive job data, especially big customer for customers, is unable to withstand the conversion between old and new data that huge workload and big spending. In addition, object-oriented RDS system makes query language extremely complex, so whether database development

46、 businessman or application customers depending on the complicated application technology to be a dangerous road. Basic structure The basic structure of database, reflects the three levels of observation database of three different Angle. (1) physical data layer. It is the most lining, is database o

47、n physical storage equipment actually stored data collection. These data are raw data, the object, the user is processed by internal model describing the throne of handled the instructions of string, character and word. (2) conceptual data layer. It is a layer of database, is among the whole logic s

48、aid. Database Points out the logic of each data definition and the logical connection between data collection of storage and record, is. It is related to the database all objects logical relationship, not their physical condition, is under the database administrator concept of database. (3) logical

49、data layer. It is the user sees and use the database, says one or some specific users use collections of data, namely the logical record set. Database different levels is the connection between conversion by mapping. Main features (1) to implement the data sharing. Data sharing contains all users ca

50、n also access database data, including the user can use all sorts of ways to use the database through interfaces, and provide data sharing. (2) reduce data redundancy. Compared with the file system, because the database to achieve data sharing so as to avoid the user respective establish application

51、 documentation. Reduce a lot of repeating data, reduce the data redundancy, maintain the consistency of the data. (3) data of independence. Data independence including database database of logical structure and application independent, also including data physical structure change does not affect th

52、e data of the logical structure. (4) data realize central control. File management mode, data in a decentralized state, different user or same users in different treatment had no relation between the documents. Using the database of data can be concentrated control and management, and through the da

53、ta model of data organization and said the relation between data. (5) the data consistency and maintainability, to ensure the safety and reliability of the data. Mainly includes: (1) the safety control: to prevent data loss, error updating and excessive use; (2) the integrity control: ensure data ac

54、curacy, effectiveness and compatibility; (3) the concurrent control: make in the same time period to allow data realization muli-access, and can prevent users of abnormal interaction between; (4) fault finding and recovery: the database management system provides a set of method, can isolate faults

55、and repair fault, thereby preventing data breaches (6) fault recovery. The database management system provides a set of method, can isolate faults and repair fault, thereby preventing data breaches. Database system can restore database system is running as soon as possible, is probably the fault occ

56、urred in the physical or logical error. For instance, in system caused by incorrect operation data error, etc. Database classification 1. The MaiJie openPlant real-time database Real-time database system is a new field in database theory expansion, in power, chemical, steel, metallurgy, papermaking,

57、 traffic control and securities finance and other fields has a very broad application prospect. It can provide enterprises with high speed, timely real-time data services, to the rapidly changing real-time data to carry on the long-term effective history storage, is a factory control layer (fieldbus

58、, DCS, PLC, etc) and production management system of the connection between the bridge, also process simulation, advanced control, online optimization, fault diagnosis system data platform. OpenPlant real-time database system used in today's advanced technology and architecture, can realize safe

59、, stable and field each control system of the interface, and collected data efficient data compression and China's long history of storage, meanwhile, we also provide convenient client application and general data interface (API/DDE/ODBC/JDBC/OPC, etc.), make the enterprise management and decision makers can prompt, and comprehensive understanding of the current production situation, also can look back at past production conditions, the timely discovery and the problems existing