Q

Enterprise versus project level conceptual data modeling

Learn the differences between enterprise level and project level conceptual data modeling, and find out how both approaches are compatible.

Would you undertake a project just to do an enterprise level conceptual data model (ECDM) by Domain -- then leave it at the project level to do the logical and physical data modeling? Or would you do the conceptual data modeling as part of the whole project?

Both approaches are valid and have their benefits, and actually both approaches may be followed at the same time. Developing an Enterprise Conceptual Data Model (ECDM) independent of any specific data design project is very valuable in that it identifies enterprise business objects/concepts and how these relate. The ECDM should be used as a framework for every project touching upon information within the domain/subject area (e.g. Finance, Customer, Sales, Product).

In addition to the ECDM, some organizations also develop an Enterprise Logical Data Model (ELDM), which may be primarily an extension of the ECDM -- the primary difference being that attributes of business concern are added to the entities/objects, or may be relational (e.g. 3NF) in nature (e.g. M:M relationships, subtypes, etc resolved), or may be some combination of both.

Projects may actually develop Conceptual, Logical, and Physical models. At the project level, a CDM may be developed in greater detail than appropriate for the ECDM. A project level CDM can and usually should be used to update/expand the ECDM, especially if what is being modeled is of enterprise concern. ECDMs usually aren't developed for all domains at the same times (definitely not to the same depth), and so it is common for enterprise applications (ERP, Data Warehouse, SOA, etc.) to act as the driver for or be a significant contributor to developing/maintaining enterprise models.

In response to the first part of your question, undertaking a project just to develop enterprise models (Subject Area – identifies domains and very high-level relationships between domains, ECDM, ELDM) is a worthwhile undertaking, but usually has to be associated with an enterprise endeavor to have any hope of funding.

More about conceptual data models

This was first published in May 2008

Dig deeper on Data modeling tools and techniques

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSOA

SearchSQLServer

Close