Research Article
Different Approaches to Modeling the Trees Data in Relational Database
|
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
|
| Volume 53 - Issue 18 |
| Published: September 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 },
year = { 2012 },
volume = { 53 },
number = { 18 },
pages = { 38-42 },
doi = { 10.5120/8524-2551 },
publisher = { Foundation of Computer Science (FCS), NY, USA }
}
%0 Journal Article
%D 2012
%A Elloub Abdelali
%A Oucamah Mohammed Cherkaoui Malki
%A Sanae Mazouz
%T Different Approaches to Modeling the Trees Data in Relational Database%T
%J International Journal of Computer Applications
%V 53
%N 18
%P 38-42
%R 10.5120/8524-2551
%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
- E. F. Codd. A relational model of data for large shared data banks. Communications of the ACM, 13(6):377–387, 1970.
- Celko, J. , 1999. SQL for Smarties: Advanced SQL Programming. Morgan Kaufmann Publishers, San Francisco, CA, 576pp.
- Celko, J. , 2008. Thinking in Auxiliary Sets, Temporal, and Virtual Tables in SQL. Morgan Kaufmann Publishers, Burlington, MA 01803-4255.
- Celko, J. , 2004. Trees & Hierarchy in SQL for Smarties. Morgan Kaufmann Publishers, San Francisco, CA 94111.
- Celko. J. , 2005. SQL for Smarties: Advanced SQL Programming third edition. Morgan Kaufmann Publishers, San Francisco, continuation 400, CA 94111.
- Celko. J. , 2011. SQL for Smarties: Advanced SQL Programming fourth edition. Morgan Kaufmann Publishers, Burlington, MA 01803,
- V. Tropashko. June 2005. Nested Intervals Tree Encoding in SQL, SIGMOD.
- V. Tropashko. Nested Intervals Tree Encoding with Continued Fraction. http://arxiv. org/pdf/cs. DB/0402051
- V. Tropashko. 2003. Trees in SQL: Nested Sets and Materialized Path
- V. Tropashko, 2004. Nested Intervals with Farey Fractions. http://arxiv. org/html/cs. DB/0401014
- 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
- 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
Keywords