Abstract: Provided are techniques for receiving a request to archive a child table. In response to receiving the request, a join operation is performed on the child table and parent archive data to create child archive data.

Abstract: 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.

Abstract: A method, computer program product, and system for deleting data from a child table with a plurality of parent tables are provided. The method, computer program product, and system provide for deleting data from the child table that is qualified by each parent table and deleting data from the child table that is qualified by only one parent table and is not related to data from any other parent table.