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

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 (Structured Query Language, Structured Query Language)
If physical deletion is used, the data will be permanently lost and cannot be recovered
However, if the data is backed up and then physically deleted, developers need to manually back up the data to be deleted, which increases the complexity of system coding and system maintenance costs

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

Embodiment Construction

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

[0036] It should be noted that the terms "comprising", "comprising" and "having" in the specification and claims of the present application and the above drawings and any variations thereof are intended to cover non-exclusive inclusion. For example, a process, method, system, product or device comprising a series of steps or units is not limited to the listed steps or units, but optionally also includes unlisted steps or units, or optionally further includes For other steps or units inherent in these processes, methods, products or devices. In the claims, description and drawings of this application, re...

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