Data Quality Rule

The Data Quality Rule feature provides the functionality to create and set rules in the system to ensure the quality of data.

Key Term:
  • Administrator: a technical specialist who configures a software system.
Description:
  • This feature allows an administrator to create rules to ensure that data quality is maintained in the system.

  • This feature allows data quality rules to be customized.

  • This feature has two main types of rule: Rule Violation and Normalization.

    Rule Violation: alerts a user about a violated rule with an error message. Normalization: reduces data redundancy and improves the data integrity.

Related topics:
Application:
  • Data Quality Rule restricts the entry of unacceptable data in the system.

  • Data Quality Rule reduces the effort in identifying data quality issues in many common information domains.

  • Data Quality Rule customizes the rules for specific data conditions.

  • Example:

    An administrator does not want to see blacklisted words (or for these words to be added) in the product information pages (e.g. Bomb, Suicide, Shit, etc). In an attribute value (e.g. Description), a rule can be customized that will show a notification message if blacklisted words are added in the description field of a product.

How-to: Data Quality Rule

To do this data governance feature, follow these steps:


  • Go to Administration.
../../../../../_images/pxp_dataqualityrule_gotoadministration.PNG


  • Under Data Governance, go to the Rule Configuration section.
../../../../../_images/pxp_dataqualityrule_gotoruleconfiguration.PNG


  • Click on the ‘+’ icon to create a new rule.
../../../../../_images/pxp_dataqualityrule_clickplus.PNG


../../../../../_images/pxp_dataqualityrule_clickplus2.PNG


  • Provide a name for the rule and click on the Attributes and Classes where the data quality rule will be applied.
../../../../../_images/pxp_dataqualityrule_entername.PNG


../../../../../_images/pxp_dataqualityrule_entername2.PNG


  • Refer to the steps below for a data quality rule example applied to an attribute:

    • Select the attribute (in Cause) and then, add the warning (in Effect). Save all the changes.
    ../../../../../_images/pxp_dataqualityrule_selectattribute.PNG


    ../../../../../_images/pxp_dataqualityrule_selectattribute2cause.PNG


    • Click on the OK button.
    ../../../../../_images/pxp_dataqualityrule_clickok.PNG


    • Go to Products.
    ../../../../../_images/pxp_dataqualityrule_gotoproductsb.PNG


    • Click on the Create button and select the class.
    ../../../../../_images/pxp_dataqualityrule_clickcreate.PNG


    ../../../../../_images/pxp_dataqualityrule_clickcreate2.PNG


    Note: As indicated in the rule, the field cannot be empty. In runtime, if it’s blank, it will be highlighted for its rule violation. When you click on the warning message, the applied rule notification will appear.

    ../../../../../_images/pxp_dataqualityrule_note.PNG


Contentserv line