OVERVIEW


Database System Concepts presents the fundamental concepts of database management in an intuitive manner geared toward allowing students to begin working with databases as quickly as possible. 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.
Extensive coverage of Big Data systems, from the user perspective, as well as from an internal
perspective with extensive additions and modifications


KEY FEATURES


? A new chapter, Blockchain Databases that introduces blockchain technology and its growing role in enterprise applications
? Updates in all chapters covering database internals to reflect current-generation technology, such as solid-state disks, main-memory databases, multi-core systems, and column-stores
? Enhanced coverage of semi-structured data management using JSON, RDF, and SPARQL
? Updated coverage of temporal data, data analytics, and advanced indexing techniques such as write-optimized indices
? Reorganization and revision of chapters to better support courses with a significant hands-on
component including use of current-generation application development tools and Big Data systems
such as Apache Hadoop and Spark

Chapter 1: Introduction
Part One: Relational Languages
Chapter 2: Introduction to the Relational Model
Chapter 3: Introduction to SQL
Chapter 4: Intermediate SQL
Chapter 5: Advanced SQL
Part Two: Database Design
Chapter 6: Database Design using the E-R model
Chapter 7: Relational Database Design
Part Three: Application Design and Development
Chapter 8: Complex Data Types
Chapter 9: Application Development
Part Four: Big Data Analytics
Chapter 10: Big Data
Chapter 11: Data Analytics
Part Five: Storage Management and Indexing
Chapter 12: Physical Storage Systems
Chapter 13: Data Storage Structures
Chapter 14: Indexing
Part Six: Query Processing and Optimization
Chapter 15: Query Processing
Chapter 16: Query Optimization
Part Seven: Transaction Management
Chapter 17: Transactions
Chapter 18: Concurrency Control
Chapter 19: Recovery Systems
Part Eight: Parallel and Distributed Databases
Chapter 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 Nine: Advanced Topics
Chapter 24: Advanced Indexing Techniques
Chapter 25: Advanced Application Development
Chapter 26: Blockchain Databases
Part Ten: Appendix A
Part Eleven: Online Chapters
Chapter 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