Database System Comprehensive Book

Author: Hector Garcia-Molina
Publisher:
Publish Date: 2003-10-01
Features: This book is an introductory text on database systems co-authored by Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom, renowned computer scientists at Stanford University. The first half of the book provides an in-depth introduction to databases from the perspectives of database designers, users, and application programmers. It includes the new database standard SQL—1999, SQLPSM, SQLCLI, ODL, and XML, covering more SQL content compared to most other books. The second half of the book introduces databases from the perspective of DBMS implementation, covering fundamental technologies in the field and discussing query optimization more extensively than most other books. Advanced topics include multidimensional and bitmap indexes, distributed transaction processing, and information integration technologies. This book can be used as a university textbook or as a reference for professionals in the field. Notable features of the book:
- Uses real-world examples to enhance readability.
- Covers unique topics such as SQLPSM (Persistent Storage Module), JDBC (Java Database Connectivity), and SQLCLI (ODBC or Open Database Connectivity).
- Introduces object-oriented design using the ODMG standard ODL and object-relational design using the SQL—99 standard.
- Expands on query processing and optimization using relational algebra.
- Discusses information integration technologies, including data warehousing, coordinators, OLAP (Online Analytical Processing), data cubes, and data mining techniques.
- Explains many important specialized technologies, such as RAID disk error correction, bitmap indexes, the application of statistics, and pointer mixing.
- Provides additional supplementary materials on the homepage: http://www-db.stanford.edu/ullmandscb.html.
This book serves as the textbook for the database series courses in the Computer Science department at Stanford University. It provides an in-depth exploration of the fundamental principles of database systems and their implementation, with detailed discussions on topics such as ODL, SQL, relational algebra, object-oriented queries, transaction management, and concurrency control. The book also introduces some of the latest technologies in the field, such as data warehousing, data mining, and data cube systems. It is suitable as a textbook for graduate students in computer science at universities or as a teaching reference for undergraduate students. Additionally, it serves as a high-level reference for professionals engaged in related research or development work.