Using the New DB2: IBM's Object-Relational Database System (Morgan Kaufmann Series in Data Management Systems) [Paperback]

D. D. Chamberlin (Author), Don Chamberlin (Author)

Book Description

Publication Date: May 1996 | Series: Morgan Kaufmann Series in Data Management Systems

"A must read for anyone using, planning to use, or simply curious about V2 of DB2. A beautifully written book that is bound to become the definitive reference for the system. The book covers the new features of the system in a style that is complete, yet not overwhelming. Simply a great book."
"-- David Dewitt, University of Wisconsin"

"Using the New DB2" provides: A comprehensive user's guide to DB2 Version 2 for OS/2, Windows/NT, AIX, and other UNIX platforms. Hundreds of tested programming examples, and dozens of practical tips for writing applications. A road map for the merging of relational and object-oriented database technologies.

DB2 Version 2 is the most significant enhancement to IBM's database product family since the introduction of IBM's original relational database products. It supports a broad array of Intel- and UNIX-based platforms, and includes many new SQL features. It defines IBM's direction for combining the advantages of relational and object-oriented database technologies in a single system.

"Using the New DB2" presents an overview of the basic features of DB2 Version 2, including historical notes on the development of SQL. It then offers a comprehensive explanation of the advanced features of the system, including recursive queries, constraints, triggers, user-defined types and functions, stored procedures, and client-server applications. Several complete sample applications are provided, illustrating storage and manipulation of complex objects, design of an active database, and use of stored procedures. A chapter is devoted to describing tools and procedures for database administrators.

Written in an informal and accessiblestyle, "Using the New DB2" is a valuable resource for DB2 application developers, end users, database designers and administrators, as well as for readers with a general interest in database systems and in the convergence of the relational and object-oriented paradigms.

Product Details

• Paperback: 681 pages
• Publisher: Ap Professional (May 1996)
• Language: English
• ISBN-10: 1558603735
• ISBN-13: 978-1558603738
• Product Dimensions: 9.5 x 7.8 x 1.2 inches
• Shipping Weight: 2.6 pounds
• Average Customer Review: 4.7 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #6,423,217 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

4.0 out of 5 stars Concise and Informative, May 19, 1998

By A Customer

This review is from: Using the New DB2: IBM's Object-Relational Database System (Morgan Kaufmann Series in Data Management Systems) (Paperback)

I'll be using this book to teach my 5th semester Computer Engineering students about SQL in a DB2 environment. The organization is excellent and the level of discussion is clear. My students need to learn about dynamic and embedded SQL as well as deal with the specifics of IBM's approach. Chamberlin should be congratulated for his approach and I hope that he continues to update his book as the DB2 product changes.

5.0 out of 5 stars Excellent resource for the rookie or the old hat., February 18, 1998

By A Customer

This review is from: Using the New DB2: IBM's Object-Relational Database System (Morgan Kaufmann Series in Data Management Systems) (Paperback)

I have worked with serveral different RDBMS packages, but up until the last year never with DB2. Every database has their own SQL idiosyncracies and C/C++ interfaces so I needed a guide that would work both for someone new to the DB2 database but also for an experienced programmer.

I found Chamberlin's book to fit that need exactly. It covers everything from the basics on up to the in-depth details of database application programming. I have never been in a situation when I could not find the information I needed. I have also noticed that it is the resource of choice for our databse administrators.

"Using the New DB2" has great examples, ranging from simple SELECT statements to setting up full-scale applications making database calls with a host language. The text is very readable and informative. You will not find yourself falling asleep because an explanation was dry or too long or too short, too simple or too complex. It really fits all needs.

I give it 2 thumbs up!

5.0 out of 5 stars A well-written guide to IBM's DB2 for common servers, February 15, 1997

By A Customer

This review is from: Using the New DB2: IBM's Object-Relational Database System (Morgan Kaufmann Series in Data Management Systems) (Paperback)

This book offers a lucid presentation of the major features of the IBM DB2 for common servers products, which run on UNIX and PC platforms. The emphasis is on support for newer SQL features such as triggers and stored procedures that make DB2 an "object-relational" system. The book, which is replete with tips and examples, is useful both as a reference and a how-to guide. I would not recommend this book for beginners, i.e., those without some hands-on experience with a relational Database Management System; although the book is clearly written, the subject matter covered is broad and necessarily compressed, even within 682 pages. This book was recommended by IBM as a study aid for their new DB2 professional certification program, before the release of the DB2 Certification Guide for common servers book