For the best web experience, please use IE11+, Chrome, Firefox, or Safari

What is a data model?

What is a data model?

Data models are visual representations of an enterprise’s data elements and the connections between them. By helping to define and structure data in the context of relevant business processes, models support the development of effective information systems. They enable business and technical resources to collaboratively decide how data will be stored, accessed, shared, updated and leveraged across an organization.

What is the purpose of a data model?

Data models play a key role in bringing together all segments of an enterprise – IT, business analysts, management and others – to cooperatively design information systems (and the databases they rely on).

These systems require properly defined and formatted data, and models shine a clear light on what data is required and how it must be structured to support the desired business processes.

By explicitly determining the structure of your data, these models support a variety of use cases, including database modeling, information system design, and process development in support of a consistent, clean exchange of data.

It’s also important to understand the three different types of data models. Each will serve a different purpose as you work through the data modeling process.

Data models play a key role in bringing together all segments of an enterprise

What are the different types of data models?

Depending on where you are in the data modeling process, you are likely to use one of three types of data models. We typically find that enterprises benefit from all three, depending on the problems they are trying to solve. Therefore, we like to view each as a “stage” of the data modeling process, rather than a distinct “type” of data model.

Conceptual data models

Also known as domain models, conceptual data models explore and detail your high-level, static business structures and concepts. They are most frequently used during the beginning of a new project, when high-level concepts and initial requirements are hashed out. Often, they are created as precursors or alternatives to the next stage: logical data models.

Conceptual data models

Logical data models

After your problem domain and initial concepts become more clear through conceptual data modeling, it’s time to get more specific with a logical data model. Whether you’re looking through the lens of a single project or your entire enterprise, these models clarify the various logical entities (types or classes of data) you’ll be working with, the data attributes that define those entities, and the relationships between them.

Logical data models

Physical data models

When you get to the physical data modeling stage, it’s truly time to get down to the nitty-gritty. These models are used to design the internal schema of a database. That includes all of the various tables, the columns on those tables and the relationships between them. These models will be directly translated into production database design, which will support further development of information systems. Physical data models generally are used to design three types of databases: relational for traditional operational databases, document for NoSQL and JSON databases, and dimensional for aggregation and business intelligence data stores such as data warehouses and data marts.

Physical data models

Ultimately, all three models can and should work independently of each other. But as your project matures, the best results will come from a natural progression through all three models. Of course, consistency must be maintained across the models on a structural level. Adjusting the table/column format on a physical model, for example, should not change the initial conceptual model in any meaningful way.

By leveraging all three models, organizations can ensure their projects do not lose sight of initial objectives – but still maintain the flexibility to address unexpected changes in requirements or parameters.

Get comprehensive support for your data modeling efforts

erwin has been the most trusted name in the data modeling space for more than 30 years, and we firmly believe that erwin Data Modeler by Quest is the best solution to help organizations understand, automate, visualize and unleash data for maximum impact.

Get started now

erwin Data Modeler is a proven data modeling technology for improving the quality, accuracy and agility of an enterprise’s data capabilities and supporting data governance and intelligence efforts. It’s time to put your data to work.