Oracle 10g Data Warehousing

"Whether you are designing a large or small data warehouse, or looking for tips on how to improve performance using Oracle Database 10g, this book will provide you with advice and examples you can follow. It also includes thorough coverage of the data warehouse features in Oracle Database 10g, and the tools in Oracle Application Server 10g." Chuck Rozwat, Executive Vice President, Server Technologies, Oracle Corporation 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 insiders 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, 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 todays 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 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. * Presents concepts with working examples * Describes best practices and critical implementation tradeoffs, based on users actual implementations. Lilian Hobbs is a Senior Principal Product Manager at Oracle responsible for Summary Management, Online Operations, ILM and XA and Transactions. Lilian holds a Phd awarded by Southampton University and has worked in the computer industry for over 25 years. Shilpa Lawande is a Principal Developer in the Server Technologies division at Oracle and has contributed to several major features in the Oracle Database including Materialized Views and SQL Access Advisor. Shilpa has a Bachelors degree in Computer Science and Engineering from Indian Institute of Technology, Bombay, and a M.S. in Computer Science from University of Wisconsin-Madison. Susan Hillson was a Senior Director of Engineering at Oracle, responsible for developing Summary Management, Change Data Capture, the Database Utilities, and Oracle Dataguard. Susan holds a Masters degree in Computer Information Systems from Boston University, and has over 25 years of experience in the computer industry. Pete Smith is a Technical Architect and a data warehouse and database server specialist with 20 years experience in the IT industry. During that time Pete has worked as an independent Oracle consultant, a Principal Consultant with Oracle UK and is currently a Senior Business Intelligence Consultant for Conchango, a UK business technology provider and IT consultancy.Susan Hillson MS in CIS Boston University is the author of 'Oracle 10g Data Warehousing', published 2004 under ISBN 9781555583224 and ISBN 1555583229.