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