Alternation statement reverse analysis method, database alternating and backspacing method and database alternating and backspacing system

A reverse analysis and database technology, which is applied in database management systems, electronic digital data processing, structured data retrieval, etc., can solve problems such as inability to guarantee correctness, high cost of complete database preparation, and high cost

Active Publication Date: 2014-03-26
中移信息技术有限公司
View PDF7 Cites 19 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0012] The technical problem to be solved by the present invention is to provide a solution for the defects of low efficiency, high cost, and unguaranteed correctness of the above-mentioned manual rollback in the prior art, as well

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
  • Alternation statement reverse analysis method, database alternating and backspacing method and database alternating and backspacing system
  • Alternation statement reverse analysis method, database alternating and backspacing method and database alternating and backspacing system
  • Alternation statement reverse analysis method, database alternating and backspacing method and database alternating and backspacing system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0089] In order to have a clearer understanding of the technical features, purposes and effects of the present invention, the specific implementation manners of the present invention will now be described in detail with reference to the accompanying drawings.

[0090] refer to figure 1 It is a flow chart of the reverse analysis method for changing sentences of the present invention;

[0091] The reverse analysis method of the change statement of the present invention is used in the database to carry out reverse analysis before the execution of the change statement to generate a rollback statement, the change statement is an SQL statement, and the method includes the following steps:

[0092] S1. Determine the objects involved in the change statement, the change instruction and the rollback instruction corresponding to the change instruction;

[0093] Wherein, the object includes a direct object and an associated object associated with the direct object, and determining the ob...

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 an alternation statement reverse analysis method, a database alternating and backspacing method and a database alternating and backspacing system. The reverse analysis method includes S1, determining objects and alternation commands both involved in an alternation statement and backspacing commands corresponding to the alternation commands; S2, in case of creating/adding of the alternation statement, directly determining a backspacing statement according to the objects and the backspacing commands, and in case of changing/ deleting of the alternation statement, determining changed/ deleted source data/content, and determining the backspacing statement according to the objects, the source data/content and the backspacing commands. The backspacing method includes S10, acquiring input, database version and database authorization of an SQL (structured query language) alternation script; S20, analyzing the SQL alternation script to generate a statement analysis result; S30, based on the statement analysis result, generating the backspacing statement and transforming the backspacing statement into an executable backspacing SQL script file according to the alternation statement reverse analysis method. The backspacing method has the advantages of wide application range, high operability, safety and high automation.

Description

technical field [0001] The invention relates to the field of software system operation and maintenance, in particular to a reverse analysis method for a change statement, a database change rollback method and a system. Background technique [0002] During the operation of the software production system, with the development and changes of the business, it is often necessary to modify or upgrade the functions of the software system, and the modification and upgrade will bring changes to the software system itself. At the same time, in the process of system operation, system defects left over from the previous period are often exposed, and the repair of defects will also lead to system changes. [0003] In most software production systems, the database system is an important component. Common database systems such as Oracle, MySQL, Sybase, MS SQL server, etc., have been widely used in software systems in various industries. Therefore, changes to the software system also invo...

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
IPC IPC(8): G06F17/30
CPCG06F16/217G06F16/25
Inventor 陈卓张爱民琚彬姚芸陈春松韩林
Owner 中移信息技术有限公司
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