Database
Principles, Programming, and Performance, Second Edition
Published on 9. May 2000
Book
Hardback
870 pages
978-1-55860-438-4 (ISBN)
Description
This second edition relies on the same successful approach that distinguished the first: it covers the principles of database theory with unmatched thoroughness, and it rigorously links theory to the real world of database programming and administration. A careful discussion of SQL standards and a multitude of examples drawn from actual databases-Oracle, DB2, and Informix-complements the authors' concept-oriented instruction, allowing you to develop product-specific understanding and to learn the important differences between the SQL dialects that will enable you to write portable applications.
Reviews / Votes
"The chapter on object-relational database should be a great selling point for the book. No one else has the coverage on object relational that this chapter has; for example, the other new texts emphasize the purely object model. I think that the approach here is much more practical."-Betty Salzberg, Northeastern University"The coverage of this book is wonderful, especially the cutting-edge of object-relational systems . . . [and] this is the only text I have seen that is not by Jeffrey Ullman that treats the theoretical material appropriately. The chapter on dependencies and relational design is excellent. Examples abound, the explanations are crisp and clear, and the appropriate concepts are discussed. I cannot wait to use it."-Bill Grosky, Wayne State University"This book makes an excellent text for anyone just approaching database systems. It's both an accessible refresher for those of us who have not been paying careful attention to developments in this area and a useful reference for designers and implementers who need just-in-time education."-Jim Gray, Microsoft Research"This book is excellent!"-Mike Hartstein, Oracle Corporation, Senior Director of Oracle8i Product ManagementMore details
Series
Language
English
Place of publication
San Francisco
United States
Publishing group
Elsevier Science & Technology
Target group
Professional and scholarly
Computer Science Students & Professionals
Dimensions
Height: 235 mm
Width: 187 mm
Weight
1700 gr
ISBN-13
978-1-55860-438-4 (9781558604384)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
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.
Content
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