Data Modeling

Data modeling (sometimes spelled data modelling) is the analysis of data objects and their relationships to other data objects. Data modeling is often the first step in database design and object-oriented programming as the designers first create a conceptual model of how data items relate to each other.

How is database modeling used?

Data modeling involves a progression from conceptual model to logical model to physical schema. It’s typically the first step in database design and object-oriented programming, acting as a blueprint for building an optimized database. Designers first create a conceptual model of how data items relate to each other, which data architects can use to build out the physical blueprint. 

In summary, data modeling works as a solution between collecting data and turning it into an actionable database.


Portions of this definition originally appeared on Datamation.com and are excerpted here with permission.


What are the types of data models?

The three primary types of data models—conceptual, logical, and physical—progress from an abstract layout to a detailed mapping of the database setup to the database’s final form.

Conceptual data model

Conceptual data models are the simplest and most abstract with little annotation or data used. Frequently used in the discovery stage of a project, the primary goal is to determine the overall layout and rules of data relationships, often related to regulations and data categories.

Logical data model

Logical data models expand on the basic framework of the conceptual model. Particularly useful in data warehousing plans, the goal is to consider more relational factors and make annotations related to overall properties or data attributes.

Physical data model

Physical data models are typically the final and most detailed step before database creation, focusing on database management system-specific properties and rules. It also illustrates details about data points and their relationships enough to create a blueprint with all needed instructions for the database build.

Data model infrastructure

Organizations can choose from several different design and infrastructure methods for visualizing their data beyond the three main types of data modeling.

Such options include the:

  • Hierarchical Data Model: Similar to a family tree, data entities look like “parents” or “children” and branch off from other data that shares a relationship with them.
  • Relational Data Model: These models are like hierarchical data models, although instead of parent-child relationships, it maps out the connections among various tables of data.
  • Entity-Relationship (ER) Data Model: The ER data model creates a diagram that showcases data entities and their relationships. It’s often used with the relational model to understand how data should connect in a database.
  • Object-Oriented Data Model: This model, often used in early development stages of multimedia technologies, groups complex real-world data entities into easy-to-read class hierarchies.

Data modeling features

The following are some of the key features of any approach to data modeling:

Data entities and their attributes

Data entities are abstractions of real pieces of data, and attributes are the properties that characterize those entities. When used together, it becomes easier to find relationships, or the similarities and connections across entities.

Unified modeling language (UML)

UML can be considered a set of building blocks and best practices for data modeling. It is a standard modeling language that helps data professionals visualize and construct appropriate model structures for their data needs.

Normalization through unique keys

Normalization is the technique that eliminates the repetition that occurs when building out relationships within a large set of data. It does this by assigning unique keys or numerical values to different groups of data entities, which allows users to normalize, or list only keys, repeating data entries for new entity relationships.


Read more about data modeling in enterpise applications at Datamation.

Shelby Hiter
Shelby Hiter
Shelby Hiter is a writer with more than five years of experience in writing and editing, focusing on healthcare, technology, data, enterprise IT, and technology marketing. She currently writes for four different digital publications in the technology industry: Datamation, Enterprise Networking Planet, CIO Insight, and Webopedia. When she’s not writing, Shelby loves finding group trivia events with friends, cross stitching decorations for her home, reading too many novels, and turning her puppy into a social media influencer.

Related Articles

What is Data?

Data refers to distinct pieces of information, usually formatted and stored in a way that is concordant with a specific purpose. What does data look...

GDPR

The General Data Protection Regulation, commonly referred to as GDPR, is an EU regulation concerning data protection and privacy in the European Union (EU)...

Qualitative Data

Qualitative data is any set of data, including text, images, and video, that expresses the subjective and interpretive qualities of an item or process....

Quantitative Data

Quantitative data is any set of numerical data, typically used for mathematics or statistics, that can be analyzed and measured objectively. Some examples of...

ScalaHosting

ScalaHosting is a leading managed hosting provider that offers secure, scalable, and affordable...

HRIS

Human resources information system (HRIS) solutions help businesses manage multiple facets of their...

Best Managed Service Providers...

In today's business world, managed services are more critical than ever. They can...