Invention Grant
- Patent Title: Database storage reclaiming program
-
Application No.: US15331929Application Date: 2016-10-24
-
Publication No.: US09672215B2Publication Date: 2017-06-06
- Inventor: Vinod P. Chirayath , Gary T. Gong , Salvador Ledezma
- 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 Kristofer L. Haggerty
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
The computer retrieves a list of the data elements contained in a database. The computer performs a static and dynamic analysis on the list to determine which data elements have been active in a static or dynamic Structured Query Language (SQL) statement, then removes active data elements from the list. The computer performs a dependency test to determine which data elements on the list are depended on by data objects not on the list and removes those data elements which are depended on. The computer analyzes application code to extract SQL statements and determine whether data elements on the list are active in application code SQL. Any data elements on the list which are active in application code SQL are removed from the list and the remaining data elements on the list are sorted in descending order based on size.
Public/Granted literature
- US20170031941A1 DATABASE STORAGE RECLAIMING PROGRAM Public/Granted day:2017-02-02
Information query