Title: Data Modelling Author: Kriko Published: May 30, 2023 Last modified: Jul 7, 2026 --- 1. [Home](https://kriko.io/) / 2. [Glossary](https://kriko.io/glossary) / 3. D Letter # Data Modelling **[Data](https://kriko.io/services/data-analysis-insight) modelling** is the process of creating models that define an organisation's [data](https://kriko.io/services/data-analysis-insight), the relationships between different [data](https://kriko.io/services/data-analysis-insight) elements and the way information will be stored. Business requirements, [data](https://kriko.io/services/data-analysis-insight) structures and database designs are represented through visual diagrams and technical definitions. [Data](https://kriko.io/services/data-analysis-insight) modelling enables organisations to explain systematically what information they collect, what it represents and how different [data](https://kriko.io/services/data-analysis-insight) elements are connected. Entities such as customers, products, orders, employees and suppliers can be defined together with their relevant attributes. Relationships between these entities are also represented according to specific business rules. This makes complex [data](https://kriko.io/services/data-analysis-insight) structures easier to understand, manage and maintain. [Data](https://kriko.io/services/data-analysis-insight) models may use diagrams to represent tables, fields, entities and relationships. These visual structures help business and technical teams develop a shared understanding of [data](https://kriko.io/services/data-analysis-insight) requirements. Professionals responsible for this work may be described as [data](https://kriko.io/services/data-analysis-insight) modellers, data architects or database designers. Their role is not limited to creating visual designs, as they must also translate business requirements into accurate and practical data structures. Data modelling makes it easier for an organisation to document the information it holds and the ways in which that information is used. A well-designed model can improve communication between business teams and information technology departments. It can support **data consistency** by preventing the same concept from being defined differently across multiple systems. It may also help identify duplicate records, missing relationships and unsuitable data structures before development begins. The data modelling process is generally divided into three main levels: **conceptual, logical and physical data models**. These models represent the same system at different levels of detail. The conceptual model focuses on business requirements, the logical model defines the structure of the data, and the physical model addresses technical implementation. Each stage provides a foundation for the next level of design. A **conceptual data model** presents the main business concepts and the general relationships between them. It does not include detailed database or technology specifications. For example, customer, product and order may be defined as the main entities. The model may also show that a customer can place an order and that an order can include one or more products. A **logical data model** transforms the entities identified in the conceptual model into a more detailed data structure. It defines entity attributes, unique identifiers and the rules governing relationships. For example, a customer entity may contain a customer number, name, contact details and membership date. The logical model remains independent of a specific database technology and describes how the information should be organised. A **physical data model** defines how the logical model will be implemented within a specific database management system. It includes table and column names, data types, primary and foreign keys, indexes, constraints and storage details. For example, a customer number may be created as an integer primary key, while a foreign key in the order table may link each order to the relevant customer. The physical model therefore represents the level closest to the actual technical database design. A relationship described as "a customer purchases a product" in the conceptual model may be expanded into customer, order and product entities in the logical model. In the physical model, this structure is implemented through actual tables, fields and key relationships. The process therefore moves systematically from a general business requirement to a working database design. This approach helps ensure that the final database meets both business needs and technical performance requirements. In summary, data modelling defines not only how information will be stored but also what it means and how different data elements are connected. A well-prepared data model can accelerate database development and reduce structural problems that may otherwise emerge later. It also provides a more reliable foundation for reporting, analytics, integration and data governance activities. Data modelling is therefore considered one of the core stages of modern data management. ## Discover it in the dictionary ### Prototype A prototype is an early-stage model created to test a product, service, interface, process or idea. It can also be described as an initial… ### Link Building Link building is an important concept in SEO that refers to activities aimed at strengthening a website's link profile. Link building can generally be… ### Attribution Models Attribution models are measurement approaches that determine how conversion credit is distributed across the marketing channels, ads or interactions a user touches before completing… ### Google Search Console (GSC) Google Search Console, commonly abbreviated as GSC, is a free Google service used to monitor a website's visibility, performance and technical status in Google… ### Data Mining Data mining is an analytical approach used to discover meaningful patterns, relationships and trends within large datasets. It helps transform raw information into insights… ### Session Duration Session duration is a web analytics concept that refers to how much time a user spends on a website or application during a specific… ### NoSQL NoSQL refers to database systems that operate outside the traditional relational database model and are used to store, manage and query different types of… ### Usability Usability refers to how easily, efficiently and accurately users can use a product, system, website, application or process. Usability is not limited to digital… ### White hat SEO White hat SEO refers to search engine optimization practices that follow search engine guidelines, focus on users and aim for sustainable organic visibility. The… ## Track the digital heartbeat with Kriko Subscribe to receive curated insights, news, and ideas shaping the digital landscape. By checking this box, you acknowledge and accept our [privacy policy](https://kriko.io/privacy-policy).