Unlock instant, AI-driven research and patent intelligence for your innovation.

Method, device and system for processing historical data in database

A technology of historical data and processing methods, applied in the database field, can solve problems such as unavailability, excessive database load, and unavailability of the entire database, and achieve the effect of reducing the scope and improving cleaning efficiency

Pending Publication Date: 2021-02-19
BEIJING VASTDATA TECH
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, vacuum is very slow for tables with a large amount of data, and new transactions are not allowed before the vacuum freeze ends, resulting in the entire database being unavailable when vacuum freezes in extreme cases
In openGauss and PostgreSQL, the vacuum process often causes the database load to be too large or even unavailable

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
  • Method, device and system for processing historical data in database
  • Method, device and system for processing historical data in database
  • Method, device and system for processing historical data in database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] Embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings.

[0038] It should be noted that, in the case of no conflict, the following embodiments and the features in the embodiments can be combined with each other; and, based on the embodiments in the present disclosure, those of ordinary skill in the art obtained without creative work All other embodiments belong to the protection scope of the present disclosure.

[0039] It is noted that the following describes various aspects of the embodiments that are within the scope of the appended claims. It should be apparent that the aspects described herein may be embodied in a wide variety of forms and that any specific structure and / or function described herein is illustrative only. Based on the present disclosure one skilled in the art should appreciate that an aspect described herein may be implemented independently of any other aspects and that two or more of t...

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 provides a method, device and system for processing historical data in a database, and the method comprises the steps: building an independent historical table space when a new databaseis built, enabling the historical table space to be used for storing historical version data and transaction information, and when the Valuum process is executed, directly accessing the historical table space to remove the expired data. According to the invention, the expired data cleaning efficiency can be improved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a processing method, device and system for historical data in a database. Background technique [0002] In openGauss and PostgreSQL, deletion just marks data as a deletion flag, so vacuum is needed to regularly clean up expired data. But since the database only keeps the transaction marker information, the vacuum must scan all the data blocks of the data files to deal with this problem. Therefore, vacuum is very slow for tables with a large amount of data, and new transactions are not allowed before the vacuum freeze ends, resulting in the entire database being unavailable when vacuum freezes in extreme cases. In openGauss and PostgreSQL, the vacuum process often causes the database to be overloaded or even unavailable. Contents of the invention [0003] In view of this, the present invention provides a method, device and system for processing historical data in a database,...

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): G06F16/21G06F16/215G06F16/22
CPCG06F16/219G06F16/215G06F16/2282
Inventor 李年
Owner BEIJING VASTDATA TECH