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

  • 7h 59m
  • Len Silverston
  • John Wiley & Sons (US)
  • 2001

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

About the Author

Len Silverston is an author, lecturer, consultant, and pioneer in the field of data management. He has devoted the last 20 years to helping organizations build and integrate information systems, using his unique approaches to develop information architectures, design databases, and solve data management issues.

Mr. Silverston has been an invited speaker at numerous national and international conferences and has written many articles on database design and data warehousing in publications such as Data Management Review and Data Warehouse Institute’s Journal of Data Warehousing.

Len Silverston is the founder and owner of Universal Data Models, LLC, a Colorado-based firm providing consulting and training to help enterprises customize and implement “universal data models” and develop holistic, integrated systems. Universal Data Models, LLC, has helped many diverse organizations develop data architectures and designs in a fraction of the typical time through its extensive repository of reusable data models and data warehouse designs. The company offers several seminars that provide tools to deliver higher quality databases and information systems in less time.

He holds a masters degree in Computer Science from Renssellear Polytechnic Institute with a specialization in database management systems.

In this Book

  • 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
  • Other Reusable Data Model and Data Warehouse Design Resources
  • The CD-ROM