Integration of parallel write ahead logging and cicada concurrency control method

Takayuki Tanabe, Hideyuki Kawashima, Osamu Tatebe

Research output: Chapter in Book/Report/Conference proceedingConference contribution

1 Citation (Scopus)

Abstract

We proposed the idea of combining the Cicada concurrency control mechanism with P-WAL (parallel write-Ahead logging) and experimentally evaluated the proposed control mechanism. Our results show that P-WAL can be combined suitably with Cicada without decreasing Cicada's performance. We then experimentally evaluated the most optimal parallel write-Ahead logging parameter among (1) conservative lock release; (2) early lock release, the early release of locks on database objects; and (3) group commit, which writes the transaction log to storage all at once. The results show that early lock release and group commit were the most optimal parameters for the combination of Cicada and P-WAL.

Original languageEnglish
Title of host publicationProceedings - 2018 IEEE International Conference on Smart Computing, SMARTCOMP 2018
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages291-296
Number of pages6
ISBN (Print)9781538647059
DOIs
Publication statusPublished - 2018 Jul 26
Externally publishedYes
Event4th IEEE International Conference on Smart Computing, SMARTCOMP 2018 - Taormina, Sicily, Italy
Duration: 2018 Jun 182018 Jun 20

Other

Other4th IEEE International Conference on Smart Computing, SMARTCOMP 2018
CountryItaly
CityTaormina, Sicily
Period18/6/1818/6/20

Keywords

  • Big data
  • Cicada
  • Concurrency control
  • Logging
  • P WAL
  • Transaction
  • Write-Ahead logging

ASJC Scopus subject areas

  • Artificial Intelligence
  • Computer Networks and Communications
  • Computer Science Applications
  • Safety, Risk, Reliability and Quality

Fingerprint Dive into the research topics of 'Integration of parallel write ahead logging and cicada concurrency control method'. Together they form a unique fingerprint.

  • Cite this

    Tanabe, T., Kawashima, H., & Tatebe, O. (2018). Integration of parallel write ahead logging and cicada concurrency control method. In Proceedings - 2018 IEEE International Conference on Smart Computing, SMARTCOMP 2018 (pp. 291-296). [8421375] Institute of Electrical and Electronics Engineers Inc.. https://doi.org/10.1109/SMARTCOMP.2018.00018