Invention Grant
- Patent Title: Extract transform load input suggestion
-
Application No.: US15248147Application Date: 2016-08-26
-
Publication No.: US10025838B2Publication Date: 2018-07-17
- Inventor: Joseph Bangs , Leonard D. Greenwood , Arron J. Harden , Xiaoyan Pu , Julian J. Vizor
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee Address: US NY Armonk
- Agency: Cantor Colburn LLP
- Agent Robert Bunker
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00 ; G06F17/30

Abstract:
A method for extract transform load (ETL) input suggestions for an ETL system in which a current job is being created. A method includes: determining when a new input is made in the current job in the ETL system and dynamically receiving the new input which includes a connection between stages input or a property of a stage input; updating stored information relating to the current job with the new input; accessing rules which apply to the current job; analyzing and applying the rules based on the new input and the current job stored information to generate one or more suggested next inputs in the current job; providing a weighting for the one or more suggested next inputs based on the analysis and application of the rules; and providing a prompt in the current job in the ETL system with the suggested one or more next inputs and their weightings.
Public/Granted literature
- US20170140014A1 EXTRACT TRANSFORM LOAD INPUT SUGGESTION Public/Granted day:2017-05-18
Information query