Efficient implementation of recursive queries in major object relational mapping systems

Authors:
Aneta Szumowska;Marta Burza$#324/ska;Piotr Wi$#347/niewski;Krzysztof Stencel
Affiliations:
Faculty of Mathematics and Computer Science, Nicolaus Copernicus University, Toru$#324/, Poland;Faculty of Mathematics and Computer Science, Nicolaus Copernicus University, Toru$#324/, Poland;Faculty of Mathematics and Computer Science, Nicolaus Copernicus University, Toru$#324/, Poland;Faculty of Mathematics and Computer Science, Nicolaus Copernicus University, Toru$#324/, Poland
Venue:
FGIT'11 Proceedings of the Third international conference on Future Generation Information Technology
Year:
2011

Citing 6
Cited 1

Recursive database structures

Journal of Computing Sciences in Colleges
Java Persistence with Hibernate

Java Persistence with Hibernate
Object/relational mapping 2008: hibernate and the entity data model (edm)

Proceedings of the 2008 ACM SIGMOD international conference on Management of data
Compiling mappings to bridge applications and databases

ACM Transactions on Database Systems (TODS)
Pushing Predicates into Recursive SQL Common Table Expressions

ADBIS '09 Proceedings of the 13th East European Conference on Advances in Databases and Information Systems
Recursive SQL query optimization with k-iteration lookahead

DEXA'06 Proceedings of the 17th international conference on Database and Expert Systems Applications

Enhanced segment trees in object-relational mapping

Proceedings of the 6th Balkan Conference in Informatics

Quantified Score

Hi-index	0.00

Visualization

Abstract

The following paper presents the effects of combining two technologies: object-relational mapping and SQL's recursive queries. Both technologies are widely used in modern software, and yet, modern ORM systems still lack the support for recursive database querying. The currently used methods for querying graph and hierarchical structures are either inefficient, difficult to maintain, or do not allow for any portability. The authors of the following paper propose extensions to the general functionality of modern ORM systems and present the results for two ORM systems: Hibernate for Java and Django-models for Python. With this extension programmers using one of those systems can benefit from the support for the recursive queries offered by various object-relational database management systems and write a maintainable code compliant with the used ORM standard. The proposed solution works with IBM DB2, Oracle and PostgreSQL DBMS and proved to be many times faster than the approaches currently used.