Invention Grant
- Patent Title: Removal of garbage data from a database
-
Application No.: US14501774Application Date: 2014-09-30
-
Publication No.: US10255304B2Publication Date: 2019-04-09
- Inventor: Daniel J. Dietterich , Jeffrey M. Keller
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Edell, Shapiro & Finnan, LLC
- Agent Anthony Curro
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00 ; G06F17/30 ; G06F12/02

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
- US20160092496A1 REMOVAL OF GARBAGE DATA FROM A DATABASE Public/Granted day:2016-03-31
Information query