Journal of the Korea Institute of Information and Communication Engineering (한국정보통신학회논문지)

The Korea Institute of Information and Commucation Engineering (한국정보통신학회)
권호 표지
DOI QR코드

DOI QR Code

Implementation and Experiment for Search Performance Analysis of SQLite Mobile Database

SQLite 모바일 데이터베이스의 검색 성능 분석을 위한 구현 및 실험

  • Choi, Jin-oh (Department of Embedded Software, Busan University of Foreign Studies)
  • Received : 2016.12.08
  • Accepted : 2016.12.17
  • Published : 2017.02.28
Download PDF
⟨ Previous Next ⟩

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.

최근 모바일 기기의 보편화로 인하여 모바일 데이터베이스를 필요로 하는 많은 새로운 모바일 응용들이 나타나고 있다. 대표적인 모바일 데이터베이스로는 SQLite, Realm 등이 있는데, 이들은 리소스 제약이 큰 소형기기에 적합한 데이터베이스 엔진들이며 리눅스 기반 모바일 기기에 많이 사용되고 있다. 이 엔진들은 대부분 오픈소스 프로그램들이며 범용 데이터베이스에 비해 가볍고 속도가 빠른 장점을 지닌다. 이 논문에서는 모바일 데이터베이스의 선두 주자인 SQLite의 성능 실험과 분석에 초점을 맞춘다. 대상인 모바일 환경을 고려하여 리눅스 기반 환경에서 실험한다. 그리고, SQLite 데이터베이스의 검색 성능을 파악하기 위한 테스트 프로그램을 구현하고 성능 실험을 실시한다. 실험은 같은 환경에서 실행되는 Oracle 데이터베이스와 비교하여 진행한다.

Keywords

References

  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/.