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

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

DOI QR Code

Modification Performance Comparison of SQLite3 Mobile Databases

SQLite3 모바일 데이터베이스의 갱신 성능 비교

  • Choi, Jin-oh (School of Embedded IT, Busan University of Foreign Studies)
  • Received : 2018.08.15
  • Accepted : 2018.09.12
  • Published : 2018.12.31
Download PDF
⟨ Previous Next ⟩

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.

최근 모바일 디바이스의 가장 주목받는 변화는 계산 성능의 획기적인 향상, 저장 용량의 대폭적인 증가, 인터넷의 상시 연결, 그리고 디스플레이 기술의 정교한 발전으로 꼽을 수 있다. 이에 따라, 모바일 디바이스를 활용한 데이터베이스 응용이 새롭게 등장하고 있다. 이러한 응용에는 모바일 서버용 데이터베이스, 에지 컴퓨팅을 위한 데이터베이스, 포그 컴퓨팅 등이 있다. 따라서 현재 출시된 모바일 데이터베이스에 주목하고 그러한 응용들에 적합한 성능을 가지고 있는지 주목하는 것이 중요하다. 이 논문에서는 대표적이고 우수한 모바일 데이터베이스인 SQLite3를 선택하여 갱신 성능 및 특성을 테스트하기 위한 실험을 실시한다. 실험 결과를 평가하기 위하여 동일한 환경에서 Oracle 데이터베이스의 결과와 비교하였다. 실험 결과 SQLite3의 Insert 성능은 개선 여지가 많았으며, Update 성능은 아주 우수한 것으로 밝혀졌다. 특히 Range Query에 우수한 성능을 보였다.

Keywords

HOJBC0_2018_v22n12_1571_f0001.png 이미지

Fig. 1 Performance of Insert Query

HOJBC0_2018_v22n12_1571_f0002.png 이미지

Fig. 2 Performance of Update Query: Point

HOJBC0_2018_v22n12_1571_f0003.png 이미지

Fig. 3 Performance of Update Query: Point, No-Index

HOJBC0_2018_v22n12_1571_f0004.png 이미지

Fig. 4 Performance of Update Query: Point, With-Index

HOJBC0_2018_v22n12_1571_f0005.png 이미지

Fig. 5 Performance of Update Query: Range

HOJBC0_2018_v22n12_1571_f0006.png 이미지

Fig. 6 Performance of Update Query: Range, No-Index

HOJBC0_2018_v22n12_1571_f0007.png 이미지

Fig. 7 Performance of Update Query: Range, With-Index

HOJBC0_2018_v22n12_1571_f0008.png 이미지

Fig. 8 Performance of Delete Query: Point

HOJBC0_2018_v22n12_1571_f0009.png 이미지

Fig. 9 Performance of Delete Query: Point, No-Index

HOJBC0_2018_v22n12_1571_f0010.png 이미지

Fig. 10 Performance of Delete Query: Point, With-Index

HOJBC0_2018_v22n12_1571_f0011.png 이미지

Fig. 11 Performance of Delete Query: Range

References

  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. https://doi.org/10.6109/JKIICE.2017.21.2.333
  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. https://doi.org/10.13067/JKIECS.2017.12.2.385
  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.

Cited by

  1. 모바일 데이터베이스 SQLite3의 File System별 갱신 성능 비교 vol.24, pp.9, 2020, https://doi.org/10.6109/jkiice.2020.24.9.1117