Object-Oriented Data Warehouse Design: A Star Schema

Rating:
Summary: Design perspectives and ideas
Review: 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.

Rating:
Summary: Design perspectives and ideas
Review: 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.

Rating:
Summary: Design perspectives and ideas
Review: 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.