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

Front Cover
John Wiley & Sons, Aug 8, 2011 - Computers - 560 pages
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 1st Edition, while adding a companion volume to take care of more specific requirements of different businesses.

This updated volume provides a common set of data models for specific core functions shared by most businesses like human resources management, accounting, and project management. These models are standardized and are easily replicated by developers looking for ways to make corporate database development more efficient and cost effective.

This guide is the perfect complement to The Data Model Resource CD-ROM, which is sold separately and provides the powerful design templates discussed in the book in a ready-to-use electronic format. A free demonstration CD-ROM is available with each copy of the print book to allow you to try before you buy the full CD-ROM.

 

Contents

Acknowledgments
People and Organizations
Products
Ordering Products
Shipments
Work Effort
Invoicing
Accounting and Budgeting
A Sample Data Warehouse Data Model
Star Schema Designs for Sales Analysis
Geographic Boundaries Dimension
Additional Star Schema Designs
Implementing the Universal Data Models
Party Roles and Relationships Physical Design Option 2
Appendix A Logical Data Model Entities and Attributes
Appendix B Data Warehouse Data Model Tables and Columns

Budget Item
Human Resources
Creating the Data Warehouse Data Model from
Removing Operational Data

Other editions - View all

Common terms and phrases

About the author (2011)

LEN SILVERSTON (lsilverston @univdata.com) is founder and owner of Universal Data Models, LLC (www.universaldatamodels.com), 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 organizations.

Bibliographic information