- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Difference between hierarchical and network database model in SQL
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. | Key | Hierarchical Data Model | Network 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 |