Hierarchical Database — IT Glossary | ITU Online IT Training
+1 855.488.5327 customerservice@ituonline.com Mon – Fri: 9:00am – 5:00pm ET

Hierarchical Database

Commonly used in Databases

Ready to start learning?Individual Plans →Team Plans →

A hierarchical database is a type of database model that organizes data in a tree-like structure, where each record is linked to one parent record and can have multiple child records. This structure resembles an inverted tree, with a single root at the top and branches extending downward to related data entries.

How It Works

In a hierarchical database, data is stored in records, which are connected through parent-child relationships. Each parent record can have multiple child records, but each child is linked to only one parent, establishing a one-to-many relationship. Data retrieval involves navigating this tree structure, starting from the root and following links to reach specific records. Relationships are predefined, and the database management system (DBMS) enforces the hierarchy, ensuring data integrity and consistency. To access a particular record, queries must specify the path through the hierarchy, often requiring sequential navigation from the root or intermediate nodes.

This model is typically implemented using pointers or links between records, which guide the traversal process. Because of its rigid structure, hierarchical databases are efficient for certain types of data with clear, fixed relationships but can be inflexible when dealing with complex or evolving data schemas.

Common Use Cases

  • Managing organizational charts where each employee reports to a single manager.
  • Storing file systems with directories and subdirectories.
  • Representing product categories and subcategories in retail databases.
  • Handling parts and subassemblies in manufacturing data systems.
  • Tracking patient records with hierarchical relationships in healthcare databases.

Why It Matters

Understanding hierarchical databases is important for IT professionals working with legacy systems or applications where data relationships are naturally hierarchical. They are foundational in fields like enterprise data management, systems integration, and legacy application maintenance. Certification candidates in database management, data architecture, or systems analysis should grasp how hierarchical models influence data retrieval, storage efficiency, and system design. Although newer models like relational and NoSQL databases have largely superseded hierarchical structures, knowledge of this model provides valuable context for understanding data organization principles and the evolution of database technologies.

Ready to start learning?Individual Plans →Team Plans →
Discover More, Learn More
What Is a Data Registry? Discover how a data register serves as a central hub for organizing,… What Is Windows XP Embedded (XPe)? Discover what Windows XP Embedded is and how it enables you to… What Is Windows Virtual Desktop? Discover how Windows Virtual Desktop enables secure remote access and streamlined app… What is UWP (Universal Windows Platform)? Discover what UWP is and how it enables developers to create versatile… What Is (ISC)² CCSP (Certified Cloud Security Professional)? Discover how to enhance your cloud security expertise, prevent common failures, and… What Is (ISC)² CSSLP (Certified Secure Software Lifecycle Professional)? Discover how earning the CSSLP certification can enhance your understanding of secure…