Publisher's Synopsis
This set contains a book and CD–ROM with proven data models that save companies′ time and money developing data architectures, databases and data warehouses.
The Data Model Resource Book provides a common set of data models for specific functions common to most businesses, such as sales, marketing, order processing, contracts, shipments, invoicing, work efforts, budgeting, and accounting. Readers can apply more than one data model to their own company to meet specific data needs.
The CD–ROM contains the SQL for all of the data models contained in the book in Oracle, Sybase, Informix, Microsoft SQL Server and ANSI compatable formats.
Subject data areas include: People and Organizations. Products. Ordering Products. Order Delivery and Invoicing. Work Effort. Accounting and Budgeting. Human Resources. Creating the Data Warehouse Data Model From the Corporate Data Model. A Sample Data Warehouse Data Model. Star Schema Designs for Sales Analysis. Star Schema Designs for Human Resources Analysis. Using These Models in the Real World. Appendices. Index.
