MASS DELETE RESTRICTION IN A DATABASE

• US 20150213078A1
• Filed: 01/24/2014
• Published: 07/30/2015
• Est. Priority Date: 01/24/2014
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Kliewe, John
• Granted Patent: US 9,405,788 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 21/62 Protecting access to data via a platform, e.g. using keys or access control rules

Abstract

In an approach for limiting mass deletions from database tables, a computer receives a deletion request corresponding to data in a database table. The computer determines whether the database table includes a restriction of a mass deletion. Responsive to determining the database table includes a restriction of a mass deletion of data from a database table, the computer determines whether the quantity of data in the deletion request exceeds the restriction of a mass deletion. Responsive to determining the quantity of data in the deletion request exceeds the restriction of a mass deletion, the computer prevents execution of the deletion request.

Claims

1. A method for limiting mass deletions from database tables, the method comprising:

a computer receiving a deletion request corresponding to data in a database table;

the computer determining whether the database table includes a restriction of a mass deletion of data from a database table;

the computer, responsive to determining the database table includes a restriction of a mass deletion of data from a database table, determining whether the quantity of data in the deletion request exceeds the restriction of a mass deletion; and

the computer, responsive to determining the quantity of data in the deletion request exceeds the restriction of a mass deletion, preventing execution of the deletion request.

2. The method of claim 1, further comprising, responsive to preventing the execution of the deletion request, the computer returning an error message.

3. The method of claim 1, further comprising, responsive to determining the database table does not include a restriction of a mass deletion, the computer allowing execution of the deletion request.

4. The method of claim 1, further comprising, responsive to determining the quantity of data in the deletion request does not exceed the restriction of a mass deletion, the computer allowing execution of the deletion request.

5. The method of claim 1, wherein the restriction of a mass deletion is defined by a database table owner at a time the database table is created.

6. The method of claim 1, wherein the restriction of a mass deletion is one that specifies a threshold quantity of rows in a database table.

7. The method of claim 1, wherein the restriction of a mass deletion is one that specifies a threshold percentage of rows in a database table.

8. A computer program product for limiting mass deletions from database tables, the computer program product comprising:

one or more computer-readable storage media and program instructions stored on the one or more computer-readable storage media, the program instructions comprising;

program instructions to receive a deletion request corresponding to data in a database table;

program instructions to determine whether the database table includes a restriction of a mass deletion of data from a database table;

responsive to determining the database table includes a restriction of a mass deletion of data from a database table, program instructions to determine whether the quantity of data in the deletion request exceeds the restriction of a mass deletion; and

responsive to determining the quantity of data in the deletion request exceeds the restriction of a mass deletion, program instructions to prevent execution of the deletion request.

9. The computer program product of claim 8, further comprising, responsive to preventing the execution of the deletion request, program instructions to return an error message.

10. The computer program product of claim 8, further comprising, responsive to determining the database table does not include a restriction of a mass deletion, program instructions to allow execution of the deletion request.

11. The computer program product of claim 8, further comprising, responsive to determining the quantity of data in the deletion request does not exceed the restriction of a mass deletion, program instructions to allow execution of the deletion request.

12. The computer program product of claim 8, wherein the restriction of a mass deletion is defined by a database table owner at a time the database table is created.

13. The computer program product of claim 8, wherein the restriction of a mass deletion is one that specifies a threshold quantity of rows in a database table.

14. The computer program product of claim 8, wherein the restriction of a mass deletion is one that specifies a threshold percentage of rows in a database table.

15. A computer system for limiting mass deletions from database tables, the computer system comprising:

one or more computer processors;

one or more computer-readable storage media;

program instructions stored on the computer-readable storage media for execution by at least one of the one or more processors, the program instructions comprising;

program instructions to receive a deletion request corresponding to data in a database table;

program instructions to determine whether the database table includes a restriction of a mass deletion of data from a database table;

responsive to determining the database table includes a restriction of a mass deletion of data from a database table, program instructions to determine whether the quantity of data in the deletion request exceeds the restriction of a mass deletion; and

responsive to determining the quantity of data in the deletion request exceeds the restriction of a mass deletion, program instructions to prevent execution of the deletion request.

16. The computer system of claim 15, further comprising, responsive to preventing the execution of the deletion request, program instructions to return an error message.

17. The computer system of claim 15, further comprising, responsive to determining the database table does not include a restriction of a mass deletion, program instructions to allow execution of the deletion request.

18. The computer system of claim 15, further comprising, responsive to determining the quantity of data in the deletion request does not exceed the restriction of a mass deletion, program instructions to allow execution of the deletion request.

19. The computer system of claim 15, wherein the restriction of a mass deletion is one that specifies a threshold quantity of rows in a database table.

20. The computer system of claim 15, wherein the restriction of a mass deletion is one that specifies a threshold percentage of rows in a database table.