Chapter 2. Designing a Warehouse

Designing a Warehouse

Readers of this chapter probably fall into one of three categories. They have either:

  1. Never designed a database before

  2. Designed a database for a transaction processing–type system

  3. Built a data warehouse system

In the latter case, you could skip this chapter or use it as a refresher, especially if your last database used Oracle. Therefore, this chapter is aimed at readers who fall into categories one or two, which may surprise the person who has previously designed a non-data warehouse database. Why? Because the skills and techniques used to create a database for a data warehouse will be different from those required for a transaction processing–type (OLTP) system. Consequently, though you will ...

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.