IP Library Granted Patent US 10,318,500
Granted Patent B2
US 10,318,500 · App. 15/064,783 · Granted Jun 11, 2019

Adapting data quality rules based upon user application requirements

Inventors: Mohan N. Dani (Chamarajpet Bangalore, IN); Anuj Gupta (New Delhi, IN); Mukesh K. Mohania (Agra, IN); Girish Venkatachaliah (San Jose, CA)
Assignee: International Business Machines Corporation
G06F16/215G06F3/0482G06F3/04842G06F16/2365G06F16/252G06F16/258
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 10,318,500
App. No.
15/064,783
Granted
Jun 11, 2019
Kind
B2
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 (16)

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

generating, at a client, an editable widget, the generating comprising:

selecting attributes from data tables of at least one data source,

discovering patterns corresponding to the selected attributes,

determining which rules of a common set of rules to apply to the widget based on the discovered patterns, and

grouping the determined rules of the common set of rules with corresponding selected attributes for selection and modification by editing the widget;

receiving, at the client 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;

modifying, by the client, 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

applying, 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.

2. The method of claim 1 , wherein the 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.

3. The method of claim 1 , wherein the 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.

4. The method of claim 1 , wherein the 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.

5. 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.

6. The method of claim 1 , wherein the user interface of the editable widget includes at least one graphical user interface menu having the adjustable control objects including at least one of toggle on/off buttons, check boxes, selectable menus, icons and fillable fields.

7. The method of claim 1 , wherein the generating the editable widget further comprises:

parameterizing each of the determined rules based upon rule artifacts.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 9, 2016
From: DANI, MOHAN N.; GUPTA, ANUJ; MOHANIA, MUKESH K.; VENKATACHALIAH, GIRISH
To: INTERNATIONAL BUSINESS MACHINES CORPORATION
Reel/Frame 037933/0331 →
Continuity (3)
Continuation 13552103 · Jul 18, 2012
Continuation 13173371 · Jun 30, 2011
Related Publication 20160188688A1 · Jun 30, 2016
Cited By (1)
US 12,282,463