Oracle Data Warehouse Tuning for 10g
Taking users beyond the basics to critical issues in running the most efficient data warehouse applications, this book illustrates how to keep data going in and out in the most productive way possible.
TABLE OF CONTENTS Oracle Data Warehouse Tuning for 10g
Chapter 14: Data Warehouse Architecture
This chapter examines general data warehouse architecture and will be divided between hardware resource usage, including memory buffers, block sizes, and I/O usage. I/O is very important in the data warehouse database. Capacity planning, which is so important to data warehousing, will also be covered. The chapter will be completed with brief information on OLAP and data mining technologies.
14.1 What Is a Data Warehouse?
A data warehouse is usually intended as a tool to allow analysis on huge amounts of historical data. Historical data is often not required by an active database, such as an OLTP transactional database, as archived information conflicts with current activity. However, analysis is well suited to being carried out in data warehouses on large quantities of historical data in order to make assumptions about the future of business activities.
14.1.1 What Is Data Warehouse Architecture?
The architecture of a data warehouse as determined by underlying I/O structure, and the hardware resources available, such as memory in the database server, can greatly affect the performance of that data warehouse. Parallel processing, partitioning, and even clustering can affect how a data warehouse performs. The down side is that the more complexity is included in data warehouse architecture, then the more complex the maintenance of that data warehouse can become.
The crux of data warehouse implementation and architecture is that a data warehouse is intended for use by end users, not by the techies who build the database. The primary purpose of a data warehouse is provision...
Copyright Elsevier Inc. 2005 under license agreement with Books24x7
