Oracle database 10g data warehousing
Oracle 10g Data Warehousing is a guide to using the Data Warehouse features in the latest version of Oracle -Oracle Database 10g. Written by people on the Oracle development team that designed and implemented the code and by people with industry experience implementing warehouses using Oracle techn...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Amsterdam ; London :
ElsevierDigital
c2005.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627075106719 |
Tabla de Contenidos:
- Front Cover; Oracle Database 10 g Data Warehousing; Copyright Page; Contents; Foreword; Preface; Acknowledgments; Chapter 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; Chapter 2. Designing a Warehouse; 2.1 Designing a Warehouse; 2.2 Other Design Considerations; 2.3 Implementing the Design; 2.4 Testing the Design; 2.5 The Schema for Easy Shopping Inc.
- Chapter 3. Architecture of a Data Warehouse3.1 Introduction; 3.2 Hardware Configurations for a Warehouse; 3.3 Hardware Components; 3.4 Automatic Storage Management; 3.5 File Management in Oracle; 3.6 Summary; Chapter 4. Physical Design of the Data Warehouse; 4.1 Introduction; 4.2 Data Partitioning; 4.3 Indexing; 4.4 Index-Organized Tables; 4.5 Data Compression; 4.6 Summary; Chapter 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.5 Transformations inside the Oracle Database5.6 Postload Operations; 5.7 Using Tools for the ETL process; 5.8 Summary; Chapter 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.5 Summary; Chapter 7. Summary Management; 7.1 Summary Tables; 7.2 Creating a Materialized View; 7.3 Refresh; 7.4 EXPLAIN_MVIEW Utility; 7.5 TUNE_MVIEW Utility; 7.6 Summary; Chapter 8. Dimensions; 8.1 Concepts; 8.2 Creating a Dimension; 8.3 Describing a Dimension; 8.4 Validating a Dimension; 8.5 Summary
- Chapter 9. Query Rewrite9.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; Chapter 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; Chapter 11. Managing the Warehouse; 11.1 What Has to Be Managed
- 11.2 Managing Using Oracle Enterprise Manager11.3 Monitoring the Warehouse; 11.4 Reorganizing the Warehouse; 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; Chapter 12. Backup and Recovery; 12.1 Strategy; 12.2 Backup; 12.3 The Recovery Catalog; 12.4 Restore and Recover; 12.5 Summary; Chapter 13. Oracle Warehousing Tools; 13.1 Which Tool; 13.2 Oracle Warehouse Builder; 13.3 Oracle Discoverer; 13.4 Oracle Reports 10g; 13.5 Summary
- Chapter 14. Data Warehousing and the Web
