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

Method and device for managing data modification process, equipment and storage medium

A technology for data modification and data management, applied in the field of database security, it can solve the problems of lack of rollback strategy, complicated and cumbersome process of restoring original data, etc., achieve rapid data modification and rollback scheme, reduce error interference, and reduce manpower cost effect

Pending Publication Date: 2022-04-22
WEIKUN (SHANGHAI) TECH SERVICE CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] In the above implementation method, the information management personnel need to rewrite the data query language (DQL) according to the SQL submitted by the data handler, and after querying the production data, manually compare and analyze the confirmation. The process is complex and cumbersome, and due to manual intervention, it is very difficult to error may occur
[0006] In addition, after confirming that the SQL is a legal file and the amount of data to be modified is correct, the process of data modification lacks a perfect rollback strategy
When the modified data does not meet expectations, the process of restoring the original data is complicated and time-consuming, and it is easy to cause data loss or tampering, which affects data security

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
  • Method and device for managing data modification process, equipment and storage medium
  • Method and device for managing data modification process, equipment and storage medium
  • Method and device for managing data modification process, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] It should be understood that the specific embodiments described here are only used to explain the present application, and are not intended to limit the present application. The equivalent structure or equivalent process conversion made by using the contents of the description and drawings of this application, or directly or indirectly used in other related technical fields, are all included in the scope of patent protection of this application.

[0039] The technical solutions in the embodiments of the present application will be described below with reference to the drawings in the embodiments of the present application. In the description of the embodiments of the present application, the terms "first" and "second" are used for description purposes only, and cannot be understood as indicating or implying relative importance or implicitly indicating the quantity of indicated technical features. Thus, features defined as "first" and "second" may explicitly or implicitl...

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 embodiment of the invention discloses a method, device and equipment for managing a data modification process and a storage medium. An intelligent data modification management system obtains a database file and a first data volume submitted by a data manager; and when the data change application passes, and it is detected that each statement after SQL statement analysis is a preset basic statement, the amount of data needing to be modified by the SQL statement is the same as the actual amount needing to be modified, and a rollback scheme after SQL statement execution exists, the SQL statement is released, and data modification is realized. According to the method, decoupling of the approval step and the modification step of data modification is realized, manual modification and comparison of the data are avoided, the error rate caused by human factors is reduced, and the data modification efficiency is improved.

Description

technical field [0001] The present application relates to the technical field of database security, and relates to but not limited to a method, device, device and storage medium for managing a data modification process. Background technique [0002] The database is the core and foundation of the information system. It can organize a large amount of data in the information system according to a certain model, and provide the functions of storing, maintaining and retrieving data, so that the information system can obtain all information from the database conveniently, timely and accurately. information required. In short, a database is a warehouse that organizes, stores, and manages data according to the data structure, and can support users to add, delete, modify, and query data. [0003] Structured query language (structured query language, SQL) is a standard database language adopted by the International Organization for Standardization. Among them, SQL can include data q...

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/23G06F16/242G06Q10/10
CPCG06F16/21G06F16/23G06F16/2433G06Q10/103
Inventor 王燕
Owner WEIKUN (SHANGHAI) TECH SERVICE CO LTD
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com