The Data Model Resource Book, Volume 1: A Library of Universal Data Models for All Enterprises
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.
What people are saying - Write a review
We haven't found any reviews in the usual places.
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
Creating the Data Warehouse Data Model from
Removing Operational Data
Star Schema Design Tables and Columns
Other editions - View all
ABC Corporation ACCOUNTING TRANSACTION ACCTG TRANS ACME Corporation AGREEMENT ITEM associated BILLING ACCOUNT BUDGET ITEM chapter COMMUNICATION EVENT CONTACT METHOD cost data mart data warehouse data DATE 0 THRU Datetime EFFORT TYPE employee enterprise data model ESTIMATED example Figure FIXED ASSET foreign key ID DESCRIPTION ID ENTITY ID No Yes ID PARTY ID ID ROLE TYPE ID Yes Yes instance INTERNAL ORGANIZATION INVENTORY ITEM INVOICE ITEM ITEM SEQ ID ledger accounts logical data models many-to-many NAME PARTY CONTACT MECHANISM PARTY ID Yes PARTY RELATIONSHIP PARTY ROLE PAYMENT PERSON POSITION TYPE POSTAL ADDRESS PRICE COMPONENT primary key PRODUCT CATEGORY provides QUANTITY request REQUIREMENT ROLE TYPE ID sales order SHIPMENT ITEM shipped shows specific star schema stored subtypes supplier Table THRU DATE track TYPE entity TYPE ID Yes Universal Data Models warehouse data model Yes ID ROLE Yes No ID Yes Yes ID Yes Yes Yes