International Business Machines Corporation

Allan Eugene Gillespie

Terry Michael Bleizeffer

Tony Kai-chi Leung

Stan Wong

Eileen Felicia Kopp

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.

Reduction of join operations when archiving related database tables

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.

Deletion of data from child tables with multiple parents

A method, apparatus, and article of manufacture for computer-implemented creation of customized tree. A customized tree is created in a computer from an original tree. The original tree contains objects from a data storage device connected to the computer. One or more objects are selected from the original tree to be contained in the customized tree in response to user input. The selected objects are linked in a user-specified manner.

Growing community of inventors

Danville, CA, United States of America

Allan Eugene Gillespie