Staffordshire University logo
STORE - Staffordshire Online Repository

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

COLLEY, Derek, STANIER, Clare and ASADUZZAMAN, Md (2020) Investigating the Effects of Object-Relational Impedance Mismatch on the Efficiency of Object-Relational Mapping Frameworks. Journal of Database Management. ISSN 1063-8016

Full text not available from this repository. (Request a copy)

Abstract or description

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.

Item Type: Article
Faculty: School of Digital, Technologies and Arts > Computer Science, AI and Robotics
Depositing User: Md ASADUZZAMAN
Date Deposited: 06 Mar 2020 15:29
Last Modified: 12 Apr 2023 09:56
URI: https://eprints.staffs.ac.uk/id/eprint/6196

Actions (login required)

View Item View Item

DisabledGo Staffordshire University is a recognised   Investor in People. Sustain Staffs
Legal | Freedom of Information | Site Map | Job Vacancies
Staffordshire University, College Road, Stoke-on-Trent, Staffordshire ST4 2DE t: +44 (0)1782 294000