Adapting data quality rules based upon user application requirements
First Claim
Patent Images
1. A system for applying data quality rules to a data set obtained from at least one data source, the system comprising:
- a client including at least one processor configured to;
generate an editable widget, the generating comprising the at least one processor being further configured to;
select attributes from data tables of the at least one data source,discover patterns corresponding to the selected attributes,determine which rules of a common set of rules to apply to the widget based on the discovered patterns, andgroup the determined rules of the common set of rules with corresponding selected attributes for selection and modification by editing the widget;
receive, in response to a query, data retrieved from the at least one data source and the common set of rules retrieved from a rules database, the common set of rules including one or more predefined data quality rules that are fixed and applicable to extracting and formatting data in a same manner for each client requesting data from any of the at least one data source;
modify the common set of rules to form a modified set of data quality rules for the editable widget in accordance with requirements of a specified application, residing on the client, during operation of the specified application, the modified set of data quality rules being different from the common set of rules, the common set of rules being modified by editing the editable widget residing on the client, the editable widget including a user interface having adjustable control objects that facilitate making adjustments to the received data to further adapt the received data for use with the specified application based upon the requirements; and
apply, by the client, 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 for the specified application executing on the client.
1 Assignment
0 Petitions
Accused Products
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.
98 Citations
13 Claims
-
1. A system for applying data quality rules to a data set obtained from at least one data source, the system comprising:
a client including at least one processor configured to; generate an editable widget, the generating comprising the at least one processor being further configured to; select attributes from data tables of the at least one data source, discover patterns corresponding to the selected attributes, determine which rules of a common set of rules to apply to the widget based on the discovered patterns, and group the determined rules of the common set of rules with corresponding selected attributes for selection and modification by editing the widget; receive, in response to a query, data retrieved from the at least one data source and the common set of rules retrieved from a rules database, the common set of rules including one or more predefined data quality rules that are fixed and applicable to extracting and formatting data in a same manner for each client requesting data from any of the at least one data source; modify the common set of rules to form a modified set of data quality rules for the editable widget in accordance with requirements of a specified application, residing on the client, during operation of the specified application, the modified set of data quality rules being different from the common set of rules, the common set of rules being modified by editing the editable widget residing on the client, the editable widget including a user interface having adjustable control objects that facilitate making adjustments to the received data to further adapt the received data for use with the specified application based upon the requirements; and apply, by the client, 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 for the specified application executing on the client. - View Dependent Claims (2, 3, 4, 5, 10, 12)
-
6. A computer program product for applying data quality rules to a data set obtained from at least one data source, the computer program product comprising:
a computer readable storage medium having computer readable program code embodied therewith such that when a client executes the computer readable program code, the client is configured to; generate an editable widget, the generating comprising the client being further configured to; select attributes from data tables of the at least one data source, discover patterns corresponding to the selected attributes by a context based pattern discovery method, determine which rules of a common set of rules to apply to the widget based on the discovered patterns, and group the determined rules of the common set of rules with corresponding selected attributes for selection and modification by editing the widget; receive, in response to a query, data retrieved from the at least one data source along with the common set of rules retrieved from a rules database, the common set of rules including one or more predefined data quality rules that are fixed and applicable to extracting and formatting data in a same manner for each client requesting data from any of the at least one data source; modify the common set of rules to form a modified set of data quality rules for the editable widget in accordance with requirements of a specified application, residing on the client, during operation of the specified application, the modified set of data quality rules being different from the common set of rules, the common set of rules being modified by editing the editable widget residing on the client, the editable widget including a user interface having adjustable control objects that facilitate making adjustments to the received data to further adapt the received data for use with the specified application based upon the requirements; and apply, by the client, 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 for the specified application executing on the client. - View Dependent Claims (7, 8, 9, 11, 13)
Specification