Proceedings of the 2017 5th International Conference on Mechatronics, Materials, Chemistry and Computer Engineering (ICMMCCE 2017)

Research and Improvement of SQLite's Concurrency Control Mechanism

Authors
Xiaolin Zhao, Jianyang Ding, Rui Ma, Qingyu Gong, Yining Yang
Corresponding Author
Xiaolin Zhao
Available Online September 2017.
DOI
10.2991/icmmcce-17.2017.272How to use a DOI?
Keywords
SQLite; concurrency control; adaptive; timestamp; multi-granularity
Abstract

On the basis of the study of SQLite and other concurrency control mechanisms in memory database, an adaptive concurrency control mechanism is proposed according to the operating environment of SQLite in intelligent mobile devices. The function and concrete flow of improved concurrency control are introduced and discussed. The data structure and the main functions of each part are analyzed. The function and performance of the improved concurrency control mechanism are tested. The results verify the correctness and validity of the adaptive concurrency control.

Copyright
© 2017, the Authors. Published by Atlantis Press.
Open Access
This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

Volume Title
Proceedings of the 2017 5th International Conference on Mechatronics, Materials, Chemistry and Computer Engineering (ICMMCCE 2017)
Series
Advances in Engineering Research
Publication Date
September 2017
ISBN
10.2991/icmmcce-17.2017.272
ISSN
2352-5401
DOI
10.2991/icmmcce-17.2017.272How to use a DOI?
Copyright
© 2017, the Authors. Published by Atlantis Press.
Open Access
This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Cite this article

TY  - CONF
AU  - Xiaolin Zhao
AU  - Jianyang Ding
AU  - Rui Ma
AU  - Qingyu Gong
AU  - Yining Yang
PY  - 2017/09
DA  - 2017/09
TI  - Research and Improvement of SQLite's Concurrency Control Mechanism
BT  - Proceedings of the 2017 5th International Conference on Mechatronics, Materials, Chemistry and Computer Engineering (ICMMCCE 2017)
PB  - Atlantis Press
SP  - 1547
EP  - 1555
SN  - 2352-5401
UR  - https://doi.org/10.2991/icmmcce-17.2017.272
DO  - 10.2991/icmmcce-17.2017.272
ID  - Zhao2017/09
ER  -