IP Library Granted Patent US 8,805,798
Granted Patent B2
US 8,805,798 · App. 13/468,938 · Granted Aug 12, 2014

Data cleaning

Inventors: Ihab Francis Ilyas Kaldas (Doha, QA); George Beskales (Doha, QA); Ahmed Elmagarmid (Doha, QA)
Assignee: Qatar Foundation
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 8,805,798
App. No.
13/468,938
Granted
Aug 12, 2014
Kind
B2
Abstract

A computer-implemented method comprising partitioning data representing an input instance of a database including multiple tuples into multiple fragments of tuples, detecting tuples which violate a data quality specification in respective ones of the fragments, selecting a data cleaning asset on the basis of characteristics of errors in detected tuples for a fragment and based on declared asset capabilities, assigning a selected data cleaning asset to the fragment, the selected data cleaning asset to provide a set of candidate corrections for the detected tuples in the fragment, providing data representing an output instance of the database in which detected tuples are replaced with selected candidate corrections.

Claims (27)

1. A computer-implemented method comprising:

partitioning data representing an input instance of a database including multiple tuples into multiple fragments of tuples;

detecting tuples which violate a data quality specification in respective ones of the fragments;

selecting multiple data cleaning assets on the basis of characteristics of errors in detected tuples for a fragment and based on declared asset capabilities;

assigning multiple selected data cleaning assets to the fragment, the selected multiple data cleaning assets to provide sets of redundant candidate corrections for the detected tuples in the fragment;

selecting a candidate correction for a tuple with a relatively higher confidence measure from measures for the candidate corrections in the redundant sets, and wherein a confidence measure includes a measure representing a majority vote for a tuple from multiple candidate corrections for the tuple from the redundant sets; and

providing data representing an output instance of the database in which detected tuples are replaced with selected candidate corrections.

2. A computer-implemented method as claimed in claim 1 , further comprising resolving conflicts in candidate corrections.

3. A computer-implemented method as claimed in claim 1 , further comprising resolving conflicts in candidate corrections, and wherein resolving conflicts includes selecting a candidate correction in the redundant sets which has a relatively higher confidence measure from measures for the candidate corrections in the redundant sets.

4. A computer-implemented method as claimed in claim 1 , further comprising resolving conflicts in candidate corrections, wherein resolving conflicts includes selecting corrections by determining a clean database instance that includes the maximum number tuples which obey the data quality specification.

5. A computer-implemented method as claimed in claim 1 , further comprising registering a set of data cleaning assets to declare capabilities of the asset.

6. A computer-implemented method as claimed in claim 1 , wherein a data cleaning asset is a machine-based or a human asset.

7. A computer-implemented method as claimed in claim 1 , wherein a data cleaning asset is a machine-based or a human asset, further comprising reconciling multiple candidate corrections from assets for a tuple from the multiple candidate corrections from the redundant sets.

8. A computer-implemented method as claimed in claim 1 , wherein a data cleaning asset is a machine-based or a human asset, further comprising reconciling multiple candidate corrections from assets for a tuple from the multiple candidate corrections from the redundant sets, and wherein reconciling includes providing a candidate correction which complies with the data quality specification.

9. A system comprising:

a processor to process a database including multiple data records to be cleaned;

multiple data cleaning assets to determine a set of data records of the database which violate at least one data quality description; and

a selection and allocation module to select a data cleaning asset from a set of assets including a user from a crowdsourcing system and a machine-based data cleaning asset, to allocate a selected asset to a fragment of the data records in the set, the selected asset to generate a candidate correction for a data record in the set, and to select candidate corrections by determining a clean database instance that includes the maximum number tuples which obey the data quality description; and using a confidence measure which includes a measure representing a majority vote for a tuple from multiple candidate corrections for the tuple from redundant sets of corrections.

10. A system as claimed in claim 9 , wherein a data cleaning asset is a machine-based or a human asset.

11. A system as claimed in claim 9 , wherein the selection and allocation module selects and allocates an asset to the fragment to provide redundant sets of candidate corrections, and the processor reconciles multiple candidate corrections from assets for a tuple from the multiple candidate corrections from the redundant sets.

12. A computer program embedded on a non-transitory tangible computer readable storage medium, the computer program including machine readable instructions that, when executed by a processor, implement a method comprising:

partitioning data representing an input instance of a database including multiple tuples into multiple fragments of tuples;

detecting tuples which violate a data quality specification in respective ones of the fragments;

selecting a data cleaning asset on the basis of characteristics of errors in detected tuples for a fragment and based on declared asset capabilities;

assigning multiple selected data cleaning assets to the fragment, the selected multiple data cleaning assets to provide sets of redundant candidate corrections for the detected tuples in the fragment;

selecting a candidate correction for a tuple with a relatively higher confidence measure from measures for the candidate corrections in the redundant sets, and wherein a confidence measure includes a measure representing a majority vote for a tuple from multiple candidate corrections for the tuple from the redundant sets; and

providing data representing an output instance of the database in which detected tuples are replaced with selected candidate corrections.

Assignments (2)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jan 17, 2025
From: QATAR FOUNDATION FOR EDUCATION, SCIENCE & COMMUNITY DEVELOPMENT
To: HAMAD BIN KHALIFA UNIVERSITY
Reel/Frame 069936/0656 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jul 12, 2012
From: KALDAS, IHAB FRANCIS ILYAS; BESKALES, GEORGE; ELMAGARMID, AHMED
To: QATAR FOUNDATION
Reel/Frame 028537/0195 →
Priority Claims (1)
GB 1206444.0 · Apr 12, 2012 · national
Continuity (1)
Related Publication 20130275393A1 · Oct 17, 2013