Oracle 10g Data Warehousing - 1st Edition - ISBN: 9781555583224, 9780080513287

Oracle 10g Data Warehousing

1st Edition

Authors: Lilian Hobbs Susan Hillson Shilpa Lawande Pete Smith
eBook ISBN: 9780080513287
Paperback ISBN: 9781555583224
Imprint: Digital Press
Published Date: 17th November 2004
Page Count: 872
Sales tax will be calculated at check-out Price includes VAT/GST
71.95
53.96
53.96
53.96
57.56
53.96
53.96
57.56
94.95
71.21
71.21
71.21
75.96
71.21
71.21
75.96
96.36
72.27
72.27
72.27
77.09
72.27
72.27
77.09
7900.00
5925.00
5925.00
5925.00
6320.00
5925.00
5925.00
6320.00
65.99
49.49
49.49
49.49
52.79
49.49
49.49
52.79
Unavailable
Price includes VAT/GST
68.95
51.71
51.71
51.71
55.16
51.71
51.71
55.16
90.95
68.21
68.21
68.21
72.76
68.21
68.21
72.76
84.95
63.71
63.71
63.71
67.96
63.71
63.71
67.96
54.99
41.24
41.24
41.24
43.99
41.24
41.24
43.99
Unavailable
Price includes VAT/GST

eBook format help

Institutional Subscription

Support Center

Secure Checkout

Personal information is secured with SSL technology.

Free Shipping

Free global shipping
No minimum order.

Description

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.

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

Professional data warehouse designers and administrators. Anyone who has to build or manage a data warehouse or data mart or anyone who simply wants more information on the 10g products and features in the data warehouse context

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

Details

No. of pages:
872
Language:
English
Copyright:
© Digital Press 2005
Published:
Imprint:
Digital Press
eBook ISBN:
9780080513287
Paperback ISBN:
9781555583224

About the Author

Lilian Hobbs

Lilian Hobbs is a member of the Oracle Corporation New England Development Centre living in the UK. During the day she works on Oracle databases, but when she isn't writing books, Lilian is a keen astronomer and mountain bike rider. To find out more about this author you can visit her Web site at home.clara.net/lmhobbs. Lilian is the author of the following Made Simple books: Designing Internet Home Pages; Windows NT. Also, she is the author of the following Digital Press Books: RdB: A Comprehensive Guide; Digital's CDD/Repository (with Ken England); Oracle8i Data Warehousing.

Affiliations and Expertise

Senior Principal Product Manager in Oracle's New England Development Center.

Susan Hillson

Susan Hillson is a Senior Director of Engineering Development at Oracle. Her group is responsible for the development of Summary Management, Oracle Data Guard, and

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

Former Senior Director of Data Server Division, Oracle Corporation's New England Development Center, Nashua, NH

Shilpa Lawande

Shilpa Lawande is a principal developer in Oracles's Server Technologies Division. She is a member of the team that introduced materialized view technology into the Oracle server.

Shilpa has a BA from Indian Institute of Technology, Bombay, and a Master’s degree in Computer Science from University of

Wisconsin-Madison.

Affiliations and Expertise

Senior Developer in the Server Technologies division at Oracle's New England Development Center, Nashua, NH

Pete Smith

Pete Smith is a Technical Architect and data warehouse specialist with a wide range of expertise from application analysis, design and development through to database design, administration and tuning. This experience covers 19 years in the IT industry, 14 of which are specifically on Oracle platforms and demonstrates a high degree of longevity and familiarity with the Oracle database server and associated products. Qualified to degree level, Pete has worked for many years as an independent Oracle consultant and, more recently, in a senior position as a Principal consultant with Oracle UK; Pete now works for a specialist UK IT consultancy.

Affiliations and Expertise

Senior Business Intelligence Consultant with Conchango, UK

Reviews

"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

Ratings and Reviews

Request Quote

Tax Exemption

We cannot process tax exempt orders online. If you wish to place a tax exempt order please contact us.