Invention Application
- Patent Title: REMOVAL OF GARBAGE DATA FROM A DATABASE
- Patent Title (中): 从数据库中删除GARBAGE数据
-
Application No.: US14501774Application Date: 2014-09-30
-
Publication No.: US20160092496A1Publication Date: 2016-03-31
- Inventor: Daniel J. Dietterich , Jeffrey M. Keller
- Applicant: International Business Machines Corporation
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Elements of a database object are removed. The database object is stored as a plurality of different object portions, where each object portion is associated with one or more versions of transaction identifiers stored separately from the database object. An oldest transaction identifier is determined for a transaction for which data portions of the database object remains visible. Each object portion is examined and object portions with a threshold amount of data to remove are determined based on a comparison of the transaction identifiers for those object portions and the oldest transaction identifier. Data from the database object are removed in response to a sufficient quantity of data is to be removed from object portions containing the threshold amount of data.
Public/Granted literature
- US10255304B2 Removal of garbage data from a database Public/Granted day:2019-04-09
Information query