{"id":"https://openalex.org/W3011800407","doi":"https://doi.org/10.4018/jdm.2020100101","title":"Investigating the Effects of Object-Relational Impedance Mismatch on the Efficiency of Object-Relational Mapping Frameworks","display_name":"Investigating the Effects of Object-Relational Impedance Mismatch on the Efficiency of Object-Relational Mapping Frameworks","publication_year":2020,"publication_date":"2020-10-01","ids":{"openalex":"https://openalex.org/W3011800407","doi":"https://doi.org/10.4018/jdm.2020100101","mag":"3011800407"},"language":"en","primary_location":{"id":"doi:10.4018/jdm.2020100101","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdm.2020100101","pdf_url":null,"source":{"id":"https://openalex.org/S73024538","display_name":"Journal of Database Management","issn_l":"1063-8016","issn":["1063-8016","1533-8010"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Database Management","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5014563986","display_name":"D.C. Colley","orcid":"https://orcid.org/0000-0002-0092-6837"},"institutions":[{"id":"https://openalex.org/I198012923","display_name":"University of Staffordshire","ror":"https://ror.org/00d6k8y35","country_code":"GB","type":"education","lineage":["https://openalex.org/I198012923"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Derek Colley","raw_affiliation_strings":["Staffordshire University, UK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Staffordshire University, UK","institution_ids":["https://openalex.org/I198012923"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5065199282","display_name":"Clare Stanier","orcid":"https://orcid.org/0000-0001-9512-0723"},"institutions":[{"id":"https://openalex.org/I198012923","display_name":"University of Staffordshire","ror":"https://ror.org/00d6k8y35","country_code":"GB","type":"education","lineage":["https://openalex.org/I198012923"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Clare Stanier","raw_affiliation_strings":["Staffordshire University, UK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Staffordshire University, UK","institution_ids":["https://openalex.org/I198012923"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5039444388","display_name":"Md Asaduzzaman","orcid":"https://orcid.org/0000-0002-8885-6721"},"institutions":[{"id":"https://openalex.org/I198012923","display_name":"University of Staffordshire","ror":"https://ror.org/00d6k8y35","country_code":"GB","type":"education","lineage":["https://openalex.org/I198012923"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Md Asaduzzaman","raw_affiliation_strings":["Staffordshire University, UK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Staffordshire University, UK","institution_ids":["https://openalex.org/I198012923"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.1621,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.51079102,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":"31","issue":"4","first_page":"1","last_page":"23"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9988999962806702,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9965000152587891,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.861100435256958},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.765560507774353},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.7015888690948486},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.6431143879890442},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.5930123329162598},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.5783858299255371},{"id":"https://openalex.org/keywords/object","display_name":"Object (grammar)","score":0.5627143979072571},{"id":"https://openalex.org/keywords/distrust","display_name":"Distrust","score":0.504578709602356},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.4931468367576599},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4921821653842926},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4789191484451294},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.4499703645706177},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.43813595175743103},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.40663230419158936},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.40426719188690186},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.37944352626800537},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.2396688163280487},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.20727238059043884},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.19838398694992065},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.13288146257400513}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.861100435256958},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.765560507774353},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.7015888690948486},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.6431143879890442},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.5930123329162598},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.5783858299255371},{"id":"https://openalex.org/C2781238097","wikidata":"https://www.wikidata.org/wiki/Q175026","display_name":"Object (grammar)","level":2,"score":0.5627143979072571},{"id":"https://openalex.org/C2778321746","wikidata":"https://www.wikidata.org/wiki/Q621922","display_name":"Distrust","level":2,"score":0.504578709602356},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.4931468367576599},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4921821653842926},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4789191484451294},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.4499703645706177},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.43813595175743103},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.40663230419158936},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.40426719188690186},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.37944352626800537},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.2396688163280487},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.20727238059043884},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.19838398694992065},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.13288146257400513},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.4018/jdm.2020100101","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdm.2020100101","pdf_url":null,"source":{"id":"https://openalex.org/S73024538","display_name":"Journal of Database Management","issn_l":"1063-8016","issn":["1063-8016","1533-8010"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Database Management","raw_type":"journal-article"},{"id":"pmh:oai:eprints.staffs.ac.uk:6196","is_oa":false,"landing_page_url":"https://www.igi-global.com/article/investigating-the-effects-of-object-relational-impedance-mismatch-on-the-efficiency-of-object-relational-mapping-frameworks/266402","pdf_url":null,"source":{"id":"https://openalex.org/S4306401113","display_name":"Staffordshire Online Repository (Staffordshire University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I198012923","host_organization_name":"University of Staffordshire","host_organization_lineage":["https://openalex.org/I198012923"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":16,"referenced_works":["https://openalex.org/W92184301","https://openalex.org/W1557001362","https://openalex.org/W1987950482","https://openalex.org/W1999077610","https://openalex.org/W2002394060","https://openalex.org/W2005521389","https://openalex.org/W2014376527","https://openalex.org/W2021570844","https://openalex.org/W2026735162","https://openalex.org/W2069171862","https://openalex.org/W2116436709","https://openalex.org/W2122253629","https://openalex.org/W2524766217","https://openalex.org/W2774489303","https://openalex.org/W2802203419","https://openalex.org/W2905507276"],"related_works":["https://openalex.org/W901556","https://openalex.org/W3266680","https://openalex.org/W7302010","https://openalex.org/W2932426","https://openalex.org/W10423078","https://openalex.org/W9045685","https://openalex.org/W7917240","https://openalex.org/W3347319","https://openalex.org/W10165973","https://openalex.org/W6917806"],"abstract_inverted_index":{"The":[0,41,88],"object-relational":[1,20],"impedance":[2],"mismatch":[3],"(ORIM)":[4],"problem":[5],"characterises":[6],"differences":[7],"between":[8],"the":[9,56,67,73,119,122,125,129,140],"object-oriented":[10,39],"and":[11,30,79,99,124,145],"relational":[12],"approaches":[13],"to":[14,26,118,138],"data":[15,86],"access.":[16],"Queries":[17],"generated":[18],"by":[19,62,111],"mapping":[21],"(ORM)":[22],"frameworks":[23],"are":[24,92,109],"designed":[25],"overcome":[27],"ORIM":[28],"difficulties":[29,94],"can":[31],"cause":[32],"performance":[33,78,82,116],"concerns":[34,71],"in":[35,95],"environments":[36],"which":[37],"use":[38],"paradigms.":[40],"aim":[42],"of":[43,52,58,69,75,121,128],"this":[44],"paper":[45],"is":[46,149],"twofold,":[47],"first":[48],"presenting":[49],"a":[50,84,136],"survey":[51],"database":[53],"practitioners":[54],"on":[55,134],"effectiveness":[57],"ORM":[59,97],"tools":[60,98],"followed":[61],"an":[63],"experimental":[64,105],"investigation":[65],"into":[66],"extent":[68],"operational":[70],"through":[72],"comparison":[74],"ORM-generated":[76,147],"query":[77,81,123,141],"SQL":[80],"with":[83],"benchmark":[85],"set.":[87],"results":[89],"show":[90],"there":[91],"perceived":[93],"tuning":[96],"distrust":[100],"around":[101],"their":[102],"effectiveness.":[103],"Through":[104],"testing,":[106],"these":[107],"views":[108],"validated":[110],"demonstrating":[112],"that":[113],"ORMs":[114],"exhibit":[115],"issues":[117],"detriment":[120],"overall":[126],"scalability":[127],"ORM-led":[130],"approach.":[131],"Future":[132],"work":[133],"establishing":[135],"system":[137],"support":[139],"optimiser":[142],"when":[143],"parsing":[144],"preparing":[146],"queries":[148],"outlined.":[150]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":3},{"year":2022,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}