DB2 harnesses the power of the latest and most robust architecture of OS/2, Windows 95/98/NT and UNIX. This book is the definitive resource for both novice and more experienced end-users and programmers, and for those who want to maximize the potential of DB2. Whether used as a step-by-step guide or as a companion reference tool, this book covers the following subjects: DB2 client and server, database design, SQL, DB2 application development (Java, REXX, C, C++, and COBOL), distributed databases, and a complete reference for DB2 built-in functions and commands.
Book Description
Editorial Reviews
About the Author
V. Mitra Gopaul is an independent consultant based in Ontario, Canada, offering his expertise to such major international companies as Merrill Lynch, IBM, XEROX, and the Royal Bank of Canada. Active for more than 25 years in the data processing field, he currently specializes in software development and database administration. He has extensive experience in relational databases including DB2, Oracle, and Informix. He has also written many computer books including DB2 2.1 for OS/2 Made Easy and IBM Mainframe Programmer's Desk Reference.
Product Details
Would you like to update product info or give feedback on images?
|
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
1 of 1 people found the following review helpful:
4.0 out of 5 stars
An Excellent book,
By A Customer
This review is from: DB2 Universal Database for Client/Server. (Concepts, Design, Programming, and Reference) (Paperback)
I found this book very valuable. I am just starting to use DB2. I have no background in relational database. This book has help me a lot to understand basic concepts of database, especially DB2. I recommend it!!!!
1 of 1 people found the following review helpful:
4.0 out of 5 stars
A Good For Understanding Basic DB2 Concepts,
By A Customer
This review is from: DB2 Universal Database for Client/Server. (Concepts, Design, Programming, and Reference) (Paperback)
What is Client/Server Architecture? How does DB2 Universal meet the challenges imposed by this architecture? What are the key concepts and terminology you have to become familiar with? What is a Relational Database System, and what are the steps required to design the database for your application? Do you need a good, wide ranging, introduction (with examples) to the SQL language? What do you need to know to develop DB2 applications, write interactive SQL queries to extract information, and maintain your databases? Any one looking for help with any or all of these questions will find Mitra's book to be of great benefit. Let us now get down to specifics of this book.An overview of the Client/Server architecture presents the main components (client, server and middleware). Industry standards are then discussed. The next chapter is devoted to DB2 Client issues, including set up and enabling of clients, software development (Developers kit), and on protocols used to communicate with the server(s). Another chapter describes the DB2 UDB as a Server. After introducing the Relational Database concept, the components (DB2 objects) are defined. Coverage includes the usual objects such as tables, columns, indexes etc., plus objects such as Packages, Stored Procedures, Triggers, and Functions. Table and Referential Integrity are discussed, and the Schema concept is introduced. The SQL language and its three components - DML (Data Management Language), DDL (Data Definition Language) and DCL (Data Control Language) - are presented. Data Base Design is addressed next. Business Information gathering, Logical Database Design, the Normalization process, and the establishment of Entity and Referential Integrity rules are covered. The Physical database is then designed using the information gathered plus performance requirements. The use of DDL to create DB2 objects and to define Table and Referential Integrity Rules, is demonstrated using an extensive set of examples. The use of DDL to Alter and/or Drop DB2 objects, is also explained. Data Manipulation is the subject of a separate chapter and is an excellent tutorial on the basic features of SQL (DML). Using examples, the basic SQL patterns are illustrated. The next chapter expands on this theme covering more advanced features such as subqueries, the EXISTS clause, Unions, Joins and Check Constrains. The concept of Outer Join is introduced (no example is provided, however). User Defined Data Types (UDTs), User Defined Functions(UDFs), Large Objects, Views (virtual tables), and Database Triggers are introduced and illustrated. The chapter on Distributed Relational Database Architecture (DRDA) discusses the DDCS connectivity product (now called DB2 Connect), the Unit of Work concept, Database Directories, and Administration issues. Both the Open Database Connectivity (ODBC) architecture and its Java incarnation (JDBC), are described. Application design is the subject of another chapter. Access Methods (embedded SQL) and Transaction Processing are defined. Embedded (static and dynamic) SQL programming is illustrated with examples using C/C++. The SQL Cursor, needed to handle Result Sets, is well described using examples. Application Design using the Call Level Interface(CLI) is demonstrated using REXX and JAVA examples. The book has comprehensive Reference chapters for Built-In functions and Command Line Process Commands. In conclusion, the book meets its stated goal very well. For those who would like to develop their expertise further, I suggest that future editions include lists for further reading. Additionally, a chapter on the DB2 Catalog Tables/Views would enhance the Reference value of this book.
1 of 1 people found the following review helpful:
5.0 out of 5 stars
USEFUL AND EASY TO UNDERSTAND,
By A Customer
This review is from: DB2 Universal Database for Client/Server. (Concepts, Design, Programming, and Reference) (Paperback)
I found this book very useful. The explanations of relational databases, SQL, and DB2 are very easy to undertand. Highly recommended.Also, a reference to all the DB2 commands with clear descriptions and examples makes this book very valuable for a long time.
Share your thoughts with other customers: Create your own review
|
|
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
