System for reducing overhead of validating constraints in a database
AssigneeInternational Business Machines Corporation
InventorsQI CHENG, HAIDER ABBAS RIZVI, CALISTO PAUL ZUZARTE
Life of this patent
Estimating the term…
Abstract
System for reducing the overhead of validating constraints in a database are provided. A target table and a source table are provided. The source table includes data to be loaded into the target table. Data is loaded into the target table from the source table including eliminating any logic to validate a constraint defined on the target table based on one or more pre-determined conditions.
Claims13
A computer program product tangibly stored on a computer-readable medium for loading data from a source table to a target table, the product comprising program instructions executed by a programmable processor to:
- provide a target table;
- provide a source table, the source table including data to be loaded into the target table;
- and
- load data into the target table from the source table including instructions to eliminate any logic to validate a constraint defined on the target table in response to one or more pre-determined conditions being met, the eliminating of any logic including not adding on the target table the logic to validate the constraint defined on the target table and wherein the logic is eliminated while keeping the constraints defined on the target table, the one or more pre-determined conditions including:
- verification that the constraint defined on the target table includes a similar definition to a similar constraint defined on the source table, and
- determination that the data has been validated prior to validating the constraint on the target table, the prior validation being against the similar constraint defined on the source table.
A database management system comprising:
- a target table;
- a source table including data to be loaded into the target table;
- and
- constraint validation logic operable to eliminate any logic to validate a constraint defined on the target table in response to one or more pre-determined conditions being met during loading of the data from the source table into the target table, the eliminating of any logic including not adding on the target table the logic to validate the constraint defined on the target table and wherein the logic is eliminated while keeping the constraints defined on the target table, the one or more pre-determined conditions including
- verification that the constraint defined on the target table includes a similar definition to a similar constraint defined on the source table, and
- determination that the data has been validated prior to validating the constraint on the target table, the prior validation being against the similar constraint defined on the source table.
Dependencies are inferred from the claim text.