Patents by Inventor Marshall Todd JARMAN

Marshall Todd JARMAN 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).

  • Increasing database performance through query aggregation
    Patent number: 11308086
    Abstract: A method, computer program product, and system includes a processor(s) executing a new instruction in place of a left outer join instruction to generate a data set, where the left outer join instruction includes at least two tables and an indication of a column in each the tables to join on. Executing the new instruction includes the processor(s) creating a temporary table including all columns of the at least two tables, where values in fields of the temporary table are null values, executing an inner join instruction, the inner join instruction includes the indication of the column in each of the at least two tables to join on, to create a preliminary results set, and generating the data set, wherein the generating includes the processor(s) overlaying the preliminary results set on the temporary table to update a portion of the null values with values from the preliminary results set.
    Type: Grant
    Filed: November 13, 2019
    Date of Patent: April 19, 2022
    Assignee: Kyndryl, Inc.
    Inventors: Karen Cheng, Marshall Todd Jarman, Charles Matula
  • INCREASING DATABASE PERFORMANCE THROUGH QUERY AGGREGATION
    Publication number: 20200081890
    Abstract: A method, computer program product, and system includes a processor(s) executing a new instruction in place of a left outer join instruction to generate a data set, where the left outer join instruction includes at least two tables and an indication of a column in each the tables to join on. Executing the new instruction includes the processor(s) creating a temporary table including all columns of the at least two tables, where values in fields of the temporary table are null values, executing an inner join instruction, the inner join instruction includes the indication of the column in each of the at least two tables to join on, to create a preliminary results set, and generating the data set, wherein the generating includes the processor(s) overlaying the preliminary results set on the temporary table to update a portion of the null values with values from the preliminary results set.
    Type: Application
    Filed: November 13, 2019
    Publication date: March 12, 2020
    Inventors: Karen Cheng, Marshall Todd Jarman, Charles Matula
  • INCREASING DATABASE PERFORMANCE THROUGH QUERY AGGREGATION
    Publication number: 20180232418
    Abstract: A method, computer program product, and system includes a processor(s) executing a new instruction in place of a left outer join instruction to generate a data set, where the left outer join instruction includes at least two tables and an indication of a column in each the tables to join on. Executing the new instruction includes the processor(s) creating a temporary table including all columns of the at least two tables, where values in fields of the temporary table are null values, executing an inner join instruction, the inner join instruction includes the indication of the column in each of the at least two tables to join on, to create a preliminary results set, and generating the data set, wherein the generating includes the processor(s) overlaying the preliminary results set on the temporary table to update a portion of the null values with values from the preliminary results set.
    Type: Application
    Filed: February 14, 2017
    Publication date: August 16, 2018
    Inventors: Karen CHENG, Marshall Todd JARMAN, Charles MATULA