Description
Book SynopsisDatabase System Concepts by Silberschatz, Korth and Sudarshan is now in its 7th 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.
The text 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.
Table of ContentsChapter 1: Introduction
Part 1: Relational LanguagesChapter 2: Introduction to the Relational Model
Chapter 3: Introduction to SQL
Chapter 4: Intermediate SQL
Chapter 5: Advanced SQL
Part II: Database DesignChapter 6: Database Design Using the E-R Model
Chapter 7: Relational Database Design
Part III: Application Design and DevelopmentChapter 8: Complex Data Types
Chapter 9: Application Development
Part IV: Big Data AnalyticsChapter 10: Big Data
Chapter 11: Data Analytics
Part V: Storage Management and IndexingChapter 12: Physical Storage Systems
Chapter 13: Data Storage Structures
Chapter 14: Indexing
Part VI: Query Processing and OptimizationChapter 15: Query Processing
Chapter 16: Query Optimization
Part VII: Transaction ManagementChapter 17: Transactions
Chapter 18: Concurrency Control
Chapter 19: Recovery System
Part VIII: Parallel and Distributed DatabasesChapter 20: Database-System Architectures
Chapter 21: Parallel and Distributed Storage
Chapter 22: Parallel and Distributed Query Processing
Chapter 23: Parallel and Distributed Transaction Processing
Part IX: Advanced TopicsChapter 24: Advanced Indexing Techniques
Chapter 25: Advanced Application Development
Chapter 26: Blockchain Databases
Part X: Appendix AAppendix A: Detailed University Schema
Part XI: Online ChaptersChapter 27: Formal Relational Query Languages
Chapter 28: Advanced Relational Database Design
Chapter 29: Object-Based Databases
Chapter 30: XML
Chapter 31: Information Retrieval
Chapter 32: PostgreSQL
