This acclaimed revision of a classic database systems text offers a complete background in the basics of database
design, languages, and system implementation. It provides the latest information combined with real-world examples
to help readers master concepts. All concepts are presented in a technically complete yet easy-to-understand style
with notations kept to a minimum. A running example of a bank enterprise illustrates concepts at work. To further
optimize comprehension, figures and examples, rather than proofs, portray concepts and anticipate results.
Table of Contents
Table of Contents
Chapter 1: Introduction
Part 1: Relational Databases
Chapter 2: Introduction to the Relational Model
Chapter 3: Introduction to SQL
Chapter 4: Intermediate SQL
Chapter 5: Advanced SQL
Chapter 6: Formal Relational Query Languages
Part II: Database Design
Chapter 7: Database Design and the E-R Model
Chapter 8: Relational Database Design
Chapter 9: Application Design and Development
Part III: Data Storage and Querying
Chapter 10: Storage and File Structure
Chapter 11: Indexing and Hashing
Chapter 12: Query Processing
Chapter 13: Query Optimization
Part IV: Transaction Management
Chapter 14: Transactions
Chapter 15: Concurrency Control
Chapter 16: Recovery System
Part V: System Architecture
Chapter 17: Database-System Architectures
Chapter 18: Parallel Databases
Chapter 19: Distributed Databases
Part VI: Data Mining and Information Retrieval
Chapter 20: Data Mining
Chapter 21: Information Retrieval
Part VII: Specialty Databases
Chapter 22: Object-Based Databases
Chapter 23: XML
Chapter 24: Advanced Application Development
Chapter 25: Advanced Data Types and New Applications
Chapter 26: Advanced Transaction Processing
Part IX: Case Studies
Chapter 27: PostgreSQL
Chapter 28: Oracle
Chapter 29: IBM DB2 Universal Database
Chapter 30: Microsoft SQL Server
Part X: Appendices
Appendix A: Detailed University Schema
Appendix B: Other Relational Query Languages
Appendix C: Advanced Relational Database Design
Appendix D: Network Model
Appendix E: Hierarchical Model
