Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data maintenance method based on SQL automatic analysis detection

A data maintenance and automatic technology, applied in the computer field, can solve problems such as misoperation, achieve the effect of reducing the length of time, solving the risk of misoperation, and improving usability

Active Publication Date: 2021-12-21
深圳市佑荣信息科技有限公司
View PDF6 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] Therefore, the purpose of the present invention is to provide a data maintenance method based on automatic analysis and detection of SQL, export the SQL script through the pre-order test environment, manually edit the SQL script, and submit the SQL script to the operation and maintenance system, specify the execution time and target environment, and operate The SQL execution engine of the dimensional system will analyze and detect the submitted SQL, generate relevant resume SQL scripts, and execute them regularly, and automatically roll back when it fails, which can solve the problem of misoperation risk in manual data maintenance

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
  • Data maintenance method based on SQL automatic analysis detection

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] In order to make the purpose, technical solution and advantages of the present invention clearer, the following will further describe the implementation of the present invention in detail in conjunction with the accompanying drawings.

[0027] The present invention provides a data maintenance method based on automatic analysis and detection of SQL, which has the advantage of solving the risk of misoperation in manual data maintenance. Please refer to figure 1 , including SQL script preparation, automated operation and maintenance system, and SQL execution engine;

[0028] Specific steps are as follows:

[0029] S1: First, the development and operation and maintenance teams prepare SQL scripts, and directly export the verified SQL scripts through the database of the pre-order test link, and the operation and maintenance and development teams sort out the SQL scripts. SQL scripts include DML and DDL;

[0030] S2: Then upload the SQL scripts in batches, and the developmen...

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 belongs to the technical field of computers, and particularly relates to a data maintenance method based on SQL automatic analysis detection, which comprises SQL script preparation, an automatic operation and maintenance system and an SQL execution engine, and specifically comprises the following steps: S1, firstly, performing SQL script preparation by an developing operation and maintenance team, and directly exporting an SQL script passing verification through a database of a preorder test link; and arranging the SQL script by the developing operation and maintenance team. The method has the beneficial effects that the SQL script is exported through the preorder test environment, the SQL script is manually edited and submitted to the operation and maintenance system, the execution time and the target environment are specified, the SQL execution engine of the operation and maintenance system analyzes and detects the submitted SQL, generates a related resume SQL script, executes the SQL script at regular time, and can automatically roll back when the SQL script fails.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a data maintenance method based on automatic analysis and detection of SQL. Background technique [0002] SQL is a database language with multiple functions such as data manipulation and data definition. This language is interactive and can provide users with great convenience. The database management system should make full use of SQL language to improve the work quality and efficiency of computer application systems. , the SQL language can not only be applied independently to the terminal, but also can be used as a sub-language to provide effective assistance for other program designs. In this program application, SQL can optimize program functions together with other program languages, thereby providing users with more comprehensive information. Whether the SQL database can run normally is directly related to the safety of the entire computer system. [0003] In the update ...

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/21G06F16/242
CPCG06F16/21G06F16/2433
Inventor 杨宇翔黄铎彭志伟
Owner 深圳市佑荣信息科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products