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

Fingerprint

Concurrency control
Object-oriented databases

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

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

Integration of parallel write ahead logging and cicada concurrency control method. / Tanabe, Takayuki; Kawashima, Hideyuki; Tatebe, Osamu.

Proceedings - 2018 IEEE International Conference on Smart Computing, SMARTCOMP 2018. Institute of Electrical and Electronics Engineers Inc., 2018. p. 291-296 8421375.

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

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., 8421375, Institute of Electrical and Electronics Engineers Inc., pp. 291-296, 4th IEEE International Conference on Smart Computing, SMARTCOMP 2018, Taormina, Sicily, Italy, 18/6/18. https://doi.org/10.1109/SMARTCOMP.2018.00018
Tanabe T, Kawashima H, Tatebe O. Integration of parallel write ahead logging and cicada concurrency control method. In Proceedings - 2018 IEEE International Conference on Smart Computing, SMARTCOMP 2018. Institute of Electrical and Electronics Engineers Inc. 2018. p. 291-296. 8421375 https://doi.org/10.1109/SMARTCOMP.2018.00018
Tanabe, Takayuki ; Kawashima, Hideyuki ; Tatebe, Osamu. / Integration of parallel write ahead logging and cicada concurrency control method. Proceedings - 2018 IEEE International Conference on Smart Computing, SMARTCOMP 2018. Institute of Electrical and Electronics Engineers Inc., 2018. pp. 291-296
@inproceedings{f087e1f0cdfc4ad98038e1f59ffef9a9,
title = "Integration of parallel write ahead logging and cicada concurrency control method",
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.",
keywords = "Big data, Cicada, Concurrency control, Logging, P WAL, Transaction, Write-Ahead logging",
author = "Takayuki Tanabe and Hideyuki Kawashima and Osamu Tatebe",
year = "2018",
month = "7",
day = "26",
doi = "10.1109/SMARTCOMP.2018.00018",
language = "English",
isbn = "9781538647059",
pages = "291--296",
booktitle = "Proceedings - 2018 IEEE International Conference on Smart Computing, SMARTCOMP 2018",
publisher = "Institute of Electrical and Electronics Engineers Inc.",

}

TY - GEN

T1 - Integration of parallel write ahead logging and cicada concurrency control method

AU - Tanabe, Takayuki

AU - Kawashima, Hideyuki

AU - Tatebe, Osamu

PY - 2018/7/26

Y1 - 2018/7/26

N2 - 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.

AB - 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.

KW - Big data

KW - Cicada

KW - Concurrency control

KW - Logging

KW - P WAL

KW - Transaction

KW - Write-Ahead logging

UR - http://www.scopus.com/inward/record.url?scp=85051546767&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=85051546767&partnerID=8YFLogxK

U2 - 10.1109/SMARTCOMP.2018.00018

DO - 10.1109/SMARTCOMP.2018.00018

M3 - Conference contribution

AN - SCOPUS:85051546767

SN - 9781538647059

SP - 291

EP - 296

BT - Proceedings - 2018 IEEE International Conference on Smart Computing, SMARTCOMP 2018

PB - Institute of Electrical and Electronics Engineers Inc.

ER -