Browse Prior Art Database

A Tool to Help Users Intelligently Delete Objects from a Database

IP.com Disclosure Number: IPCOM000123873D
Original Publication Date: 1999-Jun-01
Included in the Prior Art Database: 2005-Apr-05
Document File: 1 page(s) / 38K

Publishing Venue

IBM

Related People

Ku, WH: AUTHOR [+3]

Abstract

A program is disclosed that helps a user intelligently delete objects from a database that contains multiple tables. When an object is selected to be deleted, this tool displays a Graphical User Interface (GUI) that shows the user all of the objects in other tables in the database that are related to the object that was selected to be deleted.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 77% of the total text.

A Tool to Help Users Intelligently Delete Objects from a Database

   A program is disclosed that helps a user intelligently
delete objects from a database that contains multiple tables.  When
an object is selected to be deleted, this tool displays a Graphical
User Interface (GUI) that shows the user all of the objects in other
tables in the database that are related to the object that was
selected to be deleted.

   As more and more sophisticated applications are developed,
the databases that are associated with these applications are
becoming more and more complicated.  These databases may have
multiple tables where objects in one table are related to objects in
other tables.

   Currently, when an object is deleted from one table in
these complicated databases, the user does not know which objects in
the other tables are affected.  If the user deletes objects without
knowing which other objects are affected, he could jeopardize the
consistency and integrity of the database.

   The solution to this problem is to provide an intelligent
delete tool.  This tool would display a GUI that shows the user
which objects in other tables are related to the object that was
originally selected to be deleted.  The tool would then give the
user the following choices:
  o  Do not delete the selected object or any of its related
     objects.
  o  Delete only the selected object, but do not delete any
     of its related objects.
  o  Delete the selected object and...