使用Python的嵌入式数据库在单板计算机系统上的性能比较分析

2022 IEEE 17th International Conference on Computer Sciences and Information Technologies (CSIT) Pub Date : 2022-11-10 DOI:10.1109/CSIT56902.2022.10000475

M. Slabinoha, S. Melnychuk, I. Manuliak, Bohdan Pashkovskyi

{"title":"使用Python的嵌入式数据库在单板计算机系统上的性能比较分析","authors":"M. Slabinoha, S. Melnychuk, I. Manuliak, Bohdan Pashkovskyi","doi":"10.1109/CSIT56902.2022.10000475","DOIUrl":null,"url":null,"abstract":"The article deals with comparative analysis of SQL and NoSQL embedded databases performance on single-board computer systems, such as SQLite, LMDB and UnQLite. The aim of the article is to perform comparative testing of CRUD operations performance through database connection software implemented using Python, on single-board computer systems that need to store data in local storage without continuous running of database server process in system tray. The analysis of the related publications was done and the aim of work was set. The hardware and software was chosen to hold the experiment. The experiment details were described. The results were obtained, highlighting strong and weak features of SQL and NoSQL databases as well as key-value stores. Received results can be used when designing Python software for single-board computers with ability to store large amount of data in device local memory.","PeriodicalId":282561,"journal":{"name":"2022 IEEE 17th International Conference on Computer Sciences and Information Technologies (CSIT)","volume":"53 3 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2022-11-10","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Comparative analysis of embedded databases performance on single board computer systems using Python\",\"authors\":\"M. Slabinoha, S. Melnychuk, I. Manuliak, Bohdan Pashkovskyi\",\"doi\":\"10.1109/CSIT56902.2022.10000475\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"The article deals with comparative analysis of SQL and NoSQL embedded databases performance on single-board computer systems, such as SQLite, LMDB and UnQLite. The aim of the article is to perform comparative testing of CRUD operations performance through database connection software implemented using Python, on single-board computer systems that need to store data in local storage without continuous running of database server process in system tray. The analysis of the related publications was done and the aim of work was set. The hardware and software was chosen to hold the experiment. The experiment details were described. The results were obtained, highlighting strong and weak features of SQL and NoSQL databases as well as key-value stores. Received results can be used when designing Python software for single-board computers with ability to store large amount of data in device local memory.\",\"PeriodicalId\":282561,\"journal\":{\"name\":\"2022 IEEE 17th International Conference on Computer Sciences and Information Technologies (CSIT)\",\"volume\":\"53 3 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2022-11-10\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2022 IEEE 17th International Conference on Computer Sciences and Information Technologies (CSIT)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/CSIT56902.2022.10000475\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2022 IEEE 17th International Conference on Computer Sciences and Information Technologies (CSIT)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/CSIT56902.2022.10000475","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 0

摘要

本文对SQL和NoSQL嵌入式数据库在SQLite、LMDB和UnQLite等单板计算机系统上的性能进行了比较分析。本文的目的是通过使用Python实现的数据库连接软件，在需要将数据存储在本地存储器中而不需要在系统托盘中连续运行数据库服务器进程的单板计算机系统上，对CRUD操作性能进行比较测试。对相关文献进行了分析，确定了工作目标。选择进行实验的硬件和软件。描述了实验的细节。得到的结果突出了SQL和NoSQL数据库以及键值存储的优缺点。接收到的结果可以在为能够在设备本地内存中存储大量数据的单板计算机设计Python软件时使用。

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

查看原文本刊更多论文

Comparative analysis of embedded databases performance on single board computer systems using Python

The article deals with comparative analysis of SQL and NoSQL embedded databases performance on single-board computer systems, such as SQLite, LMDB and UnQLite. The aim of the article is to perform comparative testing of CRUD operations performance through database connection software implemented using Python, on single-board computer systems that need to store data in local storage without continuous running of database server process in system tray. The analysis of the related publications was done and the aim of work was set. The hardware and software was chosen to hold the experiment. The experiment details were described. The results were obtained, highlighting strong and weak features of SQL and NoSQL databases as well as key-value stores. Received results can be used when designing Python software for single-board computers with ability to store large amount of data in device local memory.

求助全文

通过发布文献求助，成功后即可免费获取论文全文。去求助

来源期刊

2022 IEEE 17th International Conference on Computer Sciences and Information Technologies (CSIT)

自引率

0.00%

发文量