The Data Model Resource Book, Revised Edition, Volume 1

The Data Model Resource Book, Revised Edition, Volume 1 : A Library of Universal Data Models for All Enterprises

3.9 (40 ratings by Goodreads)
By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 3 business days
When will my order arrive?


A quick and reliable way to build proven databases for core business functions Industry experts raved about The Data Model Resource Book when it was first published in March 1997 because it provided a simple, cost-effective way to design databases for core business functions. Len Silverston has now revised and updated the hugely successful First Edition, while adding a companion volume to take care of more specific requirements of different businesses. Each volume is accompanied by a CD-ROM, which is sold separately. Each CD-ROM provides powerful design templates discussed in the books in a ready-to-use electronic format, allowing companies and individuals to develop the databases they need at a fraction of the cost and a third of the time it would take to build them from scratch. Updating the data models from the First Edition CD-ROM, this resource allows database developers to quickly load a core set of data models and customize them to support a wide range of business more

Product details

  • Paperback | 560 pages
  • 187.96 x 233.68 x 25.4mm | 839.14g
  • John Wiley and Sons Ltd
  • John Wiley & Sons Inc
  • New York, United States
  • English
  • Revised
  • Revised edition
  • Ill.
  • 0471380237
  • 9780471380238
  • 271,781

Back cover copy

"These books are a must for any company implementing data models. They contain practical insights and templates of universal data models which can be used by all enterprises, regardless of their level of experience."-Ron Powell, Publisher, DM Review Industry experts raved about The Data Model Resource Book when it first came out--and no wonder. This book arms you with a powerful set of data models and data warehouse designs that you can use to jump-start your database development projects. You get proven models for common business functions such as ordering and managing products, handling shipments, invoicing, accounting and budgeting, managing human resources, contact management, and project management. You'll save countless hours and thousands of dollars in database development costs. This updated edition, fully edited and revised by Len Silverston, includes many new and expanded data models, including models for call center management, product customization, shipping and receiving, budgeting scenarios, and employee qualifications and performance. Plus, there are new data mart designs, including financial analysis, inventory management, and shipping logistics. With this book, you'll learn how to: * Customize enterprise and logical data models that meet the specific needs of your organization * Convert logical data models to data warehouses and data marts * Develop physical data designs and evaluate design options based on the universal data models * Integrate databases and data warehouses across the enterprise * Validate your organization's existing data models You'll also want to check out the companion volume, The Data Model Resource Book, Revised Edition, Volume 2 (0-471-35348-5), which provides universal data models that have been tailored for various industries and applications. See how you can save even more time and money with the Data Model ResourceBook, Revised Edition, Volume 1 CD-ROM, which: * Provides the SQL code you'll need to implement the models described in the book or to reverse-engineer them into your CASE tool * Allows you to view for free the demonstration of data models from both Volume 1 and Volume 2 * Can be purchased separately by unlocking the enclosed CD-ROM via phone or online-directions insideshow more

Review quote

"I thought the models in the books were well thought out and adequately explained" (Computer Shopper February 2002)show more

About Len Silverston

LEN SILVERSTON ( is founder and owner of Universal Data Models, LLC (, a Colorado-based firm providing consulting and training for helping enterprises customize and implement "universal data models" and develop holistic, integrated systems. Mr. Silverston has over 20 years' experience in delivering data integration, database and data warehouse solutions to more

Table of contents

Foreword. Acknowledgments. About the Author. Introduction. People and Organizations. Products. Ordering Products. Shipments. Work Effort. Invoicing. Accounting and Budgeting. Human Resources. Creating the Data Warehouse Data Model from the Enterprise Data Model. A Sample Data Warehouse Data Model. Star Schema Designs for Sales Analysis. Star Schema Designs for Human Resources. Additional Star Schema Designs. Implementing the Universal Data Models. Appendix A: Logical Data Model Entities and Attributes. Appendix B: Data Warehouse Data Model Tables and Columns. Appendix C: Star Schema Design Tables and Columns. How to Use the CD-ROM Product. Other Reusable Data Model and Data Warehouse Design Resources. more

Review Text

"I thought the models in the books were well thought out and adequately explained" (Computer Shopper February 2002)show more

Rating details

40 ratings
3.9 out of 5 stars
5 30% (12)
4 42% (17)
3 20% (8)
2 2% (1)
1 5% (2)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X