{"id":"https://openalex.org/W2080964772","doi":"https://doi.org/10.1145/1632149.1632169","title":"The influence of optimisations on the performance of an object relational mapping tool","display_name":"The influence of optimisations on the performance of an object relational mapping tool","publication_year":2009,"publication_date":"2009-10-12","ids":{"openalex":"https://openalex.org/W2080964772","doi":"https://doi.org/10.1145/1632149.1632169","mag":"2080964772"},"language":"en","primary_location":{"id":"doi:10.1145/1632149.1632169","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1632149.1632169","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2009 Annual Research Conference of the South African Institute of Computer Scientists and Information Technologists","raw_type":"proceedings-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/A5071961612","display_name":"Pieter van Zyl","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Pieter van Zyl","raw_affiliation_strings":["Espresso Research Group and Meraka, Pretoria, South Africa"],"affiliations":[{"raw_affiliation_string":"Espresso Research Group and Meraka, Pretoria, South Africa","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5106185216","display_name":"Derrick G. Kourie","orcid":null},"institutions":[{"id":"https://openalex.org/I69552723","display_name":"University of Pretoria","ror":"https://ror.org/00g0p6g84","country_code":"ZA","type":"education","lineage":["https://openalex.org/I69552723"]}],"countries":["ZA"],"is_corresponding":false,"raw_author_name":"Derrick G. Kourie","raw_affiliation_strings":["University of Pretoria, Pretoria, South Africa","University of Pretoria , Pretoria, South Africa"],"affiliations":[{"raw_affiliation_string":"University of Pretoria, Pretoria, South Africa","institution_ids":["https://openalex.org/I69552723"]},{"raw_affiliation_string":"University of Pretoria , Pretoria, South Africa","institution_ids":["https://openalex.org/I69552723"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5112227123","display_name":"Louis Coetzee","orcid":"https://orcid.org/0000-0001-7352-6810"},"institutions":[{"id":"https://openalex.org/I69552723","display_name":"University of Pretoria","ror":"https://ror.org/00g0p6g84","country_code":"ZA","type":"education","lineage":["https://openalex.org/I69552723"]}],"countries":["ZA"],"is_corresponding":false,"raw_author_name":"Louis Coetzee","raw_affiliation_strings":["Meraka Institute, Pretoria, South Africa"],"affiliations":[{"raw_affiliation_string":"Meraka Institute, Pretoria, South Africa","institution_ids":["https://openalex.org/I69552723"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5026643101","display_name":"Andrew Boake","orcid":null},"institutions":[{"id":"https://openalex.org/I69552723","display_name":"University of Pretoria","ror":"https://ror.org/00g0p6g84","country_code":"ZA","type":"education","lineage":["https://openalex.org/I69552723"]}],"countries":["ZA"],"is_corresponding":false,"raw_author_name":"Andrew Boake","raw_affiliation_strings":["University of Pretoria, Pretoria, South Africa","University of Pretoria , Pretoria, South Africa"],"affiliations":[{"raw_affiliation_string":"University of Pretoria, Pretoria, South Africa","institution_ids":["https://openalex.org/I69552723"]},{"raw_affiliation_string":"University of Pretoria , Pretoria, South Africa","institution_ids":["https://openalex.org/I69552723"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5071961612"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.3428,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.62257688,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"150","last_page":"159"},"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.9983000159263611,"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.9983000159263611,"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/T12127","display_name":"Software System Performance and Reliability","score":0.9911999702453613,"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.9901000261306763,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8476606607437134},{"id":"https://openalex.org/keywords/java","display_name":"Java","score":0.7156365513801575},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.7042948007583618},{"id":"https://openalex.org/keywords/object-relational-mapping","display_name":"Object-relational mapping","score":0.6292494535446167},{"id":"https://openalex.org/keywords/python","display_name":"Python (programming language)","score":0.5565337538719177},{"id":"https://openalex.org/keywords/bottleneck","display_name":"Bottleneck","score":0.5326176881790161},{"id":"https://openalex.org/keywords/perl","display_name":"Perl","score":0.5254939198493958},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5170515179634094},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5099531412124634},{"id":"https://openalex.org/keywords/layer","display_name":"Layer (electronics)","score":0.501483678817749},{"id":"https://openalex.org/keywords/object-oriented-programming","display_name":"Object-oriented programming","score":0.4364355504512787},{"id":"https://openalex.org/keywords/object","display_name":"Object (grammar)","score":0.4110972583293915},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.3651331961154938},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.17382168769836426},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.15683695673942566}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8476606607437134},{"id":"https://openalex.org/C548217200","wikidata":"https://www.wikidata.org/wiki/Q251","display_name":"Java","level":2,"score":0.7156365513801575},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.7042948007583618},{"id":"https://openalex.org/C72615636","wikidata":"https://www.wikidata.org/wiki/Q58748","display_name":"Object-relational mapping","level":4,"score":0.6292494535446167},{"id":"https://openalex.org/C519991488","wikidata":"https://www.wikidata.org/wiki/Q28865","display_name":"Python (programming language)","level":2,"score":0.5565337538719177},{"id":"https://openalex.org/C2780513914","wikidata":"https://www.wikidata.org/wiki/Q18210350","display_name":"Bottleneck","level":2,"score":0.5326176881790161},{"id":"https://openalex.org/C2777002779","wikidata":"https://www.wikidata.org/wiki/Q42478","display_name":"Perl","level":2,"score":0.5254939198493958},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5170515179634094},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5099531412124634},{"id":"https://openalex.org/C2779227376","wikidata":"https://www.wikidata.org/wiki/Q6505497","display_name":"Layer (electronics)","level":2,"score":0.501483678817749},{"id":"https://openalex.org/C73752529","wikidata":"https://www.wikidata.org/wiki/Q79872","display_name":"Object-oriented programming","level":2,"score":0.4364355504512787},{"id":"https://openalex.org/C2781238097","wikidata":"https://www.wikidata.org/wiki/Q175026","display_name":"Object (grammar)","level":2,"score":0.4110972583293915},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.3651331961154938},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.17382168769836426},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.15683695673942566},{"id":"https://openalex.org/C178790620","wikidata":"https://www.wikidata.org/wiki/Q11351","display_name":"Organic chemistry","level":1,"score":0.0},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1632149.1632169","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1632149.1632169","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2009 Annual Research Conference of the South African Institute of Computer Scientists and Information Technologists","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":18,"referenced_works":["https://openalex.org/W54838500","https://openalex.org/W576367677","https://openalex.org/W592025752","https://openalex.org/W1541912911","https://openalex.org/W1578824034","https://openalex.org/W1583169995","https://openalex.org/W1807162426","https://openalex.org/W1883979883","https://openalex.org/W1928009460","https://openalex.org/W2025194432","https://openalex.org/W2071116189","https://openalex.org/W2085463701","https://openalex.org/W2169562836","https://openalex.org/W2337716259","https://openalex.org/W4249631976","https://openalex.org/W6616485907","https://openalex.org/W6634963567","https://openalex.org/W6638358385"],"related_works":["https://openalex.org/W66419302","https://openalex.org/W2789551765","https://openalex.org/W2100821029","https://openalex.org/W3183359519","https://openalex.org/W2183155286","https://openalex.org/W2761120596","https://openalex.org/W2762065037","https://openalex.org/W250007877","https://openalex.org/W2296475622","https://openalex.org/W2382669648"],"abstract_inverted_index":{"Object":[0],"Relational":[1],"Mapping":[2],"(ORM":[3],"or":[4],"also":[5],"known":[6],"as":[7,22,228],"O-R)":[8],"tools":[9,46,54,78],"provide":[10,79],"a":[11,32,75,100,174],"mapping":[12,45,129],"between":[13,25,83],"the":[14,18,36,40,84,89,105,110,117,124,134,156,194,201,231],"object":[15,27,43,120,168],"model":[16],"and":[17,31,71,88,182,185,206,209],"relational":[19,33,44],"model,":[20],"acting":[21],"an":[23,26,80],"intermediary":[24],"oriented":[28],"code":[29],"base,":[30],"database.":[34],"Over":[35],"last":[37],"few":[38],"years":[39],"use":[41,118,202],"of":[42,104,112,119,136,158,193,203,235],"have":[47],"grown.":[48],"Today":[49],"their":[50],"exist":[51],"many":[52],"ORM":[53,77],"for":[55,126,218],"programming":[56],"languages,":[57],"like":[58],"C++":[59],"(LiteSQL),":[60],"Java":[61,166],"(Hibernate,":[62],"Apache":[63],"OJB),":[64],"Python":[65],"(SQLAlchemy),":[66],"Ruby,":[67],"PHP,":[68],".Net":[69],"(iBATIS)":[70],"Perl":[72],"to":[73,108,164,172,176,179,183,200,216],"name":[74],"few.":[76],"extra":[81,114,128],"layer":[82,87,97,115],"business":[85],"logic":[86],"data":[90],"layer.":[91,130],"It":[92],"is":[93,98,237],"important":[94],"that":[95,122],"this":[96,113,127,132,145],"not":[99],"bottleneck.":[101],"The":[102,160,211,220,233],"aim":[103],"study":[106],"was":[107,142,170,222],"investigate":[109,165],"influence":[111],"against":[116],"databases":[121],"remove":[123],"need":[125],"During":[131],"investigation":[133],"impact":[135],"certain":[137],"optimisation":[138,153],"techniques":[139,154],"on":[140,150],"performance":[141,157],"investigated.":[143],"In":[144],"paper":[146],"we":[147],"only":[148],"report":[149],"how":[151],"vendor-recommended":[152],"influenced":[155],"Hibernate.":[159],"OO7":[161],"benchmark,":[162],"tailored":[163],"based":[167],"persistence,":[169],"used":[171,191],"create":[173],"database;":[175],"traverse":[177],"it;":[178,181],"query":[180],"delete":[184],"update":[186],"data.":[187],"An":[188],"initial":[189],"experiment":[190,221],"out":[192],"box":[195],"Hibernate":[196,217],"settings":[197,227],"with":[198],"regard":[199],"indexes,":[204],"lazy":[205],"eager":[207],"loading,":[208],"caching.":[210],"times":[212],"taken":[213],"were":[214],"submitted":[215],"comment.":[219],"then":[223],"re-run,":[224],"using":[225],"optimised":[226],"recommended":[229],"by":[230],"vendor.":[232],"extent":[234],"improvement":[236],"reported.":[238]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2017,"cited_by_count":2},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}