Chapter 12. Warehouse Schema Design

Dimensional modeling is a term used to refer to a set of data modeling techniques that have gained popularity and acceptance for data warehouse implementations. The acknowledged guru of dimensional modeling is Ralph Kimball, and the most thorough literature currently available on dimensional modeling is his book entitled The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses, published by John Wiley & Sons (ISBN: 0-471-15337-0).

This chapter introduces dimensional modeling as one of the key techniques in data warehousing and is not intended as a replacement for Ralph Kimball's book.

OLTP Systems Use Normalized Data Structures

Most IT professionals are quite familiar with normalized ...

Get Data Warehousing: Architecture and Implementation now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.