Unlock instant, AI-driven research and patent intelligence for your innovation.

Tracking method, device and system for database DDL change operation and medium

A technology of changing operation and tracking device, applied in the data processing field of financial technology, can solve problems such as inability to track SQL statement DDL change operation, inability to determine the corresponding user of SQL statement, etc., to improve the success rate and execution efficiency, facilitate management, reduce The effect of the vulnerability

Pending Publication Date: 2019-09-06
WEBANK (CHINA)
View PDF0 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The main purpose of the present invention is to provide a tracking method, device, system and medium for database DDL change operations, aiming to solve the existing technical problems that the DDL change operations of SQL statements cannot be tracked, and the corresponding users of SQL statements cannot be determined

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
  • Tracking method, device and system for database DDL change operation and medium
  • Tracking method, device and system for database DDL change operation and medium
  • Tracking method, device and system for database DDL change operation and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0049] It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0050] The present invention provides a tracking method for database DDL change operations, referring to figure 1 , figure 1 It is a schematic flowchart of the first embodiment of the method for tracking database DDL change operations in the present invention.

[0051] The embodiment of the present invention provides an embodiment of the method for tracking database DDL change operations. It should be noted that although the logic sequence is shown in the flow chart, in some cases, all operations may be performed in a sequence different from that described here. steps shown or described.

[0052] The tracking method of database DDL change operation is applied in DDL tracking system, and DDL tracking system can include mobile terminals such as tablet computer, notebook computer, palmtop computer, personal digital ass...

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 tracking method, device and system for database DDL change operation and a medium in the field of financial science and technology. The method comprises the following steps:when an SQL statement is received through a preset structured query language SQL execution interface, detecting whether the SQL statement meets a preset execution condition; if the SQL statement conforms to the execution condition, obtaining a first DDL change statement corresponding to the SQL statement after the SQL statement is successfully executed; and obtaining user information of a user corresponding to the SQL statement, and storing the user information and the first DDL change statement in a preset database. The DDL change operation of the SQL statement is tracked through the stored DDL change statement. The success rate and the execution efficiency of SQL statement execution are improved, the user corresponding to the SQL statement is determined according to the stored user information, and management of the user corresponding to the SQL statement is facilitated.

Description

technical field [0001] The present invention relates to the technical field of data processing of financial technology (Fintech), in particular to a tracking method, device, system and medium for database DDL change operations. Background technique [0002] With the continuous development of financial technology, especially Internet technology and finance, more and more technologies (such as distributed, blockchain, artificial intelligence, etc.) More and more functions need to be implemented through SQL (Structured Query Language, Structured Query Language) statements. [0003] Execution tools currently used to execute SQL statements are generally used as database clients to execute SQL statements, and do not check SQL statements, resulting in vulnerabilities and failures in the system corresponding to SQL statements, and the current execution tools cannot determine the user who executes SQL statements . Therefore, in order to improve the security of the business system w...

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/23G06F16/242
CPCG06F16/2358G06F16/2433
Inventor 邬秋元陈晓丹李宗波殷凇
Owner WEBANK (CHINA)