Oracle Data Warehousing (Oracle Series) [Paperback]

Michael J. Corey (Author), Michael Abbey (Author)

Book Description

ISBN-10: 0078822424 | ISBN-13: 978-0078822421 | Publication Date: November 1996 | Edition: 1

This text provides an introduction to data warehousing, including a description of what it is, the business rationales that will secure essential management buy-in, and how to build an effective data warehousing management team. It gives step-by-step guidance on setting up a data warehouse with Oracle, and provides tips, tricks and techniques on how to make it an effective business tool. Included are discussion of tecnical decisions needed to be made such as choosing RAID technology; running the cost-based optimizer; using read-only tablespaces; warehouse refresh mechanisms; and backup and recovery considerations. It also shows how to convert a legacy system into an Oracle data warehouse and get information on version 7.3's new data warehousing features.

Editorial Reviews

From the Back Cover

ORACLE Data Warehousing Build and Launch the Data Warehouse of the Future. Data warehousing-a breakthrough in large-scale data storage and analysis-is ranked among the most important areas of computing today. Oracle7 is the leading data warehousing product on the market. To master the intricacies of both data warehousing and Oracle7, turn to the book officially authorized by Oracle Corporation, the leading provider of da[Ha warehousing solutions to Fortune 1000 companies. Oracle Data Warehousing is your tactical guide to every important facet of data warehousing with Oracle7 and 7.3. Whether you're a database administrator an information technology manager, a data warehouse team member, or an end user, you'll find valuable advice on how ta data warehouse can benefit your operations, how to gain management's support, how to bring the data warehouse into fruition, and finally, how to maintain it at a supreme performance level. This book discusses: building an effective data warehousing management team; Optimizing the Oracle Server for DSS; Making critical technical decisions such as choosing RAID technology, running the cost-based optimizer, using read-only tablespaces, warehouse refresh mechanisms, and backup and recovery considerations; Converting a legacy database system into an Oracle data warehouse; Exploiting the powerful new data warehousing features in Oracle7.3; Understanding the business rationale that will secure essential management buy-in. To address the full scope of warehousing your data-from the general concepts through the finer points of Oracle7's warehousing capabilities-Oracle Data Warehousing is the only resource available that covers all the bases.

Product Details

• Paperback: 384 pages
• Publisher: Oracle Pr; 1 edition (November 1996)
• Language: English
• ISBN-10: 0078822424
• ISBN-13: 978-0078822421
• Product Dimensions: 9 x 7.3 x 0.9 inches
• Shipping Weight: 1.4 pounds
• Average Customer Review: 1.8 out of 5 stars  See all reviews (5 customer reviews)
• Amazon Best Sellers Rank: #3,496,024 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

4 of 4 people found the following review helpful:

3.0 out of 5 stars General explanation of data warehousing, June 10, 1998

By A Customer

This review is from: Oracle Data Warehousing (Oracle Series) (Paperback)

I found it to have a good explanation of general data warehousing terms and concepts, but not enought depht in terms of planning and designing for a data warehouse. I wouldn't recommend buying it.

3 of 3 people found the following review helpful:

1.0 out of 5 stars Buy the Dodge/Gorman Book Instead!, May 29, 1999

By 

Richard M. Holoch - See all my reviews

This review is from: Oracle Data Warehousing (Oracle Series) (Paperback)

The Dodge and Gorman book is much, much better than this one. Also - buy a copy of Ralph Kimballs Data Warehouse Toolkit - its applies to DW and DM's. Another good book is Kimball's Data Warehouse Lifecycle book, but the Toolkit book is more concise.

1 of 1 people found the following review helpful:

2.0 out of 5 stars Draft Working Book- Oracle DataWarehousing, November 29, 2000

By 

Prof David T Wright (Vancouver, BC) - See all my reviews

This review is from: Oracle Data Warehousing (Oracle Series) (Paperback)

Aimed at all levels of users, administrators and architects, "Oracle Data Warehousing" offers basics, project management, and technical tutorials.

The lightly referenced, verbose, chapters span: what is a data warehouse; things to consider; building the team; managing the data warehouse project; moving the data into the warehouse; Oracle's data warehousing features; data mining; datamarts; metadata; RAID; keeping your data safe; Oracle Express & OLAP Solutions; data mining tools; datamart tools; index and tuning issues.

Strengths revolve around the attractive use of heading, lists, charts, screen-shots, and code examples, and the topical relevance to business of data warehousing.

Weaknesses include: the 45% excess words for content, typos; simplistic business examples; a seeming Oracle advert focus; need for business success anecdotes; a need for more science/ rigor about machine learning and artificial intelligence; and a need for more about wider industry trends/tools.

Overall this needed better editing, more business content, and more rigor to be considered worthwhile.