Synopsis:
Design your data warehouse correctly from the start!

It is well-documented that most data warehouse projects fail. The #1 reason: poor data models or the failure of warehouse designers to apply a sound design methodology. Too many warehouses, and too many books, treat building the warehouse from a template approach. Don't fall into that trap!

Object-Oriented Data Warehouse Design: Building a Star Schema delivers data modeling methodologies that are proven to work. In data warehouse design, one size definitely doesn't fit all! So,

Build a complete star schema data model from initial analysis through implementation. Make better decisions about granularity and precision Master dimensioning, hierarchies, sizing, and more. With Object-Oriented Data Warehouse Design: Building a Star Schema, you will design your data warehouse for maximum business value-the first time.

Designing a Data Warehouse: Supporting Customer Relationship Management
Authors: Chris Todman
ISBN: 0130897124

Synopsis:
The complete guide to building tomorrow's CRM-focused data warehouses.

A complete methodology for building CRM-focused data warehouses Planning, ROI, conceptual and logical models, physical implementation, project management, and beyond For database developers, architects, consultants, project managers, and decision-makers Today's next-generation data warehouses are being built with a clear goal: to maximize the power of Customer Relationship Management. To make CRM-focused data warehousing work, you need new techniques, and new methodologies. In this book, Dr. Chris Todman�one of the world's leading data warehouse consultants�delivers the first start-to-finish methodology for defining, designing, and implementing CRM-focused data warehouses. Todman covers all this, and more:

• Critical design challenges unique to CRM-focused data warehousing
• A new look at data warehouse conceptual models, logical models, and physical implementation
• The crucial implications of time in data warehouse modeling and querying
• Project management: deliverables, assumptions, risks, and team-building including a full breakdown of work
• Estimating the ROI of CRM-focused data warehouses up front
• Choosing software for loading, extraction, transformation, querying, data mining, campaign management, personalization, and metadata
• DW futures: temporal databases, OLAP SQL extensions, active decision support, integrating external and unstructured data, search agents, and more

Building the Data Warehouse
Authors: William H. Inmon
ISBN: 0471141615

Synopsis:
The data warehouse solves the problem of getting information out of legacy systems quickly and efficiently. If designed and built right, data warehouses can provide significant freedom of access to data, thereby delivering enormous benefits to any organization. In this unique handbook, W. H. Inmon, "the father of the data warehouse," provides detailed discussion and analysis of all major issues related to the design and construction of the data warehouse, including granularity of data, partitioning data, metadata, lack of creditability of decision support systems (DSS) data, the system of record, migration and more. This Second Edition of Building the Data Warehouse is revised and expanded to include new techniques and applications of data warehouse technology and update existing topics to reflect the latest thinking. It includes a useful review checklist to help evaluate the effectiveness of the design.