摘要 |
Embodiments relate to methods and apparatuses implementing database-level consistency checking in a declarative manner. A consistency engine within the database layer may access one or more consistency rules in the form of a table or executable program code. Based upon application of these consistency rules to records comprising combinations of data characteristics, the consistency engine may determine the validity or invalidity those records. Consistency rules may implement a‘check’method, and also a‘derive’method allowing derivation of data characteristics (targets) in a record from other characteristics (sources) in the record. Filters may be used to split data records to sets of records having all fields assigned, and those having‘not assigned’fields. Consistency rules used for derivation methods can be nested. Also, in certain embodiments a consistency engine may use filtering techniques for constraint checking including multi-level derivations in a declarative way. |