
Oracle 10g Data Warehousing
Description
Key Features
It provides a detailed look at the new features of Oracle Database 10g and other Oracle products and how these are used in the data warehouse
- How to use the Summary Management features, including Materialized Views and query rewrite, to best effect to radically improve query performance
- How to deploy business intelligence to the Web to satisfy today's changing and demanding business requirements
- Using Oracle OLAP and Data Mining options
- How to understand the warehouse hardware environment and how it is used by new features in the database including how to implement a high availability warehouse environment
- Using the new management infrastructure in Oracle Database 10g and how this helps you to manage your warehouse environment
Readership
Table of Contents
- Foreword
Preface
Acknowledgements
1. Data Warehousing
2. Designing a Warehouse
3. Architecture of Data Warehouse
4. Physical Desing of the Data Warehouse
5. Loading Data into the Warehouse
6. Querying the Data Warehouse
7. Summary Management
8. Dimensions
9. Query Rewrite
10. Tuning Query Performance
11. Managing the Warehouse
12. Backup and Recovery
13. Oracle Warehousing Tools
14. Oracle 9i OLAP and Data Mining
15. OLAP
16. Oracle Data Mining
17. High Availability and a Data Warehouse
A. The Schema for Easy Shopping Inc.
B. Product Information
Product details
- No. of pages: 872
- Language: English
- Copyright: © Digital Press 2004
- Published: November 17, 2004
- Imprint: Digital Press
- Paperback ISBN: 9781555583224
- eBook ISBN: 9780080513287
About the Authors
Lilian Hobbs
Affiliations and Expertise
Susan Hillson
the Database Utilities. She holds a MS degree in Computer Information Systems from Boston University. Susan has over 20 years’ experience in the computer industry,
including over 6 years teaching programming and database management systems. Susan co-authored Oracle8i Data Warehousing (Digital Press, 2000).
Affiliations and Expertise
Shilpa Lawande
Shilpa has a BA from Indian Institute of Technology, Bombay, and a Master’s degree in Computer Science from University of
Wisconsin-Madison.