Invention Application
- Patent Title: METHOD TO DETECT REFERENCE DATA TABLES IN ETL PROCESSES
- Patent Title (中): 在ETL过程中检测参考数据表的方法
-
Application No.: US13415047Application Date: 2012-03-08
-
Publication No.: US20130238596A1Publication Date: 2013-09-12
- Inventor: Dan J. Mandelstein , Ivan M. Milman , Martin A. Oberhofer , Sushain Pandit
- Applicant: Dan J. Mandelstein , Ivan M. Milman , Martin A. Oberhofer , Sushain Pandit
- Applicant Address: US NY Armonk
- Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee Address: US NY Armonk
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A method, system and computer program product for identifying reference data tables in an Extract-Transform-Load (ETL) process, by identifying, by operation of one or more computer processors, at least a first reference data operator in the process, wherein the first reference data operator references one or more tables and evaluating at least a first table referenced by the reference data operator to determine whether the first table is a reference data table by assigning a score to the first table, wherein the score is indicative of the likelihood that the first table is a reference data table and wherein a reference data table contains a set of values that describes other data.
Public/Granted literature
- US08583626B2 Method to detect reference data tables in ETL processes Public/Granted day:2013-11-12
Information query