{"id":"https://openalex.org/W4312347827","doi":"https://doi.org/10.1109/tc.2022.3222084","title":"On the Effects of Transaction Data Access Patterns on Performance in Lock-Based Concurrency Control","display_name":"On the Effects of Transaction Data Access Patterns on Performance in Lock-Based Concurrency Control","publication_year":2022,"publication_date":"2022-11-16","ids":{"openalex":"https://openalex.org/W4312347827","doi":"https://doi.org/10.1109/tc.2022.3222084"},"language":"en","primary_location":{"id":"doi:10.1109/tc.2022.3222084","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tc.2022.3222084","pdf_url":null,"source":{"id":"https://openalex.org/S157670870","display_name":"IEEE Transactions on Computers","issn_l":"0018-9340","issn":["0018-9340","1557-9956","2326-3814"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["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 Computers","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/A5051273363","display_name":"Pierangelo Di Sanzo","orcid":"https://orcid.org/0000-0001-6136-6303"},"institutions":[{"id":"https://openalex.org/I119003972","display_name":"Roma Tre University","ror":"https://ror.org/05vf0dg29","country_code":"IT","type":"education","lineage":["https://openalex.org/I119003972"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"Pierangelo Di Sanzo","raw_affiliation_strings":["Department of Economics, University of Roma Tre, Rome, Italy"],"affiliations":[{"raw_affiliation_string":"Department of Economics, University of Roma Tre, Rome, Italy","institution_ids":["https://openalex.org/I119003972"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5003036713","display_name":"Francesco Quaglia","orcid":"https://orcid.org/0000-0002-5616-7980"},"institutions":[{"id":"https://openalex.org/I116067653","display_name":"University of Rome Tor Vergata","ror":"https://ror.org/02p77k626","country_code":"IT","type":"education","lineage":["https://openalex.org/I116067653"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Francesco Quaglia","raw_affiliation_strings":["Department of Civil and Information Engineering, University of Rome Tor Vergata, Rome, Italy"],"affiliations":[{"raw_affiliation_string":"Department of Civil and Information Engineering, University of Rome Tor Vergata, Rome, Italy","institution_ids":["https://openalex.org/I116067653"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5051273363"],"corresponding_institution_ids":["https://openalex.org/I119003972"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.16485266,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"72","issue":"6","first_page":"1718","last_page":"1732"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9998999834060669,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9998999834060669,"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/T10974","display_name":"Advanced Queuing Theory Analysis","score":0.9894999861717224,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.9754999876022339,"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/atomicity","display_name":"Atomicity","score":0.8832992315292358},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8781746625900269},{"id":"https://openalex.org/keywords/concurrency-control","display_name":"Concurrency control","score":0.7762837409973145},{"id":"https://openalex.org/keywords/serializability","display_name":"Serializability","score":0.702785849571228},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.6948525309562683},{"id":"https://openalex.org/keywords/lock","display_name":"Lock (firearm)","score":0.6904894113540649},{"id":"https://openalex.org/keywords/isolation","display_name":"Isolation (microbiology)","score":0.6437234878540039},{"id":"https://openalex.org/keywords/optimistic-concurrency-control","display_name":"Optimistic concurrency control","score":0.6283684372901917},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.5887124538421631},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.5666853189468384},{"id":"https://openalex.org/keywords/transaction-data","display_name":"Transaction data","score":0.5476013422012329},{"id":"https://openalex.org/keywords/concurrency","display_name":"Concurrency","score":0.5320048928260803},{"id":"https://openalex.org/keywords/distributed-transaction","display_name":"Distributed transaction","score":0.530310869216919},{"id":"https://openalex.org/keywords/transactional-memory","display_name":"Transactional memory","score":0.5008234977722168},{"id":"https://openalex.org/keywords/multiversion-concurrency-control","display_name":"Multiversion concurrency control","score":0.4660049378871918},{"id":"https://openalex.org/keywords/exploit","display_name":"Exploit","score":0.44686785340309143},{"id":"https://openalex.org/keywords/nested-transaction","display_name":"Nested transaction","score":0.4370516240596771},{"id":"https://openalex.org/keywords/data-access","display_name":"Data access","score":0.4337783753871918},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3196713924407959},{"id":"https://openalex.org/keywords/distributed-concurrency-control","display_name":"Distributed concurrency control","score":0.26509177684783936},{"id":"https://openalex.org/keywords/computer-security","display_name":"Computer security","score":0.1391601860523224}],"concepts":[{"id":"https://openalex.org/C188045909","wikidata":"https://www.wikidata.org/wiki/Q3306359","display_name":"Atomicity","level":3,"score":0.8832992315292358},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8781746625900269},{"id":"https://openalex.org/C84511453","wikidata":"https://www.wikidata.org/wiki/Q2914952","display_name":"Concurrency control","level":3,"score":0.7762837409973145},{"id":"https://openalex.org/C191558696","wikidata":"https://www.wikidata.org/wiki/Q137712","display_name":"Serializability","level":5,"score":0.702785849571228},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.6948525309562683},{"id":"https://openalex.org/C174839445","wikidata":"https://www.wikidata.org/wiki/Q1134386","display_name":"Lock (firearm)","level":2,"score":0.6904894113540649},{"id":"https://openalex.org/C2775941552","wikidata":"https://www.wikidata.org/wiki/Q25212305","display_name":"Isolation (microbiology)","level":2,"score":0.6437234878540039},{"id":"https://openalex.org/C79240183","wikidata":"https://www.wikidata.org/wiki/Q1779327","display_name":"Optimistic concurrency control","level":5,"score":0.6283684372901917},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.5887124538421631},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.5666853189468384},{"id":"https://openalex.org/C127722929","wikidata":"https://www.wikidata.org/wiki/Q7833714","display_name":"Transaction data","level":3,"score":0.5476013422012329},{"id":"https://openalex.org/C193702766","wikidata":"https://www.wikidata.org/wiki/Q1414548","display_name":"Concurrency","level":2,"score":0.5320048928260803},{"id":"https://openalex.org/C25185021","wikidata":"https://www.wikidata.org/wiki/Q4053284","display_name":"Distributed transaction","level":4,"score":0.530310869216919},{"id":"https://openalex.org/C134277064","wikidata":"https://www.wikidata.org/wiki/Q878206","display_name":"Transactional memory","level":3,"score":0.5008234977722168},{"id":"https://openalex.org/C108744092","wikidata":"https://www.wikidata.org/wiki/Q93695","display_name":"Multiversion concurrency control","level":5,"score":0.4660049378871918},{"id":"https://openalex.org/C165696696","wikidata":"https://www.wikidata.org/wiki/Q11287","display_name":"Exploit","level":2,"score":0.44686785340309143},{"id":"https://openalex.org/C137180784","wikidata":"https://www.wikidata.org/wiki/Q6997825","display_name":"Nested transaction","level":5,"score":0.4370516240596771},{"id":"https://openalex.org/C47487241","wikidata":"https://www.wikidata.org/wiki/Q5227230","display_name":"Data access","level":2,"score":0.4337783753871918},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3196713924407959},{"id":"https://openalex.org/C208087996","wikidata":"https://www.wikidata.org/wiki/Q5283142","display_name":"Distributed concurrency control","level":4,"score":0.26509177684783936},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.1391601860523224},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"score":0.0},{"id":"https://openalex.org/C89423630","wikidata":"https://www.wikidata.org/wiki/Q7193","display_name":"Microbiology","level":1,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1109/tc.2022.3222084","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tc.2022.3222084","pdf_url":null,"source":{"id":"https://openalex.org/S157670870","display_name":"IEEE Transactions on Computers","issn_l":"0018-9340","issn":["0018-9340","1557-9956","2326-3814"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["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 Computers","raw_type":"journal-article"},{"id":"pmh:oai:art.torvergata.it:2108/396296","is_oa":false,"landing_page_url":"https://hdl.handle.net/2108/396296","pdf_url":null,"source":{"id":"https://openalex.org/S4306400993","display_name":"Cineca Institutional Research Information System (Tor Vergata University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I116067653","host_organization_name":"University of Rome Tor Vergata","host_organization_lineage":["https://openalex.org/I116067653"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"info:eu-repo/semantics/article"},{"id":"pmh:oai:iris.uniroma3.it:11590/428191","is_oa":false,"landing_page_url":"https://ieeexplore.ieee.org/document/9953325","pdf_url":null,"source":{"id":"https://openalex.org/S4377196120","display_name":"Iris (Roma Tre University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I119003972","host_organization_name":"Roma Tre University","host_organization_lineage":["https://openalex.org/I119003972"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":49,"referenced_works":["https://openalex.org/W19350695","https://openalex.org/W195676583","https://openalex.org/W1409372306","https://openalex.org/W1523021320","https://openalex.org/W1542975293","https://openalex.org/W1545155892","https://openalex.org/W1963589025","https://openalex.org/W1992490313","https://openalex.org/W1998064587","https://openalex.org/W2006239620","https://openalex.org/W2020129682","https://openalex.org/W2020384314","https://openalex.org/W2030812654","https://openalex.org/W2070317073","https://openalex.org/W2086701716","https://openalex.org/W2092911542","https://openalex.org/W2101555342","https://openalex.org/W2104759957","https://openalex.org/W2120377317","https://openalex.org/W2130617154","https://openalex.org/W2130749812","https://openalex.org/W2147193503","https://openalex.org/W2149089882","https://openalex.org/W2155440425","https://openalex.org/W2163654949","https://openalex.org/W2167084438","https://openalex.org/W2231378492","https://openalex.org/W2236986911","https://openalex.org/W2394555589","https://openalex.org/W2496508069","https://openalex.org/W2537450429","https://openalex.org/W2728945542","https://openalex.org/W2746270051","https://openalex.org/W2756159678","https://openalex.org/W2791025429","https://openalex.org/W2887021129","https://openalex.org/W2951799940","https://openalex.org/W3012303953","https://openalex.org/W3029344712","https://openalex.org/W3090742253","https://openalex.org/W3148592861","https://openalex.org/W4229791920","https://openalex.org/W4255138103","https://openalex.org/W4298077439","https://openalex.org/W6607967707","https://openalex.org/W6628101826","https://openalex.org/W6684392763","https://openalex.org/W6689773394","https://openalex.org/W6753966559"],"related_works":["https://openalex.org/W2273209818","https://openalex.org/W1593984632","https://openalex.org/W2147294988","https://openalex.org/W2384599062","https://openalex.org/W1823658424","https://openalex.org/W2347108575","https://openalex.org/W144832856","https://openalex.org/W2377801167","https://openalex.org/W132592264","https://openalex.org/W1557676514"],"abstract_inverted_index":{"Transaction":[0],"Processing":[1],"(TP)":[2],"plays":[3],"a":[4,57,80],"primary":[5],"role":[6],"in":[7,45],"the":[8,47,53,70,110,119,129,140],"design":[9],"and":[10,15,27,99,108,118],"implementation":[11],"of":[12,29,49,82,112,121,131,142],"IT":[13],"applications":[14],"services.":[16],"Many":[17],"TP":[18],"systems":[19],"exploit":[20],"lock-based":[21,62],"concurrency":[22,63],"control":[23,64],"to":[24],"guarantee":[25],"atomicity":[26],"isolation":[28],"transactions":[30],"that":[31,40,69],"access":[32,43,84],"shared":[33],"data.":[34],"In":[35],"this":[36,97],"article,":[37],"we":[38,126],"show":[39,68,127],"transaction":[41,54],"data":[42,50,85,113],"patterns,":[44],"particular":[46],"order":[48],"accesses":[51],"along":[52],"execution,":[55],"have":[56],"noticeable":[58],"impact":[59],"on":[60,76,96],"how":[61,128],"affects":[65],"performance.":[66],"We":[67,94],"performance":[71,141],"can":[72,134],"remarkably":[73],"change":[74],"depending":[75],"whether":[77],"transactions,":[78],"or":[79,92],"percentage":[81],"them,":[83],"items":[86],"following":[87],"some":[88],"common":[89,143],"ordering":[90],"rule":[91],"not.":[93],"investigate":[95],"aspect":[98],"its":[100],"root":[101],"causes":[102],"through":[103,115],"an":[104],"analytical":[105],"modeling":[106],"approach,":[107],"with":[109],"evidence":[111],"gathered":[114],"both":[116],"simulation":[117],"execution":[120],"real":[122],"transactional":[123,144],"workloads.":[124,145],"Finally,":[125],"findings":[130],"our":[132],"study":[133],"be":[135],"easily":[136],"exploited":[137],"for":[138],"improving":[139]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}