Once you sign in, your details will show here.
Knowledge Hub
Filter (1)
Sort
230 topics · Intermediate · 10 shown
Show allEvery topic is free to read. A free account also lets you search the topics, react to a topic and comment under it.
- I Am Datapedia!
Data Modeling and Design
BPMN(Business Process Model and Notation)
BPMN, which stands for Business Process Model and Notation, is a standardized visual language used to represent business processes. While Process Modelling explains the steps of a workflow, BPMN defines how those steps are drawn and represented so that everyone reads the process in the same way. Its purpose is to remove ambiguity and provide a clear, consistent way to describe how work flows through an organization.
The primary goal of BPMN is to create a common language that can be understood by both business stakeholders and technical teams. Business users can read BPMN diagrams to validate whether a process reflects how the organization actually works, while technical teams can use the same diagrams to configure workflow systems or automation tools. This shared understanding reduces miscommunication between business and IT.
BPMN builds on the ideas of Process Modelling by introducing a defined set of symbols and rules. These symbols represent common process elements such as activities, events, decision points, and responsibilities. For example, tasks represent work being performed, events show when a process starts or ends, and gateways represent decisions such as approvals or rejections. Swimlanes are used to show who is responsible for each task, such as a person, role, or department. Because these symbols are standardized, BPMN diagrams look familiar and consistent across organizations and industries.
4 min readMore
- I Am Datapedia!
Data Modeling and Design
Enterprise Data Modelling
Enterprise Data Modelling is the practice of creating a single, high-level view of data for the entire organization. Instead of looking at data system by system or project by project, it looks across all business areas and defines how key data concepts are understood at an enterprise level. The purpose is to make sure the organization has a shared understanding of its most important data.
The main goal of Enterprise Data Modelling is to provide a consistent framework for managing data across the whole enterprise. When this framework exists, different departments and systems can work together more easily. Data becomes easier to integrate, compare, and trust, because everyone is working from the same definitions.
This modelling approach brings together data from different subject areas such as customers, products, finance, and operations into one unified model. Rather than allowing each system to define data in its own way, Enterprise Data Modelling defines common entities and relationships that apply everywhere. Because of this, it acts as a strategic blueprint rather than a detailed design for a single application.
3 min readMore
- I Am Datapedia!
Data Modeling and Design
Conceptual and Logical Architecture Modelling
Conceptual and Logical Architecture Modelling describes the overall structure of an enterprise’s systems and how they interact, without focusing on specific technologies or physical implementations. It provides a blueprint that explains which systems exist, what roles they play, and how data and processes flow between them. At this stage, the goal is understanding and alignment, not technical configuration.
The primary goal of this modelling approach is to ensure that systems, data, and processes are well aligned with business needs. By clearly defining how different parts of the architecture fit together, organizations can design solutions that are scalable, well-integrated, and easier to govern over time. This helps prevent fragmented systems and poorly connected solutions that grow in isolation.
Conceptual and Logical Architecture Modelling focuses on components and interactions, rather than code, databases, or vendors. At the conceptual level, it presents a high-level view of the architecture, typically showing major domains such as applications, data, and infrastructure. This view answers questions like which systems exist and what their responsibilities are. At the logical level, the model goes a step further by showing how data flows between systems, how integrations work, and how systems are logically grouped, still without committing to specific technologies.
3 min readMore
- I Am Datapedia!
Data Modeling and Design
Concept Modelling
Concept Modelling is the practice of identifying and defining the core business concepts and making sure their meanings are clearly understood and consistently used across an organization. It focuses on what things mean in the business, rather than how they are stored, processed, or implemented in systems. The purpose is to create shared understanding before any technical design begins.
The main goal of Concept Modelling is to establish a common vocabulary. In many organizations, the same word can mean different things to different teams. Concept Modelling removes this confusion by clearly defining key terms and agreeing on their meanings. When everyone uses the same language, communication improves and misunderstandings are reduced.
This modelling approach captures the essence of business concepts such as Customer, Loan, Product, or Approval Decision. It also shows how these concepts relate to one another at a semantic level. Importantly, Concept Modelling does not include technical details such as attributes, data types, tables, or system logic. It stays intentionally simple and focused on meaning. Because of this, concept models often become the foundation for later artefacts such as ontologies, information models, and data models.
4 min readMore
- I Am Datapedia!
Data Modeling and Design
Taxonomy Modelling
Taxonomy Modelling is the practice of organizing concepts into hierarchical categories, typically arranged in parent–child structures. Its purpose is to classify terms in a structured and consistent way so that they are easier to understand, navigate, and manage.
The main goal of Taxonomy Modelling is to provide a clear and simple classification framework. By grouping related concepts under broader categories, organizations can standardize terminology, improve search and navigation, and ensure that everyone uses the same structure when referring to business terms.
A taxonomy focuses purely on classification. It arranges concepts into levels of abstraction, moving from general to specific. For example, in healthcare, one might classify Diseases at a high level, then Infectious Diseases beneath that, followed by Viral Infections, and then specific conditions such as COVID-19. Each level refines the previous one. The structure is hierarchical and orderly, but it does not attempt to capture complex rules or reasoning.
3 min readMore
- I Am Datapedia!
Data Modeling and Design
Canonical Data Modelling
Canonical Data Modelling is the practice of defining a standard, enterprise-wide representation of core data entities so that all systems within an organization can exchange information consistently. Instead of allowing each application to maintain its own version of key business objects such as Customer, Product, or Loan Application, a canonical model establishes a shared and authoritative structure that serves as the common reference point for integration. The term “canonical” refers to a standard or accepted form. In mathematics, a canonical representation expresses something in a normalized and agreed structure. In enterprise architecture, the same principle applies: a canonical model defines how a business entity should be represented when it moves between systems, even though each system may maintain its own internal structure.
In many organizations, integration evolves through point-to-point connections. In a point-to-point model, each system directly maps its data format to every other system it communicates with. While this may work in small environments, it becomes increasingly complex as more systems are added. If five systems need to exchange information, each system may require multiple custom mappings. As the enterprise grows, the number of integrations expands rapidly, creating tight coupling, duplicated transformation logic, and high maintenance overhead. Any change to one system, such as an upgrade or replacement, can require modifications in many connected systems. Over time, the integration landscape becomes fragile and difficult to manage.
4 min readMore
- I Am Datapedia!
Data Modeling and Design
Semantic Data Modelling
Semantic Data Modelling is the practice of designing data structures that are enriched with explicit business meaning so that both humans and machines can interpret and use the data consistently. Unlike purely structural models that define tables, fields, and relationships without deeper context, semantic data models embed meaning directly into the design. They ensure that data is not only structured correctly, but also understood correctly across systems, domains, and even organizational boundaries.
The primary goal of Semantic Data Modelling is to create data models that are self-descriptive and semantically precise. In traditional modelling, a field such as CustomerID may simply be defined as a numeric identifier. In a semantic model, however, that identifier is linked to a formal definition stating that it represents a unique identifier for a person or organization holding an account within a specific business context. The model clarifies what the data means, not just how it is stored. This added semantic layer enables interoperability, governance, and machine-driven reasoning.
6 min readMore
- I Am Datapedia!
Data Modeling and Design
Conceptual Data Modelling (CDM)
Conceptual Data Modelling (CDM) provides a high-level, business-oriented view of data by identifying core entities and the relationships between them without introducing technical implementation details. Its purpose is to describe how the business views its data, not how the database stores it. At this stage, the emphasis is on clarity and shared understanding rather than normalization, indexing, or storage optimization.
The primary goal of Conceptual Data Modelling is to capture the essence of business information in a way that non-technical stakeholders can understand and validate. Business leaders, analysts, and architects must first agree on what exists in the domain and how those things relate to each other before moving into more detailed design stages. CDM therefore serves as a bridge between business requirements and logical data modelling.
In a loan approval domain, for example, the conceptual model identifies high-level entities such as Customer, Loan, Application, Approval Decision, and Repayment Schedule. It then defines how these entities relate. A Customer applies for a Loan. A Loan results in an Approval Decision. A Loan has a Repayment Schedule. These relationships are represented visually as connected entities, as shown in the referenced diagram, where lines between boxes indicate how entities are associated. At this level, attributes such as interest rate, date fields, or data types are intentionally omitted. The focus remains on “what exists” and “how it connects.”
7 min readMore
- I Am Datapedia!
Data Modeling and Design
Logical Data Modelling (LDM)
Logical Data Modelling defines the detailed structure of data entities, attributes, and relationships by applying formal structural principles such as normalization to ensure accuracy, consistency, and elimination of redundancy. Where the Conceptual Data Model described what exists in the business and how entities relate, the Logical Data Model specifies exactly how those entities are structured in terms of attributes, identifiers, and constraints, while still remaining independent of any specific database technology.
The primary goal of Logical Data Modelling is to create a precise and normalized representation of data that is implementation-ready but not yet tied to a particular platform. It acts as a structural blueprint that ensures data integrity, clarity of relationships, and enforcement of business rules before moving into physical optimization. At this stage, ambiguity is removed and formal definitions are introduced.
4 min readMore
- I Am Datapedia!
Data Modeling and Design
Physical Data Modelling (PDM)
Physical Data Modelling defines the concrete implementation of data structures within a specific database platform. While the Logical Data Model specifies entities, attributes, and relationships in a technology-independent manner, the Physical Data Model translates that blueprint into executable database objects. At this stage, abstract schemas become real tables, columns, datatypes, indexes, partitions, constraints, and storage configurations tailored to a chosen platform such as PostgreSQL, Oracle, SQL Server, Snowflake, or a cloud-native engine.
The primary goal of Physical Data Modelling is to implement the logical design in a way that supports performance, scalability, reliability, and security. Unlike conceptual and logical models, which remain platform-agnostic, the physical model is deeply technology-specific. Decisions about datatypes, indexing strategies, clustering methods, partitioning schemes, and storage layouts are made with awareness of the target database engine and workload characteristics.
7 min readMore
Build a strong foundation in Data & AI
Follow the Data Foundations learning path (Beginner to Advanced).