Browse > Article
http://dx.doi.org/10.6109/jkiice.2022.26.1.1

Comparison of Search Performance of SQLite3 Database by Linux File Systems  

Choi, Jin-Oh (Division of Software, Busan University of Foreign Studies)
Publication Information
Journal of the Korea Institute of Information and Communication Engineering / v.26, no.1, 2022 , pp. 1-6 More about this Journal
Abstract
Recently, IoT sensors are often used to produce stream data locally and they are provided for edge computing applications. Mass-produced data are stored in the mobile device's database for real-time processing and then synchronized with the server when needed. Many mobile databases are developed to support those applications. They are CloudScape, DB2 Everyplace, ASA, PointBase Mobile, etc, and the most widely used database is SQLite3 on Linux. In this paper, we focused on the performance required for synchronization with the server. The search performance required to retrieve SQLite3 was compared and analyzed according to the type of each Linux file system in which the database is stored. Thus, performance differences were checked for each file system according to various search query types, and criteria for applying the more appropriate Linux file system according to the index use environment and table scan environment were prepared and presented.
Keywords
Mobile database; Linux file system; Search performance; SQLite3;
Citations & Related Records
연도 인용수 순위
  • Reference
1 What is Hybrid Cloud? [Internet]. Available: https://www.netapp.com/ko/hybrid-cloud/what-is-hybrid-cloud/.
2 Android Databases Performance Tests-CRUD [Internet]. Available: https://proandroiddev.com/android-databasesperformance-crud-a963dd7bb0eb.
3 SQLite. Architecture of SQLite [Internet]. Available: http://www.sqlite.org/arch.html.
4 The XFS File System [Internet]. Available: https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/7/html/storage_administration_guide/ch-XFS.
5 S. Wang, Y. Zhao, J. Xu, J. Yuan, and C. Hsu, "Edge Server Placement in Mobile Edge Computing," Journal of Parallel and Distributed Computing, vol. 127, pp. 160-168, 2019.   DOI
6 J. Choi, "Comparison of Update Performance by File System of Mobile Database SQLite3," Journal of The Korea Institute of Information and Communication Engineering, vol. 24, no. 9, pp. 1117-1122, Sep. 2020.   DOI
7 N. Abbas, Y. Zang, A. Taherkordi, and T. Skeie, "Mobile Edge Computing: A Survey," Journal of IEEE Internet of Things, vol. 5, no. 1, pp. 450-465, 2018.   DOI
8 An introduction to Linux's EXT4 filesystem [Internet]. Available: https://opensource.com/article/17/5/introductionExt4-filesystem.
9 A. Naohiro and K. Kenji, "File Systems are Hard to Test -Learning from Xfstests," IEICE Transactions on Information ans Systems, vol. 102, no. 2, pp. 269-279, 2019.
10 Ext4 Disk Layout [Internet]. Available: https://Ext4.wiki.kernel.org/index.php/Ext4_Disk_Layout.