Implementation and Experiment for Search Performance Analysis of SQLite Mobile Database

The Journal of the Korean Institute of Information and Communication Engineering Pub Date : 2017-02-28 DOI:10.6109/JKIICE.2017.21.2.333

Jin-Oh Choi

{"title":"Implementation and Experiment for Search Performance Analysis of SQLite Mobile Database","authors":"Jin-Oh Choi","doi":"10.6109/JKIICE.2017.21.2.333","DOIUrl":null,"url":null,"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, 모바일 데이터베이스, 성능 테스트, 리눅스 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","PeriodicalId":136663,"journal":{"name":"The Journal of the Korean Institute of Information and Communication Engineering","volume":null,"pages":null},"PeriodicalIF":0.0000,"publicationDate":"2017-02-28","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"The Journal of the Korean Institute of Information and Communication Engineering","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.6109/JKIICE.2017.21.2.333","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 0

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, 모바일 데이터베이스, 성능 테스트, 리눅스 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

查看原文本刊更多论文

SQLite移动数据库搜索性能分析的实现与实验

近年来，由于移动设备的普遍化趋势，出现了许多需要移动数据库的新型移动应用。SQLite、Realm等是具有代表性的移动数据库，它们是适用于资源限制较大的小型设备的数据库引擎，在基于Linux的移动设备中使用较多。这些引擎都是开源程序，比通用数据库具有重量更轻、速度更快的优点。本文重点对移动数据库领域的领先者SQLite进行了性能实验和分析。考虑到目标移动环境，测试在Linux环境下进行。并实现了性能测试程序，对SQLite数据库进行了性能实验来测试搜索效率。并将实验结果与同一环境下运行的Oracle数据库进行了比较。키워드:SQLite,모바일데이터베이스,성능테스트,리눅스关键字:SQLite,移动数据库,性能测试,Linux获得08年2016年12月,09年修订2016年12月,接受12月17日2016 *通讯作者Jin-Oh崔(电子邮件:jochoi@bufs.ac.kr, Tel: + 82-51-509-6245)嵌入式软件、釜山外国语大学609 - 815年釜山,朝鲜开放访问http://doi.org/10.6109/jkiice.2017.21.2.333打印ISSN: 2234 - 4772在线ISSN:2288-4165这是一篇在知识共享署名非商业许可(http://creativecommons.org/li-censes/ by-nc/3.0/)的条款下发布的开放获取文章，该许可允许在任何媒介上不受限制的非商业使用、分发和复制，前提是正确引用原始作品。版权所有C韩国信息通信工程研究院。韩国信息通信工程学院学报[J]。韩国国际研究所。Eng)。第21卷第2期:333~338 2017年2月

本文章由计算机程序翻译，如有差异，请以英文原文为准。

求助全文

约1分钟内获得全文求助全文

来源期刊

The Journal of the Korean Institute of Information and Communication Engineering

自引率

0.00%

发文量