Data modelling

What is data modeling?

November 3, 2022
November 3, 2022
03 November 2022

Data modeling is a central step of software engineering. A data-driven company’s objectives are to evaluate all data dependencies, to explain how the data will be used by the software, and to define the data objects that will be stored in the database for later use. Are you wondering about what data modeling is, its founding principles, and the different types of models? Follow this guide!

The life cycle of data, while it may seem technically complex, is conceptually quite simple. First, you need to collect the data. Then you need to clean and organize it. Finally, you need to understand how you can use it. This crucial phase is based on data modeling. The idea is to create a visual representation of an entire data portfolio (or certain segments of the data) to easily identify the different types of data available, the relationships that may exist between these different types of data, and how they can be grouped together, split up, or in any case organized to interact and generate value.

Data modeling, therefore, plays a key role in knowing how to exploit your data. Data models are built to meet the needs of the business. So, while there are different types of data models, one should never lose sight of the company’s objectives for data modeling to be truly effective.

Some of the advantages of data modeling include: reducing the risk of error during database software development, saving valuable time during the design and creation of databases, and ensuring consistency in the design of data systems. Data modeling also promises to simplify the communication between data and business teams.

The different types of data modeling

To get started on the path to data modeling, you need to start by knowing the main types of data models. Very schematically, there are three types of models:

The conceptual data model

The conceptual data model gives context and helps teams understand the data outside of the technical dimension. The conceptual model is for everyone in your company, even those who lack technical skills. The conceptual model describes the data contained by the system, its attributes and data constraints, the business rules that govern the data, and the data security and integrity requirements.

The logical data model

Logical models deliver more detail about the concepts and relationships in a data domain. In other words, they describe entities and attributes to provide a clear representation of the purpose of data for the business. A logical data model is a model that is not specific to a database. It describes the data in as much detail as possible, regardless of how it will be physically implemented in the database. Characteristics of a logical data model include all entities and the relationships between them, the attributes of each entity, and the primary key of each entity, for example.

The physical data model

The physical data model represents how the model will be built in the database. A physical database model displays the entire table structures, including the column name, column data type, column constraints, primary key, foreign key, and relationships between tables. A physical data model will be used by database administrators to estimate the size of database systems and to perform capacity planning.

How data modeling works

Data modeling is based on three key models: the relational model, the hierarchical model, and the entity-association model. The relational model is both the oldest and the most commonly used. It deals primarily with numerical data and is used mainly in mathematical calculations such as sums or averages. There is also the option to move towards a hierarchical model, which is optimized for online queries and data warehouse tools. In this case, the data is classified hierarchically, in a descending structure. Finally, there is the E-R model, which is used to generate a relational database in which each entry represents an entity and has fields that contain attributes.

Guarantee the integrity of your data, make the use of your data assets more reliable, and facilitate the development of a data culture within your company… Data modeling will allow you to be part of a virtuous circle of data use!

zeenea logo

At Zeenea, we work hard to create a data fluent world by providing our customers with the tools and services that allow enterprises to be data driven.

zeenea logo

Chez Zeenea, notre objectif est de créer un monde “data fluent” en proposant à nos clients une plateforme et des services permettant aux entreprises de devenir data-driven.

zeenea logo

Das Ziel von Zeenea ist es, unsere Kunden "data-fluent" zu machen, indem wir ihnen eine Plattform und Dienstleistungen bieten, die ihnen datengetriebenes Arbeiten ermöglichen.

Related posts

Articles similaires

Ähnliche Artikel

Be(come) data fluent

Read the latest trends on big data, data cataloging, data governance and more on Zeenea’s data blog.

Join our community by signing up to our newsletter!

Devenez Data Fluent

Découvrez les dernières tendances en matière de big data, data management, de gouvernance des données et plus encore sur le blog de Zeenea.

Rejoignez notre communauté en vous inscrivant à notre newsletter !

Werden Sie Data Fluent

Entdecken Sie die neuesten Trends rund um die Themen Big Data, Datenmanagement, Data Governance und vieles mehr im Zeenea-Blog.

Melden Sie sich zu unserem Newsletter an und werden Sie Teil unserer Community!

Let's get started
Make data meaningful & discoverable for your teams
Learn more >

Los geht’s!

Geben Sie Ihren Daten einen Sinn

Mehr erfahren >

Soc 2 Type 2
Iso 27001
© 2024 Zeenea - All Rights Reserved
Soc 2 Type 2
Iso 27001
© 2024 Zeenea - All Rights Reserved
Démarrez maintenant
Donnez du sens à votre patrimoine de données
En savoir plus
Soc 2 Type 2
Iso 27001
© 2024 Zeenea - Tous droits réservés.