{"id":"https://openalex.org/W4400909482","doi":"https://doi.org/10.1109/icde60146.2024.00385","title":"Optimized Locking in SQL Azure","display_name":"Optimized Locking in SQL Azure","alternate_titles":[],"publication_year":2024,"publication_date":"2024-05-13","ids":{"openalex":"https://openalex.org/W4400909482","doi":"https://doi.org/10.1109/icde60146.2024.00385"},"language":"en","primary_location":{"id":"doi:10.1109/icde60146.2024.00385","doi":"https://doi.org/10.1109/icde60146.2024.00385","is_oa":false,"landing_page_url":"http://dx.doi.org/10.1109/icde60146.2024.00385","pdf_url":null,"source":{"id":"https://openalex.org/S4210210321","display_name":"IEEE International Conference on Data Engineering (ICDE)","issn_l":"1084-4627","issn":["1084-4627","2375-0286"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","norway-2"],"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":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 IEEE 40th International Conference on Data Engineering (ICDE)","raw_type":"proceedings-article"},"parent_works":[],"lineage":["https://openalex.org/W4400909482"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"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/A5029290184","display_name":"Chaitanya Sreenivas Ravella","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Chaitanya Sreenivas Ravella","raw_affiliation_strings":["Microsoft Corporation,Azure Data,Redmond,USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Corporation,Azure Data,Redmond,USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5047147183","display_name":"Prashanth Purnananda","orcid":"https://orcid.org/0009-0003-8004-6104","observed_orcids":["https://orcid.org/0009-0003-8004-6104"]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Prashanth Purnananda","raw_affiliation_strings":["Microsoft Corporation,Azure Data,Redmond,USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Corporation,Azure Data,Redmond,USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5083145336","display_name":"Hanuma Kodavalla","orcid":"https://orcid.org/0009-0006-8245-8585","observed_orcids":["https://orcid.org/0009-0006-8245-8585"]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Hanuma Kodavalla","raw_affiliation_strings":["Microsoft Corporation,Azure Data,Redmond,USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Corporation,Azure Data,Redmond,USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Peter Byrne","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Peter Byrne","raw_affiliation_strings":["Microsoft Corporation,Azure Data,Redmond,USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Corporation,Azure Data,Redmond,USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5011607664","display_name":"Adrian-Leonard Radu","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Adrian-Leonard Radu","raw_affiliation_strings":["Microsoft Corporation,Azure Data,Redmond,USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Corporation,Azure Data,Redmond,USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5083301641","display_name":"Wayne Chen","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Wayne Chen","raw_affiliation_strings":["Microsoft Corporation,Azure Data,Redmond,USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Corporation,Azure Data,Redmond,USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5114195820","display_name":"Srikanth Sampath","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Srikanth Sampath","raw_affiliation_strings":["Microsoft Corporation,Azure Data,Bengaluru,India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Corporation,Azure Data,Bengaluru,India","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5104971513","display_name":"Naga Bhavana Atluri","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Naga Bhavana Atluri","raw_affiliation_strings":["Microsoft Corporation,Azure Data,Atlanta,USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Corporation,Azure Data,Atlanta,USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5107951311","display_name":"Srinag Rao","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Srinag Rao","raw_affiliation_strings":["Microsoft Corporation,Azure Data,Bengaluru,India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Corporation,Azure Data,Bengaluru,India","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5105000041","display_name":"Priyanka Kakade","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Priyanka Kakade","raw_affiliation_strings":["Microsoft Corporation,Azure Data,Bengaluru,India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Corporation,Azure Data,Bengaluru,India","institution_ids":["https://openalex.org/I1290206253"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I1290206253"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"5132","last_page":"5141"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.6265000104904175,"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.6265000104904175,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.3716000020503998,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.0003000000142492354,"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/multi-version-concurrency-control","display_name":"multiversion concurrency control","score":0.871999979019165},{"id":"https://openalex.org/keywords/database-concurrency-control","display_name":"database concurrency control","score":0.4860000014305115}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7433335781097412},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5680772066116333},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.5159755349159241},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4875878691673279},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.4139980971813202},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3856191039085388},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.147504061460495},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.050846368074417114},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde60146.2024.00385","doi":"https://doi.org/10.1109/icde60146.2024.00385","is_oa":false,"landing_page_url":"http://dx.doi.org/10.1109/icde60146.2024.00385","pdf_url":null,"source":{"id":"https://openalex.org/S4210210321","display_name":"IEEE International Conference on Data Engineering (ICDE)","issn_l":"1084-4627","issn":["1084-4627","2375-0286"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","norway-2"],"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":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 IEEE 40th International Conference on Data Engineering (ICDE)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":14,"referenced_works":["https://openalex.org/W80973625","https://openalex.org/W1513841824","https://openalex.org/W1515932031","https://openalex.org/W1569583874","https://openalex.org/W1605782097","https://openalex.org/W1987358714","https://openalex.org/W2047908203","https://openalex.org/W2104954161","https://openalex.org/W2139285682","https://openalex.org/W2751002994","https://openalex.org/W2913142830","https://openalex.org/W2948526913","https://openalex.org/W3004616691","https://openalex.org/W4301086371"],"related_works":["https://openalex.org/W2095600783","https://openalex.org/W7212866114","https://openalex.org/W4244940845","https://openalex.org/W4256640891","https://openalex.org/W2351601541","https://openalex.org/W4229738873","https://openalex.org/W4233558721","https://openalex.org/W2145761653","https://openalex.org/W2492101938","https://openalex.org/W2896767162"],"abstract_inverted_index":{"SQL":[0,182],"Azure's":[1],"concurrency":[2],"control":[3],"relies":[4],"on":[5,17],"multi-versioning":[6],"to":[7,21,39,120,177],"prevent":[8,22],"readers":[9],"and":[10,16,69,163],"writers":[11,24],"from":[12,144],"blocking":[13,101],"each":[14,102],"other":[15],"in-memory":[18,33,67,115],"row":[19,116],"locks":[20,34,68],"multiple":[23],"modifying":[25],"the":[26,30,64,111,160,164,171],"same":[27],"row.":[28],"If":[29],"number":[31,65],"of":[32,66,97,114,173],"exceeds":[35],"a":[36,56,138],"threshold,":[37],"then":[38],"reduce":[40],"memory":[41],"used":[42],"for":[43,133],"locking,":[44],"table-level":[45],"lock":[46,71,79],"escalation":[47],"occurs":[48],"which":[49,155],"severely":[50],"reduces":[51,63],"concurrency.":[52],"This":[53,118],"paper":[54,148],"presents":[55,149,170],"technique":[57,77],"called":[58,78],"transaction-id":[59],"locking":[60,87,105,176],"that":[61],"drastically":[62],"eliminates":[70],"escalation.":[72],"It":[73,168],"also":[74,169],"describes":[75],"another":[76],"after":[80],"qualification":[81],"where":[82],"rows":[83,98],"are":[84],"qualified":[85],"without":[86,100],"thereby":[88],"letting":[89],"concurrent":[90],"transactions":[91],"interested":[92],"in":[93,137,150,158,184],"mutually":[94],"exclusive":[95],"sets":[96],"execute":[99],"other.":[103],"Optimized":[104],"combines":[106],"these":[107],"two":[108],"techniques":[109],"with":[110],"prior":[112,145],"scheme":[113,154],"locks.":[117],"combination":[119],"improve":[121],"common":[122],"isolation":[123,135],"levels":[124],"(like":[125],"Read":[126],"Committed":[127],"Snapshot":[128],"Isolation)":[129],"while":[130],"retaining":[131],"support":[132],"Serializable":[134],"level":[136],"developer-friendly":[139],"manner":[140],"distinguishes":[141],"this":[142,152],"work":[143],"art.":[146],"The":[147],"detail":[151],"new":[153],"required":[156],"changes":[157],"both":[159],"storage":[161],"engine":[162],"query":[165],"processing":[166],"engine.":[167],"results":[172],"deploying":[174],"optimized":[175],"more":[178],"than":[179],"eleven":[180],"million":[181],"databases":[183],"Azure.":[185]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W4400909482","counts_by_year":[],"updated_date":"2026-10-28T10:33:24.094632","created_date":"2024-07-24T00:00:00"}
