《數(shù)據(jù)庫(kù)英文翻譯》word版

1、.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 merely data stora

2、ge 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 application. The

3、 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 paper printed or pun

4、ched 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 has caused data ma

5、nagement 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.Database system appea

6、rs 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 came into being. The d

7、ata 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 three types. Structured

8、 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.Although we refer to the SQL

9、 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 fundamental constructs and con

10、cepts. 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, originally called Sequel, as par

11、t 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 1986, the American National

12、 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 extended standard forSQL, SQL-89, in

13、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 standard. The SQL:1999 standard i

14、s 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 constructs. You should also be awa

15、re 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 relation schemas, deleting relations, a

16、nd 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 modify tuples in the database. View denitio

17、n.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-purpose programming languages, such as C

18、, 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 includes commands for specifying access r

19、ights 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 languages.SQL features supporting integrity an

20、d 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 = branch-name, branch-city, assetsCustomer-sc

21、hema = customer-name, customer-street, customer-cityLoan-schema = loan-number, branch-name, amountBorrower-schema = customer-name, loan-numberAccount-schema = account-number, branch-name, balanceDepositor-schema = customer-name, account-numberNote that in this chapter, as elsewhere in the text, we u

22、se 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 names is to replace all hyphens by the underscore symb

23、ol “ . 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 Chapter 3.SQL allows the use of null values to indicate th

24、at 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,and where. The select clause corresponds to the projectio

25、n 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 evaluation of the expression. The where clause corresponds

26、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 unfortunate historical fact. We emphasize the different interpr

27、etations 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 expressionA1,A2,.,AnP r1 × r2 × ···

28、 × rmIf 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 4.2.8.SQL forms the Cartesian product of the relations nam

29、ed 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 can be processed more efciently.However, we shall defer conc

30、erns 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 Query Language SQL Language. SQL language features include inq

31、uiry, 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 achieved database of all life cycle operation. SQL database pro

32、vides 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 relational database product development direction. However, unt

33、il 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. Currently SQL standard has three versions. ANSIX3135 - is def

34、ined 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, "Language - Embedded SQL Database, constituted the first generation

35、 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 completion of SQL - 92 ANSI and ISO standard, they started SQ

36、L3 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 application field of general data processing system, he storage is

37、 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 between natural relation, thus can provide all the necessar

38、y 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 the specific procedures restrictions and restraint. Differen

39、t 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 requirements of information, but also meet the various users of

40、 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 obvious: it can be a very good treatment of so-called "f

41、orm 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, industry once is quite confused. The influence of agitation by

42、 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 United States Stonebraker professor proposed object-oriented RDS

43、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 market development situation is not good. Theoretically perfec

44、t 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 system for years and accumulated the massive job data, especially b

45、ig 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 businessman or application customers depending on the complic

46、ated 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 on physical storage equipment actually stored data collection. Th

47、ese 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 said. Database Points out the logic of each data definition and the

48、 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 data layer. It is the user sees and use the database, says one or so

49、me 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 can also access database data, including the user can use all sorts of w

50、ays 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 documentation. Reduce a lot of repeating data, reduce the data redundan

51、cy, 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 the data of the logical structure. 4 data realize central control. File mana

52、gement 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 data model of data organization and said the relation between data. 5 the data

53、 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 accuracy, effectiveness and compatibility; 3 the concurrent control: make in the sam

54、e 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 and repair fault, thereby preventing data breaches 6 fault recovery. The database mana

55、gement 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 occurred in the physical or logical error. For instance, in system caused by incorrect oper

56、ation 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, traffic control and securities finance and other fields has a very broad application pr

57、ospect. 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, DCS, PLC, etc and production management system of the connection between the bridge, al

58、so 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, stable and field each control system of the interface, and collected data efficient data

59、 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 in the production, im