Implementation and Experiment for Search Performance Analysis of SQLite Mobile Database

Recently, because of the mobile device generalization tendency, a lot of new mobile applications which need mobile database on mobile devices appear. SQLite, Realm, etc. are representative mobile databases, and they are the database engines which are suitable for small devices that have large resource restriction and are used a lot in mobile devices based on Linux. These engines are open source programs and have advantages which are lighter weight and faster speed than general purpose databases. This paper focuses on the performance experiments and analysis of SQLite, which is front runner in mobile database fields. Considering the target mobile environments, the test is performed at Linux environment. And this paper implements performance test program and performs performance experiment of SQLite database to test search efficiency. The experiment is processed by comparison with the results of a Oracle database working out at the same environment. 키워드 : SQLite, 모바일 데이터베이스, 성능 테스트, 리눅스 Key word : SQLite, Mobile Database, Performance Test, Linux Received 08 December 2016, Revised 09 December 2016, Accepted 17 December 2016 * Corresponding Author Jin-Oh Choi(E-mail:jochoi@bufs.ac.kr, Tel:+82-51-509-6245) Department of Embedded Software, Busan University of Foreign Studies, Busan 609-815, Korea Open Access http://doi.org/10.6109/jkiice.2017.21.2.333 print ISSN: 2234-4772 online ISSN: 2288-4165 This is an Open Access article distributed under the terms of the Creative Commons Attribution Non-Commercial License(http://creativecommons.org/li-censes/ by-nc/3.0/) which permits unrestricted non-commercial use, distribution, and reproduction in any medium, provided the original work is properly cited. Copyright C The Korea Institute of Information and Communication Engineering. Journal of the Korea Institute of Information and Communication Engineering 한국정보통신학회논문지(J. Korea Inst. Inf. Commun. Eng.) Vol. 21, No. 2 : 333~338 Feb. 2017