Improve Query Performance On Hierarchical Data. Adjacency List Model Vs. Nested Set Model
Journal Title: International Journal of Advanced Computer Science & Applications - Year 2016, Vol 7, Issue 4
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
- EP ID EP149089
- DOI 10.14569/IJACSA.2016.070434
- Views 96
- Downloads 0
Repository of Static and Dynamic Signs
Gesture-based communication is on the rise in Human Computer Interaction. Advancement in the form of smart phones has made it possible to introduce a new kind of communication. Gesture-based interfaces are increasingly g...
Evaluation of Perception and Performance in ICT Related Courses
Some teaching methods adopted for disseminating Information Communication Technology Related Courses (ICTRC) in institutions of learning have been observed to be inadequate in bringing about the right perception and perf...
Evaluation of Spectral Efficiency, System Capacity And Interference Effects on CDMA Communication System
Wireless communication technology have been developed based on exploring new mobile communications frequency bands, reasonable use of frequency resources and minimization, portability and multifunction’s of mobile statio...
CWNN-Net: A New Convolution Wavelet Neural Network for Gender Classification using Palm Print
The human hand is one of the body parts with special characteristics that are unique to every individual. The distinctive features can give some information about an individual, thus, making it a suitable body part that...
Deep Transfer Learning Application for Automated Ischemic Classification in Posterior Fossa CT Images
Computed Tomography (CT) imaging is one of the conventional tools used to diagnose ischemic in Posterior Fossa (PF). Radiologist commonly diagnoses ischemic in PF through CT imaging manually. However, such a procedure co...