Extending DQL with Recursive Facilities

Piotr Wiśniewski, Marta Burzańska, Przemysław Krukowski


Object Relational Mappings reduce a gap between Relational Databases and programming languages. However, only the simplest operations are covered by the ORM frameworks. Most facilities provided by DBMSs are not usable via ORM. Among such features are recursive queries, introduced in SQL:99 standard. This paper presents integration of Recursive Common Table Expressions with Doctrine Query Language - a part of Doctrine ORM framework for PHP.


ORM, PHP, Doctrine, recursive queries, CTE

Full Text:



Boniewicz A., Burzańska M., Przymus P., Stencel, K.: Recursive query facilities in relational databases: a survey, In DTA(2010), CCIS 118, 89-99.

Hibernate ORM, http://hibernate.org/orm/

Django Framework, https://www.djangoproject.com/

Entity Framework, https://msdn.microsoft.com/en-us/data/ef.aspx

Active Records, http://api.rubyonrails.org/classes/ActiveRecord/Base.html

Doctrine Project, http://www.doctrine-project.org/

Szumowska, A., Burzańska, M., Wiśniewski, P., Stencel, K.: Extending HQL with plain recursive facilities. In Morzy, T., Harder, T., Wrembel, R., eds.: ADBIS (2). Volume 186 of Advances in Intelligent Systems and Computing., Springer (2012) 265-272.

Boniewicz, A., Stencel, K., Wiśniewski, P.: Unrolling SQL:1999 recursive queries. In Kim, T.h., Ma, J., Fang, W.c., Zhang, Y., Cuzzocrea, A., eds.: Computer Applications for Database, Education, and Ubiquitous Computing. Volume 352 of CCIS (2012) 345-354.

Szumowska, A., Burzańska, M., Wiśniewski, P., Stencel, K.: Efficient implementation of recursive queries in major object relational mapping systems. FGIT 2011, LNCS 7105 ,78-89.

Wiśniewski, P., Szumowska, A., Burzańska, M., Boniewicz, A.: Hibernate the recursive queries - defining the recursive queries using Hibernate ORM, In Eder, J., Bielikova, M., Tjoa, A.M., eds.: ADBIS (2). Volume 789 of CEUR Workshop Proceedings., CEUR-WS.org (2011) 190-199.

Gawarkiewicz, M., Wiśniewski, P.: Partial aggregation using Hibernate. FGIT 2011, LNCS 7105, 90-99.

Boniewicz, A., Gawarkiewicz, M., Wiśniewski, P.: Automatic selection of functional indexes for object relational mappings system. International Journal of Software Engineering and Its Applications 7 (2013).

Joshi, A., Kukreti, S.: Object Relational Mapping in Comparison to Traditional Data Access Techniques. International Journal of Scientific & Engineering Research, Volume 5, Issue 6, June-2014.

M. Sysak, B. Zieliński, P. Kruszyński, Ś. Sobieski & P. Maślanka. "Static Integration of SQL Queries in C++ Programs". In Advances in Databases and Information Systems, Springer International Publishing, 2014, pp. 126-138.

C.M. Gersen, "ORM Optimization through Automatic Prefetching in WebDSL". PhD Thesis. TU Delft, Delft University of Technology, 2013.

SQL Alchemy. http://www.sqlalchemy.org/

DOI: http://dx.doi.org/10.17951/ai.2016.16.1.12
Data publikacji: 2016-10-04 09:01:47
Data złożenia artykułu: 2016-05-18 07:18:26


  • There are currently no refbacks.

Copyright (c) 2016 Piotr Wiśniewski, Marta Burzańska, Przemysłąw Krukowski

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.