Database - Principles, Programming and Performance (Second Edition - Original Edition)

Author: Patrick O'Neil
Publisher:
Publication Date: 2001-05-25
Features: Since its first edition in early 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. It focuses on the object-relational model, introduces new concepts common to systems such as Oracle, DB2, and Informix, updates the discussion on isolation techniques, and presents more modern descriptions of run results. Compared to the initial standard, the SQL database language has undergone significant changes, so the object-relational model is given special attention. The book also introduces the SQL-99 design methodology and related principles, methods, 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 he 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 a number of other corporations, including Microsoft and Bolt, Beranek, and Newman.