Invention Grant
- Patent Title: Database management delete efficiency
-
Application No.: US13795262Application Date: 2013-03-12
-
Publication No.: US09229961B2Publication Date: 2016-01-05
- Inventor: Robert J. Bestgen , Daniel E. Beuch
- 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 Scott A. Berger; James R. Nock
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A method, system, and computer program product to efficiently delete data from a database is disclosed. The method, system, and computer program product may include structuring the database to have a plurality of tables having indexes to related rows and having keys with key values associated with particular rows. The method, system, and computer program product may include deleting rows in the database tables by deleting keys in indexes related to the rows in an order such that corresponding rows are deleted based on relation to the keys. The method, system, and computer program product may include ordering the rows to be deleted based on concepts such as hierarchy, spatial locality, temporal locality, frequency of access, number of rows, and value uniqueness. Comparatively closely related relationships may be prioritized to be deleted.
Public/Granted literature
- US20140229429A1 DATABASE MANAGEMENT DELETE EFFICIENCY Public/Granted day:2014-08-14
Information query