The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Feb. 16, 2010
Filed:
Jun. 18, 2004
Christopher Youngs Blaicher, Austin, TX (US);
Kerry Charles Tenberg, Austin, TX (US);
Randol Keith Bright, Austin, TX (US);
Christopher Youngs Blaicher, Austin, TX (US);
Kerry Charles Tenberg, Austin, TX (US);
Randol Keith Bright, Austin, TX (US);
BMC Software, Inc., Houston, TX (US);
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.