O'Reilly logo

Data Warehousing: Architecture and Implementation by Michelle C. Dy, Michael W. Hawkins, Mark Humphries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required