A Data Model in Database Management System (DBMS), is the concept of tools that are developed to summarize the description of the database.
It is classified into 3 types:
1. Conceptual Data Model :
Conceptual data model, describes the database at a very high level and is useful to understand the needs or requirements of the database. It is this model, that is used in the requirement gathering process i.e., before the Database Designers start making a particular database. One such popular model is the entity/relationship model (ER model). The E/R model specializes in entities, relationships and even attributes which are used by the database designers. In terms of this concept, a discussion can be made even with non-computer science(non-technical) users and stakeholders, and their requirements can be understood.
2. Representational Data Model :
This type of data model is used to represent only the logical part of the database and does not represent the physical structure of the databases. The representational data model allows us to focus primarily, on the design part of the database. A popular representational model is Relational model.
3. Physical Data Model :
Ultimately, all data in a database is stored physically on a secondary storage device such as discs and tapes. This is stored in the form of files, records and certain other data structures. It has all the information of the format in which the files are present and the structure of the databases, presence of external data structures and their relation to each other.
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.
- Thread Models in Operating System
- OSI, TCP/IP and Hybrid models
- Data Abstraction and Data Independence
- Normal Forms in DBMS
- Relational Model in DBMS
- ACID Properties in DBMS
- DBMS Architecture 2-Level, 3-Level
- Introduction of Relational Model and Codd Rules in DBMS
- Precedence Graph For Testing Conflict Serializability in DBMS
- Thomas Write Rule in DBMS
- Armstrong's Axioms in Functional Dependency in DBMS
- Advantages of DBMS over File system
- Database Recovery Techniques in DBMS
- Deadlock in DBMS
- Transaction Isolation Levels in DBMS
- File Organization in DBMS | Set 2
- Starvation in DBMS
- Number of possible Superkeys in DBMS
- File Organization in DBMS | Set 1
- File Organization in DBMS | Set 3
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.