Method for inserting records into a database

Details Method for inserting records into a database Method for inserting records into a database

2008-03-25

2008-03-25

Wong, Don (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

10923548

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: 6957225 (2005-10-01), Zait et al.
patent: 7162505 (2007-01-01), Rielau 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 Database Version 8, DB2 SQL Query Compiler Development, IBM Toronto Lab Sep. 2002, © 2002 IBM, Croporation, http://227b.software.ibm.com/dmdd/library/techarticle/0209rielau/0209rielau.htm).
IBM Marketing Announcement, Jul. 23, 2002. Preview: IBM DB2 Universal Database, V9.1, Delivery Enhanced Scalability, Manageability, and Availability for e-business Depolyment—Beta is Available http://www.ibmlink.ibm.com/PS/EMEA/ZA020235.PS).

Affiliated with

Also associated with

Rating

Method for inserting records into a database 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 for inserting records into a database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for inserting records into a database will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3906802