O|R|P|E - A data semantics driven concurrency control mechanism

  • This paper presents a concurrency control mechanism that does not follow a ‘one concurrency control mechanism fits all needs’ strategy. With the presented mechanism a transaction runs under several concurrency control mechanisms and the appropriate one is chosen based on the accessed data. For this purpose, the data is divided into four classes based on its access type and usage (semantics). Class O (the optimistic class) implements a first-committer-wins strategy, class R (the reconciliation class) implements a first-n-committers-win strategy, class P (the pessimistic class) implements a first reader-wins strategy, and class E (the escrow class) implements a firsnreaderswin strategy. Accordingly, the model is called OjRjPjE. Under this model the TPC-C benchmark outperforms other CC mechanisms like optimistic Snapshot Isolation.

Download full text files

Export metadata

Additional Services

Share in Twitter Search Google Scholar
Metadaten
Name:Laux, Friedrich
URN:urn:nbn:de:bsz:rt2-opus4-4029
URL:http://www.thinkmind.org/index.php?view=instance&instance=DBKDA+2015
ISBN:978-1-61208-408-4
Erschienen in:DBKDA 2015, the Seventh International Conference on Advances in Databases, Knowledge, and Data Applications : GraphSM 2015, the Second International Workshop on Large-Scale Graph Storage and Management ; May 24 - 29, 2015, Rome, Italy
Editor:Friedrich Laux, Andreas Schmidt, Maria Del Pilar Angeles, Iztok Savnik
Document Type:Conference Proceeding
Language:English
Year of Publication:2015
Creating Corporation:International Academy, Research, and Industry Association (IARIA)
Tag:multimodel concurrency control; optimistic concurrency control; performance analysis; snapshot isolation; transaction processing
Pagenumber:6
First Page:147
Last Page:152
Dewey Decimal Classification:000 Allgemeines, Wissenschaft
Open Access:Ja
Licence (German):License Logo  Creative Commons - Namensnennung, nicht kommerziell, Weitergabe unter gleichen Bedingungen

OPUS4 Logo