Basic Correlation Multivariate Data Warehouse Oracle Tips by Burleson Consulting

The Data Warehouse Development Life Cycle

Data Warehouse Development Methods  
Warehouse End-user Requirements basic correlation multivariate data analysis

1. Basic analysis--Calculation of averages and sums across salient subject areas. This phase is characterized by a reliance on heuristic analysis methods.

2. Correlation analysis--End-users begin to see the value of their warehouse, and they develop models for correlating facts across data dimensions. This stage marks the beginning of stochastic data analysis.

3. Multivariate data analysis--End-users begin to perform correlations on groups of related facts, and they become more sophisticated in their use of analytical statistics.

---

This is an excerpt from "High Performance Data Warehousing", copyright 1997.

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.