Method and device for recognizing abnormal operation in database

Abstract

The embodiment of the invention provides a method and device for recognizing abnormal operation in a database. The method comprises the steps of obtaining a target SQL statement used for executing target behavior operation for the database; analyzing the target SQL statement to obtain a plurality of data objects involved in the target behavior operation and a target association relationship among the data objects, wherein the single data object is a field or a data table; according to the multiple data objects and the target incidence relation, updating a pre-established data relation record, wherein the data relation record comprises at least part of the data objects in the database and the existing incidence relation between the data objects; inquiring a target field meeting a preset condition from the updated data relationship record, and judging whether the preset condition is related to a label of the field and the association relationship belongs to a preset relationship or not; and under the condition that the target field belongs to the plurality of data objects, determining that the target behavior operation belongs to the abnormal operation. High automation can be achieved, the labor cost is reduced, and meanwhile high accuracy can be kept.

Description

technical field [0001] One or more embodiments of this specification relate to the computer field, and in particular to a method and an apparatus for identifying abnormal operations in a database. Background technique [0002] Private data (private data) refers to secret data, which refers to information that does not want to be known by others or unrelated people. From the perspective of privacy owners, private data can be divided into personal private data and common private data. Personal private data includes Information that can be used to locate or identify individuals (such as phone numbers, addresses, credit card numbers, etc.) and sensitive information (such as personal health conditions, financial information, important company documents, etc.). Common privacy data is mainly based on family privacy, such as family annual income. The leakage and abuse of private data can easily cause various personal and public security issues. For the protection of private data, ...

AI Technical Summary

Problems solved by technology

For the protection of private data, it is necessary to identify abnormal operations in the database. The above abnormal operations may easily lead to privacy data leakage, system failure and other consequences. Usually, the database includes a large number of data tables, and there are dozens of fields in each data table on average. , each field corresponds to a label whether it belongs to private data

Images