Data deletion operation intercepting backup method and device, equipment and storage medium

A technology for backing up storage and data, applied to redundancy in operations for data error detection, database indexing, structured data retrieval, etc. To save system storage space, prevent permanent loss, and facilitate recovery

Pending Publication Date: 2020-09-11
CHINA PING AN PROPERTY INSURANCE CO LTD
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] 2. When physically deleting, the data is actually deleted from the database, that is, the data is completely deleted in the database and cannot be recovered
[0006] The method of logical deletion only adds but not deletes the data, which will increase the data in the table and affect the execution efficiency and complexity of SQL (

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 deletion operation intercepting backup method and device, equipment and storage medium
  • Data deletion operation intercepting backup method and device, equipment and storage medium
  • Data deletion operation intercepting backup method and device, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0035] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by those skilled in the technical field of this application. The terminology used in the specification of the application herein is only for the purpose of describing specific embodiments, and is not intended to limit the application.

[0036] It should be noted that the terms "including", "including" and "having" in the specification and claims of the present application and the above-mentioned drawings and any variations thereof are intended to cover non-exclusive inclusions. For example, a process, method, system, product, or device that includes a series of steps or units is not limited to the listed steps or units, but optionally includes unlisted steps or units, or optionally also includes Other steps or units inherent to these processes, methods, products or equipment. The terms in the claims, specification and drawings of this application, such as ...

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 data deletion operation interception backup method and device, equipment and a storage medium, and relates to the technical field of blockchain storage. Themethod comprises: receiving a database operation instruction; intercepting the database operation; analyzing the database operation, and judging whether the database operation contains a data deletion operation or not; if the data deletion operation is included, identifying target data pointed by the data deletion operation, and further analyzing the target data to obtain a target storage structure of the target data; backing up the target data to a pre-configured second database; and continuing to respond to the database operation instruction, and deleting the target data in the first database. According to the method, a user does not need to manually operate backup data, the data is stored in the blockchain type account book, permanent loss of the data can be effectively prevented, recovery is convenient, the maintenance cost of manual operation and the difficulty of system coding are reduced, the storage space of the system is saved, and the complexity and query efficiency of sql statements in an existing server are not affected.

Description

technical field [0001] The present application relates to the technical field of blockchain storage, in particular to an interception backup method, device, equipment and storage medium for data deletion operations. Background technique [0002] Some large companies nowadays pay more and more attention to data processing. Data traces during data processing are very important. Companies can trace all historical records of data changes based on data traces to troubleshoot problems. [0003] When deleting data to update data, the current common practice in the industry is through logical deletion or physical deletion: [0004] 1. When logically deleting, define a state (state) field in the table, and use a specific value of this field to indicate that the record has been deleted. When the table data is to be deleted, no delete operation is performed, and only the value in the state field is updated. This operation is actually a modification operation. [0005] 2. During physi...

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): G06F11/14G06F16/27G06F16/22
CPCG06F11/1458G06F16/2282G06F16/27
Inventor 倪佳
Owner CHINA PING AN PROPERTY INSURANCE CO LTD
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