Mass delete restriction in a database

• US 9,405,788 B2
• Filed: 01/24/2014
• Issued: 08/02/2016
• Est. Priority Date: 01/24/2014
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Kliewe, John M.
• Primary Examiner(s): Lu, Charles
• Application Number:
  US14/163,684
• Publication Number:
  US 20150213078A1
• Time in Patent Office: 921 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 from a user corresponding to data in a database table;

the computer determining whether the database table includes a restriction of a mass deletion of data from the database table, wherein the restriction of a mass deletion is one that specifies a threshold quantity of rows in the database table;

the computer receiving a request from the user to remove the mass deletion restriction on the database table;

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

the computer, responsive to receiving the request from the user to remove the mass deletion restriction, receiving a command from an owner of the database table to suspend the mass deletion restriction.

2. 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.

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

4. 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.

5. 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.

6. The method of claim 1, wherein the computer receiving a command from an owner of the database table to suspend the mass deletion restriction further comprises the computer receiving a data definition language (DDL) command.

7. 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 from a user 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 the database table, wherein the restriction of a mass deletion is one that specifies a threshold quantity of rows in the database table;

program instructions to receive a request from the user to remove the mass deletion restriction on the database table;

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

responsive to receiving the request from the user to remove the mass deletion restriction, program instructions to receive a command from an owner of the database table to suspend the mass deletion restriction.

8. The computer program product of claim 7, 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.

9. The computer program product of claim 7, further comprising, responsive to determining the number of rows of data in the deletion request does not exceed the restriction of a mass deletion, program instructions to allow execution of the deletion request.

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

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

12. 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 from a user 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 the database table, wherein the restriction of a mass deletion is one that specifies a threshold quantity of rows in the database table;

program instructions to receive a request from the user to remove the mass deletion restriction on the database table;

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

responsive to receiving the request from the user to remove the mass deletion restriction, program instructions to receive a command from an owner of the database table to suspend the mass deletion restriction.

13. The computer system of claim 12, 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.

14. The computer system of claim 12, further comprising, responsive to determining the number of rows of data in the deletion request does not exceed the restriction of a mass deletion, program instructions to allow execution of the deletion request.

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