Record Based Models

Record Based Models

Record Based Models-

In DBMS record based model are used for describing a data representation of database or project. The record based model is a logical description of database structure. If in table records are in fixed lenght then record based model are used for indication. In record based model record are joined with one another for sharing data. The record based model is divide in to 4 types-

  1. Hierarchical Model
  2. Network Model
  3. Relational Model
  4. Physical Data Models

We discuss each model in detail as fallows.

1. Hierarchical Model-

The hierarchical model is the simplest model in DBMS system. That model is represented as a tree structure. The hierarchical model structure mainly start with root node and connected to child nodes and parent nodes. This model easily represent the all over database relation in simplest manner. example display a food database relation to each other.

Hierarchical model

Advantages of Hierarchical Model-

  1. Very simple and easy to maintain.
  2. If change made in parent node then automatically change reflect in to child node.
  3. Relationship representation easy to understand.

Dis-Advantages of Hierarchical Model-

  1. That model not supported to complex data structures mainly.
  2. If parent node deleted the automatically child node deleted.

2. Network Model-

It is the extension model of hierarchical model. It is most popular model after hierarchical model. It is next extension of hierarchical model. In hierarchical model child node is only attached to single parent node but in network model the child node is join to 2 parent nodes mainly.

Network Model

Advantages of Network Model-

  1. Data accessing speed is larger than hierarchical model.
  2. If change made in parent node then automatically change reflect in to child node.

Dis-Advantages of Network Model-

  1. Complex relationship representation get complex in network model.

3. Relational Model-

In that model mainly maintain relations of table with each other. In relational model use tables for representing information mainly. The all information is denoted in to row and columns. In relational model the data is saved in two-dimensional method means information saved in table in row and column format.

relational model

Advantages of Relational Model-

  1. It simple to handle.
  2. More scalable as compare other models.

Dis-Advantages of Relational Model-

  1. Complex calculations not handle well in manner.

4. Physical Data Model-

Physical data model defines all logical representation of database. In that consist of table designing , column name and their values . In physical model also indicating the relationship between primary and foreign key of each other.

physical-data-model
Image Copy from 1keydata.com

 

 

Amol Shinde

Amol Shinde

Work as Assistant Professor and Web Developer.

Leave a Reply

Your email address will not be published. Required fields are marked *