Cascade delete processing

Details Cascade delete processing Cascade delete processing

2004-06-18

2010-02-16

Alam, Hosain T (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

07664790

ABSTRACT:
A time-efficient means for identifying and processing cascading deletes due to referential constraint violations includes: logging, to an error file, all primary key (“PK”) errors detected during table load operations; building a foreign key (“FK”) index for each child table; recursively probing each relevant FK index to identify all loaded rows that violate a referential constraint due to a PK error; logging all identified FK errors to the error file; and using the (preferably sorted) error file contents to identify, mark and physically delete table rows that violate a referential constraint. The described cascade delete processing methods make only a single pass through the table data, using ordinary computer files to track and organize rows identified for deletion. Use of error files rather than tablescans (multiple passes through the loaded table data) can provide a significant reduction in table load times, especially for large or intricately “related” tables.

REFERENCES:
patent: 4933848 (1990-06-01), Haderle et al.
patent: 4947320 (1990-08-01), Crus et al.
patent: 5133068 (1992-07-01), Crus et al.
patent: 5706494 (1998-01-01), Cochrane et al.
patent: 5745896 (1998-04-01), Vijaykumar
patent: 6098075 (2000-08-01), Becraft et al.
patent: 6163783 (2000-12-01), Hintz et al.
patent: 6189010 (2001-02-01), Isip, Jr.
patent: 6295539 (2001-09-01), Isip, Jr.
patent: 6304876 (2001-10-01), Isip, Jr.
patent: 6427143 (2002-07-01), Isip et al.
patent: 6453314 (2002-09-01), Chan et al.
patent: 7251650 (2007-07-01), Jin et al.
Gennick et al., “Oracle SQL Loader: The Definitive Guide”, O'Reilly Publisher, Apr. 2001.

Affiliated with

Also associated with

Rating

Cascade delete processing does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Cascade delete processing, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Cascade delete processing will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4185213