Analysis of mechanisms of optimization and security of database storage of the program for auditing passwords of user accounts of domain infrastructure users

Abstract

The analysis work conducted focuses on the importance of databases (DBs) in the context of modern information technology, emphasizing their key role in the efficient operation of applications. This paper analyzes different types of databases such as relational (MySQL, PostgreSQL, Oracle) and NoSQL (MongoDB, Cassandra) and emphasizes the need to choose the right type of database depending on the application requirements. The paper describes mechanisms and methods for optimizing and securing relational databases, focusing on MySQL/MariaDB in the context of a domain infrastructure account password auditing application under development, since the correct choice of database type depends on the application requirements and the nature of the data. The main mechanisms for optimizing relational database performance include indexing mechanisms to speed up queries, optimal database configuration to reduce data access time, cryptographic encryption of table contents to ensure security, analysis of cryptographic authentication protocols, and advanced monitoring techniques to detect anomalies. Application of cryptographic encryption such as SHA-1/2, DES, AES, and others ensures the security of table contents at the DBMS level. Comparing different cryptographic authentication protocols is also important to ensure data security. And also, modern monitoring and logging techniques can detect anomalies in database operation, including unauthorized access attempts. This study offers a more detailed analysis of these methods and mechanisms in order to optimize the performance and security of relational databases in the context of developing software for auditing domain infrastructure user account passwords.