Extending DQL with Recursive Facilities

• Autorzy: Wiśniewski P. , Burzańska M. , Krukowski P.

Identyfikatory

DOI

10.17951/ai.2016.16.1.12

• Języki publikacji: EN

Abstrakty

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.

Słowa kluczowe

EN

ORM; PHP; Doctrine; recursive queries; CTE

• Wydawca: Wydawnictwo UMCS
• Czasopismo: Annales Universitatis Mariae Curie-Skłodowska. Sectio AI, Informatica
• Rocznik: 2016
• Tom: Vol. 16, no. 1
• Strony: 12--20
• Opis fizyczny: Bibliogr. 16 poz., tab.

Twórcy

autor

Wiśniewski P.

• Faculty of Mathematics and Computer Science, Nicolaus Copernicus University in Torun

autor

Burzańska M.

• Faculty of Mathematics and Computer Science, Nicolaus Copernicus University in Torun

autor

Krukowski P.

• Faculty of Mathematics and Computer Science, Nicolaus Copernicus University in Torun

Bibliografia

• [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/

Uwagi

Opracowanie ze środków MNiSW w ramach umowy 812/P-DUN/2016 na działalność upowszechniającą naukę (zadania 2017).