{"id":"https://openalex.org/W2340417905","doi":"https://doi.org/10.1109/tse.2016.2553039","title":"Finding and Evaluating the Performance Impact of Redundant Data Access for Applications that are Developed Using Object-Relational Mapping Frameworks","display_name":"Finding and Evaluating the Performance Impact of Redundant Data Access for Applications that are Developed Using Object-Relational Mapping Frameworks","publication_year":2016,"publication_date":"2016-04-12","ids":{"openalex":"https://openalex.org/W2340417905","doi":"https://doi.org/10.1109/tse.2016.2553039","mag":"2340417905"},"language":"en","primary_location":{"id":"doi:10.1109/tse.2016.2553039","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tse.2016.2553039","pdf_url":null,"source":{"id":"https://openalex.org/S8351582","display_name":"IEEE Transactions on Software Engineering","issn_l":"0098-5589","issn":["0098-5589","1939-3520","2326-3881"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Software Engineering","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/A5069372430","display_name":"Tse-Hsun Chen","orcid":"https://orcid.org/0000-0003-4027-0905"},"institutions":[{"id":"https://openalex.org/I204722609","display_name":"Queen's University","ror":"https://ror.org/02y72wh86","country_code":"CA","type":"education","lineage":["https://openalex.org/I204722609"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Tse-Hsun Chen","raw_affiliation_strings":["Software Analysis and Intelligence Lab, School of Computing, Queen's University, Kingston, ON, Canada"],"affiliations":[{"raw_affiliation_string":"Software Analysis and Intelligence Lab, School of Computing, Queen's University, Kingston, ON, Canada","institution_ids":["https://openalex.org/I204722609"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5056378414","display_name":"Weiyi Shang","orcid":"https://orcid.org/0000-0001-6222-7444"},"institutions":[{"id":"https://openalex.org/I60158472","display_name":"Concordia University","ror":"https://ror.org/0420zvk78","country_code":"CA","type":"education","lineage":["https://openalex.org/I60158472"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Weiyi Shang","raw_affiliation_strings":["Department of Computer Science and Software Engineering, Concordia University, Montreal, QC, Canada"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Software Engineering, Concordia University, Montreal, QC, Canada","institution_ids":["https://openalex.org/I60158472"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5085576468","display_name":"Zhen Ming Jiang","orcid":"https://orcid.org/0000-0002-3063-3197"},"institutions":[{"id":"https://openalex.org/I192455969","display_name":"York University","ror":"https://ror.org/05fq50484","country_code":"CA","type":"education","lineage":["https://openalex.org/I192455969"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Zhen Ming Jiang","raw_affiliation_strings":["Department of Electrical Engineering and Computer Science, York University, Toronto, ON, Canada"],"affiliations":[{"raw_affiliation_string":"Department of Electrical Engineering and Computer Science, York University, Toronto, ON, Canada","institution_ids":["https://openalex.org/I192455969"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5091586373","display_name":"Ahmed E. Hassan","orcid":"https://orcid.org/0000-0001-7749-5513"},"institutions":[{"id":"https://openalex.org/I204722609","display_name":"Queen's University","ror":"https://ror.org/02y72wh86","country_code":"CA","type":"education","lineage":["https://openalex.org/I204722609"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Ahmed E. Hassan","raw_affiliation_strings":["Software Analysis and Intelligence Lab, School of Computing, Queen's University, Kingston, ON, Canada"],"affiliations":[{"raw_affiliation_string":"Software Analysis and Intelligence Lab, School of Computing, Queen's University, Kingston, ON, Canada","institution_ids":["https://openalex.org/I204722609"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5019276686","display_name":"Mohamed Nasser","orcid":null},"institutions":[{"id":"https://openalex.org/I4210139826","display_name":"Blackberry (Canada)","ror":"https://ror.org/03mmk1j33","country_code":"CA","type":"company","lineage":["https://openalex.org/I4210139826"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Mohamed Nasser","raw_affiliation_strings":["BlackBerry, Waterloo, ON, Canada"],"affiliations":[{"raw_affiliation_string":"BlackBerry, Waterloo, ON, Canada","institution_ids":["https://openalex.org/I4210139826"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5002664858","display_name":"Parminder Flora","orcid":"https://orcid.org/0000-0003-0414-1145"},"institutions":[{"id":"https://openalex.org/I4210139826","display_name":"Blackberry (Canada)","ror":"https://ror.org/03mmk1j33","country_code":"CA","type":"company","lineage":["https://openalex.org/I4210139826"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Parminder Flora","raw_affiliation_strings":["BlackBerry, Waterloo, ON, Canada"],"affiliations":[{"raw_affiliation_string":"BlackBerry, Waterloo, ON, Canada","institution_ids":["https://openalex.org/I4210139826"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5069372430"],"corresponding_institution_ids":["https://openalex.org/I204722609"],"apc_list":null,"apc_paid":null,"fwci":7.5279,"has_fulltext":false,"cited_by_count":57,"citation_normalized_percentile":{"value":0.97376317,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":95,"max":100},"biblio":{"volume":"42","issue":"12","first_page":"1148","last_page":"1161"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.9986000061035156,"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/T12127","display_name":"Software System Performance and Reliability","score":0.9986000061035156,"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/T10260","display_name":"Software Engineering Research","score":0.9965000152587891,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9940000176429749,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.9119332432746887},{"id":"https://openalex.org/keywords/leverage","display_name":"Leverage (statistics)","score":0.5292472243309021},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5261496901512146},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.4856458902359009},{"id":"https://openalex.org/keywords/data-integrity","display_name":"Data integrity","score":0.4844243824481964},{"id":"https://openalex.org/keywords/java","display_name":"Java","score":0.4667867422103882},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.40766799449920654},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.16143637895584106}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9119332432746887},{"id":"https://openalex.org/C153083717","wikidata":"https://www.wikidata.org/wiki/Q6535263","display_name":"Leverage (statistics)","level":2,"score":0.5292472243309021},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5261496901512146},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.4856458902359009},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.4844243824481964},{"id":"https://openalex.org/C548217200","wikidata":"https://www.wikidata.org/wiki/Q251","display_name":"Java","level":2,"score":0.4667867422103882},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.40766799449920654},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.16143637895584106},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tse.2016.2553039","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tse.2016.2553039","pdf_url":null,"source":{"id":"https://openalex.org/S8351582","display_name":"IEEE Transactions on Software Engineering","issn_l":"0098-5589","issn":["0098-5589","1939-3520","2326-3881"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Software Engineering","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":61,"referenced_works":["https://openalex.org/W179340165","https://openalex.org/W585538313","https://openalex.org/W1035289425","https://openalex.org/W1486481742","https://openalex.org/W1487083903","https://openalex.org/W1596127723","https://openalex.org/W1819202854","https://openalex.org/W1968028066","https://openalex.org/W1970165929","https://openalex.org/W1971473888","https://openalex.org/W1974648336","https://openalex.org/W1986136726","https://openalex.org/W1988997230","https://openalex.org/W1990535818","https://openalex.org/W1996974848","https://openalex.org/W2013901208","https://openalex.org/W2014296507","https://openalex.org/W2022424113","https://openalex.org/W2028663517","https://openalex.org/W2049962250","https://openalex.org/W2055757491","https://openalex.org/W2060015309","https://openalex.org/W2062666593","https://openalex.org/W2063393232","https://openalex.org/W2065325279","https://openalex.org/W2069171862","https://openalex.org/W2086658561","https://openalex.org/W2087450238","https://openalex.org/W2089758144","https://openalex.org/W2091851140","https://openalex.org/W2096666207","https://openalex.org/W2098129634","https://openalex.org/W2105696761","https://openalex.org/W2107031757","https://openalex.org/W2107484131","https://openalex.org/W2108349789","https://openalex.org/W2110293342","https://openalex.org/W2123061300","https://openalex.org/W2140984588","https://openalex.org/W2141069252","https://openalex.org/W2142978025","https://openalex.org/W2149207009","https://openalex.org/W2151295763","https://openalex.org/W2157662360","https://openalex.org/W2161818013","https://openalex.org/W2163851162","https://openalex.org/W2169623872","https://openalex.org/W2170114245","https://openalex.org/W2170927924","https://openalex.org/W2306420332","https://openalex.org/W2514489076","https://openalex.org/W3149216967","https://openalex.org/W3149296819","https://openalex.org/W4237335675","https://openalex.org/W4241134169","https://openalex.org/W4244284331","https://openalex.org/W4245823248","https://openalex.org/W4298277474","https://openalex.org/W6649639798","https://openalex.org/W6675709861","https://openalex.org/W6698400389"],"related_works":["https://openalex.org/W2505630977","https://openalex.org/W2383709723","https://openalex.org/W2748529818","https://openalex.org/W2626533837","https://openalex.org/W2163438384","https://openalex.org/W2375584934","https://openalex.org/W1575529579","https://openalex.org/W2525788546","https://openalex.org/W2761120596","https://openalex.org/W1988380406"],"abstract_inverted_index":{"Developers":[0],"usually":[1],"leverage":[2],"Object-Relational":[3],"Mapping":[4],"(ORM)":[5],"to":[6,72,78,89,118,150,164],"abstract":[7],"complex":[8],"database":[9,39],"accesses":[10],"for":[11,52,189],"large-scale":[12],"systems.":[13,134],"However,":[14],"since":[15],"ORM":[16,25,44,68],"frameworks":[17,26,69],"operate":[18],"at":[19],"a":[20,115],"lower-level":[21],"(i.e.,":[22],"data":[23,32,49,61,75,121,139,157,183],"access),":[24],"do":[27],"not":[28,86,98],"know":[29],"how":[30],"the":[31,79,94,101,146,151,166,170,181,185,190],"will":[33],"be":[34,87,194],"used":[35],"when":[36],"returned":[37],"from":[38],"management":[40],"systems":[41,192],"(DBMSs).":[42],"Therefore,":[43],"cannot":[45],"provide":[46,70],"an":[47,108,161,197],"optimal":[48],"retrieval":[50],"approach":[51,163],"all":[53],"applications,":[54],"which":[55,111],"may":[56,85,97],"result":[57,176],"in":[58,93,142],"accessing":[59],"redundant":[60,74,120,138,156,182],"and":[62,130,168],"significantly":[63],"affect":[64],"system":[65,186],"performance.":[66],"Although":[67],"ways":[71],"resolve":[73,100],"problems,":[76,158,184],"due":[77],"complexity":[80],"of":[81,145,154,199],"modern":[82],"systems,":[83],"developers":[84],"able":[88],"locate":[90,119],"such":[91],"problems":[92,140],"code;":[95],"hence,":[96],"proactively":[99],"problems.":[102,122],"In":[103],"this":[104],"paper,":[105],"we":[106,112,159],"propose":[107,160],"automated":[109,162],"approach,":[110],"implement":[113],"as":[114],"Java":[116],"framework,":[117],"We":[123,135],"apply":[124],"our":[125],"framework":[126],"on":[127],"one":[128],"enterprise":[129],"two":[131],"open":[132],"source":[133],"find":[136],"that":[137,178],"exist":[141],"87":[143],"percent":[144],"exercised":[147],"transactions.":[148],"Due":[149],"large":[152],"number":[153],"detected":[155],"assess":[165],"impact":[167],"prioritize":[169],"resolution":[171],"efforts.":[172],"Our":[173],"performance":[174],"assessment":[175],"shows":[177],"by":[179,196],"resolving":[180],"response":[187],"time":[188],"studied":[191],"can":[193],"improved":[195],"average":[198],"17":[200],"percent.":[201]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":6},{"year":2023,"cited_by_count":7},{"year":2022,"cited_by_count":5},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":7},{"year":2019,"cited_by_count":14},{"year":2018,"cited_by_count":5},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}