We are independent & ad-supported. We may earn a commission for purchases made through our links.
Advertiser Disclosure
Our website is an independent, advertising-supported platform. We provide our content free of charge to our readers, and to keep it that way, we rely on revenue generated through advertisements and affiliate partnerships. This means that when you click on certain links on our site and make a purchase, we may earn a commission. Learn more.
How We Make Money
We sustain our operations through affiliate commissions and advertising. If you click on an affiliate link and make a purchase, we may receive a commission from the merchant at no additional cost to you. We also display advertisements on our website, which help generate revenue to support our work and keep our content free for readers. Our editorial team operates independently of our advertising and affiliate partnerships to ensure that our content remains unbiased and focused on providing you with the best information and recommendations based on thorough research and honest evaluations. To remain transparent, we’ve provided a list of our current affiliate partners here.
Software

Our Promise to you

Founded in 2002, our company has been a trusted resource for readers seeking informative and engaging content. Our dedication to quality remains unwavering—and will never change. We follow a strict editorial policy, ensuring that our content is authored by highly qualified professionals and edited by subject matter experts. This guarantees that everything we publish is objective, accurate, and trustworthy.

Over the years, we've refined our approach to cover a wide range of topics, providing readers with reliable and practical advice to enhance their knowledge and skills. That's why millions of readers turn to us each year. Join us in celebrating the joy of learning, guided by standards you can trust.

What are Data Models?

By Troy Holmes
Updated: May 16, 2024
Views: 36,839
Share

A software application typically stores business information in files and databases. Data models are a logical representation of the business processes in a organization. They define how the business interacts with people, places, and things. The data model is used as a reference point for determining the rules of relationships between entities within an organization.

The data model creation process is divided into three primary stages. These are domain models, logical models, and physical models. Each stage is completed in a progression ending with the physical model, which represents the actual structure of the database.

The design of the domain model is the first step in creating a data model. This is a high-level view of the business units within an organization and their relationships to each other. Domain data models define the conceptual relationship between organizations and the processes required to complete a business function. An example of a domain model is the relationship between the ordering of a product and the effect the order has on the shipping department.

The enterprise domain model is typically a very high-level view of the organization and does not require the exact details on each type of business requirement. It is important, however, to include all impacted business units within the domain model design. This high-level design is necessary for the project team to understand the detail functions that are required to complete business functions.

Logical data models are the versions of data models that represent the actual business requirements of a company. These models are designed based on the high-level domain models of specific business units within an organization. A sound logical design is critical to create the physical database. This process must clearly define the data elements that are necessary to complete a specific business requirement. Logical data models include how data will be accessed and the relationships between entities within a business process.

A good example of a logical data model could be a modeling of customers for a telephone company. Each customer has a specific name, phone number, address, and phone features. The logical data model would provide the relationships between these types of elements including how the information would be reported and retrieved.

The final layer of data models is the physical data model. This is the area of data models that is used in creating the actual database. The physical data model is the database-specific blue print, which defines how data will be stored within the software application.

Share
EasyTechJunkie is dedicated to providing accurate and trustworthy information. We carefully select reputable sources and employ a rigorous fact-checking process to maintain the highest standards. To learn more about our commitment to accuracy, read our editorial process.
Discussion Comments
By NathanG — On Dec 26, 2011

@hamje32 - I should point out that not everyone who interacts with the data is a developer. If you’re an analyst the data analysis models listed here are of limited usefulness.

I suppose the most useful one mentioned is the physical data model, knowing how information is stored in the database. You won’t be doing object oriented programming as an analyst.

You get down in the muck and mire of the data itself, writing queries and creating reports. At least that’s what I did when I was an analyst.

By hamje32 — On Dec 26, 2011

@David09 - Yeah, I think it’s the supervisors or software architects who build the domain level model. I’ve programmed for years and never had to mess with it.

As for the logical model, I think there are ways of coding without using object oriented programming, but it gets messy and results in what is known as “spaghetti code.”

That’s where your code twists and turns in various loops and directions to accomplish its intended function. Spaghetti code is ugly.

By David09 — On Dec 25, 2011

I work as a developer for a software company. I think of all the conceptual data models listed here, the logical data model is one that most developers are familiar with. That’s because most programming nowadays is what’s known as object oriented, and this falls right in line with the logical data model.

In object oriented programming we create objects (or classes) in the code that model the real world objects the program is supposed emulate. For example a banking application might have a Bank class, with a deposit and withdraw function, as well as a Customer class and so forth. You get the idea.

We look at the real world objects and we create objects in code to mirror. We don’t do this to be clever, but so that the code will be easier to understand and maintain. I love object oriented programming and have been doing it for quite some time now.

Share
https://www.easytechjunkie.com/what-are-data-models.htm
Copy this link
EasyTechJunkie, in your inbox

Our latest articles, guides, and more, delivered daily.

EasyTechJunkie, in your inbox

Our latest articles, guides, and more, delivered daily.