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

Comparison of Update Performance by File System of Mobile Database SQLite3  

Choi, Jin-oh (School of Embedded IT, Busan University of Foreign Studies)
Publication Information
Journal of the Korea Institute of Information and Communication Engineering / v.24, no.9, 2020 , pp. 1117-1122 More about this Journal
Abstract
The improving performance and utilizing application fields of mobile devices are getting bigger and wider. With this trend, applications that use database engines on mobile devices are also becoming common. Applications requiring mobile databases include mobile server databases, edge computing, fog computing, and the like. By the way, the most representative and widely used mobile database is SQLite3. In this paper, we test and compare the update performance of SQLite3 by some file systems. The update performance of the file systems in the mobile environment is an important performance factor in the limited H/W environment. The comparison file system was chosen as FAT, Ext2, and NTFS. Under the same conditions, experiments with each file system to test update performance and characteristics were processed. From the experimental results, we could analyze the advantages and disadvantages of each file system for each database update pattern.
Keywords
Mobile Database; File System; SQLite3; Update Performance;
Citations & Related Records
Times Cited By KSCI : 6  (Citation Analysis)
연도 인용수 순위
1 J. Choi, "Implementation of Modification Performance Comparison of SQLite3 Mobile Databases," Journal of The Korea Institute of Information and Communication Engineering, vol. 22, no. 12, pp. 1571-1576, Dec. 2018.   DOI
2 K. Wang, H. Yin, W. Quan, and G. Min, "Enabling Collaborative Edge Computing for Software Defined Vehicular Networks," Journal of IEEE Network, vol. 32, no. 5, pp. 112-117, May. 2017.
3 Y. Hu, M Patel, D. Sabella, N. Sprecher, and V. Young, "Mobile Edge Computing-A key technology towards 5G," ETSI White Paper, no. 11, Sep. 2015.
4 B. Rad, and A. Shareef, "Fog computing: A Short Review of Concept and Applications," International Journal of Computer Science and Network Security, vol. 17, no. 11, pp. 68-74, Nov. 2017.
5 H. Lee, and J. Oh, "Design and Implementation of a Small Server Room Environment Monitoring System by Using the Arduino," Journal of The Korea Institute of Electronic Communication Science, vol. 12, no. 2, pp. 385-390, Feb. 2017.   DOI
6 SQLite. Architecture of SQLite [Internet]. Available: http://www.sqlite.org/arch.html.
7 Realm. Realm Mobile Database [Internet]. Available: http://realm.io/docs/#getting-started.
8 MachBase Database. IoT Gateway for Edge Analytics [Internet]. Available: http://machbase.com/product-iot-gateway.
9 M. Min, "Evaluating the Performance Quality of Open Source Database Management Systems," Journal of The Korean Society for Quality Management, vol. 45, no. 4, pp. 933-942, 2017.   DOI