"These books are a must for any company implementing data models.They contain practical insights and templates of universal datamodels which can be used by all enterprises, regardless of theirlevel of experience."-Ron Powell, Publisher, DM Review
Industry experts raved about The Data Model Resource Book when itfirst came out--and no wonder. This book arms you with a powerfulset of data models and data warehouse designs that you can use tojump-start your database development projects. You get provenmodels for common business functions such as ordering and managingproducts, handling shipments, invoicing, accounting and budgeting,managing human resources, contact management, and projectmanagement. You'll save countless hours and thousands of dollars indatabase development costs.
This updated edition, fully edited and revised by Len Silverston,includes many new and expanded data models, including models forcall center management, product customization, shipping andreceiving, budgeting scenarios, and employee qualifications andperformance. Plus, there are new data mart designs, includingfinancial analysis, inventory management, and shippinglogistics.
With this book, you'll learn how to:
Customize enterprise and logical data models that meet thespecific needs of your organization
Convert logical data models to data warehouses and datamarts
Develop physical data designs and evaluate design options basedon the universal data models
Integrate databases and data warehouses across theenterprise
Validate your organization's existing data models
You'll also want to check out the companion volume, The Data ModelResource Book, Revised Edition, Volume 2 (0-471-35348-5), whichprovides universal data models that have been tailored for variousindustries and applications.
See how you can save even more time and money with the Data ModelResourceBook, Revised Edition, Volume 1 CD-ROM, which:
Provides the SQL code you'll need to implement the modelsdescribed in the book or to reverse-engineer them into your CASEtool
Allows you to view for free the demonstration of data models fromboth Volume 1 and Volume 2
Can be purchased separately by unlocking the enclosed CD-ROM viaphone or online-directions inside"I thought the models in the books were well thought out and adequately explained" (Computer Shopper February 2002)
"The Data Model Resource Book, Revised Edition, Volume 1 is thebest book I?ve seen on data architecture. It does not merelyaddress the top levels of a data architecture (Zachman Frameworkrow one or two); it provides both common and industry-specificlogical models as well as data designs that may be customized tomeet your requirements. The end result is a is a rich frameworkwhose models span the higher and lower levels of a dataarchitecture, including high-level models, logical models,warehouse designs, star schemas, and SQL scripts. You can use thedata models, designs, and scripts as templates or starting pointsfor your own modeling, an introduction to subject areas you mightnot be familiar with, a reference to validate your existing models,and a help to building an enterprise data architecture. The bookprovides techniques to transform models from one level to another,as well as tips and techniques for getting the appropriate levelsof abstraction in the models. Instance tables (sample data) helpbring the models to life. I have customized and used the modelsfrom the first edition on many projects in the last two years?it isan invaluable resource to me."
--Van Scott, President, Sonata Consulting, Inc.
"Len Silverston has produced an enormously useful two-volumecompendium of generic (but not too generic) data models for anextensive set of typical enterprise subject areas, and for variousindustries that any data modeler will likely encounter at somepoint in his or her career. The material is clearly written, wellorganized, and goes below the obvious to some of the more perverseand difficult information requirements in an enterprise. This is aninvaluable resource for doing one's homework before diving into anymodeling session; if you can't find it here, there is certainly avery similar template that you can use for just about any situationwith which you might be faced."
--William G. Smith, President, William G. Smith &Associates
"In today's fast-paced e-oriented world, it is no longeracceptable to bury business constraints in hard-to-change datastructures. Data architects must comprehend complex requirementsand recast them into data architecture with vision for unforeseenfutures. Len's models provide an outstanding starting point fornovice and advanced data architects for delivering flexible datamodels. These models position an organization for the business ruleage. Their proper implementation and customization allows theorganization to externalize and manage business policies and rulesso that the business can proactively change itself. In this way,the data architecture, based on Len's models and procedures forcustomizing them, becomes by design the foundation for businesschange."
--Barbara von Halle, Founder, Knowledge Partners, Inc., Co-authorof Handbook of Relational Database Design
"These books are long overdue and a must for any companyimplementing universal data models. They contain practical insightsand templates for implementing universal data models and can helpall enterprises regardless of their level of experience. Most booksaddress the needs for data models but give little in the way ofpractical advice. These books fill in that void and should beutilized by all enterprises."
--Ron Powell, Publisher, DM Review
"Businesses across the world are demanding quality systems thatare built faster by IT shops. This book provides a foundation ofpatterns for data modelers to expand upon and can cut days, if notweeks, off a project schedule. I have found The Data Model ResourceBook, Revised Edition, Volume 1 valuable as a resource for mymodeling efforts at L.L. Bean, Inc. and feel it is an essentialcomponent in any modelers toolkit."
--Susan T. Oliver, Enterprise Data Architect, L.L. Bean, Inc.
"I was first introduced to The Data Model Resource Book threeyears ago when I was hired by a firm who wanted an enterprise datamodel. This company did not believe the dictum that ?all companiesare basically the same;? they felt they were somehow unique. Aftera little analysis with Len Silverston's help, we found that we wereactually quite a bit the same: we had customers, accounts,employees, benefits, and all the things you'd find in anycorporation. All we had to do was adapt the product component ofLen's book and we were ready to move ahead with a great frameworkfor all of our data. A CD-ROM that accompanies the book providedscripts to build the model in Oracle very quickly. We then beganmapping all of our detailed data types to the enterprise model and,voila, we could find a place for all of those various spellings andmisspellings of Account Number.
Volume 2 of this revised edition provided even more excitingfeatures: models of industry-specific data. I began to seeinteresting patterns that permeated this volume. For example, areservation is a reservation, whether you're an airline, arestaurant, or a hotel. (We even have something similar in the oilindustry--the allocation.)
Another concept from the book that has changed my thinking andvocabulary is the word "party." I recently managed a project inwhich an employee could also function as a customer and as anon-line computer user. The team was in disagreement regarding aname for this entity; but after checking The Data Model ResourceBook, we realized that here we had a party playing threeroles.
Whether your job is to jump-start a data warehouse project orborrow ideas for any subject area in your next operationaldatabase, I highly recommend The Data Model Resource Books, RevisedEdition, Volumes 1 and 2 as your bible for design."
--Ted Kowalski, Equilon Enterprises LLC, Author of OpeningDoors: A Facilitator's Handbook