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: 10025838
    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.
    Type: Grant
    Filed: August 26, 2016
    Date of Patent: July 17, 2018
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Joseph Bangs, Leonard D. Greenwood, Arron J. Harden, Xiaoyan Pu, Julian J. Vizor
  • Patent number: 9703849
    Abstract: 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: Grant
    Filed: August 29, 2013
    Date of Patent: July 11, 2017
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Leonard D. Greenwood, Arron J. Harden, Martin J. Sanders, Julian J. Vizor
  • Publication number: 20170140014
    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.
    Type: Application
    Filed: August 26, 2016
    Publication date: May 18, 2017
    Inventors: Joseph Bangs, Leonard D. Greenwood, Arron J. Harden, Xiaoyan Pu, Julian J. Vizor
  • Patent number: 9471652
    Abstract: 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: Grant
    Filed: November 18, 2015
    Date of Patent: October 18, 2016
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Joseph Bangs, Leonard D. Greenwood, Arron J. Harden, Xiaoyan Pu, Julian J. Vizor
  • Patent number: 9298596
    Abstract: 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: Grant
    Filed: July 9, 2013
    Date of Patent: March 29, 2016
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Brian K. Caufield, Ajay Sood, Julian J. Vizor
  • Patent number: 9286361
    Abstract: 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: Grant
    Filed: October 23, 2013
    Date of Patent: March 15, 2016
    Assignee: International Business Machines Corporation
    Inventors: Leonard D. Greenwood, Arron J. Harden, Julian J. Vizor
  • Publication number: 20150020049
    Abstract: 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: Application
    Filed: July 9, 2013
    Publication date: January 15, 2015
    Inventors: Brian K. Caufield, Ajay Sood, Julian J. Vizor
  • Publication number: 20140181006
    Abstract: 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: Application
    Filed: October 23, 2013
    Publication date: June 26, 2014
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: LEONARD D. GREENWOOD, ARRON J. HARDEN, JULIAN J. VIZOR
  • Patent number: 8736613
    Abstract: 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: Grant
    Filed: November 2, 2011
    Date of Patent: May 27, 2014
    Assignee: International Business Machines Corporation
    Inventors: Arron J. Harden, Alex Swain, Julian J. Vizor
  • Patent number: 8736614
    Abstract: 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: Grant
    Filed: July 2, 2012
    Date of Patent: May 27, 2014
    Assignee: International Business Machines Corporation
    Inventors: Arron J. Harden, Alex Swain, Julian J. Vizor
  • Publication number: 20140081902
    Abstract: 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: Application
    Filed: August 29, 2013
    Publication date: March 20, 2014
    Applicant: International Business Machines Corporation
    Inventors: Leonard D. Greenwood, Arron J. Harden, Martin J. Sanders, Julian J. Vizor
  • Publication number: 20130106861
    Abstract: 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: Application
    Filed: November 2, 2011
    Publication date: May 2, 2013
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Arron J. HARDEN, Alex SWAIN, Julian J. VIZOR
  • Publication number: 20130106862
    Abstract: 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: Application
    Filed: July 2, 2012
    Publication date: May 2, 2013
    Applicant: International Business Machines Corporation
    Inventors: Arron J. HARDEN, Alex SWAIN, Julian J. VIZOR