Efficient execution of joins in a star schema
Proceedings of the 2002 ACM SIGMOD international conference on Management of data
Performance evaluation of linux file systems for data warehousing workloads
InfoScale '06 Proceedings of the 1st international conference on Scalable information systems
| Hi-index | 0.00 |
From the Book:This book is a complete guide to the IBM's relational database servers, known as DB2 Universal Database Version 7.1. DB2 Universal Database (DB2 UDB) Version 7.1 is available on many operating systems, and the book has been written with this in mind. Any significant differences in the implementation of DB2 UDB on various operating systems are highlighted. If you are planning to become certified, or you would simply like to understand the powerful new DB2 UDB database servers from IBM, then read on. Those interested in becoming an IBM Certified Professional will want to review the sample questions at the end of this book. The book is divided into four parts: Part 1Introduction to DB2 UDB (Chapters 1-4). Installing and configuring DB2 UDB servers and clients are covered in Chapters 1, 2, 3, and 4. Part 2Using SQL (Chapters 5-8). The Structured Query Language (SQL) is discussed in Chapter 5, 6 and 7. Database concurrency is discussed in Chapter 8. Part 3DB2 UDB Database Administration (Chapters 9-12). Creating a DB2 UDB database and its related table spaces is covered in Chapter 9. The common administration tasks are discussed in Chapters 10 and 11. Database monitoring and performance considerations are discussed in Chapter 12. Part 4Developing Applications with DB2 UDB (Chapters 13-14).An introduction to application development for DBAs is given in Chapter 13. Chapter 14 deals with some of the DBA activities that are related to application development. SQL used in a programming environment is discussed in chapter15. This book can be used as a self-study guide to help you prepare for the DB2 Universal Database V7.1 certification exams or as a guide to DB2 Universal Database V7.1. The test objectives are provided in Appendix A. These should be used as a guide to ensure that you are fully prepared to take the DB2 UDB V7.1 exams.Experience with DB2 Universal Database Version 7.1 is the best way to prepare for any of these DB2 UDB V7.1 certification exams. Use this Certification Guide in conjunction with your day-to-day use of DB2 UDB V7.1 to assist you in preparing for exams 512 and 513. A companion book, DB2 Universal Database Version 7.1 Application Development Certification Guide, will help you prepare for exam 514. The DB2 Family Fundamentals (512) exam covers these skills: Understanding DB2 products and components Creating database objects Understanding various DB2 data types Using SQL to manipulate database objects Describing DB2 concurrencyFor more details on the test objectives of this exam, see "DB2 Family Fundamentals (512)" on page 744.The DB2 for OS/2, Windows, UNIX, and Linux Database Adminstration (513) exam covers these skills: Managing DB2 instances Creating and maintaining database objects Managing table spaces Using utilities: IMPORT, LOAD, REORG, RUNSTATS Managing recovery procedures (BACKUP/RESTORE) Analyzing resource problemsFor more details on the test objectives of this exam, see "DB2 for OS/2, Windows, and UNIX Database Administration (513)" on page 746.Note: More information about DB2 UDB certification can be found at http://www.ibm.com/certify.