The Data Model Resource Book: 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 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 functions.
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
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