A First Course in Database Systems

Table of Contents......Page all_28765_to_00482.cpc0004.djvu
1.1 The Evolution of Database Systems......Page all_28765_to_00482.cpc0013.djvu
1.1.1 Early Database Management Systems......Page all_28765_to_00482.cpc0014.djvu
1.1.2 Relational Database Systems......Page all_28765_to_00482.cpc0016.djvu
1.1.4 Bigger and Bigger Systems......Page all_28765_to_00482.cpc0017.djvu
1.2.1 Overview of DBMS Components......Page all_28765_to_00482.cpc0019.djvu
1.2.2 The Storage Manager......Page all_28765_to_00482.cpc0021.djvu
1.2.3 The Query Manager......Page all_28765_to_00482.cpc0022.djvu
1.2.4 The Transaction Manager......Page all_28765_to_00482.cpc0023.djvu
1.3.1 Types, Classes, and Objects......Page all_28765_to_00482.cpc0026.djvu
1.3.3 Multimedia Data......Page all_28765_to_00482.cpc0030.djvu
1.3.4 Data Integration......Page all_28765_to_00482.cpc0031.djvu
1.4 Outline of the Book......Page all_28765_to_00482.cpc0032.djvu
1.4.2 Programming......Page all_28765_to_00482.cpc0033.djvu
1.5 Summary of Chapter 1......Page all_28765_to_00482.cpc0034.djvu
1.6 References for Chapter 1......Page all_28765_to_00482.cpc0035.djvu
2 Database Modeling......Page all_28765_to_00482.cpc0037.djvu
2.1 Introduction to ODL......Page all_28765_to_00482.cpc0038.djvu
2.1.1 Object-Oriented Design......Page all_28765_to_00482.cpc0039.djvu
2.1.3 Attributes in ODL......Page all_28765_to_00482.cpc0041.djvu
2.1.4 Relationships in ODL......Page all_28765_to_00482.cpc0042.djvu
2.1.5 Inverse Relationships......Page all_28765_to_00482.cpc0043.djvu
2.1.6 Multiplicity of Relationships......Page all_28765_to_00482.cpc0045.djvu
2.1.7 Types in ODL......Page all_28765_to_00482.cpc0048.djvu
2.1.8 Exercises for Section 2.1......Page all_28765_to_00482.cpc0050.djvu
2.2 Entity-Relationship Diagrams......Page all_28765_to_00482.cpc0052.djvu
2.2.1 Multiplicity of E/R Relationships......Page all_28765_to_00482.cpc0053.djvu
2.2.2 Multiway Relationships......Page all_28765_to_00482.cpc0054.djvu
2.2.3 Roles in Relationships......Page all_28765_to_00482.cpc0055.djvu
2.2.4 Attributes on Relationships......Page all_28765_to_00482.cpc0057.djvu
2.2.5 Converting Multiway Relationships to Binary......Page all_28765_to_00482.cpc0058.djvu
2.2.6 Exercises for Section 2.2......Page all_28765_to_00482.cpc0060.djvu
2.3.1 Faithfulness......Page all_28765_to_00482.cpc0062.djvu
2.3.3 Simplicity Counts......Page all_28765_to_00482.cpc0063.djvu
2.3.4 Picking the Right Kind of Element......Page all_28765_to_00482.cpc0064.djvu
2.3.5 Exercises for Section 2.3......Page all_28765_to_00482.cpc0067.djvu
2.4.1 Subclasses in ODL......Page all_28765_to_00482.cpc0069.djvu
2.4.2 Multiple Inheritance in ODL......Page all_28765_to_00482.cpc0070.djvu
2.4.4 Inheritance in the E/R Model......Page all_28765_to_00482.cpc0072.djvu
2.4.5 Exercises for Section 2.4......Page all_28765_to_00482.cpc0074.djvu
2.5 The Modeling of Constraints......Page all_28765_to_00482.cpc0075.djvu
2.5.1 Keys......Page all_28765_to_00482.cpc0076.djvu
2.5.2 Declaring Keys in ODL......Page all_28765_to_00482.cpc0078.djvu
2.5.4 Single-Value Constraints......Page all_28765_to_00482.cpc0079.djvu
2.5.5 Referential Integrity......Page all_28765_to_00482.cpc0080.djvu
2.5.6 Referential Integrity in E/R Diagrams......Page all_28765_to_00482.cpc0081.djvu
2.5.7 Other Kinds of Constraints......Page all_28765_to_00482.cpc0082.djvu
2.5.8 Exercises for Section 2.5......Page all_28765_to_00482.cpc0083.djvu
2.6.1 Causes of Weak Entity Sets......Page all_28765_to_00482.cpc0084.djvu
2.6.2 Requirements for Weak Entity Sets......Page all_28765_to_00482.cpc0085.djvu
2.6.3 Weak Entity Set Notation......Page all_28765_to_00482.cpc0087.djvu
2.6.4 Exercises for Section 2.6......Page all_28765_to_00482.cpc0088.djvu
2.7.1 The Network Model......Page all_28765_to_00482.cpc0089.djvu
2.7.2 Representing Network Schemas......Page all_28765_to_00482.cpc0090.djvu
2.7.3 The Hierarchical Model......Page all_28765_to_00482.cpc0091.djvu
2.7.4 Exercises for Section 2.7......Page all_28765_to_00482.cpc0092.djvu
2.8 Summary of Chapter 2......Page all_28765_to_00482.cpc0094.djvu
2.9 References for Chapter 2......Page all_28765_to_00482.cpc0095.djvu
3.1 Basics of the Relational Model......Page all_28765_to_00482.cpc0097.djvu
3.1.2 Schemas......Page all_28765_to_00482.cpc0098.djvu
3.1.4 Domains......Page all_28765_to_00482.cpc0099.djvu
3.1.5 Equivalent Representations of a Relation......Page all_28765_to_00482.cpc0100.djvu
3.1.6 Relation Instances 3.1.7 Exercises for Section 3.1......Page all_28765_to_00482.cpc0102.djvu
3.2 From ODL Designs to Relational Designs......Page all_28765_to_00482.cpc0103.djvu
3.2.2 Nonatomic Attributes in Classes......Page all_28765_to_00482.cpc0104.djvu
3.2.3 Representing Other Type Constructors......Page all_28765_to_00482.cpc0108.djvu
3.2.4 Representing Single-Valued Relationships......Page all_28765_to_00482.cpc0109.djvu
3.2.5 Representing Multivalued Relationships......Page all_28765_to_00482.cpc0111.djvu
3.2.6 What If There Is No Key?......Page all_28765_to_00482.cpc0112.djvu
3.2.7 Representing a Relationship and Its Inverse......Page all_28765_to_00482.cpc0113.djvu
3.2.8 Exercises for Section 3.2......Page all_28765_to_00482.cpc0114.djvu
3.3 From E/R Diagrams to Relational Designs......Page all_28765_to_00482.cpc0115.djvu
3.3.1 From Entity Sets to Relations......Page all_28765_to_00482.cpc0116.djvu
3.3.2 From E/R Relationships to Relations......Page all_28765_to_00482.cpc0118.djvu
3.3.3 Handling Weak Entity Sets......Page all_28765_to_00482.cpc0120.djvu
3.3.4 Exercises for Section 3.3......Page all_28765_to_00482.cpc0123.djvu
3.4 Converting Subclass Structures to Relations......Page all_28765_to_00482.cpc0124.djvu
3.4.1 Relational Representation of ODL Subclasses......Page all_28765_to_00482.cpc0125.djvu
3.4.2 Representing Isa in the Relational Model......Page all_28765_to_00482.cpc0126.djvu
3.4.4 Using Null Values to Combine Relations......Page all_28765_to_00482.cpc0127.djvu
3.4.5 Exercises for Section 3.4......Page all_28765_to_00482.cpc0128.djvu
3.5.1 Definition of Functional Dependency......Page all_28765_to_00482.cpc0130.djvu
3.5.2 Keys of Relations......Page all_28765_to_00482.cpc0133.djvu
3.5.4 Discovering Keys for Relations......Page all_28765_to_00482.cpc0134.djvu
3.5.5 Keys for Relations Derived from ODL......Page all_28765_to_00482.cpc0136.djvu
3.6 Rules About Functional Dependencies......Page all_28765_to_00482.cpc0138.djvu
3.6.1 The Splitting/Combining Rule......Page all_28765_to_00482.cpc0139.djvu
3.6.2 Trivial Dependencies......Page all_28765_to_00482.cpc0140.djvu
3.6.3 Computing the Closure of Attributes......Page all_28765_to_00482.cpc0141.djvu
3.6.4 The Transitive Rule......Page all_28765_to_00482.cpc0144.djvu
3.6.5 Closing Sets of Functional Dependencies......Page all_28765_to_00482.cpc0146.djvu
3.6.6 Exercises for Section 3.6......Page all_28765_to_00482.cpc0147.djvu
3.7 Design of Relational Database Schemas......Page all_28765_to_00482.cpc0149.djvu
3.7.2 Decomposing Relations......Page all_28765_to_00482.cpc0150.djvu
3.7.3 Boyce-Codd Normal Form......Page all_28765_to_00482.cpc0152.djvu
3.7.4 Decomposition into BCNF......Page all_28765_to_00482.cpc0154.djvu
3.7.5 Projecting Functional Dependencies......Page all_28765_to_00482.cpc0159.djvu
3.7.6 Recovering Information from a Decomposition......Page all_28765_to_00482.cpc0160.djvu
3.7.7 Third Normal Form......Page all_28765_to_00482.cpc0163.djvu
3.7.8 Exercises for Section 3.7......Page all_28765_to_00482.cpc0166.djvu
3.8 Multivalued Dependencies......Page all_28765_to_00482.cpc0167.djvu
3.8.1 Attribute Independence and Its Consequent Redundancy......Page all_28765_to_00482.cpc0168.djvu
3.8.2 Definition of Multivalued Dependencies......Page all_28765_to_00482.cpc0169.djvu
3.8.3 Reasoning About Multivalued Dependencies......Page all_28765_to_00482.cpc0171.djvu
3.8.4 Fourth Normal Form......Page all_28765_to_00482.cpc0173.djvu
3.8.5 Decomposition into Fourth Normal Form......Page all_28765_to_00482.cpc0174.djvu
3.8.6 Relationships Among Normal Forms......Page all_28765_to_00482.cpc0175.djvu
3.8.7 Exercises for Section 3.8......Page all_28765_to_00482.cpc0176.djvu
3.9 An Example Database Schema......Page all_28765_to_00482.cpc0178.djvu
3.10 Summary of Chapter 3......Page all_28765_to_00482.cpc0181.djvu
3.11 References for Chapter 3......Page all_28765_to_00482.cpc0183.djvu
4.1 An Algebra of Relational Operations......Page all_28765_to_00482.cpc0185.djvu
4.1.1 Set Operations on Relations......Page all_28765_to_00482.cpc0186.djvu
4.1.2 Projection......Page all_28765_to_00482.cpc0188.djvu
4.1.3 Selection......Page all_28765_to_00482.cpc0189.djvu
4.1.4 Cartesian Product......Page all_28765_to_00482.cpc0190.djvu
4.1.5 Natural Joins......Page all_28765_to_00482.cpc0191.djvu
4.1.6 Theta-Joins......Page all_28765_to_00482.cpc0192.djvu
4.1.7 Combining Operations to Form Queries......Page all_28765_to_00482.cpc0194.djvu
4.1.9 Dependent and Independent Operations......Page all_28765_to_00482.cpc0197.djvu
4.1.10 Exercises for Section 4.1......Page all_28765_to_00482.cpc0199.djvu
4.2.1 Predicates and Atoms......Page all_28765_to_00482.cpc0206.djvu
4.2.2 Arithmetic Atoms......Page all_28765_to_00482.cpc0207.djvu
4.2.3 Datalog Rules and Queries......Page all_28765_to_00482.cpc0208.djvu
4.2.4 Meaning of Datalog Rules......Page all_28765_to_00482.cpc0209.djvu
4.2.6 Exercises for Section 4.2......Page all_28765_to_00482.cpc0212.djvu
4.3.2 Union......Page all_28765_to_00482.cpc0213.djvu
4.3.4 Projection......Page all_28765_to_00482.cpc0214.djvu
4.3.5 Selection......Page all_28765_to_00482.cpc0215.djvu
4.3.7 Joins......Page all_28765_to_00482.cpc0217.djvu
4.3.8 Simulating Multiple Operations with Datalog......Page all_28765_to_00482.cpc0219.djvu
4.3.9 Exercises for Section 4.3......Page all_28765_to_00482.cpc0220.djvu
4.4 Recursive Programming in Datalog......Page all_28765_to_00482.cpc0221.djvu
4.4.2 Computing the Least Fixedpoint......Page all_28765_to_00482.cpc0223.djvu
4.4.3 Fixedpoint Equations in Datalog......Page all_28765_to_00482.cpc0225.djvu
4.4.4 Negation in Recursive Rules......Page all_28765_to_00482.cpc0230.djvu
4.4.5 Exercises for Section 4.4......Page all_28765_to_00482.cpc0233.djvu
4.5.1 Relational Algebra as a Constraint Language......Page all_28765_to_00482.cpc0235.djvu
4.5.2 Referential Integrity Constraints......Page all_28765_to_00482.cpc0236.djvu
4.5.3 Additional Constraint Examples......Page all_28765_to_00482.cpc0237.djvu
4.5.4 Exercises for Section 4.5......Page all_28765_to_00482.cpc0239.djvu
4.6.1 Why Bags?......Page all_28765_to_00482.cpc0241.djvu
4.6.2 Union, Intersection, and Difference of Bags......Page all_28765_to_00482.cpc0242.djvu
4.6.3 Projection of Bags......Page all_28765_to_00482.cpc0244.djvu
4.6.4 Selection on Bags......Page all_28765_to_00482.cpc0245.djvu
4.6.5 Product of Bags......Page all_28765_to_00482.cpc0246.djvu
4.6.7 Datalog Rules Applied to Bags......Page all_28765_to_00482.cpc0247.djvu
4.6.8 Exercises for Section 4.6......Page all_28765_to_00482.cpc0249.djvu
4.7.2 Aggregations......Page all_28765_to_00482.cpc0250.djvu
4.7.4 Null Values......Page all_28765_to_00482.cpc0251.djvu
4.8 Summary of Chapter 4......Page all_28765_to_00482.cpc0252.djvu
4.9 References for Chapter 4......Page all_28765_to_00482.cpc0253.djvu
5 The Database Language SQL......Page all_28765_to_00482.cpc0255.djvu
5.1 Simple Queries in SQL......Page all_28765_to_00482.cpc0256.djvu
5.1.1 Projection in SQL......Page all_28765_to_00482.cpc0257.djvu
5.1.2 Selection in SQL......Page all_28765_to_00482.cpc0259.djvu
5.1.3 Comparison of Strings......Page all_28765_to_00482.cpc0260.djvu
5.1.5 Ordering the Output......Page all_28765_to_00482.cpc0263.djvu
5.1.6 Exercises for Section 5.1......Page all_28765_to_00482.cpc0264.djvu
5.2.1 Products and Joins in SQL......Page all_28765_to_00482.cpc0266.djvu
5.2.2 Disambiguating Attributes......Page all_28765_to_00482.cpc0267.djvu
5.2.3 Tuple Variables......Page all_28765_to_00482.cpc0268.djvu
5.2.4 Interpreting Multirelation Queries......Page all_28765_to_00482.cpc0269.djvu
5.2.5 Union, Intersection, and Difference of Queries......Page all_28765_to_00482.cpc0272.djvu
5.2.6 Exercises for Section 5.2......Page all_28765_to_00482.cpc0274.djvu
5.3 Subqueries......Page all_28765_to_00482.cpc0275.djvu
5.3.1 Subqueries that Produce Scalar Values......Page all_28765_to_00482.cpc0276.djvu
5.3.2 Conditions Involving Relations......Page all_28765_to_00482.cpc0277.djvu
5.3.3 Conditions Involving Tuples......Page all_28765_to_00482.cpc0278.djvu
5.3.4 Correlated Subqueries......Page all_28765_to_00482.cpc0279.djvu
5.3.5 Exercises for Section 5.3......Page all_28765_to_00482.cpc0281.djvu
5.4 Duplicates......Page all_28765_to_00482.cpc0282.djvu
5.4.2 Duplicates in Unions, Intersections, and Differences......Page all_28765_to_00482.cpc0283.djvu
5.5.1 Aggregation Operators......Page all_28765_to_00482.cpc0285.djvu
5.5.2 Grouping......Page all_28765_to_00482.cpc0286.djvu
5.5.3 HAVING Clauses......Page all_28765_to_00482.cpc0288.djvu
5.5.4 Exercises for Section 5.5......Page all_28765_to_00482.cpc0289.djvu
5.6.1 Insertion......Page all_28765_to_00482.cpc0291.djvu
5.6.2 Deletion......Page all_28765_to_00482.cpc0293.djvu
5.6.3 Updates......Page all_28765_to_00482.cpc0295.djvu
5.6.4 Exercises for Section 5.6......Page all_28765_to_00482.cpc0296.djvu
5.7 Defining a Relation Schema in SQL......Page all_28765_to_00482.cpc0297.djvu
5.7.2 Simple Table Declarations......Page all_28765_to_00482.cpc0298.djvu
5.7.3 Deleting Tables......Page all_28765_to_00482.cpc0299.djvu
5.7.5 Default Values......Page all_28765_to_00482.cpc0300.djvu
5.7.6 Domains......Page all_28765_to_00482.cpc0301.djvu
5.7.7 Indexes......Page all_28765_to_00482.cpc0302.djvu
5.7.8 Exercises for Section 5.7......Page all_28765_to_00482.cpc0304.djvu
5.8.1 Declaring Views......Page all_28765_to_00482.cpc0306.djvu
5.8.2 Querying Views......Page all_28765_to_00482.cpc0307.djvu
5.8.4 Modifying Views......Page all_28765_to_00482.cpc0309.djvu
5.8.5 Interpreting Queries Involving Views......Page all_28765_to_00482.cpc0312.djvu
5.8.6 Exercises for Section 5.8......Page all_28765_to_00482.cpc0315.djvu
5.9.1 Operations on Nulls......Page all_28765_to_00482.cpc0316.djvu
5.9.2 The Truth-Value UNKNOWN......Page all_28765_to_00482.cpc0318.djvu
5.9.3 SQL2 Join Expressions......Page all_28765_to_00482.cpc0319.djvu
5.9.5 Outerjoins......Page all_28765_to_00482.cpc0321.djvu
5.9.6 Exercises for Section 5.9......Page all_28765_to_00482.cpc0323.djvu
5.10.1 Defining IDB Relations in SQL3......Page all_28765_to_00482.cpc0325.djvu
5.10.2 Linear Recursion......Page all_28765_to_00482.cpc0328.djvu
5.10.3 Use of Views in With-Statements......Page all_28765_to_00482.cpc0329.djvu
5.10.4 Stratified Negation......Page all_28765_to_00482.cpc0330.djvu
5.10.5 Problematic Expressions in Recursive SQL3......Page all_28765_to_00482.cpc0331.djvu
5.10.6 Exercises for Section 5.10......Page all_28765_to_00482.cpc0334.djvu
5.11 Summary of Chapter 5......Page all_28765_to_00482.cpc0336.djvu
5.12 References for Chapter 5......Page all_28765_to_00482.cpc0338.djvu
6 Constraints and Triggers in SQL......Page all_28765_to_00482.cpc0339.djvu
6.1.1 Declaring Keys......Page all_28765_to_00482.cpc0340.djvu
6.1.2 Enforcing Key Constraints......Page all_28765_to_00482.cpc0342.djvu
6.2.1 Declaring Foreign-Key Constraints......Page all_28765_to_00482.cpc0343.djvu
6.2.2 Maintaining Referential Integrity......Page all_28765_to_00482.cpc0345.djvu
6.2.3 Exercises for Section 6.2......Page all_28765_to_00482.cpc0347.djvu
6.3 Constraints on the Values of Attributes......Page all_28765_to_00482.cpc0348.djvu
6.3.2 Attribute-Based CHECK Constraints......Page all_28765_to_00482.cpc0349.djvu
6.3.3 Domain Constraints......Page all_28765_to_00482.cpc0351.djvu
6.3.4 Exercises for Section 6.3......Page all_28765_to_00482.cpc0352.djvu
6.4.1 Tuple-Based CHECK Constraints......Page all_28765_to_00482.cpc0353.djvu
6.4.2 Assertions......Page all_28765_to_00482.cpc0354.djvu
6.4.3 Exercises for Section 6.4......Page all_28765_to_00482.cpc0358.djvu
6.5.1 Giving Names to Constraints......Page all_28765_to_00482.cpc0360.djvu
6.5.2 Altering Constraints on Tables......Page all_28765_to_00482.cpc0361.djvu
6.5.3 Altering Domain Constraints......Page all_28765_to_00482.cpc0362.djvu
6.5.5 Exercises for Section 6.5......Page all_28765_to_00482.cpc0363.djvu
6.6.1 Triggers and Constraints......Page all_28765_to_00482.cpc0364.djvu
6.6.2 SQL3 Triggers......Page all_28765_to_00482.cpc0365.djvu
6.6.3 Assertions in SQL3......Page all_28765_to_00482.cpc0368.djvu
6.6.4 Exercises for Section 6.6......Page all_28765_to_00482.cpc0369.djvu
6.7 Summary of Chapter 6......Page all_28765_to_00482.cpc0371.djvu
6.8 References for Chapter 6......Page all_28765_to_00482.cpc0372.djvu
7.1 SQL in a Programming Environment......Page all_28765_to_00482.cpc0373.djvu
7.1.1 The Impedance Mismatch Problem......Page all_28765_to_00482.cpc0374.djvu
7.1.2 The SQL/Host Language Interface......Page all_28765_to_00482.cpc0375.djvu
7.1.3 The DECLARE Section......Page all_28765_to_00482.cpc0376.djvu
7.1.4 Using Shared Variables......Page all_28765_to_00482.cpc0377.djvu
7.1.5 Single-Row Select Statements......Page all_28765_to_00482.cpc0378.djvu
7.1.6 Cursors......Page all_28765_to_00482.cpc0379.djvu
7.1.8 Cursor Options......Page all_28765_to_00482.cpc0382.djvu
7.1.9 Ordering Tuples for Fetching......Page all_28765_to_00482.cpc0383.djvu
7.1.10 Protecting Against Concurrent Updates......Page all_28765_to_00482.cpc0384.djvu
7.1.11 Scrolling Cursors......Page all_28765_to_00482.cpc0385.djvu
7.1.12 Dynamic SQL......Page all_28765_to_00482.cpc0386.djvu
7.1.13 Exercises for Section 7.1......Page all_28765_to_00482.cpc0387.djvu
7.2.1 Serializability......Page all_28765_to_00482.cpc0390.djvu
7.2.2 Atomicity......Page all_28765_to_00482.cpc0392.djvu
7.2.3 Transactions......Page all_28765_to_00482.cpc0394.djvu
7.2.4 Read-Only Transactions......Page all_28765_to_00482.cpc0396.djvu
7.2.5 Dirty Reads......Page all_28765_to_00482.cpc0397.djvu
7.2.6 Other Isolation Levels......Page all_28765_to_00482.cpc0399.djvu
7.2.7 Exercises for Section 7.2......Page all_28765_to_00482.cpc0400.djvu
7.3.1 Environments......Page all_28765_to_00482.cpc0401.djvu
7.3.2 Schemas......Page all_28765_to_00482.cpc0403.djvu
7.3.4 Clients and Servers in the SQL Environment......Page all_28765_to_00482.cpc0404.djvu
7.3.5 Connections......Page all_28765_to_00482.cpc0405.djvu
7.3.6 Sessions......Page all_28765_to_00482.cpc0406.djvu
7.4 Security and User Authorization in SQL2......Page all_28765_to_00482.cpc0407.djvu
7.4.1 Privileges......Page all_28765_to_00482.cpc0408.djvu
7.4.2 Creating Privileges......Page all_28765_to_00482.cpc0409.djvu
7.4.3 The Privilege-Checking Process......Page all_28765_to_00482.cpc0410.djvu
7.4.4 Granting Privileges......Page all_28765_to_00482.cpc0411.djvu
7.4.5 Grant Diagrams......Page all_28765_to_00482.cpc0413.djvu
7.4.6 Revoking Privileges......Page all_28765_to_00482.cpc0414.djvu
7.4.7 Exercises for Section 7.4......Page all_28765_to_00482.cpc0419.djvu
7.5 Summary of Chapter 7......Page all_28765_to_00482.cpc0420.djvu
7.6 References for Chapter 7......Page all_28765_to_00482.cpc0422.djvu
8 Object-Oriented Query Languages......Page all_28765_to_00482.cpc0423.djvu
8.1.2 Declaring Method Signatures in ODL......Page all_28765_to_00482.cpc0424.djvu
8.1.4 Exercises for Section 8.1......Page all_28765_to_00482.cpc0427.djvu
8.2 Introduction to OQL......Page all_28765_to_00482.cpc0429.djvu
8.2.2 The OQL Type System......Page all_28765_to_00482.cpc0431.djvu
8.2.3 Path Expressions......Page all_28765_to_00482.cpc0432.djvu
8.2.4 Select-From-Where Expressions in OQL......Page all_28765_to_00482.cpc0433.djvu
8.2.6 Complex Output Types......Page all_28765_to_00482.cpc0435.djvu
8.2.7 Subqueries......Page all_28765_to_00482.cpc0436.djvu
8.2.8 Ordering the Result......Page all_28765_to_00482.cpc0437.djvu
8.2.9 Exercises for Section 8.2......Page all_28765_to_00482.cpc0438.djvu
8.3.1 Quantifier Expressions......Page all_28765_to_00482.cpc0439.djvu
8.3.3 Group-By Expressions......Page all_28765_to_00482.cpc0440.djvu
8.3.4 HAVING Clauses......Page all_28765_to_00482.cpc0443.djvu
8.3.5 Set Operators......Page all_28765_to_00482.cpc0444.djvu
8.3.6 Exercises for Section 8.3......Page all_28765_to_00482.cpc0445.djvu
8.4.2 Extracting Elements of Collections......Page all_28765_to_00482.cpc0446.djvu
8.4.3 Obtaining Each Member of a Collection......Page all_28765_to_00482.cpc0447.djvu
8.4.4 Creating New Objects......Page all_28765_to_00482.cpc0448.djvu
8.4.5 Exercises for Section 8.4......Page all_28765_to_00482.cpc0450.djvu
8.5.1 Row Types......Page all_28765_to_00482.cpc0451.djvu
8.5.2 Declaring Relations with a Row Type......Page all_28765_to_00482.cpc0452.djvu
8.5.4 References......Page all_28765_to_00482.cpc0453.djvu
8.5.5 Following References......Page all_28765_to_00482.cpc0454.djvu
8.5.6 Scopes of References......Page all_28765_to_00482.cpc0456.djvu
8.5.7 Object Identifiers as Values......Page all_28765_to_00482.cpc0457.djvu
8.5.8 Exercises for Section 8.5......Page all_28765_to_00482.cpc0460.djvu
8.6 Abstract Data Types in SQL3......Page all_28765_to_00482.cpc0461.djvu
8.6.1 Defining ADT's......Page all_28765_to_00482.cpc0462.djvu
8.6.2 Defining Methods for ADT's......Page all_28765_to_00482.cpc0465.djvu
8.6.4 Exercises for Section 8.6......Page all_28765_to_00482.cpc0468.djvu
8.7 A Comparison of the ODL/OQL and SQL3 Approaches......Page all_28765_to_00482.cpc0470.djvu
8.8 Summary of Chapter 8......Page all_28765_to_00482.cpc0471.djvu
8.9 References for Chapter 8......Page all_28765_to_00482.cpc0472.djvu
Index......Page all_28765_to_00482.cpc0475.djvu