PL EN


Preferences help
enabled [disable] Abstract
Number of results
2016 | 16 | 1 |
Article title

Extending DQL with Recursive Facilities

Content
Title variants
Languages of publication
EN
Abstracts
EN
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.
Year
Volume
16
Issue
1
Physical description
Dates
published
2016
online
04 - 10 - 2016
Contributors
References
  • 1. Boniewicz A., Burzańska M., Przymus P., Stencel, K.: Recursive query facilities in relational databases: a survey, In DTA(2010), CCIS 118, 89-99.
  • 2. Hibernate ORM, http://hibernate.org/orm/
  • 3. Django Framework, https://www.djangoproject.com/
  • 4. Entity Framework, https://msdn.microsoft.com/en-us/data/ef.aspx
  • 5. Active Records, http://api.rubyonrails.org/classes/ActiveRecord/Base.html
  • 6. Doctrine Project, http://www.doctrine-project.org/
  • 7. 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.
  • 8. 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.
  • 9. 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.
  • 10. 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.
  • 11. Gawarkiewicz, M., Wiśniewski, P.: Partial aggregation using Hibernate. FGIT 2011, LNCS 7105, 90-99.
  • 12. 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).
  • 13. 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.
  • 14. 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.
  • 15. C.M. Gersen, "ORM Optimization through Automatic Prefetching in WebDSL". PhD Thesis. TU Delft, Delft University of Technology, 2013.
  • 16. SQL Alchemy. http://www.sqlalchemy.org/
Document Type
Publication order reference
Identifiers
YADDA identifier
bwmeta1.element.ojs-doi-10_17951_ai_2016_16_1_12
JavaScript is turned off in your web browser. Turn it on to take full advantage of this site, then refresh the page.