{"id":{"repo_id":"uiuc","oai_identifier":"oai:www.ideals.illinois.edu:2142/22651"},"canonical_url":"https://search.dev.ndltd.org/etd/uiuc/oai:www.ideals.illinois.edu:2142/22651","repository":{"repo_id":"uiuc","name":"University of Illinois - Urbana-Champaign","base_url":"https://www.ideals.illinois.edu/oai-pmh"},"display":{"title":"A distributed concurrency control protocol considering read-only transactions","abstract":"Item marked as restricted to the 'UIUC Users [automated]' Group (id=2) by Howard Ding (hding2@illinois.edu) on 2011-05-07T14:59:04Z Item is restricted indefinitely.","abstract_html":"Item marked as restricted to the &#x27;UIUC Users [automated]&#x27; Group (id=2) by Howard Ding (hding2@illinois.edu) on 2011-05-07T14:59:04Z Item is restricted indefinitely.","abstract_has_math":false,"creators":["Lu, Shunong"],"institution":"University of Illinois at Urbana-Champaign","degree_name":"Ph.D.","degree_level":"Dissertation","degree_discipline":"Computer Science","degree_department":null,"school":null,"contributors":["Belford, Geneva G."],"advisors":[],"committee_chairs":[],"committee_members":[],"year":2011,"date_issued":"2011-05-07T13:46:48Z","date_published":"2011-05-07T13:46:48Z","updated_at":"2026-07-22T22:25:20Z","subjects":["Computer Science"],"languages":["eng"],"rights":["Copyright 1991 Lu, Shunong"],"rights_urls":[],"identifier_entries":[{"key":"dc:identifier","label":"Identifier","values":["AAI9136669","(UMI)AAI9136669"],"render_values":[{"text":"AAI9136669","href":null,"code":true},{"text":"(UMI)AAI9136669","href":null,"code":true}]}]},"links":{"outbound_url":"http://hdl.handle.net/2142/22651","outbound_label":"Handle","outbound_source":"dc:identifier"},"metadata_groups":[{"id":"people","label":"People","entries":[{"key":"dc:contributor","label":"Contributor","values":["Belford, Geneva G."]},{"key":"dc:creator","label":"Author","values":["Lu, Shunong"]}]},{"id":"academic_context","label":"Academic Context","entries":[{"key":"dc:date","label":"Dc Date","values":["2011-05-07T13:46:48Z","10000-01-01","1991"]},{"key":"dc:type","label":"Dc Type","values":["text"]},{"key":"thesis:degree_discipline","label":"Discipline","values":["Computer Science"]},{"key":"thesis:degree_level","label":"Degree Level","values":["Dissertation"]},{"key":"thesis:degree_name","label":"Degree Name","values":["Ph.D."]},{"key":"thesis:institution_name","label":"Thesis Institution Name","values":["University of Illinois at Urbana-Champaign"]}]},{"id":"subjects_keywords","label":"Subjects and Keywords","entries":[{"key":"dc:subject","label":"Dc Subject","values":["Computer Science"]}]},{"id":"language_rights","label":"Language and Rights","entries":[{"key":"dc:language","label":"Dc Language","values":["eng"]},{"key":"dc:rights","label":"Dc Rights","values":["Copyright 1991 Lu, Shunong"]}]},{"id":"identifiers","label":"Identifiers","entries":[{"key":"dc:identifier","label":"Identifier","values":["AAI9136669","(UMI)AAI9136669","http://hdl.handle.net/2142/22651"]}]},{"id":"additional","label":"Additional Metadata","entries":[{"key":"dc:description","label":"Description","values":["Item marked as restricted to the 'UIUC Users [automated]' Group (id=2) by Howard Ding (hding2@illinois.edu) on 2011-05-07T14:59:04Z Item is restricted indefinitely.","Restriction data tranferred 2014-07-01T11:27:50-05:00 Original Data Group with Access UIUC Users [automated] Release Date: none Reason: ETDs are only available to UIUC Users without author permission","Attaining high performance of transaction processing and preserving consistency of database are two essential goals of a concurrency control protocol in distributed database systems. However, it is trade-off to accomplish these two goals. Our research focuses on the subject of syntax-based correctness that is not based on total serializability and takes into account of read-only transactions. In this thesis, it is shown that relaxing serializability improves the performance of transaction processing.","Taking advantage of read-only transactions which do not modify database, we propose a new correctness criterion for transaction processing, partial consistency. In an execution a partially consistent data view seen by a read-only transaction is consistent with all data views produced by update transactions and the final database state but is not necessarily consistent with the data views seen by other read-only transactions. Based on the partial consistency requirement, a distributed concurrency control protocol, Mixed Protocol, is developed and implemented in a simulated distributed database system. Several design and implementation issues of Mixed Protocol for fully replicated and non-replicated databases are studied.","The performance of the Mixed Protocol and of the conventional 2PL protocol are compared in a simulation study. An analytic study is conducted to validate the simulation results as well as to understand the cause-effect relationships between the interacting factors in the Mixed Protocol.","Made available in DSpace on 2011-05-07T13:46:48Z (GMT). No. of bitstreams: 2 license.txt: 4922 bytes, checksum: 910b249b4beec47e7ab768910c8f966f (MD5) 9136669.pdf: 8417383 bytes, checksum: d408d96ab16231ac68bbd517a7637b8e (MD5) Previous issue date: 1991","ETDs are only available to UIUC Users without author permission","U of I Only"]},{"key":"dc:title","label":"Title","values":["A distributed concurrency control protocol considering read-only transactions"]}]}],"canonical_facts":{"dc:contributor":["Belford, Geneva G."],"dc:creator":["Lu, Shunong"],"dc:date":["2011-05-07T13:46:48Z","10000-01-01","1991"],"dc:description":["Item marked as restricted to the 'UIUC Users [automated]' Group (id=2) by Howard Ding (hding2@illinois.edu) on 2011-05-07T14:59:04Z Item is restricted indefinitely.","Restriction data tranferred 2014-07-01T11:27:50-05:00 Original Data Group with Access UIUC Users [automated] Release Date: none Reason: ETDs are only available to UIUC Users without author permission","Attaining high performance of transaction processing and preserving consistency of database are two essential goals of a concurrency control protocol in distributed database systems. However, it is trade-off to accomplish these two goals. Our research focuses on the subject of syntax-based correctness that is not based on total serializability and takes into account of read-only transactions. In this thesis, it is shown that relaxing serializability improves the performance of transaction processing.","Taking advantage of read-only transactions which do not modify database, we propose a new correctness criterion for transaction processing, partial consistency. In an execution a partially consistent data view seen by a read-only transaction is consistent with all data views produced by update transactions and the final database state but is not necessarily consistent with the data views seen by other read-only transactions. Based on the partial consistency requirement, a distributed concurrency control protocol, Mixed Protocol, is developed and implemented in a simulated distributed database system. Several design and implementation issues of Mixed Protocol for fully replicated and non-replicated databases are studied.","The performance of the Mixed Protocol and of the conventional 2PL protocol are compared in a simulation study. An analytic study is conducted to validate the simulation results as well as to understand the cause-effect relationships between the interacting factors in the Mixed Protocol.","Made available in DSpace on 2011-05-07T13:46:48Z (GMT). No. of bitstreams: 2 license.txt: 4922 bytes, checksum: 910b249b4beec47e7ab768910c8f966f (MD5) 9136669.pdf: 8417383 bytes, checksum: d408d96ab16231ac68bbd517a7637b8e (MD5) Previous issue date: 1991","ETDs are only available to UIUC Users without author permission","U of I Only"],"dc:identifier":["AAI9136669","(UMI)AAI9136669","http://hdl.handle.net/2142/22651"],"dc:language":["eng"],"dc:rights":["Copyright 1991 Lu, Shunong"],"dc:subject":["Computer Science"],"dc:title":["A distributed concurrency control protocol considering read-only transactions"],"dc:type":["text"],"thesis:degree_discipline":["Computer Science"],"thesis:degree_level":["Dissertation"],"thesis:degree_name":["Ph.D."],"thesis:institution_name":["University of Illinois at Urbana-Champaign"]},"updated_at":"2026-07-22T22:25:20Z"}