EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login

Types of Database Models

Home » Data Science » Data Science Tutorials » Database Management Tutorial » Types of Database Models

Types-of-Database-Model

Introduction to Types of Database Models

Database models are basically known as database schemas, which are used to represent database structure and the format of database which is managed by the database management system. The database models represent the look and feel of the database. There are various types of database models like network model, entity-relationship model, hierarchical model, object-oriented model and object model. These all types of database models have different looks from each other and the operations performed on this type of database model are different from each other. The uses of database models vary as per the user requirements.

Types of Database Models

Given below are the different types of database models:

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Types of Database Models

1. Flat Model

In the flat database model, there is a single two-dimensional array of the data elements in which columns are assumed to have a similar type of values and in the row, the elements should have relational value relational to one another.

For example, there are two columns named as name and password which can be used by any security system. So each row is used to store different passwords and usernames. No two entry is the same in the flat model. In the flat model, the table format is used for storing the database. This database model has a disadvantage as it is unable to store huge chunks of data in the two-dimensional array because it is difficult to manage such a large set of entries in a flat database model.

2. Hierarchical Model

In the hierarchical model, the data is stored in the tree-like structure in which there is a root node where the data is started to store. The sort field is used for the sibling record to maintain some order while storing data in the hierarchical model. The hierarchical database model is mostly used when there is a need for maintaining an information management system. In this database model there exist a one-to-many relationship among data. The retrieval of data has a different technique in the hierarchical model.

The technique follows navigating a downward direction using the pointers so that data can be accessed sequentially. Because of this technique, the hierarchical database model has a disadvantage as it is not capable of handling all types of database operations. The retrieval time of data is more compare to other types of database models. The records are not connected to the hierarchical model. And the model consists of an upward link that is used to represent the hierarchy of data stored in the database system.

3. Network Model

The network structure database model has a very similar structure as compared to the hierarchical model. This model allows a many-to-many relationship in the tree-like structure model. It means there can be multiple parents. The network model uses the two fundamental concepts i.e. sets and records. The records contain file which can be in hierarchical form and sets which are used to define the many-to-many relationship among the records. The set uses the circular linked list as the data structure in which one record which is a parent can appear once in a circle and the child of that particular parent can appear more than once in each circle.

In the network database model, the records are connected to each other. In this manner, the hierarchy is maintained among the records. The data access in this database model is either in sequential form or can be in a circular linked list pattern. And there can be multiple paths to access to any particular record. The disadvantage of this network model is that it contains redundancy among the records which means one record can appear more than one time in the database model.

Popular Course in this category
All in One Data Science Bundle (360+ Courses, 50+ projects)360+ Online Courses | 1500+ Hours | Verifiable Certificates | Lifetime Access
4.7 (3,220 ratings)
Course Price

View Course

Related Courses
SQL Training Program (7 Courses, 8+ Projects)PL SQL Training (4 Courses, 2+ Projects)Oracle Training (14 Courses, 8+ Projects)

4. Relational Model

The relational database model is designed to remove the dependency in the database management system. The development of the relational database model is targeted for mostly microcomputer systems. The three keys which are used in relational database models are domains, attributes, and relations. The relation is defined as a table that contains rows and columns. The columns present in the table are called attributes in the relational database model. And the domain is defined as a set of values that can be inserted in the database model. The data structure used is a table in this model and the data is stored in the form of rows and columns in the model. The rows are also known as tuples.

For example, there is a relation named employee details. It can have multiple attributes like name, age, gender. And there can be multiple tuples for one single relation named as employee details. The key which can be used to uniquely identify any row is called the primary key. And these keys can be used to join more than one table at the same time. For example, there can be a column named location in the employee table and the column location can be the primary key of the location table.

By this key, the two table location table and employee table can join and the operations can be performed on the join table. The relational database model uses the structured query language (SQL) to perform operations on the database system. The relational model contains multiple tables which look like flat database model. One of the key advantages of this model is whenever the value appears more than on time in two different records there exist some relationships among them.

5. Dimensional Model

