Invention Grant
- Patent Title: Managing data obsolescence in relational databases
-
Application No.: US15828781Application Date: 2017-12-01
-
Publication No.: US10606835B2Publication Date: 2020-03-31
- Inventor: Luis Campo Giralte , Jose Luis Mujeriego Gomez
- 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
- Agent Edward J. Wixted, III
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F16/2453 ; G06F16/215

Abstract:
Data obsolescence is managed using a bitmap or bit array index which is associated with a table during an obsolescence control period. A table is selected to undergo obsolescence control for a period of time. Any records that have not been accessed for a certain number of cycles ‘M’, which represents an obsolescence limit, are deemed to be obsolete. During at least a part of each cycle, the results of database queries to the table are monitored, such that for each cycle an ‘obsolescence’ bitmap is created indicating which records were accessed. Once a sufficient number of cycles have elapsed, so that records that have not been accessed at all since the start of the obsolescence control period lie outside the obsolescence limit, queries are restricted to records which have been accessed during the last ‘M’ cycles by applying the ‘M’ most recently stored obsolescence bitmaps.
Public/Granted literature
- US20180081942A1 Managing Data Obsolescence in Relational Databases Public/Granted day:2018-03-22
Information query