Cracking the code to successful conversions: Enterprise data modeling


There are multiple types of data models, and some companies choose to NOT data model purchased software applications. I view this a bit differently. I think that any purchased application is part of our enterprise, thus it is part of our enterprise data model (or that concept is part of the enterprise!). An enterprise data model is very conceptual in nature, and it relates to how a company does business.

Most enterprise data models are split up by subject areas.  For example, Customer, Product, Facilities and Sales would each have their own model. The relationships between those subject areas are shown in a diagram, so that it is easy to see and understand.

Upkeep of this data model is so very important for any company. Each and every project needs to address updates or changes to the concepts represented in the enterprise data model. Sometimes the update is as easy as adding to a few definitions. Other times, you may need to add a new entity or subject area. You need to consider adding just enough to make sense to the enterprise.

I have had the privilege of working with a company that had the BEST enterprise data model that I have ever seen.  The model included:

  1. Subject area that relate to how they do business.
  2. In each subject area, there are entities with business definitions.
  3. The entities have a representative amount of attributes that relate to how they do business with definitions.

If you do not have an enterprise data model, consider starting one with your next project, then enhancing it as time permits.



About Author

Joyce Norris-Montanari

President of DBTech Solutions, Inc

Joyce Norris-Montanari, CBIP-CDMP, is president of DBTech Solutions, Inc. Joyce advises clients on all aspects of architectural integration, business intelligence and data management. Joyce advises clients about technology, including tools like ETL, profiling, database, quality and metadata. Joyce speaks frequently at data warehouse conferences and is a contributor to several trade publications. She co-authored Data Warehousing and E-Business (Wiley & Sons) with William H. Inmon and others. Joyce has managed and implemented data integrations, data warehouses and operational data stores in industries like education, pharmaceutical, restaurants, telecommunications, government, health care, financial, oil and gas, insurance, research and development and retail. She can be reached at

Related Posts

Leave A Reply

Back to Top