Database

Patrick O'Neil is a professor of computer science at the University of Massachusetts at Boston. He is responsible for a number of important research results in transactional performance and disk access algorithms, and he holds patents for his work in these and other database areas. Author of "The Set Query Benchmark" (in The Benchmark Handbook for Database and Transaction Processing Systems, also from Morgan Kaufmann) and an area editor for Information Systems, O'Neil is also an active industry consultant who has worked with a number of prominent companies, including Microsoft, Oracle, Sybase, Informix, Praxis, Price Waterhouse, and Policy Management Systems Corporation. Elizabeth O'Neil is also 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. From 1980 to 1998 she implemented and managed new hardware and software labs in the Computer Science Department of the University of Massachusetts at Boston.

Foreword --Jim Gray, Microsoft Preface Chapter 1 Introduction Chapter 2 The Relational Model Chapter 3 Basic SQL Query Language Chapter 4 Object-Relational SQL Chapter 5 Programs to Access a Database Chapter 6 Database Design Chapter 7 Integrity, Views, Security, and Catalogs Chapter 8 Indexing Chapter 9 Query Processing Chapter 10 Update Transactions Chapter 11 Parallel and Distributed Databases Appendix A Introductory Tutorial Appendix B Programming Details Appendix C SQL Statement Syntax Appendix D Set Query Counts Solutions to Selected Exercises