[1]王龙翔,魏晓林,陈跃辉,等.面向 SQLite 的TPC-E 基准测试系统的设计与实现[J].计算机技术与发展,2018,28(08):38-42.[doi:10.3969/ j. issn.1673-629X.2018.08.008]
　WANG Long-xiang,WEI Xiao-lin,CHEN Yue-hui,et al.Design and Implementation of TPC-E Benchmark System for SQLite[J].,2018,28(08):38-42.[doi:10.3969/ j. issn.1673-629X.2018.08.008]
点击复制

面向 SQLite 的TPC-E 基准测试系统的设计与实现()
分享到：

《计算机技术与发展》[ISSN:1006-6977/CN:61-1281/TN]

卷:
28
期数:
2018年08期
页码:
38-42
栏目:
智能、算法、系统工程
出版日期:
2018-08-10

文章信息/Info

Title:
Design and Implementation of TPC-E Benchmark System for SQLite
文章编号:
1673-629X(2018)08-0038-05
作者:
王龙翔; 魏晓林; 陈跃辉; 刘 成; 董小社
西安交通大学 电子与信息工程学院,陕西 西安 710049
Author(s):
WANG Long-xiang; WEI Xiao-lin; CHEN Yue-hui; LIU Cheng; DONG Xiao-she
School of Electronics and Information Engineering,Xi’an Jiaotong University,Xi’an 710049,China
关键词:
SQLite; TPC-E; 基准测试; 数据库系统
Keywords:
SQLite; TPC-E; benchmark; database system
分类号:
TP392
DOI:
10.3969/ j. issn.1673-629X.2018.08.008
文献标志码:
A
摘要:
TPC-E 是 TPC(transaction processing performance council,事务处理性能委员会)组织发布的新一代数据库性能评测标准,用于取代日渐老化的 TPC-C 标准。 SQLite 是目前被广泛使用的一种嵌入式数据库,研究在 TPC-E 标准下的SQLite 具体性能表现对实际应用具有重要参考意义。 然而,目前业界缺少面向 SQLite 的 TPC-E 实现。 为了解决该问题,设计和实现了面向嵌入式轻量级数据库 SQLite 的 TPC-E 基准测试系统,它不仅可以为 SQLite 数据库提供准确高效的性能评测系统,而且对 SQLite 在市场上的扩展应用和开发具有重要的参考价值。 该测试系统严格遵循 TPC 组织最新发布的OLTP 性能评测基准 TPC-E,不仅能对 SQLite 作为内存数据库与文件数据库时的数据库特性进行精确有效的性能评测,还能客观真实地获得 SQLite 数据库的性能评测数据。 实验结果表明,在 TPC-E 负载下,与 Oracle 等重量级的关系型数据库相比,SQLite 事务处理性能较低。 但由于其简单易用和体积小等优势,SQLite 在实时性高的行业小型智能设备方面的应用依然具有较大的优势。 同时通过对实验结果的分析,指出了制约 SQLite 性能的主要原因。
Abstract:
Design and Implementation of TPC-E Benchmark System for SQLite WANG Long-xiang,WEI Xiao-lin,CHEN Yue-hui,LIU Cheng,DONG Xiao-she (School of Electronics and Information Engineering,Xi’an Jiaotong University,Xi’an 710049,China) Abstract:TPC-E,which is published by TPC (transaction processing performance council),is the new generation of database performance evaluation standard to replace the aging TPC-C standard. SQLite is currently widely used as an embedded database in a lot of practical applications. Consequently,research on the specific performance of SQLite under TPC-E is of great reference to practical applications. However,the community lacks the TPC-E standard implementation for SQLite currently. To solve this problem,we design and implement a TPC-E benchmark for the embedded lightweight database—SQLite. It can not only provide an accurate and efficient performance evaluation,but also is of great reference value to the extended application and development of the SQLite database in the commercial market. This benchmark system strictly follows the TPC-E standard which is the newest testing benchmark of OLTP. It can evaluate the performance of the database features of SQLite as an in-memory database and a file database accurately and effectively,and can get the evaluation result in an objective way. Experiment shows that in the TPC-E standard the transaction processing performance of SQLite pales in comparison with heavyweight relational database such as Oracle. However,SQLite still has a greater advantage in the real-time industry,such as small-scale application in small intelligent devices due to their features of easy-using and small size. Besides,through the analysis of the experiment,we point out the main reasons that restrict the performance of SQLite.

相似文献/References:

[1]姜默涵 陈榕 黄玉坤.Elastos智能手机动态多UI电话簿排序的实现[J].计算机技术与发展,2008,(01):196.
　JIANG Mo-han,CHEN Rong,HUANG Yu-kun.Implementation of Dynamic UI Phone Book Sorting on Elastos Smart Phone[J].,2008,(08):196.
[2]汪俊峰,王星东,郑传海.智能社区三维展示系统的设计与实现[J].计算机技术与发展,2018,28(09):156.[doi:10.3969/ j. issn.1673-629X.2018.09.032]
　WANG Jun-feng,WANG Xing-dong,ZHENG Chuan-hai.Design and Implementation of 3D Demonstration Display System of Intelligent Community[J].,2018,28(08):156.[doi:10.3969/ j. issn.1673-629X.2018.09.032]
[3]张亚娟,韩银雪,刘效洋.基于 AES 算法的账号密码管理 APP[J].计算机技术与发展,2019,29(08):125.[doi:10. 3969 / j. issn. 1673-629X. 2019. 08. 024]
　ZHANG Ya-juan,HAN Yin-xue,LIU Xiao-yang.Account Password APP Based on AES Algorithm[J].,2019,29(08):125.[doi:10. 3969 / j. issn. 1673-629X. 2019. 08. 024]
[4]迪力夏提·多力昆,张太红,冯向萍.LabelMe 标注核对系统的设计与实现[J].计算机技术与发展,2022,32(03):214.[doi:10. 3969 / j. issn. 1673-629X. 2022. 03. 036]
　Duolikun DILIXIATI,ZHANG Tai-hong,FENG Xiang-ping.Design and Implementation of LabelMe Label Checking System[J].,2022,32(08):214.[doi:10. 3969 / j. issn. 1673-629X. 2022. 03. 036]

更新日期/Last Update: 2018-10-16