Patent ID: 7788241

Claim:
A method for loading data from a source table to a target table on a data processing system, the method comprising: providing a target table, wherein a constraint is defined on the target table such that validation of data against the constraint allows the data that passes the constraint to be loaded into the target table; providing a source table, the source table including particular data to be loaded into the target table; loading the particular data into the target table from the source table including: 1) using the data processing system to check whether a plurality of pre-determined conditions have been met, the predetermined conditions including a) the data processing system verifying that the constraint defined on the target table includes a similar definition to a constraint defined on the source table; and b) the data processing system checking the source table to determine that the particular data is validated against the constraint defined on the source table prior to loading the particular data into the target table; and 2) in response to the plurality of pre-determined conditions being met, avoiding validation of particular data against the constraint defined on the target table during the loading of the particular data into the target table, wherein the avoiding validation includes avoiding defining validation logic on the target table or removing pre-existing validation logic defined on the target table, wherein the avoiding validation is performed while keeping the constraint constraints defined on the target table.