AUTOMATED HYBRID CONSTRAINT DATABASE MANAGER

摘要

Automated database manager aspects selectively apply different active constraints within a definition statement for a hybrid constraint name to a relational database management system table data field. One at a time the definition statement constraints are selected and tested, their logical set values to TRUE in response to the testing meeting their defined conditions and an OR statement output generated of the logical values of all of the hybrid constraint name definition statement constraints, wherein the logical values are linked by logical OR operators and the output is TRUE in response to the logical value of any one of the constraints having a logical value of TRUE. In response to the OR statement output set to TRUE, the data operation is performed on the target table name and affected column name without testing any other untested ones of the constraints within the definition statement.

主权项

1. A computer-implemented method for an automated database manager that selectively applies different constraints of a hybrid constraint definition to a table data field of a relational database management system, the method comprising executing on a computer processor the steps of:
in response to determining that a hybrid constraint name is active for field data values of a target table name and an affected column name for a data operation, identifying each of a plurality of different constraints within a definition statement for the hybrid constraint name that are each individually active for the field data values of the target table name and the affected column name for the data operation, wherein the data operation is an insert, an update, or a delete operation; selecting an untested one of the plurality of constraints of the definition statement; testing a field data value of the target table name and affected column name for defined conditions of the selected constraint, and setting a logical value of the selected constraint to TRUE in response to the testing of the field data value meeting the defined conditions of the selected constraint, wherein each of untested ones of the plurality of different constraints within the definition statement have logical values of FALSE; in response to each testing of the selected ones of the plurality of different constraints within the definition statement, generating an OR statement output of the logical values of all of the plurality of different constraints within the definition statement, wherein the logical values are linked by logical OR operators and the output is TRUE in response to any one of the logical values of all of the plurality of different constraints within the definition statement having a logical value of TRUE; and in response to the OR statement output having a logical value of TRUE, performing the data operation on the target table name and affected column name without testing any other untested ones of the plurality of different constraints within the definition statement.