257 0

Atomic Multi-database Transaction of WAL Journaling Mode in SQLite

Title
Atomic Multi-database Transaction of WAL Journaling Mode in SQLite
Author
원유집
Keywords
Atomicity; Database; Multi-database; SQLite; Write-Ahead Logging
Issue Date
2017-02
Publisher
IEEE
Citation
2017 19th International Conference on Advanced Communication Technology (ICACT), page. 874-878
Abstract
This works is to propose a solution for multi-database atomicity problem of WAL journaling mode in SQLite. SQLite is the most widely deployed and used DBMS in mobile system [1]. SQLite has several journaling modes. WAL (Write-Ahead Logging) is the one of those journaling modes included from version 3.7.0. WAL is significantly faster in most scenarios and provides more concurrency as reading and writing can proceed concurrently. However, transactions that involve changes with multiple attached databases do not guarantee atomicity across all databases as a set [2]. We modify transaction and recovery procedure of WAL to solve this problem. This work consists of three parts: (i) Enabling Use of Master Journal for WAL. (ii) Creation of `mj-stored' File in Multi-Database Transaction. (iii) Rollback with `mj-stored' File. In multi-database transaction, we create `mj-stored' file for each WAL file to save the state before the transaction begins and the master journal file name. If crash occurs during the transaction, database with WAL journaling mode try to find the `mj-stored' file and corresponding master journal file to roll back to the state before the transaction began in recovery time. With this solution, multi-database transaction with WAL journaling mode can guarantee atomicity.
URI
https://ieeexplore.ieee.org/document/7890219https://repository.hanyang.ac.kr/handle/20.500.11754/112708
ISBN
9788996865094; 9788996865087; 9781509048922
DOI
10.23919/ICACT.2017.7890219
Appears in Collections:
COLLEGE OF ENGINEERING[S](공과대학) > COMPUTER SCIENCE(컴퓨터소프트웨어학부) > Articles
Files in This Item:
There are no files associated with this item.
Export
RIS (EndNote)
XLS (Excel)
XML


qrcode

Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.

BROWSE