The Data Model Resource Book: A Library of Logical Data Models and Data Warehouse Designs

Len Silverston, W. H. Inmon, Kent Graziano

Database and data warehouse designers, this book can save you and your staff hundreds of hours of hard work and tens of thousands of dollars in systems development costs and/or consultants' fees.

Let's face it, most data models are made up of common constructs that have been developed countless times before in other organizations. As a consequence, each time you build a data model from scratch it's like you're reinventing the wheel. Clearly, developing database systems and data warehouses would be much simpler if you had your own library of "best models" to work from. Now you do.

The Data Model Resource Book arms you with a set of proven data models and data warehouse designs for the core functions shared by most businesses. You get a comprehensive set of detailed models for marketing and sales, human resources, inventory, professional services, order processing, billing, product delivery, work order management, budgeting, accounting, and more. The authors also show you how to quickly convert the logical data models into enterprise-wide data warehouses as well as data marts.

LEN SILVERSTON (lsilvers@qdbc.com) is President of Quest Database Consulting, Inc. (http://www.qdbc.com), a Denver-based firm specializing in the delivery of database and data warehouse solutions.

W. H. INMON is the acknowledged "father of the data warehouse" and the founder of Pine Cone Systems, a data warehousing company.

KENT GRAZIANO (kgraziana@qdbc.com) is Director of Data Warehouse Services for Quest Database Consulting, Inc.

Table of Contents

  • People and Organizations.
  • Products.
  • Ordering Products.
  • Order Delivery and Invoicing.
  • Work Effort.
  • Accounting and Budgeting.
  • Human Resources.
  • Creating the Data Warehouse Data Model From the Corporate Data Model.
  • A Sample Data Warehouse Data Model.
  • Star Schema Designs for Sales Analysis.
  • Star Schema Designs for Human Resources Analysis.
  • Using These Models in the Real World.
  • Appendices.
  • Index.

Copyright © 1999 John Wiley & Sons, Wiley Computer Books

Cover

$54.99
ISBN 0471153648
368 pages
March, 1997
Paperback

This title is out of print.
Go here to see the product page on Amazon

You may also Visit the author's other data model resource products page at http://www.wiley.com/go/silverston.

 Area:
Database and Data Warehouses

Companion

Visit Universal Data Solutions, LLC. home page for the author of the book.