A data model (or datamodel) is an abstract model that organizes elements of data and standardizes how they relate to one another and to properties of the real world entities .
A database model shows the logical structure of a database, including the relationships and constraints that determine how data can be stored and accessed. Individual database models are designed based on the rules and concepts of whichever broader data model the designers adopt. Most data models can be represented by an accompanying database diagram .
Data modeling helps in the visual representation of data and enforces business rules, regulatory compliances, and government policies on the data. Data Models ensure consistency in naming conventions, default values, semantics, security while ensuring quality of the data .
Data model emphasizes on what data is needed and how it should be organized instead of what operations need to be performed on the data. Data Model is like architect’s building plan which helps to build a conceptual model and set the relationship between data items .
Categories and types of Data Model
There are mainly three different types of data models :
Conceptual: This Data Model defines WHAT the system contains. This model is typically created by Business stakeholders and Data Architects. The purpose is to organize, scope and define business concepts and rules.
Logical: Defines HOW the system should be implemented regardless of the DBMS. This model is typically created by Data Architects and Business Analysts. The purpose is to developed technical map of rules and data structures.
Physical: This Data Model describes HOW the system will be implemented using a specific DBMS system. This model is typically created by DBA and developers. The purpose is actual implementation of the database.
Common Characteristic of Data Model
Characteristics of a conceptual data model
Offers Organisation-wide coverage of the business concepts.
This type of Data Models are designed and developed for a business audience.
The conceptual model is developed independently of hardware specifications like data storage capacity, location or software specifications like DBMS vendor and technology. The focus is to represent data as a user will see it in the “real world.“
Characteristics of a Logical data model
Describes data needs for a single project but could integrate with other logical data models based on the scope of the project.
Designed and developed independently from the DBMS.
Data attributes will have datatypes with exact precisions and length.
Normalization processes to the model is applied typically till 3NF.
Characteristics of a physical data model:
The physical data model describes data need for a single project or application though it maybe integrated with other physical data models based on project scope.
Data Model contains relationships between tables that which addresses cardinality and nullability of the relationships.
Developed for a specific version of a DBMS, location, data storage or technology to be used in the project.
Columns should have exact datatypes, lengths assigned and default values.
Primary and Foreign keys, views, indexes, access profiles, and authorizations, etc. are defined.
Data Model Consideration
To develop Data model one should know physical data stored characteristics.
This is a navigational system produces complex application development, management. Thus, it requires a knowledge of the biographical truth.
Even smaller change made in structure require modification in the entire application.
There is no set data manipulation language in DBMS.
Data modeling is the process of developing data model for the data to be stored in a Database with a main goal to make certain that data objects offered by the functional team are represented accurately .
Data Models ensure consistency in naming conventions, default values, semantics, security while ensuring quality of the data .
There are three types of conceptual, logical, and physical .
The main aim of conceptual model is to establish the entities, their attributes, and their relationships.
Logical data model defines the structure of the data elements and set the relationships between them.
A Physical Data Model describes the database specific implementation of the data model.
I am lecturer in Interactive Media Department, Faculty of Information and Communication Technology (FTMK), Universiti Teknikal Malaysia Melaka (UTeM), Melaka, Malaysia. Currently on study leave doing PhD research study at University of Southampton, United Kingdom. My research relate to MOOC, analytic data and web observatory. I also interest on technopreneur , research and innovation activities in multidisciplinary fields.