Data Warehousing with ORACLE
Bring me home...
If you have problems viewing some of the pdf documentation links provided on this page,
try right click on the links from your browser and "save target" instead. There might be problems
viewing them in the browser when the pdf files are too big.
Data warehousing FAQs
ORACLE server techonology: the warehouse backend
--->>> Querying <<<---
Hierachical queries in Data Warehousing
Tuning star queries with star transformation
--->>> Integrity constraints <<<---
Integrity constraints maintainence
Unique constraint summary
Primary key summary
--->>> Indexing <<<---
Avoid PK non-unique index maintainence
Avoid UK non-unique index maintainence
Bitmap Join Index on a star schema
Bitmap Join Index on a snow flake schema
Execution plan of a snow flake/BJI
--->>> Data loading <<<---
Generate surrogate key with SQL*Loader
External table
Bulk data loading methods
--->>> DOCs <<<---
ORACLE9i Data Warehousing Guide
ORACLE Warehouse Builder: the ETL tool
--->>> DOCs <<<---
OWB overview
Implementing slowly changing dimension
Put ORACLE external tables to work
The runtime environment of OWB
Oracle9i Warehouse Builder User's Guide
Oracle9i Warehouse Builder Transformation Guide
Oracle9i Warehouse Builder Installation Configuration Guide
ORACLE Discoverer: the reporting frontend
--->>> DOCs <<<---
ORACLE9i Discoverer Administrator tutorial
ORACLE9i Discoverer Administration Guide
ORACLE9i Discoverer Desktop User's Guide
Favorite Data Warehousing books
OLAP solutions comparison