{"id":{"repo_id":"uiuc","oai_identifier":"oai:www.ideals.illinois.edu:2142/69543"},"canonical_url":"https://search.dev.ndltd.org/etd/uiuc/oai:www.ideals.illinois.edu:2142/69543","repository":{"repo_id":"uiuc","name":"University of Illinois - Urbana-Champaign","base_url":"https://www.ideals.illinois.edu/oai-pmh"},"display":{"title":"Performance of Concurrency Control Methods in Distributed Database Management Systems (Timestamp Ordering, Two-Phase Locking, Optimistic Scheme, Restart, Transaction Blocking)","abstract":"The effects of transaction restart overhead on the performance of concurrency control methods (CCMs) have been studied using the simulation approach. In order to do this, detailed simulation models for a representative sample of concurrency control mechanisms, namely Basic Timestamp Ordering (BTO), Basic Optimistic scheme (BOPT), Basic Two-Phase Locking (B2PL), and Conservative Timestamp Ordering (CoTO), were developed, and the performances of those CCMs in distributed database management system (DDBMS) were simulated with some care to get statistically significant results. The performances of the CCMs were then compared with respect to several measures. This study systematically investigated effects of major factors on CCM performance in a quantitative manner, whereas few quantitative results have been obtained in the past work on CCM performance.","abstract_html":"The effects of transaction restart overhead on the performance of concurrency control methods (CCMs) have been studied using the simulation approach. In order to do this, detailed simulation models for a representative sample of concurrency control mechanisms, namely Basic Timestamp Ordering (BTO), Basic Optimistic scheme (BOPT), Basic Two-Phase Locking (B2PL), and Conservative Timestamp Ordering (CoTO), were developed, and the performances of those CCMs in distributed database management system (DDBMS) were simulated with some care to get statistically significant results. The performances of the CCMs were then compared with respect to several measures. This study systematically investigated effects of major factors on CCM performance in a quantitative manner, whereas few quantitative results have been obtained in the past work on CCM performance.","abstract_has_math":false,"creators":["Moon, Song Chun"],"institution":"University of Illinois at Urbana-Champaign","degree_name":"Ph.D.","degree_level":"Dissertation","degree_discipline":"Computer Science","degree_department":null,"school":null,"contributors":[],"advisors":[],"committee_chairs":[],"committee_members":[],"year":2014,"date_issued":"2014-12-15T19:25:39Z","date_published":"2014-12-15T19:25:39Z","updated_at":"2026-07-22T22:26:01Z","subjects":["Computer Science"],"languages":[],"rights":[],"rights_urls":[],"identifier_entries":[{"key":"dc:identifier","label":"Identifier","values":["(UMI)AAI8521839"],"render_values":[{"text":"(UMI)AAI8521839","href":null,"code":true}]}]},"links":{"outbound_url":"http://hdl.handle.net/2142/69543","outbound_label":"Handle","outbound_source":"dc:identifier"},"metadata_groups":[{"id":"people","label":"People","entries":[{"key":"dc:creator","label":"Author","values":["Moon, Song Chun"]}]},{"id":"academic_context","label":"Academic Context","entries":[{"key":"dc:date","label":"Dc Date","values":["2014-12-15T19:25:39Z","10000-01-01","1985"]},{"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":"identifiers","label":"Identifiers","entries":[{"key":"dc:identifier","label":"Identifier","values":["http://hdl.handle.net/2142/69543","(UMI)AAI8521839"]}]},{"id":"additional","label":"Additional Metadata","entries":[{"key":"dc:description","label":"Description","values":["The effects of transaction restart overhead on the performance of concurrency control methods (CCMs) have been studied using the simulation approach. In order to do this, detailed simulation models for a representative sample of concurrency control mechanisms, namely Basic Timestamp Ordering (BTO), Basic Optimistic scheme (BOPT), Basic Two-Phase Locking (B2PL), and Conservative Timestamp Ordering (CoTO), were developed, and the performances of those CCMs in distributed database management system (DDBMS) were simulated with some care to get statistically significant results. The performances of the CCMs were then compared with respect to several measures. This study systematically investigated effects of major factors on CCM performance in a quantitative manner, whereas few quantitative results have been obtained in the past work on CCM performance.","Based upon the simulation results and results from the analysis of effects of restart overhead, the transaction restart overhead is found to have a determining effect on the performance of CCMs in DDBMS in most cases.","Qualitatively, the CCMs that use mainly a blocking mechanism to handle conflicting transactions, for example CoTO and B2PL, generally perform better, with respect to most performance indices, than the CCMs that use mainly a restarting mechanism, for example BTO and BOPT.","Made available in DSpace on 2014-12-15T19:25:39Z (GMT). No. of bitstreams: 1 8521839.pdf: 5009548 bytes, checksum: c4c85942e3d489cd13b0464c0f5d5c68 (MD5) Previous issue date: 1985","Embargo set by: Seth Robbins for item 69709 Lift date: Forever Reason: Restricted to the U of I community idenfinitely during batch ingest of legacy ETDs","Restricted to the U of I community idenfinitely during batch ingest of legacy ETDs","U of I Only","167 p.","Thesis (Ph.D.)--University of Illinois at Urbana-Champaign, 1985."]},{"key":"dc:title","label":"Title","values":["Performance of Concurrency Control Methods in Distributed Database Management Systems (Timestamp Ordering, Two-Phase Locking, Optimistic Scheme, Restart, Transaction Blocking)"]}]}],"canonical_facts":{"dc:creator":["Moon, Song Chun"],"dc:date":["2014-12-15T19:25:39Z","10000-01-01","1985"],"dc:description":["The effects of transaction restart overhead on the performance of concurrency control methods (CCMs) have been studied using the simulation approach. In order to do this, detailed simulation models for a representative sample of concurrency control mechanisms, namely Basic Timestamp Ordering (BTO), Basic Optimistic scheme (BOPT), Basic Two-Phase Locking (B2PL), and Conservative Timestamp Ordering (CoTO), were developed, and the performances of those CCMs in distributed database management system (DDBMS) were simulated with some care to get statistically significant results. The performances of the CCMs were then compared with respect to several measures. This study systematically investigated effects of major factors on CCM performance in a quantitative manner, whereas few quantitative results have been obtained in the past work on CCM performance.","Based upon the simulation results and results from the analysis of effects of restart overhead, the transaction restart overhead is found to have a determining effect on the performance of CCMs in DDBMS in most cases.","Qualitatively, the CCMs that use mainly a blocking mechanism to handle conflicting transactions, for example CoTO and B2PL, generally perform better, with respect to most performance indices, than the CCMs that use mainly a restarting mechanism, for example BTO and BOPT.","Made available in DSpace on 2014-12-15T19:25:39Z (GMT). No. of bitstreams: 1 8521839.pdf: 5009548 bytes, checksum: c4c85942e3d489cd13b0464c0f5d5c68 (MD5) Previous issue date: 1985","Embargo set by: Seth Robbins for item 69709 Lift date: Forever Reason: Restricted to the U of I community idenfinitely during batch ingest of legacy ETDs","Restricted to the U of I community idenfinitely during batch ingest of legacy ETDs","U of I Only","167 p.","Thesis (Ph.D.)--University of Illinois at Urbana-Champaign, 1985."],"dc:identifier":["http://hdl.handle.net/2142/69543","(UMI)AAI8521839"],"dc:subject":["Computer Science"],"dc:title":["Performance of Concurrency Control Methods in Distributed Database Management Systems (Timestamp Ordering, Two-Phase Locking, Optimistic Scheme, Restart, Transaction Blocking)"],"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:26:01Z"}