Chapter 4. Physical Design of the Data Warehouse
Introduction
In the previous chapters, we discussed the high-level architecture of a data warehouse and logical design concepts such as dimensional modeling. We also gave an overview of creating the database and all the different structures you will encounter in designing your database. Due to the large volumes of data handled by a data warehouse, it is important to have a physical design that supports both efficient data access and efficient data storage. In this chapter, we will discuss various techniques for physical design, such as partitioning and indexing, to improve the data access performance in a data warehouse. We will also discuss data compression, which can help reduce the storage requirements ...
Get Oracle 10g Data Warehousing now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
