|
|
| |
 |
|
Oracle Tips
by Burleson Consulting
|
The Data Warehouse Development Life Cycle
Aggregating Data For The Oracle Warehouse
Summary
Now that you have a fundamental understanding of OLAP and
do-it-yourself data aggregation techniques, we are ready to dive
into the internals of the Oracle database. Subsequent chapters will
take a close look at how to tune the Oracle architecture for data
warehousing and the issues involved with managing Oracle locks and
tuning Oracle SQL. Even if you are an experienced Oracle
professional, I suggest that you take the time to read these
chapters. The information is directly related to data warehousing,
and some of the tuning tips are not intuitive.
SQL utilities to detect and correct row chaining, see
Chapter 10, Oracle Data Warehouse Utilities.
 |
Expert Remote DBA
BC is America's oldest and largest Remote DBA Oracle support
provider. Get real Remote DBA experts, call
BC Remote DBA today. |
 |
|
|
|
|