{"id":"https://openalex.org/W3043816384","doi":"https://doi.org/10.1109/icoei48184.2020.9142943","title":"Study of Locking Protocols in Database Management for Increasing Concurrency","display_name":"Study of Locking Protocols in Database Management for Increasing Concurrency","publication_year":2020,"publication_date":"2020-06-01","ids":{"openalex":"https://openalex.org/W3043816384","doi":"https://doi.org/10.1109/icoei48184.2020.9142943","mag":"3043816384"},"language":"en","primary_location":{"id":"doi:10.1109/icoei48184.2020.9142943","doi":"https://doi.org/10.1109/icoei48184.2020.9142943","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icoei48184.2020.9142943","pdf_url":null,"source":{"id":"https://openalex.org/S4363607842","display_name":"International Conference on Trends in Electronics and Informatics (ICOEI)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":"2020 4th International Conference on Trends in Electronics and Informatics (ICOEI)(48184)","raw_type":"proceedings-article"},"parent_works":[],"lineage":["https://openalex.org/W3043816384"],"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/A5029856041","display_name":"Swati","orcid":"https://orcid.org/0000-0002-9105-5327","observed_orcids":["https://orcid.org/0000-0002-9105-5327"]},"institutions":[{"id":"https://openalex.org/I4405262955","display_name":"Amity University Gurugram","ror":"https://ror.org/00k8kkh85","country_code":"IN","type":"education","lineage":["https://openalex.org/I191972202","https://openalex.org/I4405262955"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Swati","raw_affiliation_strings":["Computer Science Engineering, Amity University Haryana, Gurugram, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Science Engineering, Amity University Haryana, Gurugram, India","institution_ids":["https://openalex.org/I4405262955"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5063694953","display_name":"Shalini Bhaskar Bajaj","orcid":"https://orcid.org/0000-0001-6935-4884","observed_orcids":["https://orcid.org/0000-0001-6935-4884"]},"institutions":[{"id":"https://openalex.org/I4405262955","display_name":"Amity University Gurugram","ror":"https://ror.org/00k8kkh85","country_code":"IN","type":"education","lineage":["https://openalex.org/I191972202","https://openalex.org/I4405262955"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Shalini Bhaskar Bajaj","raw_affiliation_strings":["Computer Science Engineering, Amity University Haryana, Gurugram, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Science Engineering, Amity University Haryana, Gurugram, India","institution_ids":["https://openalex.org/I4405262955"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I4405262955"],"apc_list":null,"apc_paid":null,"fwci":0.18,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.24745861,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":96},"biblio":{"volume":"10","issue":null,"first_page":"556","last_page":"560"},"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.8169000148773193,"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.8169000148773193,"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.17980000376701355,"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/T10927","display_name":"Access Control and Trust","score":9.999999747378752e-05,"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/locking-protocols","display_name":"locking protocols","score":0.9110000133514404},{"id":"https://openalex.org/keywords/database-concurrency","display_name":"database concurrency","score":0.5979999899864197},{"id":"https://openalex.org/keywords/multi-version-concurrency-control","display_name":"multiversion concurrency control","score":0.8740000128746033},{"id":"https://openalex.org/keywords/transaction-isolation-levels","display_name":"transaction isolation levels","score":0.6690000295639038},{"id":"https://openalex.org/keywords/database-consistency","display_name":"database consistency","score":0.6610000133514404}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.877731442451477},{"id":"https://openalex.org/C177774035","wikidata":"https://www.wikidata.org/wiki/Q1246948","display_name":"Granularity","level":2,"score":0.7958484292030334},{"id":"https://openalex.org/C131346163","wikidata":"https://www.wikidata.org/wiki/Q2290484","display_name":"Two-phase locking","level":5,"score":0.7368829250335693},{"id":"https://openalex.org/C84511453","wikidata":"https://www.wikidata.org/wiki/Q2914952","display_name":"Concurrency control","level":3,"score":0.7314519882202148},{"id":"https://openalex.org/C174839445","wikidata":"https://www.wikidata.org/wiki/Q1134386","display_name":"Lock (firearm)","level":2,"score":0.7221890687942505},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.6058058738708496},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.5691857933998108},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5239213109016418},{"id":"https://openalex.org/C193702766","wikidata":"https://www.wikidata.org/wiki/Q1414548","display_name":"Concurrency","level":2,"score":0.5076709985733032},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.49875712394714355},{"id":"https://openalex.org/C93361087","wikidata":"https://www.wikidata.org/wiki/Q4426698","display_name":"Data consistency","level":2,"score":0.49815845489501953},{"id":"https://openalex.org/C2780385302","wikidata":"https://www.wikidata.org/wiki/Q367158","display_name":"Protocol (science)","level":3,"score":0.48423004150390625},{"id":"https://openalex.org/C2776436953","wikidata":"https://www.wikidata.org/wiki/Q5163215","display_name":"Consistency (knowledge bases)","level":2,"score":0.4735754430294037},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.4577433466911316},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.4413680136203766},{"id":"https://openalex.org/C191558696","wikidata":"https://www.wikidata.org/wiki/Q137712","display_name":"Serializability","level":5,"score":0.4140908718109131},{"id":"https://openalex.org/C25185021","wikidata":"https://www.wikidata.org/wiki/Q4053284","display_name":"Distributed transaction","level":4,"score":0.36544474959373474},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.2720130383968353},{"id":"https://openalex.org/C142724271","wikidata":"https://www.wikidata.org/wiki/Q7208","display_name":"Pathology","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},{"id":"https://openalex.org/C204787440","wikidata":"https://www.wikidata.org/wiki/Q188504","display_name":"Alternative medicine","level":2,"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/C71924100","wikidata":"https://www.wikidata.org/wiki/Q11190","display_name":"Medicine","level":0,"score":0.0},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icoei48184.2020.9142943","doi":"https://doi.org/10.1109/icoei48184.2020.9142943","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icoei48184.2020.9142943","pdf_url":null,"source":{"id":"https://openalex.org/S4363607842","display_name":"International Conference on Trends in Electronics and Informatics (ICOEI)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":"2020 4th International Conference on Trends in Electronics and Informatics (ICOEI)(48184)","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":22,"referenced_works":["https://openalex.org/W105746118","https://openalex.org/W200639877","https://openalex.org/W1550275036","https://openalex.org/W1970827137","https://openalex.org/W1993871034","https://openalex.org/W2001007629","https://openalex.org/W2003895614","https://openalex.org/W2009453307","https://openalex.org/W2011395086","https://openalex.org/W2020129682","https://openalex.org/W2049183208","https://openalex.org/W2147319745","https://openalex.org/W2148998558","https://openalex.org/W2272669552","https://openalex.org/W2296365647","https://openalex.org/W2409338718","https://openalex.org/W2585096443","https://openalex.org/W2585130803","https://openalex.org/W2604961016","https://openalex.org/W2886614606","https://openalex.org/W2887272665","https://openalex.org/W6697018713"],"related_works":["https://openalex.org/W2933546321","https://openalex.org/W3137186698","https://openalex.org/W1569020360","https://openalex.org/W2389863374","https://openalex.org/W4210703544","https://openalex.org/W2985323895","https://openalex.org/W2114813502","https://openalex.org/W7096028639","https://openalex.org/W2886614606","https://openalex.org/W1970827137"],"abstract_inverted_index":{"Transaction":[0],"performs":[1],"lock":[2,104],"and":[3,42,84,119],"unlocking":[4,43],"operations":[5,15],"on":[6,16,45,107],"the":[7,17,28,31,46,55,70,103,126,150,172],"data":[8,18,32,47],"items":[9,19,48],"required":[10],"in":[11,22,149,161,180],"its":[12],"execution.":[13],"These":[14],"are":[20,79],"important":[21],"order":[23],"to":[24,65,158,169],"maintain":[25],"consistency":[26],"of":[27,60,110,128,175],"database":[29],"as":[30],"may":[33],"be":[34,66,100,117,124,159],"accessed":[35],"by":[36,132,142,163],"concurrently":[37],"executing":[38],"transactions.":[39],"Designing":[40],"locking":[41,77,87,92,130,138],"mechanism":[44],"it":[49],"involves":[50,54],"fine":[51],"tuning":[52],"which":[53,96],"following":[56],"factors":[57],"a)":[58],"level":[59,97,109],"granularity":[61,86,91,148],"b)":[62],"appropriate":[63,167],"version":[64,83,145,168],"locked":[67],"c)":[68],"supporting":[69],"compatibility":[71],"mode.":[72],"In":[73],"this":[74],"paper,":[75],"two":[76],"protocols":[78],"covered":[80],"namely":[81],"Multi":[82,85],"protocol.":[88],"The":[89],"Multiple":[90],"protocol":[93,131],"specify":[94],"at":[95],"locks":[98],"can":[99,116,123],"applied,":[101],"if":[102],"is":[105,140,179],"applied":[106],"exact":[108],"database,":[111],"then":[112],"definitely":[113],"system":[114],"performance":[115],"improved":[118],"basically":[120],"explore":[121],"how":[122],"increase":[125],"concurrency":[127],"MGL":[129],"considering":[133],"suitable":[134],"example.":[135],"An":[136],"efficient":[137],"technique":[139],"proposed":[141],"integrating":[143],"multi":[144],"with":[146],"multiple":[147],"hierarchical":[151],"structure.":[152],"This":[153],"allows":[154],"several":[155],"requesting":[156],"transactions":[157],"executed":[160],"parallel":[162],"serving":[164],"them":[165],"an":[166],"read":[170],"while":[171],"write":[173],"operation":[174],"some":[176],"other":[177],"transaction":[178],"progress.":[181]},"counts_by_year":[{"year":2024,"cited_by_count":3},{"year":2022,"cited_by_count":1}],"updated_date":"2026-11-14T11:04:58.165337","created_date":"2020-07-23T00:00:00"}