Relational Database Systems (Hardcover)

Introduction to Database Concepts: Databases and Database Systems. The Entity-Relationship Model. The Relational Model: The Relational Model. Relational Algebra Operations. Relational Algebra Computations. Relational Algebra Expressions. Other Operations. SQL--The Interactive Language: The Data Definition Component. The Data Manipulation Component. SQL and Database Administration. SQL Dialects. Embedded SQL: Structure of Embedded SQL Programs. Variablesin Embedded SQL. Flow of Control. Cursors. Updates in Embedded SQL. Dynamic SQL. SQL92 and Embedded SQL. Relational Calculi: Domain Calculus. Tuple Calculus. The QUEL Query Language. Query-by-Example. Paradoxs QBE Facility. Constraints and Schemas: Constraints and Schemas. Project-Join Mappings. SQL and Integrity Constraints. Functional Dependencies: Proofs and Functional Dependencies. Keys and Functional Dependencies. Covers. Tableaux. Normalization: Normal Forms. Normalization. Multivalued and Join Dependencies: Multivalued and Join Dependencies. Rules of Inference. Dependency Bases. Further Normalization. Tableaux and Multivalued Dependencies. Hypergraphs. Physical Design Principles: Basic Data Structures. Hierarchical Systems of Indices. Hashing. Product-Specific Data Structures. Query Processing: Algebraic Manipulation. Selection Query Processing. Join Processing. The Wong-Youssefi Algorithm. Informed Decisions. Concurrency In Database Systems: Transactions. Serializability. Concurrency Control Algorithms. Recovery. SQL Support for Transactions. List of Notation. Index.