Chapter 9. Operational Issues and More

After the base database objects have been created and the initial data has been loaded, you have a candidate production data warehouse. You might begin with just a few facts and some simple aggregates, and you might have just a few hundred million rows to start, but the general concepts of how to successfully deploy and manage that data warehouse will remain exactly the same as you scale from these very humble beginnings into a full-fledged, multi-terabyte behemoth. Always bear in mind just how big you think the data warehouse will be 12 months into the future when making any operational support decisions. If you don't, then you will most definitely want to keep your resume up-to-date for when you run into ...

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.