Historical state data processing method, device, computer equipment and storage medium

A data processing and historical state technology, applied in the database field, can solve the problems of historical data damage and low security of historical data, and achieve the effect of avoiding malicious damage, improving security, and saving storage space.

Active Publication Date: 2020-12-25
TENCENT TECH (SHENZHEN) CO LTD
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The embodiment of the present invention provides a historical state data processing method, device, computer equipment and storage medium, which can solve the problem of low security of historical state data and easy to cause malicious damage to historical state data

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
  • Historical state data processing method, device, computer equipment and storage medium
  • Historical state data processing method, device, computer equipment and storage medium
  • Historical state data processing method, device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] In order to make the object, technical solution and advantages of the present invention clearer, the implementation manner of the present invention will be further described in detail below in conjunction with the accompanying drawings.

[0029] Before introducing the embodiments of the present invention, some basic concepts in database technology need to be introduced:

[0030] The database involved in the embodiment of the present invention stores multiple data tables, each data table can be used to store tuples, and tuples can have one or more versions. Wherein, the database may be any type of database based on MVCC. In this embodiment of the present invention, the type of the database is not specifically limited. It should be noted that the data in the above database is based on state attributes and can include three states: current state, transition state, and historical state. Each of the different status attributes in the data can be used to identify the status...

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 a historical data processing method and device, computer equipment and a storage medium, and belongs to the technical field of databases. The method comprises the following steps: when any first device of a single-machine database system meets a data transfer condition, obtaining historical data to be copied from the single-machine database system; Based on the historical data, copying the copy data to a cluster database system; And when the copying is successful, allowing the standalone database system to delete the stored historical data and the meta-information in response to the deletion operation of the database engine. The invention provides a data security strategy for processing historical data. According to the method, when the copy data in the stand-alonedatabase system is successfully copied to the cluster database system, the historical data and the meta-information are allowed to be deleted, so that the storage space of the stand-alone database system is saved, malicious damage to the historical data is avoided, and the security of the historical data is improved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a historical state data processing method, device, computer equipment and storage medium. Background technique [0002] With the development of database technology, the life cycle of data includes current state, transition state and historical state. The state transition process has gradually attracted the attention of technicians. [0003] At present, in databases based on MVCC (multi-version concurrency control, multi-version concurrency control) technology, historical state data is data generated by transactions before the smallest transaction in the current active transaction list, for example, in the user table (User table) The balance of account A was originally 10 yuan. After recharging 10 yuan, the server executes the balance update transaction to update the account balance to 20 yuan. After the balance update transaction is submitted, "10 yuan" is converted from the c...

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/27G06F16/21
Inventor 李海翔
Owner TENCENT TECH (SHENZHEN) 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

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