|
|
|
|
Oracle Tips
by Burleson Consulting
|
The Data Warehouse Development Life Cycle
Online Analytical Processing and Oracle
Data Warehouses And Multidimensional Databases
* Pre-joining tables together--This is an obtuse way of
saying that a de-normalized table is created from the normalized
online database. A large pre-join of several tables is sometimes
called a fact table in a STAR schema.
* Pre-summarization--This prepares the data for any
drill-down requests that may come from the end user. Essentially,
the different levels of aggregation are identified, and the
aggregate tables are computed and populated when the data is loaded.
* Massive de-normalization--The side effect of very
inexpensive disks has been the rethinking of the merits of third
normal form (3NF). Today, redundancy is widely accepted, as seen by
the popularity of replication tools, snapshot utilities, and non-3NF
databases. If you can precreate every possible result table at load
time, your end user will enjoy excellent response time when making
queries. The STAR schema is an example of massive de-normalization.
* Controlled periodic batch updating--New detail data is
rolled into the aggregate table on a periodic basis while the online
system is down, with all summarization recalculated as the new data
is introduced into the database. While data loading is important, it
is only one component of the tools for loading a warehouse.
|
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. |
|
|
|
|
|