title: Ð¡ÑÐ°Ð²Ð½Ð¸ÑÐµÐ»ÑÐ½ÑÐ¹ Ð°Ð½Ð°Ð»Ð¸Ð· Ð¼ÐµÑÐ¾Ð´Ð¾Ð² ÑÐ¶Ð°ÑÐ¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð¸ Ð¸Ñ Ð²Ð»Ð¸ÑÐ½Ð¸Ñ Ð½Ð° Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´Ð¸ÑÐµÐ»ÑÐ½Ð¾ÑÑÑ Ð¡Ð£ÐÐ PostgreSQL
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¼Ð°Ð³Ð¸ÑÑÑÐ°
titleType: Subtitle
title: Comparative analysis of data compression methods and their impact on the performance of PostgreSQL DBMS
Creators: name: Ð¥Ð°Ð¼Ð¼Ð°ÑÐ¾Ð²Ð°, ÐÑÐ¸Ð·Ð°
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2024
Subjects: Ð±Ð°Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ
ÑÐ¸ÑÑÐµÐ¼Ð° ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð±Ð°Ð·Ð°Ð¼Ð¸ Ð´Ð°Ð½Ð½ÑÑ
Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼Ñ ÑÐ¶Ð°ÑÐ¸Ñ Ð´Ð°Ð½Ð½ÑÑ
database
database management system
data compression algorithms

