Title: Implementation of Adjacency List-Based Algorithms for Managing Hierarchical Binary Large Objects in Relational Databases
Authors: Mustafa Kadhim Taqi
Volume: 10
Issue: 1
Pages: 19-25
Publication Date: 2026/01/28
Abstract:
Efficient management of hierarchical data in the context of Relational Database Management Systems (RDBMS) is a crucial aspect of modern digital archival systems. In this article, efficient data storage and classification techniques are presented, designed specifically for a hierarchical documentation management system (HDMS) based on the Adjacency List Model, designed to handle a tree-like directory structure. For data import, a directory-traversal algorithm is incorporated using a flowchart at the system level. Conversely, for data export, a recursive SQL query is utilized, where the resulting tree-like structure is retrieved from the normalized database. The proposed system is analyzed on a set of practical file-path examples, demonstrating its scalability and efficiency in handling hierarchical data in a typical SQL setup.