Data Quality: The Accuracy Dimension (The Morgan Kaufmann Series in Data Management Systems)

B.7 Data Rules

• Name of rule

• Description of business meaning

• Table names and column names used

• Execution logic

  • Rule logic expression or program or procedure name

• Execution results

  • Date executed

  • Number of rows

  • RowID list of violations with data

• Remedy implementation

  • Date/time implemented

  • Type of implementation

    • Data entry

    • Transaction program

    • Database-stored procedure

    • Periodic checker execution

    • Business process procedure