Database Systems

Database Systems, Second Edition, is a comprehensive resource designed for students and professionals who engage with database design, application development, and management systems. Authored by Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom, this 1248-page guide is tailored for junior, senior, and graduate courses in computer science, assuming a basic familiarity with algebraic expressions, logic, data structures, and programming principles. The book is structured in two distinct sections. The first part delves into the principles of database design and practical application, covering modern standards such as SQL:1999, SQL/PSM, SQL/CLI, JDBC, ODL, and XML. This section provides essential insights for both designers and application programmers, ensuring a robust understanding of how databases are constructed and utilized effectively. In the latter portion, attention shifts to the inner workings of database management systems. Topics such as storage structures, query processing, and transaction management receive detailed treatment, along with advanced subjects like query optimization, multidimensional and bitmap indexes, distributed transactions, and innovative information integration techniques. This edition stands as an invaluable reference for mastering both the development and implementation aspects of database systems.