ebook-Deploying Oracle9i RAC on eServer Cluster 1600 with GPFS by Ibm Download

This IBM Redbook explores the steps for installing Oracle 9i RAC in an IBM Cluster 1600. GPFS is implemented in the Cluster as the file system of choice for Oracle code and database files.
Performance and availability considerations are presented to show system architects, system administrators, and database administrators how to implement various features of a high performance, high availability database cluster environment.
This book also presents a set of high availability tests and scenarios to help in considering these aspects in the planning and implementation phases.

Download

ebook Download Data Warehousing with DB2 for OS 390 by Ibm

This redbook will help you design and tune DB2 for OS/390 in a data warehousing environment. It contains considerations for modeling, such as the entity relationship and star schema models.
This redbook will also help you evaluate the performance and scalability of DB2 for OS/390 in a data warehousing environment, by providing several measurements performed by IBM with internal and customer data. It proves that DB2 on the S/390 platform is a very good choice for hosting a data warehouse and provides data that supports this statement.
The redbook provides hints on how to design the database and explains how parallelism works and how to take advantage of it.
This redbook discusses choices for database design and SQL tuning for a data warehouse in a parallel multinode environment. It explains how to partition and select keys, which secondary indexes should be added, and how indexes affect canned and ad hoc SQL processing. Real-world data warehouse application examples form the backdrop to the technical analysis in this redbook.
The audience for this redbook is anybody with an interest in data warehousing. Parts of the book can be read by managers and parts of the book are directed to technical professionals, such as database administrators and systems programmers.

Download

Download ebook Data Modeling Techniques for Data Warehousing by Ibm

This redbook gives detail coverage to the topic of data modeling
techniques for data warehousing, within the context of the
overall data warehouse development process.
The process of data warehouse modeling, including the steps
required before and after the actual modeling step, is discussed.
Detailed coverage of modeling techniques is presented in an
evolutionary way through a gradual, but well-managed, expansion
of the content of the actual data model.
Coverage is also given to other important aspects of data
warehousing that affect, or are affected by, the modeling process.
These include architecting the warehouse and populating the data
warehouse.
Guidelines for selecting a data modeling tool that is
appropriate for data warehousing are presented.

Download