Table of Contents

Preface Part 1 Background 1 Introduction to Databases 2 Database Environment Part 2 The Relational Model and Languages 3 The Relational Model 4 Relational Algebra and Relational Calculus 5 SQL: Data Manipulation 6 SQL: Data Definition 7 Query-By-Example 8 Commercial RDBMSs: Office Access and Oracle Part 3 Database Analysis and Design Techniques 9 Database Planning, Design, and Administration 10 Fact-Finding Techniques 11 Entity--Relationship Modeling 12 Enhanced Entity--Relationship Modeling 13 Normalization 14 Advanced Normalization Part 4 Methodology 15 Methodology -- Conceptual Database Design 16 Methodology -- Logical Database Design for the Relational Model 17 Methodology -- Physical Database Design for Relational Databases 18 Methodology -- Monitoring and Tuning the Operational System Part 5 Selected Database Issues 19 Security 20 Transaction Management 21 Query Processing Part 6 Distributed DBMSs and Replication 22 Distributed DBMSs -- Concepts and Design 23 Distributed DBMSs -- Advanced Concepts 24 Replication and Mobile Databases Part 7 Object DBMSs 25 Introduction to Object DBMSs 26 Object-Oriented DBMSs -- Concepts 27 Object-Oriented DBMSs -- Standards and Systems 28 Object-Relational DBMSs Part 8 Web and DBMSs 29 Web Technology and DBMSs 30 Semistructured Data and XML Part 9 Business Intelligence 31 Data Warehousing Concepts 32 Data Warehousing Design 33 OLAP 34 Data Mining Appendices A Users' Requirements Specification for DreamHome Case Study B Other Case Studies C File Organizations and Indexes D When is a DBMS Relational? E Programmatic SQL F Alternative ER Modeling Notations G Summary of the Database Design Methodology for Relational Databases H Estimating disk space requirements (web only) I Example web scripts (web only) References Further Reading Index