Database historical log backtracking method, device and system, equipment and storage medium

A backtracking method and database technology, applied in systems, equipment and storage media, database history log backtracking methods, and devices, can solve problems such as weak security awareness, increased user operating costs, and unacceptable problems, and achieve the expansion of data volume and historical logs. Retrospective requirements are met and the effect of meeting user needs

Pending Publication Date: 2020-10-02
ALIBABA GRP HLDG LTD
View PDF0 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, this method will increase the user's operating costs, and it is not easy to accept for a large number of users with weak security awareness

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database historical log backtracking method, device and system, equipment and storage medium
  • Database historical log backtracking method, device and system, equipment and storage medium
  • Database historical log backtracking method, device and system, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0049] Currently, if figure 1 A schematic diagram of the architecture of the database log audit system is shown. The database log audit system 10 includes: a database instance running device 11x , a message queue 12 and a database storage system 13 . Among them, multiple database instance running devices 11x form a database instance running device cluster 11, refer to figure 1 , the cloud database SQL audit solution usually includes the following steps:

[0050] On the device running the database instance 11x, write the SQL log file to the local storage space, for example, to the local disk, and then, by pushing or pulling, the SQL audit function instance will be enabled on the local server of the database running device 11x The SQL log file is written into the message queue 12, and the SQL in the message queue 12 can be written into by means of message forwarding (for example, through a message forwarder broker, specifically through multiple message forwarders, such as broke...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a database historical log backtracking method, device and system, equipment and a storage medium, and the method comprises: querying a log file set stored by database instanceoperation equipment of a user in response to a log backtracking instruction of the user, and positioning a to-be-backtracked log file; and obtaining a log file to be traced back, and writing the log file to be traced back into a database storage system of the user, so that the user traces back to the log file written into the database storage system. By adopting the scheme of the embodiment of theinvention, the data security of the database can be further improved.

Description

technical field [0001] The embodiments of this specification relate to the technical field of database security, and in particular, to a method, apparatus, system, device, and storage medium for backtracking a database history log. Background technique [0002] The database stores the core data of the system, and its security problems have become an important source of leakage and tampering in the traditional environment. In the cloud, the threat to databases is further amplified. Therefore, the operation behavior of the cloud database, especially the audit log of the full structured query language (Structured Query Language, SQL) execution record, is particularly important, and it is the most basic requirement to ensure the security of the cloud database. [0003] The SQL audit function of the existing cloud database is usually a value-added service, and can only query the SQL log after the SQL audit function is enabled. Many users do not enable the audit function when the...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/14G06F16/174G06F16/18G06F16/242
CPCG06F16/144G06F16/1744G06F16/1815G06F16/2433
Inventor 吴迪楼江航邓由由吴学强丁顺杰
Owner ALIBABA GRP HLDG LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap