A maintenance-free method for life cycle table garbage data

Abstract

The invention provides a maintenance-free method for realizing garbage data in the life cycle table. The data is stored in the pre-established life cycle table. The life cycle table is divided into multiple continuous time periods from far to near, which are P1, P2, and P3 in sequence. , each time new data is stored, the historical data in the table is transferred once. The transfer steps are: lock the life cycle table; clear the garbage data in the P2 partition, copy the first part of the data stored in P3 to P2, and use it as Store the latest data in P2; clear the garbage data in the P1 partition, copy the first part of the data stored in P2 to P1, and store it as the latest data in P1; update the internal system time of the life cycle table; delete the deleted data in P3 Data copied to P2; delete data in P2 that has been copied to P1; unlock. The lifecycle table described in the present invention uses partition boundaries to control data visibility and queryability, adopts a method of copying and then deleting, that is, does not generate any additional costs, has high efficiency, and is reliable in circulation.

Description

technical field [0001] The invention belongs to the field of databases, and in particular relates to a maintenance-free method for realizing garbage data in a life cycle table. Background technique [0002] Life cycle table, as the name suggests, is a method of splitting and managing data in the direction of the time axis through partition technology. The main purpose is to store data with the same or similar attributes in one place (same partition), so that the operation will be more convenient and independent during data processing. At the same time, time life is given to each partition, and the conversion of life cycles between different partitions is conditionally allowed, so as to realize the management and use of the complete data life cycle. However, when data flows in one direction between partitions (from new to old), due to the complexity caused by the superposition of various factors in use (such as network, business busyness, etc.), system designers Faced with ...

AI Technical Summary

Problems solved by technology

[0003] In view of this, the present invention aims to propose a maintenance-free method for garbage data in the life cycle table, so as to solve the problem that in the traditional method, the validity of the data is judged when the data is used or inserted, which causes a large impact on performance. , and in the process of data transfer, due to busy data errors, garbage data is not processed in a timely manner, resulting in the failure of the data corresponding to the partition

Images