The Data Model Resource Book/CD set: A Library of Logical Data and Data Warehouse Models - Softcover

Silverston, Len; Inmon, W. H.; Graziano, Kent

Softcover

ISBN 10: 0471153672 ISBN 13: 9780471153672

Publisher: John Wiley & Sons, 1997

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.

About this title

Synopsis

Development of corporate database systems is complex, time-consuming, and expensive, leaving developers on the lookout for ways to cut costs. The authors of this text have found a way to do this. It's based on a simple observation: most companies handle a core set of basic business functions in similar ways. Therefore the databases that support these functions can be boiled down to a relatively few basic models. But most companies continue to "reinvent the wheel" by creating their own data models, a complicated and lengthy task. The solution is to identify the core data models that most companies share, standardize them, and make them available to all. This book provides a common set of data models for the specific core functions shared by most businesses such as sales, marketing, order processing, budgeting and accounting; it also provides a library of data models for companies in specific industry groups. In many cases, readers can apply more than one industry model to the organization, for example, for companies that both manufacture, market and distribute products. It also shows how to turn these data models into a structure suitable for data warehousing.

This practical volume provides proven data models that database developers can use to save the time it normally takes to develop databases for common business tasks, plus save considerable sums in consulting fees. The CD-ROM provides all of the data models contained in the main text in electronic form (ASCII). Companies can use the CD to load the data directly to most data modelling tools and customize the models to fit their specific requirements.

From the Back Cover

This valuable CD–ROM provides you with all of the SQL scripts needed to implement the models described in The Data Model Resource Book. Companies can use the CD to load the data directly into the most popular data modeling tools and customize the models to fit their specific requirements. Database designers will save a significant amount of time from what it normally takes to design and implement databases for common business functions.

The CD–ROM includes models for functions shared by most businesses, including human resources, accounting, budgeting, order processing, invoicing, shipments, sales and marketing, project management and professional services, as well as a number of data warehouse designs.

Edition details

• Publisher: John Wiley & Sons
• Publication date: 1997
• ISBN 10: 0471153672
• ISBN 13: 9780471153672
• Binding: Paperback
• Language: English
• Number of pages: 356