Automatic data purging in a database management system

Patent metadata

Field	Value
Publication number	US-10783125-B2
Application number	US-201615346121-A
Country	US
Kind code	B2
Filing date	Nov 8, 2016
Priority date	Nov 8, 2016
Publication date	Sep 22, 2020
Grant date	Sep 22, 2020

Abstract

A computer-implemented method for managing a database space includes writing, via a processor, a purge rule to a database management system (DBMS). When the purge rule is executed by the DBMS they automatically purge data in one or more databases at regular intervals. The method includes executing, via a DBMS processor, the purge rule. The purge rule is configured to define, via the DBMS processor, a purge object having purge object attributes without user intervention, and purge, via the DBMS processor, the data based on the purge rule at intervals defined by the purge rule attributes and without user intervention.

First claim

What is claimed is:

1. A computer-implemented method for managing a database, comprising:
writing, via a processor, a purge rule to a database management system (DBMS) that, when executed by the DBMS, automatically purges data in one or more databases at regular intervals, wherein the purge rule corresponds to a table in the one or more databases, and wherein the purge rule is set at a creation time of the table; and
executing, via a DBMS processor, the purge rule, wherein executing the purge rule defines, without user intervention, a purge object having purge object attributes, the purge object created using DBMS language statements;
altering, via the DMBS processor, the purge object attributes using DBMS language statements; and
purging, via the DBMS processor, the data from the table based on the purge rule and its attributes at intervals defined by the purge rule and without user intervention.

2. The computer-implemented method of claim 1 , wherein the purge object attributes are indicative of at least one row from the table.

3. The computer-implemented method of claim 1 , wherein the purge rule causes the processor to delete one or more purge objects to deactivate automatic data purging.

4. The computer-implemented method of claim 1 , wherein the intervals defined by the purge rule are indicative of when the data should be purged by the DBMS processor.

5. A system for managing a database, comprising:
a processor configured to:
write a purge rule to a database management system (DBMS) that, when executed by the DBMS, automatically purges data in one or more databases at regular intervals, wherein the purge rule corresponds to a table in the one or more databases, and wherein the purge rule is set at a creation time of the table;
execute the purge rule, wherein executing the purge rule defines, without user intervention, a purge object having purge object attributes, the purge object created using DBMS language statements;
alter the purge object attributes using DBMS language statements; and
purge the data from the table based on the purge rule and its purge object attributes at intervals defined by the purge rule and without user intervention.

6. The system of claim 5 , wherein the purge object attributes are indicative of at least one row from the table.

7. The system of claim 5 , wherein the purge rule cause the processor to delete one or more purge objects to deactivate automatic data purging.

8. The system of claim 5 , wherein the intervals defined by the purge rule are indicative of when the data should be purged by the processor.

9. A computer program product for managing a database, the computer program product comprising a computer readable storage device having program instructions embodied therewith, the program instructions executable by a processor to cause the processor to perform a method comprising:
writing, via a processor, a purge rule to a database management system (DBMS) that, when executed by a DBMS processor, automatically purges data in one or more databases at regular intervals, wherein the purge rule corresponds to a table in the one or more databases, and wherein the purge rule is set at a creation time of the table;
altering, via the processor, the purge object attributes using DBMS language statements; and
executing, via a DBMS processor, the purge rule, wherein executing the purge rule defines, without user intervention, a purge object having purge object attributes, the purge object created using DBMS language statements; and
purging, via the DBMS processor, the data from the table based on the purge rule and its purge object attributes at intervals defined by the purge rule and without user intervention.

10. The computer program product of claim 9 , wherein the purge object attributes are indicative of at least one row from the table.

11. The computer program product of claim 9 ,
wherein the purge rule causes the DBMS processor to delete one or more purge objects to deactivate automatic data purging; and
wherein the intervals defined by the purge rule are indicative of when the purge object should be purged by the DBMS processor.

Assignees

• IBM

Inventors

• Bester Karla
• Shewell Mark A
• Yates Stephen J

Classifications

• G06F16/2282

  Tablespace storage structures; Management thereof · CPC title

• G06F16/215 Primary

  Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors · CPC title

• G06F16/2379

  Updates performed during online database operations; commit processing · CPC title