V. A. Egunov, V. S. Surin, P. S. Stupnitskiy, R. D. Akhmetova
{"title":"关系型数据库管理系统和 NoSQL 数据库管理系统中数据压缩方法的有效性研究","authors":"V. A. Egunov, V. S. Surin, P. S. Stupnitskiy, R. D. Akhmetova","doi":"10.21822/2073-6185-2024-51-1-87-94","DOIUrl":null,"url":null,"abstract":"Objective. The research presented in the paper is aimed at studying the effectiveness of modern DBMSs.Method. Along with traditional relational solutions, NoSQL-based DBMSs are becoming increasingly popular. This is primarily due to the ability of such systems to store and process huge volumes of data. At the same time, to work effectively with this data, it is necessary to ensure its compression. Compression allows you to reduce the amount of stored data and provide quick access to it.Result. A comparative analysis of data compression in the MySQL and OpenSe DBMS was performed.Conclusion. Data compression in OpenSearch is more efficient than in MySQL when using standard algorithms. OpenSearch is an excellent choice if youneed to conserve storage resources while making optimal use of the processor, otherwise both systems will do the job well.","PeriodicalId":202454,"journal":{"name":"Herald of Dagestan State Technical University. Technical Sciences","volume":"106 5","pages":""},"PeriodicalIF":0.0000,"publicationDate":"2024-04-16","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Research on the effectiveness of data compression methods in relational and NoSQL DBMS\",\"authors\":\"V. A. Egunov, V. S. Surin, P. S. Stupnitskiy, R. D. Akhmetova\",\"doi\":\"10.21822/2073-6185-2024-51-1-87-94\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Objective. The research presented in the paper is aimed at studying the effectiveness of modern DBMSs.Method. Along with traditional relational solutions, NoSQL-based DBMSs are becoming increasingly popular. This is primarily due to the ability of such systems to store and process huge volumes of data. At the same time, to work effectively with this data, it is necessary to ensure its compression. Compression allows you to reduce the amount of stored data and provide quick access to it.Result. A comparative analysis of data compression in the MySQL and OpenSe DBMS was performed.Conclusion. Data compression in OpenSearch is more efficient than in MySQL when using standard algorithms. OpenSearch is an excellent choice if youneed to conserve storage resources while making optimal use of the processor, otherwise both systems will do the job well.\",\"PeriodicalId\":202454,\"journal\":{\"name\":\"Herald of Dagestan State Technical University. Technical Sciences\",\"volume\":\"106 5\",\"pages\":\"\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2024-04-16\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Herald of Dagestan State Technical University. Technical Sciences\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.21822/2073-6185-2024-51-1-87-94\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Herald of Dagestan State Technical University. Technical Sciences","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.21822/2073-6185-2024-51-1-87-94","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0
摘要
目标。本文介绍的研究旨在研究现代 DBMS 的有效性。除了传统的关系型解决方案,基于 NoSQL 的 DBMS 也越来越受欢迎。这主要是因为此类系统能够存储和处理海量数据。同时,为了有效地处理这些数据,有必要确保对其进行压缩。压缩可以减少存储的数据量,并提供快速访问。对 MySQL 和 OpenSe DBMS 中的数据压缩进行了比较分析。当使用标准算法时,OpenSearch 的数据压缩比 MySQL 更有效。如果需要在充分利用处理器的同时节省存储资源,OpenSearch 是一个很好的选择,否则这两个系统都能很好地完成工作。
Research on the effectiveness of data compression methods in relational and NoSQL DBMS
Objective. The research presented in the paper is aimed at studying the effectiveness of modern DBMSs.Method. Along with traditional relational solutions, NoSQL-based DBMSs are becoming increasingly popular. This is primarily due to the ability of such systems to store and process huge volumes of data. At the same time, to work effectively with this data, it is necessary to ensure its compression. Compression allows you to reduce the amount of stored data and provide quick access to it.Result. A comparative analysis of data compression in the MySQL and OpenSe DBMS was performed.Conclusion. Data compression in OpenSearch is more efficient than in MySQL when using standard algorithms. OpenSearch is an excellent choice if youneed to conserve storage resources while making optimal use of the processor, otherwise both systems will do the job well.