Database: Principles, Programming, Peformance

2. Auflage 2000
ISBN: 978-1-55860-580-0
Verlag: Elsevier Science & Technology

Buch, Englisch, 870 Seiten

Of the many introductory books on database technology, none are as pragmatic or as broadly useful as Database: Principles, Programming, Performance. In this second edition, authors O'Neil and O'Neil offer a thoroughly up-to-date look at today's most critical database technologies, including established relational products and the emerging object-relational model. Throughout, the focus is on the programming, implementation, and optimisation techniques that developers and administrators need to know to enjoy rapid, regular advancement in the information technology field. This book will appeal not only to the academic and corporate training market, but also to new and aspiring professionals, including data analysts seeking a reliable, practical desktop reference.

Thoroughly revised and updated including coverage of the forthcoming SQL 99.
Discusses three different DBMSs for all concepts, applications, and examples: IBM, DB2, UDB, Informix, and Oracle.
The most practical text/reference book focused on implementation and performance.
Provides in-depth coverage of object-relational technology that is changing the way databases are designed, administered, and used.
Serves well as a practical reference for database programmers, administrators, as well as users, who want to increase the sophistication of their queries.
A Companion Web site gives access to extensive SQL code, lecture notes, and solutions to exercises.

Autoren/Hrsg.

O'Neil, Patrick

O'Neil, Elizabeth

Fachgebiete

• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Prozedurale Programmierung

Inhaltsverzeichnis

Foreword by Jim Gray, Microsoft
Preface
Introduction
The Relational Model
Basic SQL Query Language
Object-Relational SQL
Programs to Access a Database
Database Design
Integrity, Views, Security and Catalogs
Indexing
Query Processing
Update Transactions
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

Über Autor(innen)

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.