The Data Model Resource Book: A Library of Logical Data Models and Data Warehouse Designs: A Library of Logical Data and Data Warehouse Models - Softcover

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

Softcover

ISBN 10: 0471153648 ISBN 13: 9780471153641

Publisher: John Wiley & Sons, 1997

Synopsis

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.

A CD–ROM ,sold separately, contains the SQL for all of the data models contained in the book in Oracle, Sybase, Informix, Microsoft SQL Server and ANSI compatable formats.

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 resource 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 product is available. It provides all of the data models contained in the book 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

Database and data warehouse designers, this book can save you and your staff hundreds of hours of hard work and tens of thousands of dollars in systems development costs and/or consultants′ fees.

Let′s face it, most data models are made up of common constructs that have been developed countless times before in other organizations. As a consequence, each time you build a data model from scratch it′s like you′re reinventing the wheel. Clearly, developing database systems and data warehouses would be much simpler if you had your own library of "best models" to work from. Now you do.

The Data Model Resource Book arms you with a set of proven data models and data warehouse designs for the core functions shared by most businesses. You get a comprehensive set of detailed models for marketing and sales, human resources, inventory, professional services, order processing, billing, product delivery, work order management, budgeting, accounting, and more. The authors also show you how to quickly convert the logical data models into enterprise–wide data warehouses as well as data marts.

Edition details

• Publisher: John Wiley & Sons
• Publication date: 1997
• ISBN 10: 0471153648
• ISBN 13: 9780471153641
• Binding: Paperback
• Language: English
• Number of pages: 368