Database System Concepts

Database System Concepts, 7th Edition, presents a comprehensive framework for managing relational database systems and understanding internal execution engines. Written specifically for junior and senior undergraduate students as well as first-year graduate students, the text directly addresses the instructional objectives of an initial upper-level university database course.

Instruction begins with foundational relational data models before guiding readers through the syntax and application of basic, intermediate, and advanced SQL. The text integrates conceptual modeling through the Entity-Relationship model alongside formal normalization techniques for relational database design. Progression then shifts to storage mechanisms and query execution engines, examining physical storage systems, data storage structures, B+-tree indexing, bitmap indices, cost evaluation of join operations in query optimization, transaction management, concurrency control protocols, and system recovery.

Learning is supported by interactive digital tools alongside theoretical explanations. A companion website enables learners to write and execute SQL queries directly inside their web browsers through an embedded environment built on SQLite and sql.js.