Skip to main content
SpringerLink
Log in
Book cover

Advances in Databases and Information Systems pp 265–272Cite as

Extending HQL with Plain Recursive Facilities

  • Conference paper

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 186))

Abstract

The mismatch between relational databases and object-oriented programming languages has been significantly mitigated by the use of object-relational mapping. However, the querying facilities available in such mapping systems are still inferior when compared to the features of a fully-fledged relational DBMS. In our research we aim at enriching object-relation mapping with advanced database concepts. An example of such an aspect is recursive querying. In prequel papers we have shown how to extend Hibernates mapping configurations with comprehendible recursive views that map to SQL common table expressions. In this paper we show how one can extend Hibernate Query Language (HQL) with plain recursive query facilities based on Oracles CONNECT BY phrase. Although, unfortunately it has not become a part of the SQL standard, its properties like cleanness and guaranteed stop make it worth exploiting.We propose adding CONNECT BY to HQL.We have implemented a prototype mapping of this phrase to recursive queries in major DBMSs and tested its efficiency. As the result we have got a simple, safe and fast way to pose recursive queries in HQL.

This is a preview of subscription content, log in via an institution.

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   129.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   169.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Brandon, D.: Recursive database structures. J. Comput. Small Coll. 21(2), 295–304 (2005)

    Google Scholar 

  2. Przymus, P., Boniewicz, A., Burzańska, M., Stencel, K.: Recursive Query Facilities in Relational Databases: A Survey. In: Zhang, Y., Cuzzocrea, A., Ma, J., Chung, K.-i., Arslan, T., Song, X. (eds.) DTA and BSBT 2010. CCIS, vol. 118, pp. 89–99. Springer, Heidelberg (2010)

    Chapter  Google Scholar 

  3. Ghazal, A., Crolotte, A., Seid, D.Y.: Recursive SQL Query Optimization with k-Iteration Lookahead. In: Bressan, S., Küng, J., Wagner, R. (eds.) DEXA 2006. LNCS, vol. 4080, pp. 348–357. Springer, Heidelberg (2006)

    Chapter  Google Scholar 

  4. Burzańska, M., Stencel, K., Wiśniewski, P.: Pushing Predicates into Recursive SQL Common Table Expressions. In: Grundspenkis, J., Morzy, T., Vossen, G. (eds.) ADBIS 2009. LNCS, vol. 5739, pp. 194–205. Springer, Heidelberg (2009)

    Chapter  Google Scholar 

  5. django-models, https://docs.djangoproject.com/en/dev/topics/db/models/

  6. Burzaska, M., Boniewicz, A., Szumowska, A., Winiewski, P.: Hibernate the Recursive Queries - Defining the Recursive Queries Using Hibernate ORM. In: ADBIS Research Communications, pp. 190–199 (2011)

    Google Scholar 

  7. Keller, W.: Mapping objects to tables: A pattern language. In: EuroPLoP (2007)

    Google Scholar 

  8. Wisniewski, P., Burzańska, M., Stencel, K.: The impedance mismatch in light of the Unified State Model. Fundam. Inform. (to appear, 2012)

    Google Scholar 

  9. Hibernate, http://www.hibernate.org

  10. Burzańska, M., Stencel, K., Suchomska, P., Szumowska, A., Wiśniewski, P.: Recursive Queries Using Object Relational Mapping. In: Kim, T.-H., Lee, Y.-H., Kang, B.-H., Ślęzak, D. (eds.) FGIT 2010. LNCS, vol. 6485, pp. 42–50. Springer, Heidelberg (2010)

    Chapter  Google Scholar 

  11. Bauer, C., King, G.: Java Persistence with Hibernate. Manning Publications Co., Greenwich (2006)

    Google Scholar 

  12. O’Neil, E.J.: Object/relational mapping 2008: hibernate and the entity data model (EDM). In: Proc. ACM SIGMOD, pp. 1351–1356 (2008)

    Google Scholar 

  13. Szumowska, A., Burzańska, M., Wiśniewski, P., Stencel, K.: Efficient Implementation of Recursive Queries in Major Object Relational Mapping Systems. In: Kim, T.-H., Adeli, H., Slezak, D., Sandnes, F.E., Song, X., Chung, K.-I., Arnett, K.P. (eds.) FGIT 2011. LNCS, vol. 7105, pp. 78–89. Springer, Heidelberg (2011)

    Chapter  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Faculty of Mathematics and Computer Science, Nicolaus Copernicus University, Toruń, Poland

    Aneta Szumowska, Marta Burzańska, Piotr Wiśniewski & Krzysztof Stencel

Authors
  1. Aneta Szumowska
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Marta Burzańska
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Piotr Wiśniewski
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Krzysztof Stencel
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Aneta Szumowska .

Editor information

Editors and Affiliations

  1. Institute of Computing Science, Poznan University of Technology, ul. Piotrowo 3a, Poznan, 60-965, Poland

    Tadeusz Morzy

  2. , Dept. of Computer Science, University of Kaiserslautern, Kaiserslautern, 67653, Germany

    Theo Härder

  3. Institute of Computing Science, Faculty of Computing, Poznań University of Technology, Piotrowo 2, Poznań, 60-965, Poland

    Robert Wrembel

Rights and permissions

Reprints and permissions

Copyright information

© 2013 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Szumowska, A., Burzańska, M., Wiśniewski, P., Stencel, K. (2013). Extending HQL with Plain Recursive Facilities. In: Morzy, T., Härder, T., Wrembel, R. (eds) Advances in Databases and Information Systems. Advances in Intelligent Systems and Computing, vol 186. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-32741-4_24

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-32741-4_24

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-32740-7

  • Online ISBN: 978-3-642-32741-4

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics

Search

Navigation