Back to results
US 2014/0279972 A1Published application
Cleansing and standardizing data
AssigneeTeradata US, Inc.
InventorsSantosh Kumar Singh, Achal Patel, Anand Louis, Venugopal Reddy
Life of this patent
Estimating the term…
Abstract
Data cleansing and standardization techniques are provided. A user interactively defines rules for cleansing and standardizing data of a source dataset. The rules are applied to the data and varying degrees of results and metrics associated with applying the rules are presented to the user for inspection and analysis.
Claims20
A method, comprising:
- obtaining, by a data manager executing on one or more processors, a source dataset;
- acquiring, by the data manager, rules to cleanse and standardize the source dataset;
- and
- applying, by the data manager, the rules to the source dataset to modify data of the source dataset.
1 more element
A method, comprising:
- interacting, by an interface managing executing on one or more processors, with a user to obtain:
- a source dataset and rules to clean and standardize data of the source dataset;
- applying, by the interface manager, the rules against the data of the source dataset;
- and
- presenting, by the interface manager, a graphical user interface (GUI) to the user summarizing results from applying the rules.
2 more elements
A system, comprising:
- a processor having a data cleanser and standardizer module;
- and
- the data cleanser and standardizer module, the data cleanser and standardizer module adapted and configured to (i) execute on the processor;
- (ii) interact with a user to define a source database and rules to cleanse and standardize data within the source database;
- (iii) apply the rules to the data;
- and (iv) present summary results to the user after the rules are applied.
3 more elements
Dependencies are inferred from the claim text.