The first part of this chapter builds a data warehouse model that will be
used throughout the remainder of this book. The data warehouse model is
constructed from two relational data model schemas covering demograph-
ics and inventory-accounting. The inventory-accounting database has mil-
lions of rows, providing a reasonable amount of data to demonstrate the
tuning process as this book progresses. The second part of this chapter will
introduce the multifarious methods that can be used to tune a data ware-
house data model. All these methods will be described and demonstrated in
subsequent chapters.
2.1Let’s Build ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.