G - Physics – 06 – F
Patent
G - Physics
06
F
G06F 17/30 (2006.01) G06F 9/40 (2006.01)
Patent
CA 2326805
A database deletion tool that is configurable, extensible and adaptable to the changing structure of a database to provide a desired deletion. Embodiments of the invention are configurable in the tasks performed, extensible to new tables and changes to the database as the database develops, and adaptable in changes to the database structure (or schema) without requiring customization (i.e., through custom programming). Embodiments of the invention are programmed to identify the data delete rules associated with data to be deleted. Based on the rules identified, some embodiments will perform a top- down or bottom up deletion of data in the database. Top down deletion uses cascade operations (e.g., cascade delete) in the database. During a bottom up deletion, the tables affected by the cleanup may be recursively determined using metadata stored by the database system. An algorithm also determines the referential integrity constraints that affect the data requiring deletion. From this information, embodiments of the invention identify all the child tables affected, identify the data in the child tables that require deletion and then, from the bottom child tables up to the parent tables affected, delete the data required. In some embodiments, the database delete tool acts as a database cleanup tool which removes unwanted data from a database.
Ibm Canada Limited - Ibm Canada Limitee
Rosen Arnold
LandOfFree
Method and apparatus for deleting data in a database does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and apparatus for deleting data in a database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for deleting data in a database will most certainly appreciate the feedback.
Profile ID: LFCA-PAI-O-1769625