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
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 | |
Star Schema Design Tables and Columns | |
Other editions - View all
Common terms and phrases
ACCOUNT actual additional AGREEMENT allows amount application assigned associated attribute BILLING BUDGET ITEM CATEGORY chapter complete COMPONENT CONTACT MECHANISM cost data model data warehouse database Datetime defined described DESCRIPTION detail dimension EFFORT employee enterprise ENTRY ESTIMATED example FACILITY Figure ID No Yes ID Yes Yes identify indicates instance INTERNAL ORGANIZATION INVOICE ITEM involved ITEM SEQ ID maintain manager METHOD NAME ORDER ITEM PARTY ID PARTY RELATIONSHIP PARTY ROLE PAYMENT performance PERIOD PERSON physical POSITION PRICE PRODUCT PRODUCT FEATURE provides purchase order QUANTITY QUOTE record represents request REQUIREMENT REVIEW ROLE TYPE ID separate SHIPMENT SHIPMENT ITEM shipped shown shows specific standard STATUS TYPE stored structure subtypes supplier Table THRU DATE track transaction TYPE entity TYPE ID TYPE ID Yes various Yes Yes ID Yes Yes Yes