Method and system for monitoring database operation

Abstract

The invention discloses a method and system for monitoring database operation. The method comprises the steps that a monitored data configuration table is created; the data structure information of all databases in the monitored data configuration table is synchronized into a back-up table; according to a preset period, the data structure information of the databases, starting the monitoring function, in the monitored data configuration table is compared with the corresponding data structure information in the back-up table; if the data structure information is changed, the changed data structure information is recorded into a result table. By means of the method, the data structure change conditions of the monitored databases can be found in time, a database manager can control the operation of an operator by checking a result, and therefore the database operation risk is lowered.

Description

technical field [0001] The invention relates to the field of database operation, in particular to a method and system for monitoring database operation. Background technique [0002] At present, the database administrator cannot quickly and effectively monitor the modification of the database structure by the operator, resulting in the inability to timely supervise the operation beyond the scope of the operator, and there are potential safety hazards. And the security of the database is very important, and its damage may cause serious losses. [0003] Therefore, how to quickly and effectively monitor the operation of the ORACLE database is a technical problem to be solved by those skilled in the art. Contents of the invention [0004] The purpose of the present invention is to provide a method and system for monitoring database operation, which can detect the data structure changes of the monitored database in time, and enable the database administrator to control the ope...

AI Technical Summary

Problems solved by technology

[0002] At present, the database administrator cannot quickly and effectively monitor the modification of the database structure by the operator, resulting in the inability to timely supervise the operation beyond the scope of the operator, and there are potential safety hazards

And the security of the database is very important, its damage may cause serious losses

Images