Constraints

Previous Next

A constraint is a programmatic construct, typically a SQL statement, that guarantees that business data in a USoft application meet some kind of restriction. For example, a constraint could guarantee that the total of salaries in a given country of operation never exceeds a given amount.

A cornerstone idea in the USoft approach is that business rules take the form, in an IT system, of business data that exhibit some form of data quality. In summary, in USoft, constraints implement business rules.

USoft Teamwork lets you (optionally) register the business rules you have. It also lets you register which constraints implement which rules. For details, see the USoft Teamwork Guide.

 

Click on a subject to continue:

Domain constraints

Table constraints

Transitional constraints

Constraint messages

Constraint comments

Deferred table constraints

Recursive constraints

Time constraints

Constraint implementation

USoft Rule Language