Data processing: database and file management or data structures – Database and file access – Search engines
Reexamination Certificate
2011-04-19
2011-04-19
Rones, Charles (Department: 2164)
Data processing: database and file management or data structures
Database and file access
Search engines
Reexamination Certificate
active
07930291
ABSTRACT:
Constraint processing for a relational database generates primary (e.g., based on primary key values) and constraint index records (e.g., based on foreign key values) during table load operations that are then sorted in a manner that rapidly and unambiguously identifies rows that fail the specified constraint test. Rows so identified may be deleted to maintain the constraint (e.g., referential) integrity of a child table. In one case, child table row data may be processed in constraint key order, eliminating the need first load the child table with row data and then delete those rows that subsequently fail the integrity test.
REFERENCES:
patent: 4933848 (1990-06-01), Haderle et al.
patent: 4947320 (1990-08-01), Crus et al.
patent: 5706494 (1998-01-01), Cochrane et al.
patent: 6098075 (2000-08-01), Becraft 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: 2004/0122828 (2004-06-01), Sidle et al.
patent: 2004/0122868 (2004-06-01), Chan et al.
Blaicher Christopher Youngs
Bright Randol Keith
Tenberg Kerry Charles
BMC Software Inc.
Quader Fazlul
Rones Charles
Wong, Cabello, Lutsch, Rutherford & Brucculeri L.L.P.
LandOfFree
Constraint 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 Constraint processing, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Constraint processing will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2735852