Research on the effectiveness of data compression methods in relational and NoSQL DBMS

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.

Keywords

• database management systems
• dbms
• relational dbms
• nosql
• data compression
• zlib.
• lz4
• deflate