Deletion of data from child tables with multiple parents
View Patent ↗A method, computer program product, and system delete a row from a child table. The method, computer program product, and system delete the requested child row from the child table if the query corresponds to each of the plurality of parent tables and each of the plurality of parent tables has a row with a linked parent column that has a same value as a linked child column in the requested child row from the child table. Alternatively, deletion is performed if the query corresponds to only one of the plurality of parent tables having a row with a linked parent column that has a same value as a linked child column in the requested row from the child table and, for each remaining parent table, no row has a linked column that has a same value as a linked column in the requested row from the child table.
1. A method comprising:
(a) linking, with a computer, a child table and a plurality of parent tables in a database such that, for each of the plurality of parent tables, the child table has a linked child column that is linked to a linked parent column;
(b) receiving a query for information corresponding to at least one of the plurality of parent tables;
(c) receiving a request to delete a requested child row from the child table;
(d) determine a first condition, the first condition being that the query corresponds to each of the plurality of a parent table and each of the plurality of parent tables has a row with a linked parent column that has a same value as a linked child column in the requested child row from the child table;
(e) deleting the requested child row from the child table upon the first condition being met; and
(f) determining a second condition, the second condition being that the query corresponds to only one of the plurality of parent tables that has a row with a linked parent column that has a same value as a linked child column in the requested row from the child table and, for each remaining parent table, no row has a linked column has a same value as a linked column in the requested row from the child table; and
(g) deleting the requested child row from the child upon the second condition being met.
2. The method of claim 1 , further comprising deleting, for each of the plurality of parent tables that has the row with the linked parent column that has the same value as the linked child column in the requested child row from the child table, the row with the linked parent column that has the same value as the linked child column in the requested child row from the child table upon the requested child row being deleted.
3. The method of claim 1 , wherein the query is from an application.
4. The method of claim 1 , wherein the query is a structured query language (SQL) statement.
5. A system comprising:
a database that stores a child table and a plurality of parent tables of the child table;
a database management system having a computer that controls access to and manipulation of data stored in the database; and
an application in communication with the database management system, wherein the application
(a) links, with the computer, a child table and a plurality of parent tables in a database such that, for each of the plurality of parent tables, the child table has a linked child column that is linked to a linked parent column;
(b) receives a query for information corresponding to at least one of the plurality of parent tables;
(c) receives a request to delete a requested child row from the child table;
(d) determines a first condition, the first condition being that the query corresponds to each of the plurality of parent tables and each of the plurality of parent tables has a row with a linked parent column that has a same value as a linked child column in the requested child row from the child table;
(e) deletes the requested child row from the child table upon the first condition being met; and
(f) determines a second condition, the second condition being that the query corresponds to only one of the plurality of parent tables that has a row with a linked parent column that has a same value as a linked child column in the requested row from the child table and, for each remaining parent table, no row has a linked column that has a same value as linked column in the requested row from the child table; and
(g) deletes the requested child row from the child table upon the second condition being met.
6. The system of claim 5 , wherein the application deletes, for each of the plurality of parent tables that has the row with the linked parent column that has the same value as the linked child column in the requested child row from the child table, the row with the linked parent column that has the same value as the linked child column in the requested child row from the child table upon the requested child row being deleted.
7. The system of claim 5 , wherein the query is from an application.
8. A computer program product comprising a computer readable storage medium, the computer readable storage medium including a computer readable program for deleting data from a child table with a plurality of parent tables, wherein the computer readable program when executed on a computer causes the computer to:
(a) link, with a computer, a child table and a plurality of parent tables in a database such that, for each of the plurality of parent tables, the child table has a linked child column that is linked to a linked parent column;
(b) receive a query for information corresponding to at least one of the plurality of parent tables;
(c) receive a request to delete a requested child row from the child table;
(d) determine a first condition, the first condition being that the query corresponds to each of the plurality of parent tables and each of the plurality of parent tables has a row with a linked parent column that has a same value as a linked child column in the requested child row from the child table;
(e) delete the requested child row from the child table upon the first condition being met; and
(f) determine a second condition, the second condition being that the query corresponds to only one of the plurality of parent tables that has a row with a linked parent column that has a same value as a linked child column in the requested row from the child table and, for each remaining parent table, no row has a linked column that has a same value as a linked column in the requested row from the child table; and
(g) delete the requested child row from the child table upon the second condition being met.
9. The computer program product of claim 8 , wherein the computer readable program when executed on the computer further causes the computer to delete, for each of the plurality of parent tables that has the row with the linked parent column that has the same value as the linked child column in the requested child row from the child table, the row with the linked parent column that has the same value as the linked child column in the requested child row from the child table upon the requested child row been deleted.
10. The computer program product of claim 8 , wherein the query is from an application.
11. The computer program product of claim 8 , wherein the query is a structured query language (SQL) statement.