Mass delete restriction in a database
First Claim
Patent Images
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.
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
15 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. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
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. - View Dependent Claims (8, 9, 10, 11)
-
-
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. - View Dependent Claims (13, 14, 15)
-
Specification