Adapting Data Quality Rules Based Upon User Application Requirements

• US 20160188688A1
• Filed: 03/09/2016
• Published: 06/30/2016
• Est. Priority Date: 06/30/2011
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Dani, Mohan N., Gupta, Anuj, Mohania, Mukesh K., Venkatachaliah, Girish
• Granted Patent: US 10,318,500 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence

Abstract

During application of data quality rules to a data set obtained from a data source, data is retrieved from the data source along with a common set of rules configured to format the retrieved data in a manner in accordance with one or more predefined data quality rules of the common set of rules. At least one predefined data quality rule is adjusted utilizing at least one editable widget to form a modified set of data quality rules adapted for use with a specified application. The modified set of data quality rules is applied to the retrieved data.

Claims

1. A computer-implemented method of applying data quality rules to a data set obtained from at least one data source, comprising:

receiving data retrieved from the at least one data source along with a common set of rules configured to format the retrieved data in a manner in accordance with one or more predefined data quality rules of the common set of rules;

modifying the common set of rules utilizing at least one editable widget in accordance with a specified application during operation of the specified application to form a modified set of data quality rules; and

applying the modified set of data quality rules to the retrieved data to output the retrieved data in accordance with the modified set of data quality rules by the specified application.

2. The method of claim 1, wherein each editable widget is associated with an entity that defines a category of data records, and the modified set of data quality rules is applied to records or columns of the retrieved data.

4. The method of claim 1, further comprising:

generating an editable widget by selecting attributes from data tables of the at least one data source and grouping the selected attributes with the editable widget.

5. The method of claim 4, wherein each editable widget facilitates modification of a predefined data quality rule applied to one attribute associated with the editable widget separately from another attribute associated with the editable widget.

6. The method of claim 4, wherein each editable widget comprises a first graphical user interface listing attributes associated with the editable widget and at least one additional graphical user interface comprising at least one editable field that facilitates modification of a predefined data quality rule.

7. The method of claim 1, wherein the common set of rules is provided to a first client and a second client, the first client adjusts at least one predefined data quality rule utilizing a first editable widget to form a first modified set of data quality rules, and the second client adjusts at least one predefined data quality rule utilizing a second editable widget to form a second modified set of data quality rules that differs from the first modified set of data quality rules.

3. (canceled)