Patent ID: 7840531

Claim:
A computer program product for directing a data processing system to process a record to be inserted into a database, the database comprising a plurality of base tables, the computer program product comprising: a computer readable medium tangibly embodying computer executable code for directing the data processing system, the computer executable code comprising: code for making a record copy matching the record; code to be executed for each base table to be selected from the plurality of base tables, the code to be executed comprising: code for 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 on the record copy, the before triggers and the constraints being associated with the selected base table, and the base table candidate indication being recorded in a computer-readable storage medium; and code for 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.