Chapter 4. Star Schema Universe
Let me start this chapter by restating this book's mission statement:
To serve as the DBA's definitive and detailed reference regarding the successful design, construction, tuning, and maintenance of star schema data warehouses in Oracle 8i and 9i.
Note that “star schema” is much more than a term; it's a mindset. In fact, it's as big a leap in theory and technique as between hierarchical and relational databases. This mindset applies first and foremost to database design and tuning techniques. But more importantly, it directly controls which Oracle optimizer features can best be leveraged and the resulting query explain plans that can possibly be achieved.
If you're the DBA for a star schema data warehouse, then ...
Get Oracle® DBA Guide to Data Warehousing and Star Schemas 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.
