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

Data maintenance method based on sql automatic analysis and 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, improving usability, and solving the risk of misoperation

Active Publication Date: 2022-02-18
深圳市佑荣信息科技有限公司
View PDF6 Cites 0 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 and detection

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] In order to make the objects, technical solutions, and advantages of the present invention, the embodiments of the present invention will be further described in detail below with reference to the accompanying drawings.

[0027] The present invention provides a data maintenance method based on SQL automation parsing, and has the advantages of solving the risk of errors that perform data maintenance, see figure 1 , Including SQL script preparation, automated operation and maintenance system, SQL execution engine;

[0028] Specific steps are as follows:

[0029] S1: First development, the operation and main team is prepared by the SQL script, directly export the SQL script that verifies through the database, by the operation and maintenance, development team, SQL scripts include DML, DDL;

[0030] S2: Then upload the SQL script, upload the SQL script by the development, and the operation and maintenance system, the archive and backup of the SQL script, and set the rule of the...

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 field of computer technology, and specifically relates to a data maintenance method based on SQL automatic analysis and detection, including SQL script preparation, automatic operation and maintenance system, and SQL execution engine. Prepare, directly export the verified SQL script through the database of the pre-order test link, and organize the SQL script by the operation and maintenance and development teams; the beneficial effects of the present invention are: export the SQL script through the pre-order test environment, manually edit the SQL script, and submit it to The operation and maintenance system submits the SQL script, specifying the execution time and target environment, and the SQL execution engine of the operation and maintenance system will parse and detect the submitted SQL, and generate the relevant history SQL script, and execute it regularly, and automatically roll back when it fails.

Description

Technical field [0001] The present invention relates to the field of computer technology, in particular, data maintenance methods based on SQL automation parsing. Background technique [0002] SQL is a database language with a variety of functions such as data manipulation and data definition. This language has an interactive feature that provides 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 used independently in the terminal, but also as a sub-language to provide effective boosts for other programming. In this program application, SQL can optimize the program functionality with other program languages, which in turn provides users with more comprehensive information. The SQL database can be directly related to the operation of the entire computer system. [0003] During the update publishing maintenance of the existing ...

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 Patents(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