Related Titles from Digital Press
by Pete Smith, Shilpa Lawande, Susan Hillson, Lilian Hobbs
Oracle 10g Data Warehousing
- Copyright
- Related Titles from Digital Press
- Foreword
- Preface
- Acknowledgments
- 1. Data Warehousing
- 1.1. An Introduction to Oracle Database 10g
- 1.2. What Is a Data Warehouse?
- 1.3. A Historical Perspective
- 1.4. Data Warehousing Features in the Oracle Database 10g
- 1.5. Building a Data Warehouse Poses Many Challenges
- 1.6. The Future of Data Warehousing
- 1.7. Summary
- 2. Designing a Warehouse
- 2.1. Designing a Warehouse
- 2.2. Other Design Considerations
- 2.3. Implementing the Design
- 2.3.1. Single Database or Many?
- 2.3.2. Naming Conventions
- 2.3.3. Database Configuration Assistant
- 2.3.4. Which Schema?
- 2.3.5. Data Files and Tablespaces
- 2.3.6. Creating the Fact and Dimension Tables
- 2.3.7. Constraints
- 2.3.8. Indexes
- 2.3.9. Partitioning
- 2.3.10. Materialized Views
- 2.3.11. Security
- 2.3.12. Using the Parallel Option
- 2.4. Testing the Design
- 2.5. The Schema for Easy Shopping Inc.
- 3. Architecture of a Data Warehouse
- 4. Physical Design of the Data Warehouse
- 4.1. Introduction
- 4.2. Data Partitioning
- 4.2.1. How to Partition Data?
- 4.2.2. Range Partitioning
- 4.2.3. Hash Partitioning
- 4.2.4. List Partitioning
- 4.2.5. Composite Partitioning
- 4.2.6. Multicolumn Partition Keys
- 4.2.7. Choosing the Partitioning Method
- 4.2.8. Partitioning Using Oracle Enterprise Manager
- 4.2.9. Partition Maintenance Operations
- 4.3. Indexing
- 4.4. Index-Organized Tables
- 4.5. Data Compression
- 4.6. Summary
- 5. Loading Data into the Warehouse
- 5.1. The ETL Process
- 5.2. Extracting Data from the Operational Systems
- 5.3. Transforming the Data into a Common Representation
- 5.4. Loading the Warehouse
- 5.4.1. Using SQL*Loader to Load the Warehouse
- 5.4.2. The Data File
- SQL*Loader Modes of Operation
- Data Load Options
- Scheduling the Load Operation
- Monitoring Progress of the Load Operation
- Inspecting the SQL*Loader Log
- Optimizing SQL*Loader Performance
- SQL*Loader Direct Path Load of a Single Partition
- Step 1: Create a Tablespace
- Step 2: Add a Partition
- Step 3: Disable All Referential Integrity Constraints and Triggers
- Step 4: Load the Data
- Step 5: Inspect the Log
- Step 6: Reenable All Constraints and Triggers, Rebuild Indexes
- SQL*Loader Parallel Direct Path Load
- Step 1: Disable All Constraints and Triggers
- Step 2: Drop all Indexes
- Step 3: Load the Data
- Step 4: Inspect the Log
- Step 5: Reenable All Constraints and Triggers, Recreate All Indexes
- Transformations Using SQL*Loader
- SQL*Loader Postload Operations
- Step 1: Inspect the Logs
- Step 2: Process the Load Exceptions
- Step 3: Reenable Data Integrity Constraints
- Step 4: Handle Constraint Violations
- Step 5: Enabling Constraints without Validation
- Check for Unusable Indexes
- Rebuild unusable indexes
- 5.4.3. Loading the Warehouse Using Data Pump
- 5.4.4. Loading the Warehouse Using External Tables
- 5.4.5. Loading the Warehouse Using Transportable Tablespaces
- Step 1: Create a Tablespace in the OLTP System
- Step 2: Move the Data for April 2004 into a Table in the Newly Created Tablespace
- Step 3: Alter the Tablespace So That It Is Read-Only
- Step 4: EXPORT the Metadata
- Step 5: Convert the Datafiles (Optional)
- Step 6: Transport the Tablespace
- Step 7: Import the Metadata
- Step 8: Alter the Tablespace to Read/Write
- 5.4.6. Loading the Dimensions Using SQL MERGE
- 5.5. Transformations inside the Oracle Database
- 5.5.1. Transformations That Cleanse Data and Derive New Data
- 5.5.2. Validating Data Using a Dimension
- 5.5.3. Looking up the Warehouse Key
- 5.5.4. Table Functions
- 5.5.5. Transformations That Split One Data Source into Multiple Targets
- 5.5.6. Moving Data from a Staging Table into the Fact Table
- Step 1: Create a New Tablespace for the Jan Purchases and the Jan Purchases Index
- Step 2: Add a Partition to the Purchases Table
- Step 3: Move the table into the new partition
- Moving Data Using Exchange Partition
- Moving Data Between Tables Using Direct Path Insert
- Creating a New Table Using Create Table As Select
- 5.6. Postload Operations
- 5.7. Using Tools for the ETL process
- 5.8. Summary
- 6. Querying the Data Warehouse
- 6.1. Introduction
- 6.2. The Query Optimizer
- 6.3. Parallel Execution
- 6.4. SQL Features for Querying the Data Warehouse
- 6.4.1. SQL Extensions for Aggregation
- 6.4.2. SQL Functions for Analysis
- Ranking Functions
- PARTITION BY Clause
- Relative Ranking Functions
- WIDTH_BUCKET Function
- Period-over-Period Comparison Functions—LAG and LEAD
- Window Aggregate Functions
- Specifying a Logical Window
- Converting Sparse Data into Dense Form
- OUTER JOIN
- Partition Outer Join
- Reporting Aggregates
- First and Last Functions
- Inverse Percentile
- Hypothetical RANK and Distribution Functions
- Statistical Analysis Functions
- DBMS_STATS_FUNC Package
- CASE Expression
- WITH Clause
- 6.4.3. The SQL Model Clause
- 6.5. Summary
- 7. Summary Management
- 7.1. Summary Tables
- 7.2. Creating a Materialized View
- 7.2.1. Naming the Materialized View
- 7.2.2. The Physical Storage for the Materialized View
- 7.2.3. When Should the Materialized View Be Populated with Data?
- 7.2.4. How Should the Materialized View Be Refreshed?
- 7.2.5. When should the Materialized View be refreshed?
- 7.2.6. Enabling the Materialized View for Query Rewrite
- 7.2.7. Specifying the Contents of the Materialized View
- 7.2.8. Creating a Materialized View in Enterprise Manager
- 7.2.9. Using Summary Management with Existing Summary Tables
- 7.2.10. Partitioning the Materialized View
- 7.2.11. Indexing the Materialized View
- 7.2.12. Security of Materialized Views
- 7.3. Refresh
- 7.4. EXPLAIN_MVIEW Utility
- 7.5. TUNE_MVIEW Utility
- 7.6. Summary
- 8. Dimensions
- 9. Query Rewrite
- 9.1. Setting up Query Rewrite
- 9.2. Types of Query Rewrite
- 9.3. Query Rewrite Integrity Modes
- 9.4. Query Rewrite and Partition Change Tracking
- 9.5. Troubleshooting Query Rewrite with EXPLAIN_REWRITE
- 9.6. Advanced Query Rewrite Techniques
- 9.7. Summary
- 10. Tuning Query Performance
- 10.1. Monitoring Performance
- 10.2. Advisor Central
- 10.3. SQL Access Advisor
- 10.4. SQL Tuning Advisor
- 10.5. Memory Advisor
- 10.6. Troubleshooting Parallel Execution
- 10.7. Plan Stability
- 10.8. Summary
- 11. Managing the Warehouse
- 11.1. What Has to Be Managed
- 11.2. Managing Using Oracle Enterprise Manager
- 11.3. Monitoring the Warehouse
- 11.4. Reorganizing the Warehouse
- 11.4.1. Why Reorganize?
- 11.4.2. Partition Maintenance
- 11.4.3. Index Changes
- 11.4.4. Online Redefinition of Tables
- Online Redefinition via Enterprise Manager
- Online Redefinition Using the DBMS_REDEFINITION Package
- Step 1: Create an Interim Table
- Step 2: Start the Redefinition Process
- Step 3: Create the Dependant Objects
- Step 4: Synchronize the Tables
- Step 5: Finish the Redefinition
- Step 6: Gather Statistics on the Redefined Table
- 11.4.5. Online Segment Shrink
- 11.5. Refreshing the Warehouse
- 11.6. Gathering Optimizer Statistics
- 11.7. Parallel Management Tasks
- 11.8. Maintaining Security
- 11.9. Monitoring Space Usage
- 11.10. Other Management Issues
- 11.11. Summary
- 12. Backup and Recovery
- 13. Oracle Warehousing Tools
- 13.1. Which Tool
- 13.2. Oracle Warehouse Builder
- 13.2.1. Setting up Warehouse Builder
- 13.2.2. Oracle Warehouse Builder Client
- 13.2.3. Data Sources and Targets
- 13.2.4. Defining the Tables in Our Data Warehouse
- 13.2.5. Creating Dimensions
- 13.2.6. Creating a Cube
- 13.2.7. Defining Source to Target Mappings
- 13.2.8. Validating the Design
- 13.2.9. Generating the Design
- 13.2.10. Deploying the Design
- 13.3. Oracle Discoverer
- 13.4. Oracle Reports 10g
- 13.5. Summary
- 14. Data Warehousing and the Web
- 15. OLAP
- 15.1. Why Do We Need the Oracle OLAP Option?
- 15.2. Oracle OLAP Architecture
- 15.3. Analytic Workspaces
- 15.4. The OLAP Catalog
- 15.5. The Analytic Workspace Manager
- 15.6. Querying Analytic Workspaces
- 15.7. Summary
- 16. Oracle Data Mining
- 17. High Availability and a Data Warehouse
- 17.1. Introduction
- 17.2. What Is a Highly Available System?
- 17.3. Overview of Oracle Database 10g High Availability Features
- 17.4. Protecting against Hardware/Software Failures
- 17.5. Protecting against Data Loss
- 17.5.1. Recovering from Media Failure
- 17.5.2. Recovery from Human Errors with Flashback
- 17.5.3. Disaster Recovery Using Data Guard
- Data Guard Concepts
- Physical Standby
- Logical Standby
- Logical Standby Databases and Data Warehouse
- Data Guard Configuration
- Data Guard Broker
- Using Oracle Enterprise Manager to Configure Data Guard
- Data Guard Protection Modes
- Maximum Protection Mode
- Maximum Performance Mode
- Maximum Availability Mode
- Switching Roles From Primary to Standby Database
- 17.5.4. Oracle Maximum Availability Architecture
- 17.5.5. Protecting Metadata
- 17.6. Managing Planned Downtime
- 17.7. Information Lifecycle Management
- 17.8. Summary
- A. The Schema for Easy Shopping Inc.
- B. Product Information
Oracle 9iR2 Data Warehousing, Hobbs, et al ISBN: 1-55558-287-7, 2004 |
Oracle High Performance Tuning for 9i and 10g, Gavin Powell, ISBN: 1-55558-305-9, 2004 |
Oracle SQL Jumpstart with Examples, Gavin Powell, ISBN: 1-55558-323-7, 2005 |
Oracle Real Applications Clusters, Murali Vallath, ISBN: 1-55558-288-5, 2004 |
For more information or to order these and other Digital Press titles, please visit our website at www.books.elsevier.com/digitalpress! |
At www.books.elsevier.com/digitalpress you can: |
•Join the Digital Press Email Service and have news about our books delivered right to your desktop •Read the latest news on titles •Sample chapters on featured titles for free •Question our expert authors and editors •Download free software to accompany select texts |
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.