Database System Concepts

Database System Concepts" by Silberschatz is now in its 6th edition and is one of the cornerstone texts of database education. It presents the fundamental concepts of database management in an intuitive manner geared toward allowing students to begin working with databases as quickly as possible. Silberschatz is designed for a first course in databases at the junior/senior undergraduate level or the first year graduate level. It also contains additional material that can be used as supplements or as introductory material for an advanced course. Because the authors present concepts as intuitive descriptions, a familiarity with basic data structures, computer organization, and a high-level programming language are the only prerequisites. Important theoretical results are covered, but formal proofs are omitted. In place of proofs, figures and examples are used to suggest why a result is true.

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