Data processing: database and file management or data structures – Data integrity – Triggers – stored procedures – user defined function
Reexamination Certificate
2007-07-23
2010-12-28
LeRoux, Etienne P (Department: 2166)
Data processing: database and file management or data structures
Data integrity
Triggers, stored procedures, user defined function
C707S609000, C707S687000, C707S690000, C707S691000
Reexamination Certificate
active
07860845
ABSTRACT:
For a data processing system having memory for storing a database, a method, a system and a computer program product for directing the data processing system to process a record to be inserted into the database is disclosed. The database includes a plurality of base tables. The method includes the steps of making a record copy matching the record, for each base table to be selected from the plurality of base tables: providing a base table candidate indication for a selected base table, the base table candidate indication indicating whether the selected base table is a candidate base table that may receive the record, the base table candidate indication being determined on an outcome of executing before triggers and an outcome of testing constraints in association with the record copy, the before triggers and the constraints being associated with the selected base table; and restoring the record copy so that the record copy matches the record before providing a next subsequent base table candidate indication for another base table to be selected.
REFERENCES:
patent: 5546576 (1996-08-01), Cochrane et al.
patent: 5680614 (1997-10-01), Bakuya et al.
patent: 5873075 (1999-02-01), Cochrane et al.
patent: 6078925 (2000-06-01), Anderson et al.
patent: 6421658 (2002-07-01), Carey et al.
patent: 6460052 (2002-10-01), Thomas et al.
patent: 6745174 (2004-06-01), Levy et al.
patent: 6882993 (2005-04-01), Lawande et al.
patent: 6957225 (2005-10-01), Zait et al.
patent: 7028057 (2006-04-01), Vasudevan et al.
patent: 7162505 (2007-01-01), Rielau et al.
patent: 7181461 (2007-02-01), Bonner et al.
patent: 7209933 (2007-04-01), Saxena
patent: 7257597 (2007-08-01), Pryce et al.
patent: 2003/0078923 (2003-04-01), Voss et al.
patent: 2005/0131964 (2005-06-01), Saxena
patent: 2005/0131966 (2005-06-01), Lou
Rielau,Updateable Union All views in DB2 Universal Database Version 8, DB2 SQL Query Compiler Development, IBM Toronto Lab Sep. 2002, © 2002 IBM, Corporation, http://227b.software.ibm.com/dmdd/library/techarticle/0209rielau/0209rielau.html).
IBM Marketing Announcement, Jul. 23, 2002. Preview: IBM DB2 Universal Database, V9.1, Delivery Enhanced Scalability, Manageability, and Availability for e-business Deployment—Beta is Available http://www.ibmlink.ibm.com/PS/EMEA/ZA020235.PS).
Notice of Allowance mailed Jul. 15, 2010 in U.S. Appl. No. 12/021,462.
Chen Zhimin
Liu Linqi
Qian Xiaoyan
Rielau Serge Philippe
International Business Machines - Corporation
LeRoux Etienne P
Sughrue & Mion, PLLC
Witzenburg Bruce A
LandOfFree
Method, system and computer program for inserting records... 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, system and computer program for inserting records..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method, system and computer program for inserting records... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4210290