Joe Celko's SQL for Smarties: Advanced SQL Programming
Joe Celko's SQL for Smarties: Advanced SQL Programming
Database Processing
Advanced Transact-SQL for SQL Server 2000
Advanced Transact-SQL for SQL Server 2000
Joe Celko's SQL for Smarties: Trees and Hierarchies
Joe Celko's SQL for Smarties: Trees and Hierarchies
An improvement of an approach for representation of tree structures in relational tables
CompSysTech '07 Proceedings of the 2007 international conference on Computer systems and technologies
A Pattern Based Approach for Re-engineering Non-Ontological Resources into Ontologies
ASWC '08 Proceedings of the 3rd Asian Semantic Web Conference on The Semantic Web
Efficient implementation of recursive queries in major object relational mapping systems
FGIT'11 Proceedings of the Third international conference on Future Generation Information Technology
A Pattern-Based Method for Re-Engineering Non-Ontological Resources into Ontologies
International Journal on Semantic Web & Information Systems
| Hi-index | 0.00 |
Recursion has always been an interesting topic in computer science, and one of the most difficult data structures to implement in modern relational database systems is recursive relationships. In a recursive relationship one type of entity is related in some way to other entity instances of the same type. Since a relationship exists, referential integrity constraints must be enforced and processing must be developed to follow the bi-directional relationship in both mapping directions. For non-recursive relationships, referential integrity constraint enforcement and bi-directional information flows have been automated to a great extent in modern database products; but this automation is not available for the recursive case. This paper discusses this problem, presents proposed solutions, and illustrates a practical application of such a solution.