CFP last date
20 December 2024
Reseach Article

Different Approaches to Modeling the Trees Data in Relational Database

by Elloub Abdelali, Oucamah Mohammed Cherkaoui Malki, Sanae Mazouz
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 53 - Number 18
Year of Publication: 2012
Authors: Elloub Abdelali, Oucamah Mohammed Cherkaoui Malki, Sanae Mazouz
10.5120/8524-2551

Elloub Abdelali, Oucamah Mohammed Cherkaoui Malki, Sanae Mazouz . Different Approaches to Modeling the Trees Data in Relational Database. International Journal of Computer Applications. 53, 18 ( September 2012), 38-42. DOI=10.5120/8524-2551

@article{ 10.5120/8524-2551,
author = { Elloub Abdelali, Oucamah Mohammed Cherkaoui Malki, Sanae Mazouz },
title = { Different Approaches to Modeling the Trees Data in Relational Database },
journal = { International Journal of Computer Applications },
issue_date = { September 2012 },
volume = { 53 },
number = { 18 },
month = { September },
year = { 2012 },
issn = { 0975-8887 },
pages = { 38-42 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume53/number18/8524-2551/ },
doi = { 10.5120/8524-2551 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T20:54:26.113606+05:30
%A Elloub Abdelali
%A Oucamah Mohammed Cherkaoui Malki
%A Sanae Mazouz
%T Different Approaches to Modeling the Trees Data in Relational Database
%J International Journal of Computer Applications
%@ 0975-8887
%V 53
%N 18
%P 38-42
%D 2012
%I Foundation of Computer Science (FCS), NY, USA
Abstract

This paper presents a detailed study of the work to modeling the hierarchies and data trees in relational database area. Hierarchical structures are used in diverse domains, in engineering and in research. We give a comparison between the various models cited in literature. This study allowed us to synthesize the most interesting of these models to represents the data trees.

References
  1. E. F. Codd. A relational model of data for large shared data banks. Communications of the ACM, 13(6):377–387, 1970.
  2. Celko, J. , 1999. SQL for Smarties: Advanced SQL Programming. Morgan Kaufmann Publishers, San Francisco, CA, 576pp.
  3. Celko, J. , 2008. Thinking in Auxiliary Sets, Temporal, and Virtual Tables in SQL. Morgan Kaufmann Publishers, Burlington, MA 01803-4255.
  4. Celko, J. , 2004. Trees & Hierarchy in SQL for Smarties. Morgan Kaufmann Publishers, San Francisco, CA 94111.
  5. Celko. J. , 2005. SQL for Smarties: Advanced SQL Programming third edition. Morgan Kaufmann Publishers, San Francisco, continuation 400, CA 94111.
  6. Celko. J. , 2011. SQL for Smarties: Advanced SQL Programming fourth edition. Morgan Kaufmann Publishers, Burlington, MA 01803,
  7. V. Tropashko. June 2005. Nested Intervals Tree Encoding in SQL, SIGMOD.
  8. V. Tropashko. Nested Intervals Tree Encoding with Continued Fraction. http://arxiv. org/pdf/cs. DB/0402051
  9. V. Tropashko. 2003. Trees in SQL: Nested Sets and Materialized Path
  10. V. Tropashko, 2004. Nested Intervals with Farey Fractions. http://arxiv. org/html/cs. DB/0401014
  11. J. Roy. 2003. Using the Node Data Type to Solve Problems with Hierarchies in DB2 Universal Database http://www. ibm. com/developerworks/data/library/techarticle/0302roy/0302roy. html
  12. Mohammad G. Ali, December 2011. Evolution of Database Emerging to Sybase Adaptive Server Enterprise and Ensuring Better Server Performance Tuning and Query Optimization
Index Terms

Computer Science
Information Sciences

Keywords

Trees data hierarchies SQL relational database models