Data processing: database and file management or data structures – Database and file access – Record – file – and data search and comparisons
Reexamination Certificate
2009-02-23
2011-11-22
Breene, John E (Department: 2162)
Data processing: database and file management or data structures
Database and file access
Record, file, and data search and comparisons
C707S770000, C707SE17014, C707SE17045
Reexamination Certificate
active
08065323
ABSTRACT:
An aspect of the present invention performs offline validation of data in database system for foreign key constraints. In an embodiment, a foreign key constraint defined for a database system is identified and an SQL script designed to verify whether data values stored in a foreign key column of a detail table is present in a primary key column of a master table (corresponding to the identified foreign key constraint), is generated. The SQL script is executed to determine whether the data stored in the database system satisfies the identified foreign key constraint.
REFERENCES:
patent: 4947320 (1990-08-01), Crus et al.
patent: 5956725 (1999-09-01), Burroughs et al.
patent: 6151608 (2000-11-01), Abrams
patent: 6560598 (2003-05-01), Delo et al.
patent: 6795821 (2004-09-01), Yu
patent: 7136868 (2006-11-01), Sonkin et al.
patent: 7401094 (2008-07-01), Kesler
patent: 2002/0059187 (2002-05-01), Delo et al.
patent: 2004/0093559 (2004-05-01), Amaru et al.
patent: 2004/0153435 (2004-08-01), Gudbjartsson et al.
patent: 2005/0283501 (2005-12-01), Blaicher et al.
patent: 2006/0224637 (2006-10-01), Wald
patent: 2007/0038618 (2007-02-01), Kosciusko et al.
patent: 2007/0174234 (2007-07-01), Ramsey
patent: 2007/0208787 (2007-09-01), Cheng et al.
patent: 2007/0226196 (2007-09-01), Adya et al.
patent: 2008/0183766 (2008-07-01), Weston et al.
patent: 2009/0024652 (2009-01-01), Thompson et al.
patent: 2009/0024677 (2009-01-01), Cheng et al.
patent: 2009/0292711 (2009-11-01), Konik et al.
D. Gomik—“UML Data Modeling Profile”—Relational Corporation IBM—TP162, May 2002 (pp. 1-13).
Sun Microsystems—Sun GlassFish Enterprise Server—SGFE server 2.1 Developer's Guide—Jan. 2009 (pp. 1-318).
“Lihua Ran et al.,”, “AUTODBT: A Framework for Automatic Testing of Web Database Applications”, “http://cat.inist.fr/?aModele=afficheN&cpsidt=16368005”, Dated: Nov. 22, 2004, p. 1, vol. 3306.
“DTM Data Generator—Realistic Data for Database Testing Purposes”, “http://www.sqledit.com/dg/”, Copyright Date: 2004-2008, p. 1.
“Michael Kelly et al.,”, “Effective Database Testing With IBM Rational Functional Tester 6.1”, “http://www.ibm.com/developerworks/rational/library/05/0906—kelly/index.html”, Updated Date: Nov. 10, 2005, pp. 1-12.
“LDC's Automated Data Validation (ADV)”, “http://www.lab-data.com/adv.htm”, Downloaded Circa: Nov. 11, 2008, p. 1.
“Migrating ZIM Applications to Oracle and Other SQL DBMS”, “http://www.bakersoftwaretechnologies.com/torch.pps”, Downloaded Circa: Nov. 11, 2008, pp. 1-49.
“Softinabox Script Engine 0.3.0 Build 52 (Beta 3)”, “http://www.softpedia.com/get/Internet/Servers/Database-Utils/Softinabox-Script-Engine.shtml”, Last Updated Date: Oct. 28, 2005, pp. 1-2.
“Validating a Database”, “http://opensitesearch.sourceforge.net/docs/helpzone/dbb/dbb—50-20-90t.html”, Downloaded Circa: Nov. 11, 2008, pp. 1-2.
Ayyamperumal Selvaganapathy
Bear Mary E. G
Sallakonda Satish Kumar
Breene John E
Ly Anh
Oracle International Corporation
Thappeta Narendra Reddy
LandOfFree
Offline validation of data in a database system for foreign... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Offline validation of data in a database system for foreign..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Offline validation of data in a database system for foreign... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4273785