DB2 Universal Database UDB supports many different types of applications, on many different kinds of data, in many different software and hardware environments.This book provides a complete guide to DB2 UDB Version 5 in all its aspects, including the interfaces that support end users, application developers, and database administrators It is complementary to the IBM product documentation, providing a clear and informal explanation of how the features of DB2 were intended to be used It is an extensive revision of the author s earlier book, Using the New DB2 IBM s Object Relational Database System.Offers complete and self contained information, and does not assume prior knowledge of DB2, SQL, or relational database conceptsCovers elementary principles of database management as well as the advanced features of UDB, including recursive queries, constraints, triggers, user defined datatypes, stored procedures, parallel databases, and graphical tools for database administrationIncludes dozens of practical tips that will save readers many hours of work in developing database applications...
|Title||:||A Complete Guide to DB2 Universal Database (The Morgan Kaufmann Series in Data Management Systems)|
|Publisher||:||Morgan Kaufmann 1 edition June 15, 1998|
|Number of Pages||:||816 pages|
|File Size||:||873 KB|
|Status||:||Available For Download|
|Last checked||:||21 Minutes ago!|
A Complete Guide to DB2 Universal Database (The Morgan Kaufmann Series in Data Management Systems) Reviews
It was a good buy because, the book is in good condition, although it was used.
As an experienced DBA and DB developer in just about every major DB product except DB2, I was disappointed that there is no book on the market explaining "in DB2, feature A works like this; feature B goes like that; feature C is entirely unique, etc. etc."
I usually stay away from computer books entitled "Complete Guide to..." or 'Complete Reference of..." as they are usually pretty worthless, being clogged up with snapshots of the administrators console and windy discussions of mundane administrative tasks. This book was different.
It is clear that Don Chamberlin knows the DB2 product. It is also refreshing to read an up-to-date book that isn't full of spelling and grammer errors. This book will get you up and running on DB2 without being a DBA. (There is plenty of time for that later). DB2 UDB graphic interface is a giant step forward for IBM! There is some reference to using DB2 UDB with Java but not very much.
Don's "A Complete Guide..." is both, TOP-SHELF; and a CARRY-ON ITEM (wgth:28.35ozs, 1,347grams). Don and his editorial team have achieved an enjoyable; comprehensive; and succinct treatment of DB2/UDB in a mere 767 pages. More than just a great guide, Don gives us glorious insights into our burgeonning world of multi-Domain Enterprise Servers, --so anyone involved in learning more about the "Open" approach will enjoy it. The Table of Contents reads as a Primary-Menu to the evolving family of DB2 system products and provides very nice gleanings of the emerging SQL3 forward posture.
The idea of a universal database (UDB) was invented as a reaction to object-oriented databases of the early 1990s from Object Store, Gemstone, and Versant. Capabilities were added to the prevailing dominant design of relational database management systems (RDBMs), including user defined functions and data types, enhanced stored procedures and triggers (active database components), and SQL extensions. It is a winning idea and one that has gained "top of mind position" in the market, relating the n-relational competition to niche players. One of the ironies of technology is that you can tell the pioneers by the arrows in their back. In many instances IBM has been first, and has the arrows to prove it. In the instance of UDB this was not the case - the term having been popularized elsewhere - but they have had the opportunity to leap-frog the competition. Don Chamberlin's comprehensive guide to the product - DB2 UDB - is suitable for entry level database developers as well as advanced technicians. It is a pleasure to find such a formidable subject treated in such a readable, professional, and entertaining way without assuming that the audience is in any way intellectually challenged (as, for example, occasionally happens in the dummy series). The opening chapter contains a fascinating brief history of structured query language (SQL) in which the author and his colleague Ray Boyce are deservedly credited with the invention of what has proved to be a powerful and compelling non-procedureal English-like interface to relational databases. Query Power (Chapter Five) starts looking at interesting SQL extensions, include new built in functions of the kind useful in data warehousing (and decision support) applications), rollup, cube and grouping sets. This illustrates a familiar feature of technology innovation and evolution - built in functions that required purchase of separate proprietary products such as Red Brick - are now bundled as part of the UDB product. An especially engaging fact is that the approach to Stored Procedures enabled by IBM makes use of procedural languages - C, C++, a version of Basic, and (note well) Java - as the host code in which the SP's SQL is embedded. This sets a standard for openness, interoperability, and portability, which may make the other database vendors with proprietary scripting languages cringe. A possible outcome: Convergence on Java. It is hard to imagine that in a superbly written book of nearly 800 pages, six useful appendices, an excellent detailed index, supplementary exercises on the Web, anything more could be said. Even the on-going "Webificaiton" of the planet falls within the horizon, since dynamic SQL with Java receives a useful treatment with sample program (pp. 498ff). The nicely edited and prepared text is supplemented with charming illustrations by Duane Bibby of a bird-like creature, which seems to morph between a sea gull and an owl, depending on the context, but actually looks to me like Don Haderle of the IBM Santa Teresa DB2 Lab (who writes a nice forward). For a database professional or a developer accessing DB2 data through UDB, this text is likely to become a well-worn and dog-eared resource, making life in the software trenches a bit less difficult and more like operating within the horizon of an object-relational future towards which so many projects are converging. --excerpt from my review published in Computing Reviews, November 1998
Common table expressions and super groups are very well explained in this book, with many detailed examples . The examples progress in a well defined manner. I agree with jbrunton that more Java JDBC and SQLJ examples would be useful.