title: Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¸ Ð°Ð½Ð°Ð»Ð¸Ð· ÑÐ¸ÑÑÐµÐ¼ Ð°ÑÐ´Ð¸ÑÐ° Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð² PostgreSQL
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Development and analysis of database audit systems in PostgreSQL
Creators: name: ÐÑÑÐ¸Ð½ÑÐºÐ°Ñ, ÐÐ»ÐµÐºÑÐ°Ð½Ð´ÑÐ°
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2023
Subjects: Ð±Ð°Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ
Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»Ð¸
Ð°ÑÐ´Ð¸Ñ
Ð°ÑÐ´Ð¸Ñ Ð² Ð±Ð°Ð·Ð°Ñ Ð´Ð°Ð½Ð½ÑÑ
database
users
audit
audit in database

description: ÐÐ±ÑÐµÐºÑÐ¾Ð¼ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ ÑÐ²Ð»ÑÐµÑÑÑ Ð¿ÑÐ¾ÑÐµÑÑ Ð°ÑÐ´Ð¸ÑÐ° Ð² Ð¡Ð£ÐÐ PostgreSQL, Ð° Ð¿ÑÐµÐ´Ð¼ÐµÑÐ¾Ð¼ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ - Ð¸Ð½ÑÑÑÑÐ¼ÐµÐ½ÑÑ Ð¸ Ð¼ÐµÑÐ¾Ð´Ñ, Ð¸ÑÐ¿Ð¾Ð»ÑÐ·ÑÐµÐ¼ÑÐµ Ð´Ð»Ñ Ð¾Ð±ÐµÑÐ¿ÐµÑÐµÐ½Ð¸Ñ Ð°ÑÐ´Ð¸ÑÐ° Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ, Ð²ÐºÐ»ÑÑÐ°Ñ ÑÐ±Ð¾Ñ Ð´Ð°Ð½Ð½ÑÑ, Ð°Ð½Ð°Ð»Ð¸Ð· Ð¸ ÑÑÐ°Ð½ÐµÐ½Ð¸Ðµ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¸ Ð¾ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»ÑÑ Ð¸ Ð¾Ð¿ÐµÑÐ°ÑÐ¸ÑÑ Ð² ÐÐ. Ð¦ÐµÐ»ÑÑ Ð´Ð¸Ð¿Ð»Ð¾Ð¼Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÑ ÑÐ²Ð»ÑÐµÑÑÑ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¸ Ð°Ð½Ð°Ð»Ð¸Ð· ÑÐ¸ÑÑÐµÐ¼Ñ Ð°ÑÐ´Ð¸ÑÐ° Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð² PostgreSQL. ÐÐ°Ð´Ð°ÑÐ¸: 1. ÐÐ·ÑÑÐµÐ½Ð¸Ðµ Ð¾ÑÐ½Ð¾Ð²Ð½ÑÑ Ð¿ÑÐ¸Ð½ÑÐ¸Ð¿Ð¾Ð² ÑÐ°Ð±Ð¾ÑÑ Ñ Ð±Ð°Ð·Ð°Ð¼Ð¸ Ð´Ð°Ð½Ð½ÑÑ, Ð²ÐºÐ»ÑÑÐ°Ñ ÑÑÑÑÐºÑÑÑÑ Ð¸ ÑÐ¸Ð¿Ñ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ, ÑÐ·ÑÐº SQL Ð¸ ÐµÐ³Ð¾ Ð²Ð¾Ð·Ð¼Ð¾Ð¶Ð½Ð¾ÑÑÐ¸, Ð° ÑÐ°ÐºÐ¶Ðµ Ð¿ÑÐ¸Ð½ÑÐ¸Ð¿Ñ Ð±ÐµÐ·Ð¾Ð¿Ð°ÑÐ½Ð¾ÑÑÐ¸ Ð¸ Ð·Ð°ÑÐ¸ÑÑ Ð´Ð°Ð½Ð½ÑÑ. 2. ÐÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ðµ ÑÑÐµÐ±Ð¾Ð²Ð°Ð½Ð¸Ð¹ Ð¸ ÑÑÐ½ÐºÑÐ¸Ð¾Ð½Ð°Ð»ÑÐ½ÑÑ Ð²Ð¾Ð·Ð¼Ð¾Ð¶Ð½Ð¾ÑÑÐµÐ¹ Ð´Ð»Ñ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ¸ ÑÐ¾Ð±ÑÑÐ²ÐµÐ½Ð½Ð¾Ð¹ ÑÐ¸ÑÑÐµÐ¼Ñ Ð°ÑÐ´Ð¸ÑÐ° Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð² PostgreSQL, Ð²ÐºÐ»ÑÑÐ°Ñ Ð·Ð°Ð¿Ð¸ÑÑ Ð¸Ð·Ð¼ÐµÐ½ÐµÐ½Ð¸Ð¹ Ð² Ð±Ð°Ð·Ðµ Ð´Ð°Ð½Ð½ÑÑ, Ð¼Ð¾Ð½Ð¸ÑÐ¾ÑÐ¸Ð½Ð³ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð¸ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº Ð´Ð°Ð½Ð½ÑÐ¼, Ð°Ð½Ð°Ð»Ð¸Ð· Ð»Ð¾Ð³Ð¾Ð² Ð¸ Ð¾ÑÑÐµÑÐ½Ð¾ÑÑÑ. 3. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° ÑÐ¸ÑÑÐµÐ¼Ñ Ð°ÑÐ´Ð¸ÑÐ°. 4. ÐÑÐ¾Ð²ÐµÐ´ÐµÐ½Ð¸Ðµ ÑÐµÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð½Ð¾Ð¹ ÑÐ¸ÑÑÐµÐ¼Ñ Ð½Ð° ÑÐ¿ÑÐ¾ÐµÐºÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð½Ð¾Ð¹ Ð±Ð°Ð·Ðµ Ð´Ð°Ð½Ð½ÑÑ. 5. ÐÐ½Ð°Ð»Ð¸Ð· Ð¿Ð¾Ð»ÑÑÐµÐ½Ð½ÑÑ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð² Ð¸ ÑÐ´ÐµÐ»Ð°Ð½Ð½ÑÑ Ð²ÑÐ²Ð¾Ð´Ð¾Ð² Ð¾ Ð¿ÑÐ¸Ð¼ÐµÐ½Ð¸Ð¼Ð¾ÑÑÐ¸ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð½Ð¾Ð¹ ÑÐ¸ÑÑÐµÐ¼Ñ Ð°ÑÐ´Ð¸ÑÐ° Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð² PostgreSQL Ð´Ð»Ñ Ð¿Ð¾Ð²ÑÑÐµÐ½Ð¸Ñ Ð±ÐµÐ·Ð¾Ð¿Ð°ÑÐ½Ð¾ÑÑÐ¸ Ð¸ Ð½Ð°Ð´ÐµÐ¶Ð½Ð¾ÑÑÐ¸ ÑÐ°Ð±Ð¾ÑÑ Ñ Ð´Ð°Ð½Ð½ÑÐ¼Ð¸. Ð Ð´Ð°Ð½Ð½Ð¾Ð¼ Ð´Ð¸Ð¿Ð»Ð¾Ð¼Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÐµ Ð±ÑÐ»Ð° Ð¿ÑÐ¾Ð²ÐµÐ´ÐµÐ½Ð° ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¸ Ð°Ð½Ð°Ð»Ð¸Ð· ÑÐ¸ÑÑÐµÐ¼ Ð°ÑÐ´Ð¸ÑÐ° Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð² PostgreSQL. ÐÑÐ»Ð¸ ÑÐ°ÑÑÐ¼Ð¾ÑÑÐµÐ½Ñ Ð¾ÑÐ½Ð¾Ð²Ð½ÑÐµ Ð¿ÑÐ¸Ð½ÑÐ¸Ð¿Ñ ÑÐ°Ð±Ð¾ÑÑ Ð°ÑÐ´Ð¸ÑÐ°, ÐµÐ³Ð¾ ÑÐ¸Ð¿Ñ Ð¸ Ð¼ÐµÑÐ¾Ð´Ñ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ. Ð¢Ð°ÐºÐ¶Ðµ Ð±ÑÐ»Ð¸ Ð¿ÑÐ¾Ð°Ð½Ð°Ð»Ð¸Ð·Ð¸ÑÐ¾Ð²Ð°Ð½Ñ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÑ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ Ð°ÑÐ´Ð¸ÑÐ° Ð² PostgreSQL Ð¸ Ð´Ð°Ð½Ñ ÑÐµÐºÐ¾Ð¼ÐµÐ½Ð´Ð°ÑÐ¸Ð¸ Ð¿Ð¾ ÐµÐ³Ð¾ ÑÐ»ÑÑÑÐµÐ½Ð¸Ñ. Ð ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐµ ÑÐ°Ð±Ð¾ÑÑ Ð±ÑÐ»Ð¾ Ð¾Ð¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð¾, ÑÑÐ¾ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ðµ Ð°ÑÐ´Ð¸ÑÐ° Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð½ÐµÐ¾Ð±ÑÐ¾Ð´Ð¸Ð¼Ð¾ Ð´Ð»Ñ Ð¾Ð±ÐµÑÐ¿ÐµÑÐµÐ½Ð¸Ñ Ð±ÐµÐ·Ð¾Ð¿Ð°ÑÐ½Ð¾ÑÑÐ¸ Ð¸ Ð½Ð°Ð´ÐµÐ¶Ð½Ð¾ÑÑÐ¸ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¸. ÐÑÐ»Ð¸ Ð¸Ð·ÑÑÐµÐ½Ñ Ð²Ð¾Ð·Ð¼Ð¾Ð¶Ð½Ð¾ÑÑÐ¸ Ð°ÑÐ´Ð¸ÑÐ° Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð² PostgreSQL Ð¸ Ð²ÑÐ±ÑÐ°Ð½ Ð½Ð°Ð¸Ð±Ð¾Ð»ÐµÐµ Ð¿Ð¾Ð´ÑÐ¾Ð´ÑÑÐ¸Ð¹ Ð¼ÐµÑÐ¾Ð´ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ. ÐÑÐ» Ð¿ÑÐ¾Ð²ÐµÐ´ÐµÐ½ Ð°Ð½Ð°Ð»Ð¸Ð· ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð² Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ Ð°ÑÐ´Ð¸ÑÐ° Ð¸ Ð´Ð°Ð½Ñ ÑÐµÐºÐ¾Ð¼ÐµÐ½Ð´Ð°ÑÐ¸Ð¸ Ð¿Ð¾ ÐµÐ³Ð¾ ÑÐ»ÑÑÑÐµÐ½Ð¸Ñ. ÐÑÐ°ÐºÑÐ¸ÑÐµÑÐºÐ°Ñ Ð·Ð½Ð°ÑÐ¸Ð¼Ð¾ÑÑÑ Ð´Ð°Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÑ Ð·Ð°ÐºÐ»ÑÑÐ°ÐµÑÑÑ Ð² ÑÐ¾Ð¼, ÑÑÐ¾ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÑ Ð¼Ð¾Ð³ÑÑ Ð±ÑÑÑ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ñ Ð¿ÑÐ¸ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ð¸ Ð°ÑÐ´Ð¸ÑÐ° Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð² Ð´ÑÑÐ³Ð¸Ñ Ð¾ÑÐ³Ð°Ð½Ð¸Ð·Ð°ÑÐ¸ÑÑ, ÑÐ°Ð±Ð¾ÑÐ°ÑÑÐ¸Ñ Ñ PostgreSQL. ÐÐ½Ð°Ð»Ð¸Ð· ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð² Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ Ð¿Ð¾Ð·Ð²Ð¾Ð»ÑÐµÑ Ð¾ÑÐµÐ½Ð¸ÑÑ ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÑ Ð°ÑÐ´Ð¸ÑÐ° Ð¸ Ð´Ð°ÑÑ ÑÐµÐºÐ¾Ð¼ÐµÐ½Ð´Ð°ÑÐ¸Ð¸ Ð¿Ð¾ ÐµÐ³Ð¾ ÑÐ»ÑÑÑÐµÐ½Ð¸Ñ Ð´Ð»Ñ Ð¾Ð±ÐµÑÐ¿ÐµÑÐµÐ½Ð¸Ñ Ð²ÑÑÐ¾ÐºÐ¾Ð³Ð¾ ÑÑÐ¾Ð²Ð½Ñ Ð·Ð°ÑÐ¸ÑÑ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¸. ÐÐ°Ð»ÑÐ½ÐµÐ¹ÑÐ¸Ðµ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð¼Ð¾Ð³ÑÑ Ð±ÑÑÑ Ð½Ð°Ð¿ÑÐ°Ð²Ð»ÐµÐ½Ñ Ð½Ð° ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÑ Ð½Ð¾Ð²ÑÑ Ð¼ÐµÑÐ¾Ð´Ð¾Ð² Ð°ÑÐ´Ð¸ÑÐ° Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð² PostgreSQL, Ð¸Ð·ÑÑÐµÐ½Ð¸Ðµ Ð²Ð¾Ð·Ð¼Ð¾Ð¶Ð½Ð¾ÑÑÐµÐ¹ Ð¸Ð½ÑÐµÐ³ÑÐ°ÑÐ¸Ð¸ Ð°ÑÐ´Ð¸ÑÐ° Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ñ Ð´ÑÑÐ³Ð¸Ð¼Ð¸ ÑÐ¸ÑÑÐµÐ¼Ð°Ð¼Ð¸ Ð±ÐµÐ·Ð¾Ð¿Ð°ÑÐ½Ð¾ÑÑÐ¸.
description: The topic of the final qualifying work: "Development and analysis of database audit systems in PostgreSQL". The object of the study is the audit process in the PostgreSQL DBMS, and the subject of the study is the tools and methods used to ensure the audit of the database, including data collection, analysis and storage of information about users and operations in the database. The purpose of the thesis is to develop and analyze a database audit system in PostgreSQL. Tasks: 1. Study of the basic principles of working with databases, including the structure and types of databases, the SQL language and its capabilities, as well as the principles of data security and protection. 2. Defining requirements and functionality for developing your own database audit system in PostgreSQL, including recording changes in the database, monitoring queries and data access, log analysis and reporting. 3. Development of an audit system. 4. Testing of the developed system on the designed database. 5. Analysis of the results obtained and conclusions drawn about the applicability of the developed database audit system in PostgreSQL to improve the security and reliability of working with data. As a result of the work, it was determined that the implementation of a database audit is necessary to ensure the security and reliability of information. The possibilities of database auditing in PostgreSQL were studied and the most appropriate implementation method was chosen. The results of the audit implementation were analyzed and recommendations for its improvement were given. The practical significance of this work lies in the fact that the results can be used in the implementation of database auditing in other organizations working with PostgreSQL. The analysis of the implementation results allows you to evaluate the effectiveness of the audit and make recommendations for its improvement to ensure a high level of information protection. Further research may be aimed at developing new methods of database audit in PostgreSQL, exploring the possibilities of integrating database audit with other security systems.