Oracle 10g Data Warehousing

✍ Scribed by Lilian Hobbs

• Publisher: Digital Press
• Year: 2004
• Tongue: English
• Leaves: 855
• Category: Library

✦ Synopsis

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 technology, this thoroughly updated and extended edition provides an insider's view of how the Oracle Database 10g software is best used for your application.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. This book will show you how to deploy the Oracle database and correctly use the new Oracle Database 10g features for your data warehouse. It contains walkthroughs and examples on how to use tools such as Oracle Discoverer and Reports to query the warehouse and generate reports that can be deployed over the web and gain better insight into your business.This how-to guide provides step by step instructions including screen captures to make it easier to design, build and optimize performance of the data warehouse or data mart. It is a 'must have' reference for database developers, administrators and IT professionals who want to get to work now with all of the newest features of Oracle Database 10g. 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, including: 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 warehouseenvironment* Using the new management infrastructure in Oracle Database 10g and how this helps you to manage your warehouse environment

✦ Table of Contents

Cover......Page 1
Contents......Page 7
Foreword......Page 19
Preface......Page 21
Acknowledgments......Page 24
1 Data Warehousing......Page 27
2 Designing a Warehouse......Page 49
3 Architecture of a Data Warehouse......Page 98
4 Physical Desigh of the Data Warehouse......Page 137
5 Loading Data into the Warehouse......Page 179
6 Querying the Data Warehouse......Page 278
7 Summary Management......Page 344
8 Dimensions......Page 389
9 Query Rewrite......Page 405
10 Tuning Query Performance......Page 450
11 Managing the Warehouse......Page 498
12 Backup and Recovery......Page 580
13 Oracle Warehousing Tools......Page 612
14 Data Warehousing and the Web......Page 674
15 OLAP......Page 691
16 Oracle Data Mining......Page 745
17 High Availability and a Data Warehouse......Page 776
A The Schema for Easy Shopping Inc.......Page 813
B Product Information......Page 821
Index......Page 823