Open Access Open Access  Restricted Access Subscription Access

Evaluating Performance of Hibernate ORM based Applications using HQL Query Optimization


Affiliations
1 Mehran University of Engineering & Technology Jamshoro, Hyderabad, Pakistan
 

With the continuous advancement in technology, web technologies have reached to a new height. Enterprise applications are meant to be the basic need of today’s world which aims to produce results that are highly reliable, portable and adaptable. With these enormous features, they needed the storage mechanism which could handle and store the data effectively. The storage system thus required was a database management system but again technical knowledge was required to make things work appropriately. However, this approach was the traditional one which requires data to be stored in tabular format whereas Object oriented architecture has taken the programming language to a whole new technical phase for which the traditional RDBMS will not efficiently accomplish the expected job. To fulfill this gap in the literature, Object Relational Mapping is emerged as a solution to provide which provide comparative technical features effortlessly. These characteristics simplify and make the mapping of objects in object-oriented programming languages more flexible, efficient and easy to use. Therefore, we propose in this paper that Object relational Modeling (ORM) relates each object of object oriented languages to corresponding rows in the table.

Keywords

Hibernate, ORM, HQL, Mapping, RDMS, OOP.
User
Notifications
Font Size

  • Chen, Tse-Hsun, et al., "An empirical study on the practice of maintaining object-relational mapping code in java systems." Proceedings of the 13th International Conference on Mining Software Repositories. ACM, 2016.
  • Decan, Alexandre, Mathieu Goeminne, and Tom Mens. "On the interaction of relational database access technologies in open source java projects." arXiv preprint arXiv:1701.00416(2017).
  • Dhingra, Neha, EmadAbdelmoghith, and Hussein T. Mouftah. "Performance Evaluation of JPA Based ORM Techniques.” In Proceedings of 2nd International Conference on Computer Science Networks and Information Technology, Held on 27th - 28th Aug 2016.
  • Babu, Chitra, and G. Gunasingh. "DESH: Database evaluation system with hibernate ORM framework." Advances in Computing, Communications and Informatics (ICACCI), 2016 International Conference on. IEEE, 2016.
  • Fraczek, Konrad, and MalgorzataPlechawska-Wojcik. "Comparative Analysis of Relational and Non-relational Databases in the Context of Performance in Web Applications." International Conference: Beyond Databases, Architectures and Structures. Springer, Cham, 2017.
  • Wan, Jing-Jing, Zhen Qin, and Xia Liu. "ORM Elevation in Response to Cognitive Impairment Is an Accompanying Phenomenon." CNS neuroscience & therapeutics 22.8 (2016): 723-724.
  • Bernstein, Philip A., et al., Incremental mapping compilation in an object-to-relational mapping system (extended version). Technical Report MSR-TR-2013-45, Microsoft Research, 2013.
  • Chen, Tse-Hsun, et al., "CacheOptimizer: Helping developers configure caching frameworks for Hibernate-based database-centric web applications." Proceedings of the 2016 24th ACM SIGSOFT International Symposium on Foundations of Software Engineering. ACM, 2016.
  • Procaccianti, Giuseppe, Patricia Lago, and WouterDiesveld. "Energy efficiency of orm approaches: an empirical evaluation." Proceedings of the 10th ACM/IEEE International Symposium on Empirical Software Engineering and Measurement. ACM, 2016.
  • Chen, Tse-Hsun, et al., "Cache Optimizer: Helping developers configure caching frameworks for Hibernate-based database-centric web applications." Proceedings of the 2016 24th ACM SIGSOFT International Symposium on Foundations of Software Engineering. ACM, 2016.
  • Chen, Tse-Hsun, et al., "Detecting problems in the database access code of large scale systems-an industrial experience report." Software Engineering Companion (ICSE-C), IEEE/ACM International Conference on. IEEE, 2016.
  • Chen, Tse-Hsun, et al., "An empirical study on the practice of maintaining object-relational mapping code in java systems." Proceedings of the 13th International Conference on Mining Software Repositories. ACM, 2016.
  • Grechanik, Mark, et al., "Enhancing rules for cloud resource provisioning via learned software performance models." Proceedings of the 7th ACM/SPEC on International Conference on Performance Engineering. ACM, 2016.
  • Ackermann, Hilmar, et al., "A backend extension mechanism for PQL/Java with free run-time optimisation." International Conference on Compiler Construction. Springer, Berlin, Heidelberg, 2015.
  • Emani, K. Venkatesh, and S. Sudarshan. "Cobra: A Framework for Cost Based Rewriting of Database Applications." arXiv preprint arXiv:1801.04891 (2018).
  • Zhengju, Chen. "Hibernate-Based Database Access Optimization [J]." Computer Applications and Software 7 (2012): 045.
  • Van Zyl, Pieter, Derrick G. Kourie, and Andrew Boake. "Comparing the performance of object databases and ORM tools." Proceedings of the 2006 annual research conference of the South African institute of computer scientists and information technologists on IT research in developing countries. South African Institute for Computer Scientists and Information Technologists, 2006.

Abstract Views: 224

PDF Views: 0




  • Evaluating Performance of Hibernate ORM based Applications using HQL Query Optimization

Abstract Views: 224  |  PDF Views: 0

Authors

Salahuddin Saddar
Mehran University of Engineering & Technology Jamshoro, Hyderabad, Pakistan
Junaid Baloch
Mehran University of Engineering & Technology Jamshoro, Hyderabad, Pakistan
Memoona Sami
Mehran University of Engineering & Technology Jamshoro, Hyderabad, Pakistan
Nasrullah Pirzada
Mehran University of Engineering & Technology Jamshoro, Hyderabad, Pakistan
Vijdan Khalique
Mehran University of Engineering & Technology Jamshoro, Hyderabad, Pakistan
Arsalan Aftab Memon
Mehran University of Engineering & Technology Jamshoro, Hyderabad, Pakistan

Abstract


With the continuous advancement in technology, web technologies have reached to a new height. Enterprise applications are meant to be the basic need of today’s world which aims to produce results that are highly reliable, portable and adaptable. With these enormous features, they needed the storage mechanism which could handle and store the data effectively. The storage system thus required was a database management system but again technical knowledge was required to make things work appropriately. However, this approach was the traditional one which requires data to be stored in tabular format whereas Object oriented architecture has taken the programming language to a whole new technical phase for which the traditional RDBMS will not efficiently accomplish the expected job. To fulfill this gap in the literature, Object Relational Mapping is emerged as a solution to provide which provide comparative technical features effortlessly. These characteristics simplify and make the mapping of objects in object-oriented programming languages more flexible, efficient and easy to use. Therefore, we propose in this paper that Object relational Modeling (ORM) relates each object of object oriented languages to corresponding rows in the table.

Keywords


Hibernate, ORM, HQL, Mapping, RDMS, OOP.

References