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

Implementation and Experiment for Search Performance Analysis of SQLite Mobile Database  

Choi, Jin-oh (Department of Embedded Software, Busan University of Foreign Studies)
Publication Information
Journal of the Korea Institute of Information and Communication Engineering / v.21, no.2, 2017 , pp. 333-338 More about this Journal
Abstract
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.
Keywords
SQLite; Mobile Database; Performance Test; Linux;
Citations & Related Records
연도 인용수 순위
  • Reference
1 S. Kim, J. Lee, M. Sin, S. Kim and Y. Kim, "Development of music & AV Server with Raspberry PI," in Proceedings of KSMTE, pp. 117-117, 2015.
2 M. Beck, M. Wemer and S. Feld, "Mobile Edge Computing: A Taxonomy," in Proceedings of 6th Conference on Advances in Future Internet, pp. 48-54, 2014.
3 A. Sripriya and R. Dhanapal, "Mobile software solutions using mobile database design methodology," in Proceedings of International Conference on ICCCNT(IEEE), pp. 1-5, 2010.
4 Architecture of SQLite [Internet]. Available: http://www.sqlite.org/arch.html.
5 D. Tuan, S. Cheon and Y. Won, "On the IO characteristics of the SQLite transactions," in Proceedings of the International Conference on Mobile Software Engineering and Systems, Austin Texas, pp. 214-224, 2016.
6 H. Ouarnoughi, J. Boukhobza, P. Olivier, L. Plassart and L. BellatrecheOu, "Performance analysis and modeling of SQLite embedded databases on flash file systems," in Design Automation for Embedded Systems, Springer, Vol. 17, No. 3-4, pp. 507-542, Oct. 2014.
7 Realm Mobile Database [Internet]. Available: http://realm.io/docs/#getting-started.
8 Android Working with Realm Database - Replacing SQLite & Core Data [Internet]. Available: http://www.androidhive.info/2016/05/android-working-with-realm-database-replacing-sqlite-core-data/.
9 Parse Server Guide [Internet]. Available: http://parseplatform.github.io/docs/parse-server/guide/.
10 Apache CouchDB 2.0 Documentation [Internet]. Available: http://couchdb.apache.org/en/2.0.0/.