Data Models

Definition

A data model is an abstract representation that organizes elements of data and standardizes how they relate to one another and to the properties of real-world entities. It acts as a blueprint for database designers, ensuring that data is stored, processed, and accessed efficiently within an information system.

Main Content

1. Conceptual Data Model

• Focuses on the high-level business requirements and "what" data is needed.
• It identifies entities (e.g., Customer, Order) and their relationships without specifying technical details like data types.

2. Logical Data Model

• Defines "how" the data should be implemented in the database structure.
• It maps the conceptual model to specific entities and attributes, defining primary keys and foreign keys to establish relationships.

3. Physical Data Model

• Describes the "internal" schema of the database, specifying how data is physically stored in the system.
• Includes table names, column names, data types, indexes, and constraints tailored to a specific Database Management System (DBMS).

[Conceptual] -> [Logical] -> [Physical]
  Entities      Attributes     Tables/Indexes

Visual representation of the progression from abstract requirements to technical implementation.

Working / Process

1. Requirements Gathering

• Analysts interview stakeholders to identify business processes and the information necessary to support them.
• Creating a list of business rules that govern data integrity.

2. Design and Modeling

• Selecting the appropriate model type (e.g., Relational, Hierarchical, or NoSQL).
• Drawing Entity-Relationship Diagrams (ERDs) to visualize data flows and associations.

3. Validation and Implementation

• Reviewing the model with stakeholders to ensure it meets business needs.
• Translating the design into SQL scripts or NoSQL configurations to create the actual database structure.

Advantages / Applications

• Improves communication between technical developers and business stakeholders by using a common visual language.
• Reduces development costs by identifying errors in data structure early in the design phase.
• Enhances data quality and consistency across an organization by providing a single source of truth.

Summary

Data models provide the essential structural foundation for database design, progressing from abstract business concepts to technical implementation. By mapping relationships and data attributes, they ensure that complex information is organized efficiently for storage and retrieval. Important terms to remember include Entities, Attributes, Relationships, ERD, and Schemas.