| |
| |
| |
| The Worlds of Database Systems | |
| |
| |
| |
| The Evolution of Database Systems | |
| |
| |
| |
| Overview of a Database Management System | |
| |
| |
| |
| Outline of Database-System Studies | |
| |
| |
| |
| Summary of Chapter 1 | |
| |
| |
| |
| References for Chapter 1 | |
| |
| |
| |
| The Entity-Relationship Data Model | |
| |
| |
| |
| Elements of the E/R Model | |
| |
| |
| |
| Design Principles | |
| |
| |
| |
| The Modeling of Constraints | |
| |
| |
| |
| Weak Entity Sets | |
| |
| |
| |
| Summary of Chapter 2 | |
| |
| |
| |
| References for Chapter 2 | |
| |
| |
| |
| The Relational Data Model | |
| |
| |
| |
| Basics of the Relational Model | |
| |
| |
| |
| From E/R Diagrams to Relational Designs | |
| |
| |
| |
| Converting Subclass Structures to Relations | |
| |
| |
| |
| Functional Dependencies | |
| |
| |
| |
| Rules About Functional Dependencies | |
| |
| |
| |
| Design of Relational Database Schemas | |
| |
| |
| |
| Multivalued Dependencies | |
| |
| |
| |
| Summary of Chapter 3 | |
| |
| |
| |
| References for Chapter 3 | |
| |
| |
| |
| Other Data Models | |
| |
| |
| |
| Review of Object-Oriented Concepts | |
| |
| |
| |
| Introduction to ODL | |
| |
| |
| |
| Additional ODL Concepts | |
| |
| |
| |
| From ODL Designs to Relational Designs | |
| |
| |
| |
| The Object-Relational Model | |
| |
| |
| |
| Semistructured Data | |
| |
| |
| |
| XML and Its Data Model | |
| |
| |
| |
| Summary of Chapter 4 | |
| |
| |
| |
| References for Chapter 4 | |
| |
| |
| |
| Relational Algebra | |
| |
| |
| |
| An Example Database Schema | |
| |
| |
| |
| An Algebra of Relational Operations | |
| |
| |
| |
| Relational Operations on Bags | |
| |
| |
| |
| Extended Operators of Relational Algebra | |
| |
| |
| |
| Constraints on Relations | |
| |
| |
| |
| Summary of Chapter 5 | |
| |
| |
| |
| References for Chapter 5 | |
| |
| |
| |
| The Database Language SQL | |
| |
| |
| |
| Simple Queries in SQL | |
| |
| |
| |
| Queries Involving More Than One Relation | |
| |
| |
| |
| Subqueries | |
| |
| |
| |
| Full-Relation Operations | |
| |
| |
| |
| Database Modifications | |
| |
| |
| |
| Defining a Relation Schema in SQL | |
| |
| |
| |
| View Definitions | |
| |
| |
| |
| Summary of Chapter 6 | |
| |
| |
| |
| References for Chapter 6 | |
| |
| |
| |
| Constraints and Triggers | |
| |
| |
| |
| Keys and Foreign Keys | |
| |
| |
| |
| Constraints on Attributes and Tuples | |
| |
| |
| |
| Modification of Constraints | |
| |
| |
| |
| Schema-Level Constraints and Triggers | |
| |
| |
| |
| Summary of Chapter 7 | |
| |
| |
| |
| References for Chapter 7 | |
| |
| |
| |
| System Aspects of SQL | |
| |
| |
| |
| SQL in a Programming Environment | |
| |
| |
| |
| Procedures Stored in the Schema | |
| |
| |
| |
| The SQL Environment | |
| |
| |
| |
| Using a Call-Level Interface | |
| |
| |
| |
| Java Database Connectivity | |
| |
| |
| |
| Transactions in SQL | |
| |
| |
| |
| Security and User Authorization in SQL | |
| |
| |
| |
| Summary of Chapter 8 | |
| |
| |
| |
| References for Chapter 8 | |
| |
| |
| |
| Object-Orientation in Query Languages | |
| |
| |
| |
| Introduction to OQL | |
| |
| |
| |
| Additional Forms of OQL Expressions | |
| |
| |
| |
| Object Assignment and Creation in OQL | |
| |
| |
| |
| User-Defined Types in SQL | |
| |
| |
| |
| Operations on Object-Relational Data | |
| |
| |
| |
| Summary of Chapter 9 | |
| |
| |
| |
| References for Chapter 9 | |
| |
| |
| |
| Logical Query Languages | |
| |
| |
| |
| A Logic for Relations | |
| |
| |
| |
| From Relational Algebra to Datalog | |
| |
| |
| |
| Recursive Programming in Datalog | |
| |
| |
| |
| Recursion in SQL | |
| |
| |
| |
| Summary of Chapter 10 | |
| |
| |
| |
| References for Chapter 10 | |
| |
| |
| Index | |