Method and system for monitoring operation and maintenance behavior of database administrators

Abstract

The invention provides a monitoring method and system for the operation and maintenance behavior of a database administrator. The system comprises a first monitoring module, a window state judgment module, a first content acquiring module, a second monitoring module, a redrawing instruction output module, a second content acquiring module, a screen video frame acquiring module, an account information acquiring module and a mapping relation configuration list maintenance module. The first monitoring module is used for monitoring an I / O module. The first content acquiring module is used for acquiring window handles and then acquiring execution context content corresponding to the window handles. The second monitoring module is used for monitoring the I / O module. The redrawing instruction output module is used for outputting an operation instruction for redrawing the bottom area of a command line tool. The second content acquiring module is used for acquiring the context content which is output again. The mapping relations of screen video frames, account information, execution context content and the current timestamp are stored. The monitoring method and system for the operation and maintenance behavior of the database administrator has the advantages that an existing network structure of a user does not need to be changed, and the valid or invalid operation instruction which is attempted to be sent to a database server through a database operation terminal by the database administrator can be comprehensively monitored.

Description

technical field [0001] The invention belongs to the technical field of database administrator operation behavior auditing, and in particular relates to a monitoring method and system for database administrator operation and maintenance behavior. Background technique [0002] A database administrator (DBA, Database Administrator) is a person who is responsible for overall management, control and maintenance of the database server. Its main tasks include: registering database users, maintaining database security, controlling and monitoring user access to the database, Monitor and optimize database performance, restore database information when disasters occur, maintain archives or backup data on appropriate media, backup and restore databases, etc.; comprehensively monitor the operation and maintenance behavior of database administrators to improve database security . [0003] In the prior art, the following methods are mainly used to monitor the operation and maintenance beh...

AI Technical Summary

Problems solved by technology

[0005] (1) It is necessary to change the user's existing network structure and deploy additional network nodes, thereby increasing the monitoring cost of the database administrator's operation and maintenance behavior;

[0006] (2) In the process of monitoring the operation and maintenance behavior of the database administrator, it is necessary to monitor the designated port and analyze a large number of data packets to obtain database operation instructions. When the designated port changes, the monitoring rules need to change accordingly. Therefore, it is necessary to The monitoring process is complicated and the monitoring efficiency is low;

[0007] (3) Because the communication messages between the database operation terminal and the database server need to be analyzed and processed by the monitoring node, when the monitoring node itself fails, it will directly affect the normal communication between the database operation terminal and the database server, making the database management (4) When the database administrator sends an operation command through the database operation terminal, the database operation terminal usually needs to check the syntax of the operation command. If the operation command is an error, the database operation The terminal directly displays the error information, and does not send the wrong operation command to the database server through the network; therefore, the monitoring node cannot intercept the wrong operation command, so it cannot fully monitor the database administrator, which has certain monitoring limitations;

[0008] (5) The monitoring node can only analyze and record the intercepted database operation instructions, which still has the problem of limited monitoring effect

Images