HOME
SEARCH
BLOG
SCRIPTS
CONTACT
SEARCH
SEARCH
Disclaimer:
Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
×
BOOK ORACLE DATA WAREHOUSE MANAGEMENT
DOWNLOAD
SUMMARY
Items Found:
50
Introduction 1
Hour 1: 2
Conceptual Overview 2
Objectives: 2
Data Systems Architectures 2
Data Warehouse Concepts 7
Objectives: 7
Data Warehouse Terminology 8
Data Warehouse Storage Structures 10
Data Warehouse Aggregate Operations 11
Data Warehouse Structure 11
Objectives: 11
Schema Structures For Data Warehousing 11
Oracle and Data Warehousing 15
Hour 2: 15
Oracle7 Features 15
Objectives: 15
Oracle7 Data Warehouse related Features 15
Oracle8 Features 19
Objectives: 19
Partitioned Tables and Indexes 20
Oracle8 Enhanced Parallel DML 22
Oracle8 Enhanced Optimizer Features 24
Oracle8 Enhanced Index Structures 25
Oracle8 Enhanced Internals Features 25
Backup and Recovery Using RMAN 26
COPYRIGHT © 2003 RAMPANT TECHPRESS ALL RIGHTS RESERVED
ROBO BOOKS MONOGRAPH DATA WAREHOUSING AND ORACLE8I
Data Warehousing 201 27
Hour 1: 27
Oracle8i Features 27
Objectives: 27
Oracle8i SQL Enhancements for Data Warehouses 27
Oracle8i Data Warehouse Table Options 31
Oracle8i and Tuning of Data Warehouses using Small Test Databases 36
Procedures in DBMS_STATS 38
Stabilizing Execution Plans in a Data Warehouse in Oracle8i 62
Oracle8i Materialized Views, Summaries and Data Warehousing 68
The DBMS_SUMMARY Package in Oracle8i 74
DIMENSION Objects in Oracle8i 81
Managing CPU Utilization for Data Warehouses in Oracle8i 84
Restricting Access by Rows in an Oracle8i Data Warehouse 103
DBMS_RLS Package 108
Hour 2: 112
Data Warehouse Loading 112
IMPORT-EXPORT 115
Data Warehouse Tools 118
An Overview of Oracle Express Server 118
An Overview of Oracle Discoverer 120
Summary 121