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

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

DOI QR Code

Comparison of Search Performance of SQLite3 Database by Linux File Systems

Linux File Systems에 따른 SQLite3 데이터베이스의 검색 성능 비교

  • Choi, Jin-Oh (Division of Software, Busan University of Foreign Studies)
  • Received : 2021.10.13
  • Accepted : 2021.10.31
  • Published : 2022.01.31
Download PDF
⟨ Previous Next ⟩

Abstract

Recently, IoT sensors are often used to produce stream data locally and they are provided for edge computing applications. Mass-produced data are stored in the mobile device's database for real-time processing and then synchronized with the server when needed. Many mobile databases are developed to support those applications. They are CloudScape, DB2 Everyplace, ASA, PointBase Mobile, etc, and the most widely used database is SQLite3 on Linux. In this paper, we focused on the performance required for synchronization with the server. The search performance required to retrieve SQLite3 was compared and analyzed according to the type of each Linux file system in which the database is stored. Thus, performance differences were checked for each file system according to various search query types, and criteria for applying the more appropriate Linux file system according to the index use environment and table scan environment were prepared and presented.

최근 IoT 센서를 이용하여 데이터를 로컬에서 생산하고 스트림으로 제공하는 엣지 컴퓨팅(Edge Computing) 응용 분야가 넓어지고 있다. 대량으로 생산된 데이터는 실시간 처리를 위해 모바일 장치의 데이터베이스에 저장했다가 필요한 시점에 서버와 동기화된다. 이러한 응용 분야를 지원하기 위한 다양한 모바일 데이터베이스가 개발되었다. CloudScape, DB2 Everyplace, ASA, PointBase Mobile 등이며 그중 가장 널리 사용되는 대표적 모바일 데이터베이스는 리눅스 기반 SQLite3이다. 이 논문에서는 서버와 동기화 시 필요한 성능에 초점을 맞추었다. SQLite3의 정보 선택 시 필요한 검색 성능을 데이터베이스가 저장된 각 리눅스 파일 시스템의 종류에 따라 비교 분석하였다. 그래서 다양한 검색 쿼리 유형에 따라 파일 시스템별로 성능 차이를 확인하고 인덱스 사용 환경과 테이블 스캔 환경에 따라 더 적합한 리눅스 파일 시스템을 적용하는 기준을 마련하고 제시하였다.

Keywords

Acknowledgement

This work was supported by the research grant of the Busan University of Foreign Studies in 2021.

References

  1. N. Abbas, Y. Zang, A. Taherkordi, and T. Skeie, "Mobile Edge Computing: A Survey," Journal of IEEE Internet of Things, vol. 5, no. 1, pp. 450-465, 2018. https://doi.org/10.1109/JIOT.2017.2750180
  2. S. Wang, Y. Zhao, J. Xu, J. Yuan, and C. Hsu, "Edge Server Placement in Mobile Edge Computing," Journal of Parallel and Distributed Computing, vol. 127, pp. 160-168, 2019. https://doi.org/10.1016/j.jpdc.2018.06.008
  3. What is Hybrid Cloud? [Internet]. Available: https://www.netapp.com/ko/hybrid-cloud/what-is-hybrid-cloud/.
  4. J. Choi, "Comparison of Update Performance by File System of Mobile Database SQLite3," Journal of The Korea Institute of Information and Communication Engineering, vol. 24, no. 9, pp. 1117-1122, Sep. 2020. https://doi.org/10.6109/JKIICE.2020.24.9.1117
  5. Android Databases Performance Tests-CRUD [Internet]. Available: https://proandroiddev.com/android-databasesperformance-crud-a963dd7bb0eb.
  6. SQLite. Architecture of SQLite [Internet]. Available: http://www.sqlite.org/arch.html.
  7. The XFS File System [Internet]. Available: https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/7/html/storage_administration_guide/ch-XFS.
  8. An introduction to Linux's EXT4 filesystem [Internet]. Available: https://opensource.com/article/17/5/introductionExt4-filesystem.
  9. A. Naohiro and K. Kenji, "File Systems are Hard to Test -Learning from Xfstests," IEICE Transactions on Information ans Systems, vol. 102, no. 2, pp. 269-279, 2019.
  10. Ext4 Disk Layout [Internet]. Available: https://Ext4.wiki.kernel.org/index.php/Ext4_Disk_Layout.