Patents by Inventor Martin Serrano

Martin Serrano 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: 9916350
    Abstract: A computer system processes a plurality of unrelated database tables to create a join graph where each node in the join graph represents a table. The nodes in the join graph are connected by weighted, directed edges, where each directed edge represents a join from a first column in a first table to a second column in a second table and where the weight of the directed edge represents a predicted level of success in performing the join. The edge weights can be based on a likelihood of finding a value from the first column in the second column. A user selects a subset of the tables, and the system creates a join tree with recommended joins between the tables selected by the user. The recommended joins are used to create a structured query language statement which is executed to return a result to the user.
    Type: Grant
    Filed: November 28, 2016
    Date of Patent: March 13, 2018
    Inventors: Jonathan Young, John O'Neil, William K. Johnson, III, Martin Serrano, Gregory George, Udayan Das
  • Publication number: 20170193045
    Abstract: A computer system processes a plurality of unrelated database tables to create a join graph where each node in the join graph represents a table. The nodes in the join graph are connected by weighted, directed edges, where each directed edge represents a join from a first column in a first table to a second column in a second table and where the weight of the directed edge represents a predicted level of success in performing the join. The edge weights can be based on a likelihood of finding a value from the first column in the second column. A user selects a subset of the tables, and the system creates a join tree with recommended joins between the tables selected by the user. The recommended joins are used to create a structured query language statement which is executed to return a result to the user.
    Type: Application
    Filed: November 28, 2016
    Publication date: July 6, 2017
    Inventors: Jonathan Young, John O'Neil, William K. Johnson, III, Martin Serrano, Gregory George, Udayan Das
  • Patent number: 9507824
    Abstract: A computer system processes a plurality of unrelated database tables to create a join graph where each node in the join graph represents a table. The nodes in the join graph are connected by weighted, directed edges, where each directed edge represents a join from a first column in a first table to a second column in a second table and where the weight of the directed edge represents a predicted level of success in performing the join. The edge weights can be based on a likelihood of finding a value from the first column in the second column. A user selects a subset of the tables, and the system creates a join tree with recommended joins between the tables selected by the user. The recommended joins are used to create a structured query language statement which is executed to return a result to the user.
    Type: Grant
    Filed: August 24, 2015
    Date of Patent: November 29, 2016
    Assignee: Attivio Inc.
    Inventors: Jonathan Young, John O'Neil, William K. Johnson, III, Martin Serrano, Gregory George, Udayan Das
  • Publication number: 20160055205
    Abstract: A computer system processes a plurality of unrelated database tables to create a join graph where each node in the join graph represents a table. The nodes in the join graph are connected by weighted, directed edges, where each directed edge represents a join from a first column in a first table to a second column in a second table and where the weight of the directed edge represents a predicted level of success in performing the join. The edge weights can be based on a likelihood of finding a value from the first column in the second column. A user selects a subset of the tables, and the system creates a join tree with recommended joins between the tables selected by the user. The recommended joins are used to create a structured query language statement which is executed to return a result to the user.
    Type: Application
    Filed: August 24, 2015
    Publication date: February 25, 2016
    Inventors: Young Jonathan, John O'Neil, William K. Johnson, III, Martin Serrano, Gregory George, Udayan Das
  • Publication number: 20160055212
    Abstract: A computer system processes arbitrary data sets to identify fields of data that can be the basis of a join operation. Each data set has a plurality of entries, with each entry having a plurality of fields. For each pair of data sets, the computer system compares the values of fields in a first data set in the pair of data sets to the values of fields in a second data set in the pair of data sets, to identify fields having substantially similar sets of values. Given pairs of fields that have similar sets of values, the computer system measures entropy with respect to an intersection of the sets of values of the pair of fields. The computer system can recommend fields for a join operation between any pair of data sets in the plurality of data sets based on such statistical measures.
    Type: Application
    Filed: August 22, 2014
    Publication date: February 25, 2016
    Inventors: Jonathan Young, John O'Neil, William K. Johnson, III, Martin Serrano, Gregory George
  • Patent number: 7047232
    Abstract: A system and method for parallelizing applications of script-driven software tools. Scripts in the software tool scripting language are automatically analyzed in order to produce a specification for a parallel computation plus a set of “script fragments”, the combination of which is functionally equivalent to the original script. The computational specification plus the script fragments are then executed by a parallel runtime system, which causes multiple instances of the original software tool and/or supplemental programs to be run as parallel processes. The resulting processes will read input data and produce output data, performing the same computation as was specified by the original script.
    Type: Grant
    Filed: January 13, 1999
    Date of Patent: May 16, 2006
    Assignee: Ab Initio Software Corporation
    Inventor: Martin Serrano