Star Schema Challenges

The more experience you have as an Oracle DBA, the harder you're going find this book's techniques to initially trust. Data warehousing is truly a strange new world for anyone, but especially accomplished DBAs. In particular, star schemas require that you:

  • Throw out your OLTP experience baggage.

  • Be a good dog willing to learn some new tricks.

  • Forget all your Oracle design and tuning Golden Rules.

This is no small challenge. It took me over a year to feel comfortable that what I was doing was right (remember, I had no book such as this to soothe my concerns). All my OLTP DBA counterparts thought I was a “crackpot.” But as I explained to them, my database's temporary and rollback tablespaces were each double the size of their ...

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.