Books for your bucks

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to
for a chance to win.
Privacy Policy

Visit our stores

    Recently Viewed clear list

    Original Essays | June 10, 2015

    Rob Hart: IMG The End of Apocalypse

    My plan here is to write about how New York City disappears out from under your feet. So I wanted to include a picture of Apocalypse Lounge, a bar... Continue »
    1. $10.47 Sale Trade Paper add to wish list

      New Yorked (Ash McKenna)

      Rob Hart 9781940610405

Qualifying orders ship free.
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Burnside Database- Design

More copies of this ISBN

Designing a Data Warehouse: Supporting Customer Relationship Management (Hewlett-Packard Professional Books)


Designing a Data Warehouse: Supporting Customer Relationship Management (Hewlett-Packard Professional Books) Cover


Synopses & Reviews

Publisher Comments:

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

If you want to leverage the full power of your CRM system, you need a data warehouse designed for the purpose. One book shows you exactly how to build one: Designing Data Warehouses by Dr. Chris Todman.


Includes bibliographical references (p. 313) and index.

About the Author

DR. CHRIS TODMAN has, for the last decade, specialized in data warehousing projects throughout the telecommunications, financial services, automotive and utilities industries. During the past five years he has served as Hewlett-Packard's UK Data Warehouse Practice Manager. An IT professional for more than 20 years, Todman earned a Ph.D. based in part on his advanced research into data warehousing.

Table of Contents

1. Customer Relationship Management.

The Business Dimension. Business Goals. Business Strategy. The Value Proposition. Customer Relationship Management. Summary.

2. An Introduction to Data Warehousing.

Introduction. What Is a Data Warehouse? Dimensional Analysis. Building a Data Warehouse. Problems When Using Relational Databases. Summary.

3. Design Problems We Have to Face Up To.

Dimensional Data Models. What Works for CRM. Summary.

4. The Implications of Time in Data Warehousing.

The Role of Time. Problems Involving Time. Capturing Changes. First-Generation Solutions for Time. Variations on a Theme. Conclusions to the Review of First-Generation Methods.

5. The Conceptual Model.

Requirements of the Conceptual Model. The Identification of Changes to Data. Dot Modeling. Dot Modeling Workshops. Summary.

6. The Logical Model.

Logical Modeling. The Implementation of Retrospection. The Use of the Time Dimension. Logical Schema. Performance Considerations. Choosing a Solution. Frequency of Changed Data Capture. Constraints. Evaluation and Summary of the Logical Model.

7. The Physical Implementation.

The Data Warehouse Architecture. CRM Applications. Backup of the Data. Archival. Extraction and Load. Summary.

8. Business Justification.

The Incremental Approach. The Submission. Summary.

9. Managing the Project.

Introduction. What Are the Deliverables? What Assumptions and Risks Should I Include? What Sort of Team Do I Need? Summary.

10. Software Products.

Extraction, Transformation, and Loading. OLAP. Query Tools. Data Mining. Campaign Management. Personalization. Metadata Tools. Sorts.

11. The Future.

Temporal Databases (Temporal Extensions). OLAP Extensions to SQL. Active Decision Support. External Data. Unstructured Data. Search Agents. DSS Aware Applications.

Appendix A. Wine Club Temporal Classifications.

Appendix B. Dot Model for the Wine Club.

Appendix C. Logical Model for the Wine Club.

Appendix D. Customer Attributes.



Product Details

Todman, Chris
Prentice Hall
Upper Saddle River, N.J.
Database Management - General
Database Management - Data Warehousing and Data Mining
Data warehousing
Database Management - Data Warehousing
Database-Data Warehousing
Edition Description:
Trade paper
HP Professional Series
Series Volume:
Publication Date:
December 2000
Grade Level:
Professional and scholarly
9 x 7 x 0.8 in 476 gr

Related Subjects

Computers and Internet » Artificial Intelligence » General
Computers and Internet » Database » Database Management
Computers and Internet » Database » Design
Computers and Internet » Database » General

Designing a Data Warehouse: Supporting Customer Relationship Management (Hewlett-Packard Professional Books) Used Trade Paper
0 stars - 0 reviews
$11.50 In Stock
Product details 352 pages Prentice Hall PTR - English 9780130897121 Reviews:
  • back to top


Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at