Description
Book SynopsisThe development of corporate database systems is complex, time-consuming, and expensive, causing developers to look for ways to cut costs. Len Silverston found a way to do this by identifying core data models that most companies share, standardizing them, and making them available on this CD-ROM.
Trade Review"I thought the models in the books were well thought out and adequately explained" (Computer Shopper February 2002)
Table of ContentsForeword.
Acknowledgments.
About the Author.
Introduction.
People and Organizations.
Products.
Ordering Products.
Shipments.
Work Effort.
Invoicing.
Accounting and Budgeting.
Human Resources.
Creating the Data Warehouse Data Model from the Enterprise Data Model.
A Sample Data Warehouse Data Model.
Star Schema Designs for Sales Analysis.
Star Schema Designs for Human Resources.
Additional Star Schema Designs.
Implementing the Universal Data Models.
Appendix A: Logical Data Model Entities and Attributes.
Appendix B: Data Warehouse Data Model Tables and Columns.
Appendix C: Star Schema Design Tables and Columns.
How to Use the CD-ROM Product.
Other Reusable Data Model and Data Warehouse Design Resources.
Index.
