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

Modification Performance Comparison of SQLite3 Mobile Databases  

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.22, no.12, 2018 , pp. 1571-1576 More about this Journal
Abstract
Recently, the attractive changes of mobile device are a improvement of the computing performance, dramatic improvement of storage capacity, constant connection to the internet, and sophisticated development of display technology. As a result, database applications utilizing mobile devices are emerging. These applications include databases for mobile servers, databases for edge computing, and fog computing. Therefore, it is important to pay attention to the current mobile database and pay attention to whether it has suitable performance for the applications. In this paper, the most common mobile database, SQLite3 is selected and experimented to test and understand the update performance and characteristics. The results of experiment are compared with the one of Oracle database at the same condition to evaluate the experiment. As a result, Insert Performance of SQLite3 has a lot of points to be improved and Update performance is very good. Especially, the performance of Range Query is excellent.
Keywords
Mobile Database; Oracle Test; SQLite3; Update Performance;
Citations & Related Records
Times Cited By KSCI : 2  (Citation Analysis)
연도 인용수 순위
1 J. Choi, "Implementation and Experiment for Search Performance Analysis of SQLite Mobile Database," Journal of The Korea Institute of Information and Communication Engineering, vol. 21, no. 2, pp. 333-338, Feb. 2017.   DOI
2 H. Lee, 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
3 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.
4 B. Rad, 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 SQLite. Architecture of SQLite [Internet]. Available: http://www.sqlite.org/arch.html.
6 Realm. Realm Mobile Database [Internet]. Available: http://realm.io/docs/#getting-started.
7 MachBase Database. IoT Gateway for Edge Analytics [Internet]. Available: http://machbase.com/product-iot-gateway.
8 Oracle Help Center. Oracle 11g Database new Features [Internet]. Available: https://docs.oracle.com/cd/B28359_01/server.111/b28279/chapter1.htm#NEWFTCH1.