- Trending Categories
- Data Structure
- Operating System
- C Programming
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Hierarchical Data Model
A hierarchical data model was one of the earliest data models. This model was a file based model build like a tree. In this tree, parent could be associated to multiple child nodes, but a child node could have only one parent.
In the case of directories and files, it could be said that a single directory further contained multiple files or directories, those directories then contained more files and so on.
This can be represented as −
An example of the hierarchical model using relational databases is as follows −
In the example given above, the Employee table is the parent table and the Computer table is the child. The computer table points to the employee table as it specifies which employee is using which computer.
Disadvantages of Hierarchical model
- In the hierarchical model, one to many relationships can easily be displayed as one parent node has multiple child nodes. But it is much more complicated to show many to many relationships using this model.
- The hierarchical model is rigid and not very flexible. If another node or relationship needs to be added to the model, it may disrupt the whole existing structure.
- Hierarchical Database Model
- What is Hierarchical model in DBMS?
- Difference between hierarchical and network database model in SQL
- How to traverse Hierarchical data in Oracle?
- Network Data Model
- Relational Data Model
- Object-oriented Data Model
- Object-relational Data Model
- What is hierarchical routing?
- What are Hierarchical Methods?
- Django model data to JSON data in 2 lines
- The Data Link Layer of OSI Model
- What is a Data Model in DBMS?
- C# Example for Hierarchical Inheritance
- Creating hierarchical JSON in MongoDB?