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.
CN109902127BActive Publication Date: 2020-12-25TENCENT TECH (SHENZHEN) CO LTD
5 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN Β· China
Patent Type
Patents(China)
Current Assignee / Owner
TENCENT TECH (SHENZHEN) CO LTD
Publication Date
2020-12-25

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

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.
Need to check novelty before this filing date? Find Prior Art

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