Oracle Tips  by Burleson Consulting

The Data Warehouse Development Life Cycle

Data Warehouse Development Methods  
Warehouse End-user Requirements
Not concerned about end-user analysis? Yes! When you approach your end-user community, especially those who have not used a data warehouse before, you will be met with blank stares when you begin to gather data analysis requirements. Many experienced warehouse developers attest that the end-users become increasingly sophisticated in their use of the data warehouse, largely as a function of becoming familiar with the power of the system. Initially, all the warehouse designer needs to address is getting the data into the warehouse. The uses for the data will follow when the end-user community becomes familiar with the data delivery vehicle and recognizes the potential types of data analysis that can be delivered by your warehouse.

When a data warehouse system is delivered, end-users initially tend to make simple queries, followed by an ongoing cycle or more and more complex types of data analysis. In general, the following progression of usage takes place for a brand-new data warehouse.

If you like Oracle tuning, you may enjoy the book Oracle Tuning: The Definitive Reference , with over 900 pages of BC's favorite tuning tips & scripts.  You can buy it directly from the publisher and save 30%, and get instant access to the code depot of Oracle tuning scripts.