Difference between hierarchical and network database model in SQL

SQLSQLiteDatabase

In Hierarchical data model, relationship between table and data is defined in parent child structure. In this structure data are arranged in the form of a tree structure. This model supports one-to-one and one-to-many relationships.

On the other hand, network model arrange data in graph structure. In this model each parents can have multiple children and children can also have multiple parents. This model supports many to many relationships also.

Sr. No.KeyHierarchical Data ModelNetwork Data Model

1

Basic 

Relationship between records is of the parent child type

Relationship between records is expressed in the form of pointers or links.

2

        Data Inconsistency 

It can have data inconsistency during the updation and deletion of the data 

No Data inconsistency 

3

Traversing 

Traversing of data is complex 

Data traversing is easy because node can be accessed from parent to child or child to parent 

4

Relationship

It does not support many to many relationships  

It support many to many relationships  

5

Structure 

Its create tree like structure 

It support graph like structure 


raja
Published on 21-Jan-2020 14:17:19
Advertisements