In our quest to share our endless wisdom (ahem…) one of the things we figured might be handy is recording some of the best practices for data warehousing. And so we did. And, we did some more…

We now have recreated our websites on Oracle Technology Network and have a separate page for best practices, parallelism and other cool topics related to data warehousing.

But the main topic of this post is the set of recorded best practices. Here is what is available (and it is a series that ties together but can be read independently), applicable for almost any database version:

• Partitioning
• 3NF schema design for a data warehouse
• Star schema design
• Data Loading
• Parallel Execution
• Optimizer and Stats management

The best practices page has a lot of other useful information so have a look here.