International Business Machines Corporation

Intellution, Inc.

Joseph Bangs

Xiaoyan Pu

Arron J Harden

Julian J Vizor

Leonard D Greenwood

Eric Jacobson

Mark Tucker

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.

Extract transform load input suggestion

Methods and systems are provided for extract transform load (ETL) input suggestion 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; 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.

According to one embodiment, a recipe for use with a process control system includes unit procedures (to be executed on units) and information that identifies unit procedures that must be executed on units that are physically connected to one another, unit procedures that must be executed on the same unit, and/or unit procedures that must be executed on different units. According to another embodiment, a method for configuring a recipe includes the step of storing information in memory that identifies unit procedures of the recipe that must be executed on units that are physically connected to one another, unit procedures of the recipe that must be executed on the same unit, and/or unit procedures of the recipe that must be executed on different units. According to yet another embodiment, a method for configuring a process control system includes the steps of storing first information in memory that identifies unit procedures that must be executed on units that are physically connected to one another, unit procedures that must be executed on the same unit, and/or unit procedures that must be executed on different units; and storing second information in memory that identifies units that are physically connected to one another.

Growing community of inventors

Wrentham, MA, United States of America

Joseph Bangs