The Impact of Object-Relational Mapping Frameworks on Relational Query Performance

This paper considers the impact of object-relational mapping (ORM) tools on relational database query performance. ORM tools are widely used to address the object-relational impedance mismatch problem but can have negative performance consequences. We first define the background of the problem, describing the growth of ORM tools against a backdrop of the changing application development landscape, then demonstrate examples of undesirable query performance patterns resulting from the application of these tools using a leading application stack. We review selected literature for prior research into this problem and summarise the findings. Finally, we conclude by suggesting future research directions to help mitigate the issues found with ORMs and signpost some potential solutions.

[1]  Bill Karwin,et al.  SQL Antipatterns: Avoiding the Pitfalls of Database Programming , 2010 .

[2]  Jeff Sutherland,et al.  Manifesto for Agile Software Development , 2013 .

[3]  S. Balaji,et al.  WATEERFALLVs V-MODEL Vs AGILE: A COMPARATIVE STUDY ON SDLC , 2012 .

[4]  Michael Stonebraker,et al.  The design and implementation of INGRES , 1976, TODS.

[6]  Ade Miller,et al.  A Hundred Days of Continuous Integration , 2008, Agile 2008 Conference.

[7]  Clare Stanier,et al.  Identifying New Directions in Database Performance Tuning , 2017, CENTERIS/ProjMAN/HCist.

[8]  Michael Meyling,et al.  Axiomatic Set Theory , 2008 .

[9]  Agile Manifesto,et al.  Manifesto for Agile Software Development , 2001 .

[10]  Joseph N Cappella,et al.  Vectors into the Future of Mass and Interpersonal Communication Research: Big Data, Social Media, and Computational Social Science. , 2017, Human communication research.

[11]  Tom Chen,et al.  Design and implementation , 2006, IEEE Commun. Mag..

[12]  Yixin Chen,et al.  A comparison of a graph database and a relational database: a data provenance perspective , 2010, ACM SE '10.

[13]  Kevin Waugh,et al.  A Classification of Object-Relational Impedance Mismatch , 2009, 2009 First International Confernce on Advances in Databases, Knowledge, and Data Applications.

[14]  Sajimon Abraham,et al.  Exploring the merits of nosql: A study based on mongodb , 2017, 2017 International Conference on Networks & Advances in Computational Technologies (NetACT).

[15]  Gregory Vial.  Lessons in Persisting Object Data Using Object-Relational Mapping , 2019, IEEE Software.

[16]  Clare Stanier,et al.  Towards Differentiating Business Intelligence, Big Data, Data Analytics and Knowledge Discovery , 2016, ERP Future.

[17]  C. J. Date,et al.  Foundation for Future Database Systems: The Third Manifesto , 2000 .

[18]  Alvin Cheung,et al.  Sloth: being lazy is a virtue (when issuing database queries) , 2014, SIGMOD Conference.

[19]  Ahmed E. Hassan,et al.  Detecting performance anti-patterns for applications developed using object-relational mapping , 2014, ICSE.