Patents by Inventor Leonard D. Greenwood
Leonard D. Greenwood has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 10025838Abstract: 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.Type: GrantFiled: August 26, 2016Date of Patent: July 17, 2018Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Joseph Bangs, Leonard D. Greenwood, Arron J. Harden, Xiaoyan Pu, Julian J. Vizor
-
Patent number: 9703849Abstract: Embodiments relate to integrating data transform test with a data transform tool. A method and system are described for creating a data transform test for a data transform job having a data transform script, the method includes determining all data transform units available in the data transform job, determining a subset of the available data transform units for a new test, and generating a subset test execution script for the subset of data transform units from the data transform script. The method further includes determining boundary test data at each boundary of the subset of data transform units, defining a data transform test, and saving the data transform test for later testing. The data transform test includes the subset of data transform units with subset test execution script and with boundary test data.Type: GrantFiled: August 29, 2013Date of Patent: July 11, 2017Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Leonard D. Greenwood, Arron J. Harden, Martin J. Sanders, Julian J. Vizor
-
Publication number: 20170140014Abstract: 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.Type: ApplicationFiled: August 26, 2016Publication date: May 18, 2017Inventors: Joseph Bangs, Leonard D. Greenwood, Arron J. Harden, Xiaoyan Pu, Julian J. Vizor
-
Patent number: 9495336Abstract: This invention relates to a data comparison tool, method and computer program product for analyzing a set of data, the set of data being derived from an original set of data, comprising: comparing the derived set of data with the original set of data; generating a hyperlink to represent each difference between the derived and original data set, each difference being a changed item, an additional item, or a missing data item; providing at least one agent that is activated on selection of the hyperlink to operate on the changed, additional or missing data item; whereby a list of hyperlinks is generated to represent all the differences of the derived and original data set and selecting one of the hyperlinks will execute an agent to operate on a single data item in one of the data sets. An editor agent is provided for allowing the user to confirm or make further changes to the data item.Type: GrantFiled: July 3, 2007Date of Patent: November 15, 2016Assignee: International Business Machines CorporationInventors: Barrie R. Green, Leonard D. Greenwood
-
Patent number: 9471652Abstract: 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.Type: GrantFiled: November 18, 2015Date of Patent: October 18, 2016Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Joseph Bangs, Leonard D. Greenwood, Arron J. Harden, Xiaoyan Pu, Julian J. Vizor
-
Patent number: 9286361Abstract: A controller is coupled to an Extract-Transform-Load (ETL) processor, which is connected to data storage devices. The controller comprises: a hardware storage device; a storage control component for storing, on said hardware storage device, a set of criteria for preferredness of ETL stage placements; an I/O input device detecting component for recognizing a proposed placement of a stage on a GUI canvas on the display device; an analytical component for analyzing an eventual result of the proposed placement in an ETL activity represented on the GUI canvas; a comparator for comparing the eventual result of the proposed placement in the ETL activity with the set of criteria; and an indicator control component for, responsive to an outcome of an operation of the comparator, providing to the user an indicator of a degree of preferredness of said proposed placement according to the set of criteria.Type: GrantFiled: October 23, 2013Date of Patent: March 15, 2016Assignee: International Business Machines CorporationInventors: Leonard D. Greenwood, Arron J. Harden, Julian J. Vizor
-
Publication number: 20140181006Abstract: A controller is coupled to an Extract-Transform-Load (ETL) processor, which is connected to data storage devices. The controller comprises: a hardware storage device; a storage control component for storing, on said hardware storage device, a set of criteria for preferredness of ETL stage placements; an I/O input device detecting component for recognizing a proposed placement of a stage on a GUI canvas on the display device; an analytical component for analyzing an eventual result of the proposed placement in an ETL activity represented on the GUI canvas; a comparator for comparing the eventual result of the proposed placement in the ETL activity with the set of criteria; and an indicator control component for, responsive to an outcome of an operation of the comparator, providing to the user an indicator of a degree of preferredness of said proposed placement according to the set of criteria.Type: ApplicationFiled: October 23, 2013Publication date: June 26, 2014Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: LEONARD D. GREENWOOD, ARRON J. HARDEN, JULIAN J. VIZOR
-
Publication number: 20140081902Abstract: Embodiments relate to integrating data transform test with a data transform tool. A method and system are described for creating a data transform test for a data transform job having a data transform script, the method includes determining all data transform units available in the data transform job, determining a subset of the available data transform units for a new test, and generating a subset test execution script for the subset of data transform units from the data transform script. The method further includes determining boundary test data at each boundary of the subset of data transform units, defining a data transform test, and saving the data transform test for later testing. The data transform test includes the subset of data transform units with subset test execution script and with boundary test data.Type: ApplicationFiled: August 29, 2013Publication date: March 20, 2014Applicant: International Business Machines CorporationInventors: Leonard D. Greenwood, Arron J. Harden, Martin J. Sanders, Julian J. Vizor
-
Publication number: 20090313308Abstract: This invention relates to a data comparison tool, method and computer program product for analysing a set of data, the set of data being derived from an original set of data, comprising: comparing the derived set of data with the original set of data; generating a hyperlink to represent each difference between the derived and original data set, each difference being a changed item, an additional item, or a missing data item; providing at least one agent that is activated on selection of the hyperlink to operate on the changed, additional or missing data item; whereby a list of hyperlinks is generated to represent all the differences of the derived and original data set and selecting one of the hyperlinks will execute an agent to operate on a single data item in one of the data sets. An editor agent is provided for allowing the user to confirm or make further changes to the data item.Type: ApplicationFiled: July 3, 2007Publication date: December 17, 2009Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Barrie R. Green, Leonard D. Greenwood