Welcome to the InfoSci Platform
Reference Hub1
Investigating the Effects of Object-Relational Impedance Mismatch on the Efficiency of Object-Relational Mapping Frameworks

Investigating the Effects of Object-Relational Impedance Mismatch on the Efficiency of Object-Relational Mapping Frameworks

Derek Colley, Clare Stanier, Md Asaduzzaman
Copyright: © 2020 |Volume: 31 |Issue: 4 |Pages: 23
ISSN: 1063-8016|EISSN: 1533-8010|EISBN13: 9781799804727|DOI: 10.4018/JDM.2020100101
Cite Article Cite Article

MLA

Colley, Derek, et al. "Investigating the Effects of Object-Relational Impedance Mismatch on the Efficiency of Object-Relational Mapping Frameworks." JDM vol.31, no.4 2020: pp.1-23. http://doi.org/10.4018/JDM.2020100101

APA

Colley, D., Stanier, C., & Asaduzzaman, M. (2020). Investigating the Effects of Object-Relational Impedance Mismatch on the Efficiency of Object-Relational Mapping Frameworks. Journal of Database Management (JDM), 31(4), 1-23. http://doi.org/10.4018/JDM.2020100101

Chicago

Colley, Derek, Clare Stanier, and Md Asaduzzaman. "Investigating the Effects of Object-Relational Impedance Mismatch on the Efficiency of Object-Relational Mapping Frameworks," Journal of Database Management (JDM) 31, no.4: 1-23. http://doi.org/10.4018/JDM.2020100101

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

The object-relational impedance mismatch (ORIM) problem characterises differences between the object-oriented and relational approaches to data access. Queries generated by object-relational mapping (ORM) frameworks are designed to overcome ORIM difficulties and can cause performance concerns in environments which use object-oriented paradigms. The aim of this paper is twofold, first presenting a survey of database practitioners on the effectiveness of ORM tools followed by an experimental investigation into the extent of operational concerns through the comparison of ORM-generated query performance and SQL query performance with a benchmark data set. The results show there are perceived difficulties in tuning ORM tools and distrust around their effectiveness. Through experimental testing, these views are validated by demonstrating that ORMs exhibit performance issues to the detriment of the query and the overall scalability of the ORM-led approach. Future work on establishing a system to support the query optimiser when parsing and preparing ORM-generated queries is outlined.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.