Oracle9iR2 Data Warehousing
Oracle9iR2 Data Warehousing
ISBN: 1555582877
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 91
Pages: 91
- Table of Contents
- Back Cover
- Oracle 9iR2 Data Warehousing
- Foreword
- Preface
- Chapter 1: Data Warehousing
- What is a data warehouse?
- A historical perspective
- Oracle 9i
- Building a data warehouse poses many challenges
- The future of data warehousing
- Chapter 2: Designing a Warehouse
- Other design considerations
- Implementing the design
- Testing the design
- The schema for Easy Shopping Inc.
- Chapter 3: Data Warehouse Features
- Indexing
- Data partitioning
- Data compression
- Query optimization techniques
- Automatic memory management
- SQL functions
- Parallelism
- Summary
- Chapter 4: Summary Management
- Creating a materialized view
- Refresh
- EXPLAIN_MVIEW utility
- Dimensions
- Query rewrite
- Summary Advisor
- Summary
- Chapter 5: Loading Data into the Warehouse
- Extracting data from the operational systems
- Transforming the data into a common representation
- Loading the warehouse
- Transformations inside the Oracle Server
- Postload operations
- Using tools for the ETL process
- Summary
- Chapter 6: Oracle Warehousing Tools
- Oracle Warehouse Builder
- Oracle Discoverer
- Chapter 7: Managing the Warehouse
- Managing using Oracle Enterprise Manager
- Backup and recovery
- Disaster recovery
- Reorganizing the warehouse
- Refreshing the warehouse
- Gathering optimizer statistics
- Parallel management tasks
- Tuning the warehouse
- Maintaining security
- Monitoring space use
- Other management issues
- Summary
- Chapter 8: Data Warehousing and the Web
- Oracle 9i Application Server
- Oracle 9i Reports
- The data warehouse and e-business intelligence
- Chapter 9: Oracle 9i OLAP and Data Mining
- Oracle Data Mining
- Summary
- Appendix
- index_A
- index_B
- index_C
- index_D
- index_E
- index_F
- index_G
- index_H
- index_I
- index_J
- index_K
- index_L
- index_M
- index_N
- index_O
- index_P
- index_Q
- index_R
- index_S
- index_T
- index_U
- index_V
- index_W
- List of Figures
- List of Tables
Oracle9iR2 Data Warehousing
ISBN: 1555582877
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 91
Pages: 91