Database (Second Edition)

Author: (USA) Patrick O'Neil
Publisher:
Publish Date: 2001-05-01
Features: Since its first edition in 1994, this book has become a classic textbook for those learning, designing, and using relational databases. It provides rigorous explanations of database design and programming from both theoretical and practical perspectives. Its content includes relational theory, database design, database programming, and run-dump results. Each section starts with fundamental principles and then illustrates them with examples from real systems. This revised edition reflects the overall progress and development trends in the database field over the past six years, with a focus on object-relational models; introduction of new concepts common to systems (such as Oracle, DB2, and Informix); an updated discussion of isolation techniques; and more modern descriptions of run results. Compared to the initial standard, the SQL database language has undergone significant changes, so object-relational models are given special attention. The book also introduces SQL-99 design methods and related principles, methodologies, and major products. The authors are seasoned experts with over 30 years of experience in the database field, rich in teaching and practical experience. The book aims to provide a unified perspective on the diverse thoughts and trends in the database field for readers. It serves as an excellent textbook for those new to database systems, an accessible reference for those who have not paid enough attention to the development of the database field, and a useful reference for designers and programmers to update their knowledge.
Content:
1. Introduction
2. Relational Model
3. Basic SQL Query Language
4. Object-Relational SQL
5. Database Programming Access
6. Database Design
7. Integrity, Views, Security, and Catalogs
8. Indexes
9. Query Processing
10. Transaction Updates
11. Parallel and Distributed Databases
Appendix A: Introductory Guide
Appendix B: Programming Details
Appendix C: SQL Statement Language
Appendix D: Setting Query Count
Author Bio: Patrick O'Neil is a professor of computer science at the University of Massachusetts at Boston. He is responsible for several important results in transactional performance and disk access algorithms, and holds patents for his work in these and other database areas. Elizabeth O'Neil is a professor of computer science at the University of Massachusetts at Boston. She serves as a consultant to Sybase IQ in Concord, Massachusetts, and has worked with numerous corporations, including Microsoft and Bolt, Beranek, and Newman.