The Official Guide to Informix/Red Brick Data Warehousing (With CD-ROM) [Paperback]

Robert J. Hocutt (Author)

Book Description

Publication Date: November 15, 2000 | ISBN-10: 0764546945 | ISBN-13: 978-0764546945

The Official Guide to Informix/Red Brick Data Warehousing is a comprehensive tutorial and reference to Informix Red Brick Data Warehouses, perfect for Red Brick consultants, customers and those evaluating Red Brick's software for adoption. The book covers key Red Brick features necessary for building a data warehouse through its complete lifecycle, beginning with planning the project, modeling the database, building and loading the database, and maintaining the data warehouse in the future. A case study is used that you will build upon with each major area to create a sample data warehouse. Sample forms and documents are provided on the CD-ROM.

Editorial Reviews

Amazon.com Review

The Official Guide to Informix/Red Brick Data Warehousing documents the process of creating a top-flight data warehouse from project definition, through information gathering and preliminary designs, and finally to implementation with Informix Red Brick Decision Server. Building a data warehouse--a high-capacity, high-transaction-volume database that exists for the purpose of centralizing an organization's information and making it available to support decisions--is much more than an everyday exercise for database managers. Because they're so complex and potentially so central to the operations of their businesses, they have to be designed and implemented with care. Some of the material in this book may seem extraneous to people who have managed big projects before and wish only to learn about the product, but Robert Hocutt's work should prove illuminating to anyone who reads it.

Hocutt likes to explain his subject with prose, and he's good at doing so. He'll typically describe a concept or behavior, then rattle off a series of straight facts, well suited to buttressing a design decision. The author understands that the design of an organization's data warehousing infrastructure is an intimate process, and he does his readers a service by sharing facts, expressing opinions, and leaving actual processes up to them. That said, he's liberal with SQL examples that illustrate Red Brick Decision Server's special capabilities; these are best located through the index in the heat of implementation. This is a fine document on Informix's data warehousing product. --David Wall

Topics covered: Large-scale data warehousing with Informix Red Brick Decision Server, explained for all the members of the teams designated to design and implement it. Project scoping, business-process discovery, database design, data scrubbing mechanisms, and query setup all get attention. Special sections deal with installation, query processing (including parallel queries), sizing, and segmentation. A CD-ROM includes a sample database for experimentation and dry runs.

From the Publisher

Comprehensive tutorial with a lifecycle approach includes how to plan, design, deploy and maintain a RedBrick Data Warehouse

Essential reference for data warehousing fundamentals; details the basic concepts in data warehousing and OLAP, how to design and build a database using the star schema approach and set up scripts to load the database with data, how to set up data warehouse to deploy the database to the business users, and how to maintain the data warehouse for the future as new business areas and users expand their needs.

Covers the key features and improvements in RedBrick's latest release: star schema join technology, unique optimizations, query processing, fast leader

Advanced topics including: modeling the database using star schema, setting up the database, and navigating aggregates using RedBrick Vista

BONUS CD INCLUDES: sample forms, documents, completed exercises, and a sample data warehouse

See all Editorial Reviews

Product Details

• Paperback: 395 pages
• Publisher: Wiley (November 15, 2000)
• Language: English
• ISBN-10: 0764546945
• ISBN-13: 978-0764546945
• Product Dimensions: 9.2 x 7.5 x 1 inches
• Shipping Weight: 1.6 pounds
• Average Customer Review: 4.0 out of 5 stars  See all reviews (1 customer review)
• Amazon Best Sellers Rank: #4,684,119 in Books (See Top 100 in Books)
  • #62 in Books > Computers & Technology > Databases > Specific Databases

More About the Author

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

Customer Reviews

Most Helpful Customer Reviews

4.0 out of 5 stars Good orientation to Redbrick, January 23, 2008

By 

R. Smith (MN United States) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: The Official Guide to Informix/Red Brick Data Warehousing (With CD-ROM) (Paperback)

This book was a good orientation to Redbrick. I do not consider it a reference book, and can only recommend it to people just wanting to get acquainted with Redbrick.