数据库:原理、编程与性能：英文（第二版　影印版） PDF下载

Foreword
Preface
Chapter 1 Introduction 
 1.1 Fundamental Database Concepts
　　History of Database Systems
　　The Relational and Object-Relational Models
　　The Database Systems Covered
　　A Relational Database Example
　　An Object-Relational Database Example
 1.2 Database Users
 1.3 Overview of Relational and Object-Relational DBMS
　　Chapter 2: The Relational Model
　　Chapter 3: Basic SQL Query Language
　　Chapter 4: The Object-Relational ModelForeword<；br>；Preface<；br>；Chapter 1 Introduction <；br>； 1.1 Fundamental Database Concepts<；br>；　　History of Database Systems<；br>；　　The Relational and Object-Relational Models<；br>；　　The Database Systems Covered<；br>；　　A Relational Database Example<；br>；　　An Object-Relational Database Example<；br>； 1.2 Database Users<；br>； 1.3 Overview of Relational and Object-Relational DBMS<；br>；　　Chapter 2: The Relational Model<；br>；　　Chapter 3: Basic SQL Query Language<；br>；　　Chapter 4: The Object-Relational Model<；br>；　　Chapter 5: Programs to Access a Database<；br>；　　Chapter 6: Database Design<；br>；　　Chapter 7: Integrity, Views, Security, and Catalogs<；br>；　　Chapter 8: Indexing<；br>；　　Chapter 9: Query Processing<；br>；　　Chapter 10: Update Transactions<；br>；　　Chapter 11: Parallel and Distributed Databases<；br>； 1.4 Putting It All Together<；br>；Chapter 2 The Relational Model <；br>； 2.1 The CAP Database<；br>； 2.2 Naming the Parts of a Database<；br>；　　Domains and Datatypes<；br>；　　Tables and Relations<；br>； 2.3 Relational Rules<；br>； 2.4 Keys, Superkeys, and Null Values<；br>；　　Null Values<；br>； 2.5 Relational algebra <；br>；　　Fundamental Operations of Relational Algebra<；br>； 2.6 Set-Theoretic Operations<；br>；　　The Union, Intersection, and Difference Operations<；br>；　　Assignment and Alias<；br>；　　The Product Operation<；br>； 2.7 Native Relational Operations<；br>；　　The Projection Operation<；br>；　　The Selection Operation<；br>；　　Precedence of Relational Operations<；br>；　　The Join Operation<；br>；　　The Division Operation<；br>； 2.8 The Interdependence of Operations<br> 2.9 Illustrative Examples<br> 2.10 Other Relational Operations<br>　　Outer Join<br>　　Theta Join<br>Chapter 3 Basic SQL Query Language <br> 3.1 Introduction<br>　　SQL Capabilities<br>　　SQL History-Standards and Dialects<br> 3.2 Setting Up the Database<br>　　Standard Typographical Conventions<br>　　A Practical Exercise<br> 3.3 Simple Select Statements<br> 3.4 Subqueries<br>　　The IN Predicate<br>　　The Quantified Comparison Predicate<br>　　The EXISTS Predicate<br>　　A Weakness of SQL: Too Many Equivalent Forms<br> 3.5 UNION Operators and FOR ALL Conditions<br>　　The UNION Operator<br>　　Division: SQL "FOR ALL..." Conditions<br> 3.6 Some Advanced SQL Syntax<br>　　The INTERSECT and EXCEPT Operators in Advanced SQL<br>　　Join Forms in Advanced SQL<br>　　OUTER JOIN<br>　　Join Forms Implemented in Database Systems<br> 3.7 Set Functions in SQL Handling Null Values<br> 3.8 Groups of Rows in SQL<br> 3.9 A Complete Dexcription of SQL Select<br>　　Identifiers<br>　　Expressions, Predicates, and the search_condition<br>　　Scalar Subqueries as Expressions:Advanced SQL<br>　　Basic SQL versus Advanced SQL: Summary<br>　　A Discussion of the Predicates<br> 3.10 Insert, Update, and Delete Statements<br>　　The Insert Statement<br>　　The Update Statement<br>　　The Delete Statement<br> 3.11 The Power of the Select Statement<br>　　The Non-Procedural Select Statement<br>　　Turing Power<br>　　Limited Power of the Basic SQL Select Statement<br>Chapter 4 Object-Relational SQL<br> 4.1 Introduction<br>　　ORSQL Capabilities<br>　　Form of Presentation for This Chapter<br>　　Object-Relational History<br> 4.2 Objects and Tables<br>　　4.2.1 Object Types in ORACLE<br>　　　　Definition of the REF Object Reference<br>　　4.2.2 INFORMIX Row Types for Objects<br>　　　　Absence of Refs in INFORMIX<br>　　　　Type Inheritance in INFORMIX<br>　　4.2.3 Objects and Tables: Summary<br>　　　　Object Orientation<br> 4.3 Collection Types<br>　　4.3.1 Collection Types in ORACLE<br>　　　　Table Types and Nested Tables<br>　　　　Two Techniques for Retrieving from a Table of Tables<br>　　　　Unnesting via Table Products<br>　　　　Nested Cursors<br>　　　　Array Types for VARRAYs<br>　　　　SQL SYntax for Collections in ORACLE<br>　　　　Inserts and Updates in ORACLE<br>　　4.3.2 Collection Types in INFORMIX<br>　　　　Sets in INFORMIX<br>　　　　Lists in INFORMIX<br>　　　　SQL Syntax for Collections in INFORMIX<br>　　　　inserts and Updates in INFORMIX<br>　　4.3.3 Collection Types:Summary<br> 4.4 Procedural SQL, User-Defined Functions (UDFs), and Methods<br>　　4.4.1 ORACLE PL/SQL Procedures, UDFs, and Methods<br>　　　　PL/SQL: ORACLEs Procedural SQL Language<br>　　　　Using PL/LQL to Implement Methods in ORACLE<br>　　　　Update Methods<br>　　4.4.2 INFORMIX User-Defined Functions<br>　　　　SPL:INFORMIXs Procedural SQL Language<br>　　　　Using SPL to Implement UDFs in INFORMIX<br>　　　　Update Functions<br>　　4.4.3 User-Defined Functions:Summary<br> 4.5 External Functions and Packaged User-Defined Types(UDTs)<br>　　Binary Data and BLOBs<br>　　External Functions<br>　　Encapsulation<br>　　Distinct Types<br>　　BLOB Objects<br>　　Packaged UDTs and Other Encapsulated UDTs<br>　　Summary<br>Chapter 5 Programs to Access a Database <br>Chapter 6 Database Design <br>Chapter 7 Integrity, Views, Security, and Catalogs <br>Chapter 8 Indexing <br>Chapter 9 Query Processing <br>Chapter 10 Update Transactions <br>Chapter 11 Parallel and Distributed Databases <br>Appendix A Introductory Tutorial<br>Appendix B Programming Details<br>Appendix C SQL Statement Syntax<br>Appendix D Set Query Counts<br>Solutions to Selected Exercises<br>Index<br>