Improve Query Performance On Hierarchical Data. Adjacency List Model Vs. Nested Set Model

Abstract

Hierarchical data are found in a variety of database applications, including content management categories, forums, business organization charts, and product categories. In this paper, we will examine two models deal with hierarchical data in relational databases namely, adjacency list model and nested set model. We analysed these models by executing various operations and queries in a web-application for the management of categories, thus highlighting the results obtained during performance comparison tests. The purpose of this paper is to present the advantages and disadvantages of using an adjacency list model compared to nested set model in a relational database integrated into an application for the management of categories, which needs to manipulate a big amount of hierarchical data.

Authors and Affiliations

Cornelia Gyorödi, Romulus-Radu Moldovan-Duse, Robert Gyorödi, George Pecherle

Keywords

Related Articles

Advanced Personnel Vetting Techniques in Critical Multi-Tennant Hosted Computing Environments

The emergence of cloud computing presents a strategic direction for critical infrastructures and promises to have far-reaching effects on their systems and networks to deliver better outcomes to the nations at a lower co...

Adaptive Simulated Evolution based Approach for Cluster Optimization in Wireless Sensor Networks

Energy consumption minimization is crucial for the constrained sensors in wireless sensor networks (WSNs). Partitioning WSNs into optimal set of clusters is a promising technique utilized to minimize energy consumption a...

Towards Development of Real-Time Handwritten Urdu Character to Speech Conversion System for Visually Impaired

Text to Speech (TTS) Conversion Systems have been an area of research for decades and have been developed for both handwritten and typed text in various languages. Existing research shows that it has been a challenging t...

Forecasting Production Values using Fuzzy Logic Interval based Partitioning in Different Intervals

Fuzzy time series models have been put forward for rice production from many researchers around the globe, but the prediction has not been very accurate. Frequency density or ratio based partitioning methods have been us...

Performance Evaluation of Loss Functions for Margin Based Robust Speech Recognition

Margin-based model estimation methods are applied for speech recognition to enhance the generalization capability of acoustic model by increasing the margin. An important aspects of margin based acoustic model for parame...

Download PDF file
  • EP ID EP149089
  • DOI 10.14569/IJACSA.2016.070434
  • Views 111
  • Downloads 0

How To Cite

Cornelia Gyorödi, Romulus-Radu Moldovan-Duse, Robert Gyorödi, George Pecherle (2016). Improve Query Performance On Hierarchical Data. Adjacency List Model Vs. Nested Set Model. International Journal of Advanced Computer Science & Applications, 7(4), 272-278. https://europub.co.uk/articles/-A-149089