---

Oracle9iR2 Data Warehousing

ISBN: 1555582877
EAN: 2147483647

Year: 2005
Pages: 91

Authors: Lilian Hobbs, Susan Hillson MS in CIS Boston University, Shilpa Lawande

BUY ON AMAZON

• 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