|
 |
|
 |
 |
Object-Oriented Data Warehouse Design: Building A Star Schema
|
by William A. Giovinazzo
Sales Rank: 1030153
|
List Price: $54.99
$44.40
At Amazon
|
|
Hardcover: 368 pages
Publisher: Prentice Hall PTR February 26, 2000
Language: English
ISBN-10: 0130850810
ISBN-13: 978-0130850812
Product Dimensions:
8.9 x 7.1 x 0.9 inches
Shipping Weight: 1.2 pounds
Product Review
Written for any database developer or IS manager planning to build a data warehouse, Object-Oriented Data Warehouse Design provides just the right level of detail. Mixing practical advice for project management with a remarkably clear explanation of how data warehouses store information, this book fits the bill for anyone who wants to deliver a working system that fits the needs of its users.
Data warehouses are often plagued with failure, the author argues, and his prescription for success is what makes this title worthwhile. First on the agenda is a concise tour of project management techniques (using today's iterative software methodologies) along with a practical guide to what's in store for the potential data warehouse architect as he or she works within the enterprise to combine data from disparate sources. (The author's candid sample interviews with different users of a hypothetical warehouse are alone worth the price of the book.)
The remarkably clear diagrams for understanding how data is stored in a "cube" (or hypercube) within a data warehouse will help any developer or manager understand the underlying theoretical design issues. Combined with a sample star schema for a real-estate brokerage firm, this title also demonstrates a distinctly practical side. (There are numerous pages listing the specifics of tables needed for the sample project.) You'll also be able to understand the traditional star schema, where dimensions are used to query large fact tables, plus when to implement snowflake schemas to improve performance.
This concise and well-diagrammed book can let virtually anyone understand how warehouses work; the material on project management may save the day in your next data warehouse project. Filled with practical information, Object-Oriented Data Warehouse Design will be a valuable resource for any developer or project manager. --Richard Dragan
Topics covered: Introduction to data warehouses, advantages and design issues, decision support systems (DSS), online analytical processing (OLAP), data mining, iterative development techniques, metadata and metadata standards, object modeling, analysis and design, case study and sample interviews with data warehouse stakeholders, multiple dimensions and dimension tables, cubes and hypercubes, slicing and dicing, constellation/star vs. snowflake schemas, fact tables, design hints, parallel processing for data warehousing, star query optimization, data warehousing on the Web, and checklist for successful data warehouse design.
Book Info
Designed to help build a complete star schema data model-from initial analysis through implementation, make better decisions about granularity and precision, master dimensioning, hierarchies, and sizing. DLC: Data warehousing.
Customer Reviews & Comments
What this book offers is perspectives on designing warehouses with the goal of "business intelligence". Particularly useful is an interview process of extracting requirements from the end users, business strategists, upper management, and IT support people. Giovinazzo, also introduces the topology of multidimensional databases (e.g cubes, stars, and snowflakes) and the use of "fact" tables to tie these dimensions together. Through the use of the "Big Brother and the Building Company" example, he provides some down to earth examples. In a few appendices he introduces spatially enabled warehousing (weakly), metadata standards and good tips and tips on extraction, transformation, and loading. These alone are not "minor subjects", but warrant the introduction given here (and subsequent books). The books title includes "object oriented" but is perhaps not emphasized enough. I think the real value is getting the designer to think about the needs and dimensions early in the process.
Comment | Permalink |
(Report this)
|
Object-Oriented Data Warehouse Design: Building A Star Schema
List Price: $54.99
Available from Amazon
Price: $44.40
| |
|
|
|
|
