The Data Model Resource Book, Volume 1: A Library of Universal Data Models for All EnterprisesA 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
Chapter | 1 |
Conventions and Standards Used in This Book | 8 |
Conventions Used for Illustration Tables | 18 |
Copyright | |
22 other sections not shown
Other editions - View all
The Data Model Resource Book, Volume 2: A Library of Universal Data Models ... Len Silverston No preview available - 2011 |
Common terms and phrases
ABC Corporation ABC Subsidiary ACCOUNTING TRANSACTION ACCTG TRANS ACME Corporation AGREEMENT ITEM associated BILLING ACCOUNT BUDGET ITEM chapter COMMUNICATION EVENT cost Currency amount data mart DATE O THRU DATE Yes Datetime defined EFFORT TYPE employee enterprise data model ENTITY NAME ATTRIBUTE example Figure FIXED ASSET 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 PRODUCT CATEGORY PRODUCT ID provides QUANTITY REQUEST REQUIREMENT ROLE TYPE ID sales order SEQ ID Yes SHIPMENT ITEM shipped shows specific star schema STATUS TYPE stored subtype supplier Table THRU DATE track TYPE ID DESCRIPTION TYPE ID Yes Universal Data Models varchar warehouse data model Yes ID PARTY Yes ID ROLE Yes No ID Yes Yes ID