The Data Model Resource Book: A Library of Universal Data Models for All Enterprises, Volume 1A 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.
Contents
Introduction | 1 |
People and Organizations | 21 |
Products | 69 |
Copyright | |
17 other sections not shown
Other editions - View all
The Data Model Resource Book: A Library of Universal Data Models for All ... Len Silverston No preview available - 2011 |
Common terms and phrases
ABC Corporation ACCOUNTING TRANSACTION ACCTG TRANS ACME Corporation AGREEMENT ITEM associated ATTRIBUTE NAME PK BILLING ACCOUNT BUDGET ITEM chapter COMMUNICATION EVENT cost Currency amount data mart data warehouse data DATE o THRU DATE Yes EFFORT TYPE employee enterprise data model ENTITY NAME ATTRIBUTE example Figure FIXED ASSET foreign key ID DESCRIPTION ID ENTITY ID No Yes ID PARTY ID ID ROLE TYPE ID Yes Yes INTERNAL ORGANIZATION INVENTORY ITEM INVOICE ITEM ITEM SEQ ID ledger accounts logical data models NAME ATTRIBUTE NAME PARTY ID Yes PARTY RELATIONSHIP PARTY ROLE PAYMENT PERSON POSITION TYPE POSTAL ADDRESS primary key provides QUANTITY REQUEST REQUIREMENT ROLE TYPE ID sales order SEQ ID Yes SHIPMENT ITEM shipped Short varchar shows specific star schema stored subtypes supplier Table THRU DATE track TYPE ID Yes Universal Data Models warehouse data model Yes ID PARTY Yes ID ROLE Yes No ID Yes Yes ID