description: ÐÐ°Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¿Ð¾ÑÐ²ÑÑÐµÐ½Ð° Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼Ð¾Ð² ÑÐ¶Ð°ÑÐ¸Ñ, Ð²ÑÑÑÐ¾ÐµÐ½Ð½ÑÑ Ð² Ð¡Ð£ÐÐ PostgreSQL, Ð°Ð½Ð°Ð»Ð¸Ð·Ñ Ð¿Ð¾Ð»ÑÑÐµÐ½Ð½ÑÑ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð². Ð¦ÐµÐ»ÑÑ ÑÐ°Ð±Ð¾ÑÑ ÑÐ²Ð»ÑÐµÑÑÑ Ð²ÑÑÐ²Ð»ÐµÐ½Ð¸Ðµ Ð·Ð°Ð²Ð¸ÑÐ¸Ð¼Ð¾ÑÑÐ¸ ÑÑÐµÐ¿ÐµÐ½Ð¸ ÑÐ¶Ð°ÑÐ¸Ñ, Ð²ÑÐµÐ¼ÐµÐ½Ð¸ ÑÑÐµÐ½Ð¸Ñ Ð¸ Ð·Ð°Ð¿Ð¸ÑÐ¸ Ð´Ð°Ð½Ð½ÑÑ Ð¾Ñ ÑÐ»ÐµÐ´ÑÑÑÐ¸Ñ Ð¿Ð°ÑÐ°Ð¼ÐµÑÑÐ¾Ð²: Ð²ÑÐ±ÑÐ°Ð½Ð½Ð¾Ð³Ð¾ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼Ð°, ÑÐ¾Ð´ÐµÑÐ¶Ð°Ð½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð¸ Ð¾Ð±ÑÐµÐ¼Ð° Ð´Ð°Ð½Ð½ÑÑ. ÐÐ»Ñ Ð´Ð¾ÑÑÐ¸Ð¶ÐµÐ½Ð¸Ñ Ð¿Ð¾ÑÑÐ°Ð²Ð»ÐµÐ½Ð½Ð¾Ð¹ ÑÐµÐ»Ð¸ Ð² ÑÐ°Ð±Ð¾ÑÐµ ÑÐµÑÐ°ÑÑÑÑ ÑÐ»ÐµÐ´ÑÑÑÐ¸Ðµ Ð·Ð°Ð´Ð°ÑÐ¸: 1. Ð¸Ð·ÑÑÐµÐ½Ð¸Ðµ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼Ð¾Ð² ÑÐ¶Ð°ÑÐ¸Ñ, Ð²ÑÑÑÐ¾ÐµÐ½Ð½ÑÑ Ð² Ð¡Ð£ÐÐ PostgreSQL; 2. Ð²ÑÐ±Ð¾Ñ Ð¸Ð½ÑÑÑÑÐ¼ÐµÐ½ÑÐ° Ñ Ð³ÑÐ°ÑÐ¸ÑÐµÑÐºÐ¸Ð¼ Ð¸Ð½ÑÐµÑÑÐµÐ¹ÑÐ¾Ð¼ Ð´Ð»Ñ Ð²Ð¸Ð·ÑÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð² Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð²; 3. Ð¾ÑÐµÐ½ÐºÐ° ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼Ð¾Ð² Ñ ÑÐ¾ÑÐºÐ¸ Ð·ÑÐµÐ½Ð¸Ñ ÑÐ¾Ð¾ÑÐ½Ð¾ÑÐµÐ½Ð¸Ñ ÑÐ¶Ð°ÑÐ¸Ñ, ÑÐºÐ¾ÑÐ¾ÑÑÐ¸ ÑÐ¶Ð°ÑÐ¸Ñ Ð¸ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´Ð¸ÑÐµÐ»ÑÐ½Ð¾ÑÑÐ¸ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð²; 4. ÑÑÐ°Ð²Ð½ÐµÐ½Ð¸Ðµ Ð¸ Ð°Ð½Ð°Ð»Ð¸Ð· Ð¿Ð¾Ð»ÑÑÐµÐ½Ð½ÑÑ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð². Ð Ð°Ð±Ð¾ÑÐ° ÑÐ¾ÑÑÐ¾Ð¸Ñ Ð¸Ð· ÑÑÐµÑ Ð³Ð»Ð°Ð². ÐÐµÑÐ²Ð°Ñ Ð³Ð»Ð°Ð²Ð° ÑÐ¾Ð´ÐµÑÐ¶Ð¸Ñ Ð¾Ð±Ð·Ð¾Ñ ÑÑÑÑÐºÑÑÑÑ ÑÑÐ°Ð½ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð¸ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼Ð¾Ð² ÑÐ¶Ð°ÑÐ¸Ñ Ð¡Ð£ÐÐ PostgeSQL. ÐÐ¾ Ð²ÑÐ¾ÑÐ¾Ð¹ Ð³Ð»Ð°Ð²Ðµ ÑÐ¾Ð´ÐµÑÐ¶Ð¸ÑÑÑ Ð¾Ð±Ð·Ð¾Ñ Ð¸ Ð²ÑÐ±Ð¾Ñ Ð½ÐµÐ¾Ð±ÑÐ¾Ð´Ð¸Ð¼Ð¾Ð³Ð¾ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð³Ð¾ Ð¾Ð±ÐµÑÐ¿ÐµÑÐµÐ½Ð¸Ñ, Ð¾Ð¿Ð¸ÑÐ°Ð½Ð¸Ðµ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·ÑÐµÐ¼ÑÑ Ð½Ð°Ð±Ð¾ÑÐ¾Ð² Ð´Ð°Ð½Ð½ÑÑ Ð´Ð»Ñ ÑÐµÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼Ð¾Ð² ÑÐ¶Ð°ÑÐ¸Ñ. Ð ÑÑÐµÑÑÐµÐ¹ Ð³Ð»Ð°Ð²Ðµ ÑÐ¾Ð´ÐµÑÐ¶Ð¸ÑÑÑ Ð¾Ð¿Ð¸ÑÐ°Ð½Ð¸Ðµ Ð¿ÑÐ¾Ð²ÐµÐ´ÐµÐ½Ð¸Ñ ÑÐºÑÐ¿ÐµÑÐ¸Ð¼ÐµÐ½ÑÐ¾Ð², Ð°Ð½Ð°Ð»Ð¸Ð· ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð². ÐÐ»Ñ Ð¿ÑÐ¾Ð²ÐµÐ´ÐµÐ½Ð¸Ñ ÑÐºÑÐ¿ÐµÑÐ¸Ð¼ÐµÐ½ÑÐ¾Ð² Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð»Ð°ÑÑ Ð¿ÑÐµÐ´Ð¾ÑÑÐ°Ð²Ð»ÐµÐ½Ð½Ð°Ñ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸ÐµÐ¹-ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÑÐ¸ÐºÐ¾Ð¼ Ð¡Ð£ÐÐ Postgres Pro Enterprise Ð¸ Ð¾Ð±Ð»Ð°ÑÐ½ÑÐµ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ.
description: This work is devoted to the study of compression algorithms embedded in the PostgreSQL DBMS, the analysis of the results. The purpose of the work is to identify the dependence of the compression ratio, the time of reading and writing data on the following parameters: the selected algorithm, the data content and the amount of data. To achieve this goal, the following tasks are solved in the work: 1. study of compression algorithms embedded in the PostgreSQL DBMS; 2. Selection of graphical tools for visualization of query results; 3. Evaluation of the effectiveness of algorithms in terms of compression ratio, compression speed and query performance; 4. comparison and analysis of the results obtained. The work consists of three chapters. The first chapter provides an overview of the data storage structure and compression algorithms of the PostgeSQL DBMS. The second chapter contains an overview and selection of the necessary software, a description of the datasets used to test compression algorithms. The third chapter contains a description of the experiments and an analysis of the results. For the possibility of conducting experiments, the Postgres Pro Enterprise DBMS and cloud databases were provided.