Invention Grant
- Patent Title: In-querying data cleansing with semantic standardization
-
Application No.: US13493945Application Date: 2012-06-11
-
Publication No.: US10120916B2Publication Date: 2018-11-06
- Inventor: Tanveer A. Faruquie , Mukesh K. Mohania , L. Venkata Subramaniam , Charles D. Wolfson
- Applicant: Tanveer A. Faruquie , Mukesh K. Mohania , L. Venkata Subramaniam , Charles D. Wolfson
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Konrad, Raynes, Davda & Victor LLP
- Agent Janaki K. Davda
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
The present invention relates to data cleansing, and in particular performing the semantic standardization process within a database before the transform portion of the extract-transform-load (ETL) process. Provided are a method, system and computer program product for standardizing data within a database engine, configuring the standardization function to determine at least one standardized value for at least one data value by applying the standardization table in a context of at least one data value, receiving a database query identifying the standardization function, at least one database value and the context of the data, and invoking the standardization function.
Public/Granted literature
- US20130332407A1 IN-QUERYING DATA CLEANSING WITH SEMANTIC STANDARDIZATION Public/Granted day:2013-12-12
Information query