Data processing: database and file management or data structures – File or database maintenance
Reexamination Certificate
2008-01-25
2010-11-23
Wong, Don (Department: 2163)
Data processing: database and file management or data structures
File or database maintenance
C707S649000, C707S679000
Reexamination Certificate
active
07840531
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: 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: 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,Updatable UNION ALL Views in DB2 Universal Datatbase 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.
Chen Zhimin
Liu Linqi
Qian Xiaoyan
Rielau Serge Philippe
International Business Machines - Corporation
Nguyen Merilyn P
Sughrue & Mion, PLLC
Wong Don
LandOfFree
System and computer program for inserting records into a... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System and computer program for inserting records into a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and computer program for inserting records into a... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4247301