Table Of ContentForeword. 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.
Edition DescriptionRevised edition
SynopsisA 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., 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., "These books are a must for any company implementing data models. They contain practical insights and templates of universal data models which can be used by all enterprises, regardless of their level of experience." Ron Powell, Publisher, DM Review Industry experts raved about The Data Model Resource Book when it first came out and no wonder. This book arms you with a powerful set of data models and data warehouse designs that you can use to jump-start your database development projects. You get proven models for common business functions such as ordering and managing products, handling shipments, invoicing, accounting and budgeting, managing human resources, contact management, and project management. Youll save countless hours and thousands of dollars in database development costs. This updated edition, fully edited and revised by Len Silverston, includes many new and expanded data models, including models for call center management, product customization, shipping and receiving, budgeting scenarios, and employee qualifications and performance. Plus, there are new data mart designs, including financial analysis, inventory management, and shipping logistics. With this book, youll learn how to: Customize enterprise and logical data models that meet the specific needs of your organization Convert logical data models to data warehouses and data marts Develop physical data designs and evaluate design options based on the universal data models Integrate databases and data ware- houses across the enterprise Validate your organizations existing data models Youll also want to check out the companion volume, The Data Model Resource Book, Revised Edition, Volume 2 (0-471-35348-5), which provides universal data models that have been tailored for various industries and applications. See how you can save even more time and money with The Data Model ResourceBook, Revised Edition, Volume 1 CD-ROM, which: Provides the SQL code youll need to implement the models described in the book or to reverse-engineer them into your CASE tool You can view for free the demon- stration of data models from both Volume 1 and Volume 2 on the Demo CD included with this book Can be purchased separately by phone or online directions inside, Datenmodelle für Kernfunktionen, die in nahezu allen Geschäftsbereichen eine Rolle spielen: Dieses zweibändige, überarbeitete Handbuch in der 2. Auflage zeigt Datenbankprogrammierern, wie sie zwei Drittel der üblichen Entwicklungszeit sparen können! Neu in diesem 1. Band ist ein Kapitel zu Data Marts für die Finanzanalyse; über 30% des Stoffes wurde au erdem sorgfältig aktualisiert. Aufgenommen wurden hochaktuelle Datenmodelle, mit denen die Autoren seit dem Erscheinen der Erstauflage Erfahrungen sammeln konnten. Eine separat erhältliche CD-ROM beinhaltet sämtliche Datenmodelle in einer Form, die leicht in gebräuchliche kommerzielle Datenbanken zu integrieren ist.