Patents by Inventor Julian J. VIZOR
Julian J. VIZOR 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: 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: 9298596Abstract: According to one embodiment of the present invention, a system tests jobs in a computing environment. The system creates a test case for one or more existing executable jobs without modifying the job design or recompiling the executable itself, wherein the test case includes one or more capture points in a job flow of the executable jobs and corresponding rules for capturing data, identification of data for testing the one or more executable jobs, and rules for comparing the captured data to expected results. The system captures the data at the one or more capture points in the job flow in accordance with the test case and generates a baseline of expected results.Type: GrantFiled: July 9, 2013Date of Patent: March 29, 2016Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Brian K. Caufield, Ajay Sood, 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: 20150020049Abstract: According to one embodiment of the present invention, a system tests jobs in a computing environment. The system creates a test case for one or more existing executable jobs without modifying the job design or recompiling the executable itself, wherein the test case includes one or more capture points in a job flow of the executable jobs and corresponding rules for capturing data, identification of data for testing the one or more executable jobs, and rules for comparing the captured data to expected results. The system captures the data at the one or more capture points in the job flow in accordance with the test case and generates a baseline of expected results.Type: ApplicationFiled: July 9, 2013Publication date: January 15, 2015Inventors: Brian K. Caufield, Ajay Sood, 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
-
Patent number: 8736613Abstract: Provided are a computer implemented method, computer program product, and system for presenting information about multiple data series. The multiple data series are obtained. A main graphing area with a graph showing one or more of the obtained data series, an active process execution metrics area with information about the one or more obtained data series shown in the graph, and an available process execution metrics area with one or more thumbnail views of one or more of the obtained data series available for selection to be shown in the graph are displayed.Type: GrantFiled: November 2, 2011Date of Patent: May 27, 2014Assignee: International Business Machines CorporationInventors: Arron J. Harden, Alex Swain, Julian J. Vizor
-
Patent number: 8736614Abstract: Provided are a computer implemented method, computer program product, and system for presenting information about multiple data series. The multiple data series are obtained. A main graphing area with a graph showing one or more of the obtained data series, an active process execution metrics area with information about the one or more obtained data series shown in the graph, and an available process execution metrics area with one or more thumbnail views of one or more of the obtained data series available for selection to be shown in the graph are displayed.Type: GrantFiled: July 2, 2012Date of Patent: May 27, 2014Assignee: International Business Machines CorporationInventors: Arron J. Harden, Alex Swain, 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: 20130106861Abstract: Provided are a computer implemented method, computer program product, and system for presenting information about multiple data series. The multiple data series are obtained. A main graphing area with a graph showing one or more of the obtained data series, an active process execution metrics area with information about the one or more obtained data series shown in the graph, and an available process execution metrics area with one or more thumbnail views of one or more of the obtained data series available for selection to be shown in the graph are displayed.Type: ApplicationFiled: November 2, 2011Publication date: May 2, 2013Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Arron J. HARDEN, Alex SWAIN, Julian J. VIZOR
-
Publication number: 20130106862Abstract: Provided are a computer implemented method, computer program product, and system for presenting information about multiple data series. The multiple data series are obtained. A main graphing area with a graph showing one or more of the obtained data series, an active process execution metrics area with information about the one or more obtained data series shown in the graph, and an available process execution metrics area with one or more thumbnail views of one or more of the obtained data series available for selection to be shown in the graph are displayed.Type: ApplicationFiled: July 2, 2012Publication date: May 2, 2013Applicant: International Business Machines CorporationInventors: Arron J. HARDEN, Alex SWAIN, Julian J. VIZOR