The dimensional database model is defined as a specialized version of the relational database model. This model is used to represent data in the data warehouses in such a manner so that data can be summarized using OLAP queries and online analytical processing. In the dimensional database model, the database schema consists of a single table of a huge size which contains facts and dimensions. The dimension is used to define the context of fact and is in hierarchical form. The dimensional database model uses the star schema which contains a highly normalized table that has facts and dimensions.

Conclusion

The database models are widely used to store data in different structural forms. The goal is to maintain the structure properly so that data retrieval time is minimum as possible. And the database operations can be performed easily in different types of database models.

Recommended Articles

This is a guide to Types of Database Models. Here we discuss the introduction and 5 different types of database models in detail. you may also have a look at the following articles to learn more –

  1. Cloud Service Models
  2. NoSQL Data Models
  3. Laravel Models
  4. Top 8 Relational Database Advantages
  5. How to Use Primary Key in SQL?
  6. 10 Different Types of Database
  7. Circular Linked List in Data Structure

All in One Data Science Bundle (360+ Courses, 50+ projects)

360+ Online Courses

1500+ Hours

Verifiable Certificates

Lifetime Access

Learn More

0 Shares
Share
Tweet
Share
Primary Sidebar
Database Management Tutorial
  • DataBase Management
    • Introduction To DBMS
    • What is DBMS?
    • Roles of Database Management System in Industry
    • SQL Server Database Management Tools
    • Database Management Systems Advantages
    • Database Testing Interview Questions
    • Database Management Software
    • DataStage
    • Types of Database Models
    • Types of DBMS
    • Types of Database
    • Normalization in DBMS
    • Specialization in DBMS
    • Aggregation in DBMS
    • Relational Database
    • Relational Database Advantages
    • Operational Database
    • What is RDBMS?
    • What is DB2?
    • Data Masking Tools
    • Database Security
    • Relational Calculus in DBMS
    • Data Replication
    • Hashing in DBMS
    • Static Hashing in DBMS
    • Advantages of DBMS
    • Normal Forms in DBMS
    • Second Normal Form
    • Third Normal Form
    • Fourth Normal Form
    • Relationship in DBMS
    • ER Model in DBMS
    • Data Models in DBMS
    • Data Definition Language
    • Data Manipulation Language
    • Data Control Language
    • Transaction Control Language
    • Transaction Property in DBMS
    • Conceptual Data Model
    • Entity-Relationship Model
    • Relational Database Model
    • Serializability in DBMS
    • File Organization in DBMS
    • Functional Dependency in DBMS
    • Generalization in DBMS
    • Data Independence in DBMS
    • Deadlock in DBMS
    • Integrity Constraints in DBMS
    • Concurrency Control in DBMS
    • Sequential File Organization
    • Validation Based Protocol in DBMS
    • Checkpoint in DBMS
    • DBMS Canonical Cover
    • DBMS Log-Based Recovery
    • DBMS Multivalued Dependency
    • DBMS_Scheduler
    • Centralized Database
    • Data Storage in Database
    • Thomas write Rule
    • DBA Interview Questions
    • What is JDBC?
    • JDBC Architecture
    • JDBC Interview Questions
    • Wildcard Characters
    • Distributed Database System
    • Lock Based Protocols in DBMS
    • Multidimensional Database
  • PL/SQL
    • What is PL/SQL?
    • Careers in PL/SQL
    • PL/SQL Commands
    • PL/SQL Data Types
    • CASE statement in PL/SQL
    • Loops in PL/SQL
    • Triggers in PL/SQL
    • PL/SQL Collections
    • PLSQL Interview Questions
  • TSQL
    • What is T-SQL
    • T-SQL Commands
    • T-SQL String Functions
    • TSQL Interview Questions
  • MariaDB
    • MariaDB Versions
    • MariaDB Commands
    • MariaDB UPDATE
    • MariaDB AUTO_INCREMENT
    • MariaDB MaxScale
    • MariaDB Foreign Key
    • MariaDB Grant All Privileges
    • MariaDB List Databases
    • MariaDB Functions
    • MariaDB Transaction

Related Courses

SQL Certification Course

PL/SQL Certification Course

Oracle Certification Course

Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

© 2020 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you
Book Your One Instructor : One Learner Free Class

Let’s Get Started

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you