System and computer program for inserting records into a...

Data processing: database and file management or data structures – File or database maintenance

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

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.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

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.

Rate now

     

Profile ID: LFUS-PAI-O-4247301

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.