Database--Principles, Programming, and Performance (The Morgan Kaufmann Series in Data Management Systems)

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, it 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, it provides in-depth coverage of object-relational technology that is changing the way databases are designed, administered, and used. It 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.