Patents by Inventor Paul-John A. To

Paul-John A. To 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: 11016970
    Abstract: Trace data is received for a first execution of a first query on first tables having first data values. Second data values are generated for second tables from the trace data and without accessing the first data values. The second data values are configured to reproduce, by a second execution of a second query, the evaluation states from the first execution. Evaluation states from the first execution are reproduced without accessing the first data values by performing the second execution of the second query on the second data values. The first execution evaluates only a first subset of the first data values and the generating the second data values from the trace data generates second data values corresponding to the first subset. The second execution only evaluates ones of the second data values that correspond to data values of the first subset.
    Type: Grant
    Filed: August 7, 2019
    Date of Patent: May 25, 2021
    Assignee: International Business Machines Corporation
    Inventors: James A. Ford, Lakshman R. Sakaray, Paul-John A. To
  • Patent number: 10970279
    Abstract: Trace data is received that was captured for an execution of a query on first tables when execution trouble occurs during an execution of the query on the first tables. Trace data includes counts of evaluation states caused by the execution and includes identifications of portions of the query that reference variables of the first tables and that correspond with the evaluation states. Second tables are generated from the evaluation state counts and the identifications of the trace data without accessing data values of the first tables, so that the first tables are kept private. Evaluation states are reproduced from the execution of the query on the first tables by executing the query on the second tables without accessing the data values of the first tables.
    Type: Grant
    Filed: June 10, 2019
    Date of Patent: April 6, 2021
    Assignee: International Business Machines Corporation
    Inventors: James A. Ford, Lakshman R. Sakaray, Paul-John A. To
  • Publication number: 20190361889
    Abstract: Trace data is received for a first execution of a first query on first tables having first data values. Second data values are generated for second tables from the trace data and without accessing the first data values. The second data values are configured to reproduce, by a second execution of a second query, the evaluation states from the first execution. Evaluation states from the first execution are reproduced without accessing the first data values by performing the second execution of the second query on the second data values. The first execution evaluates only a first subset of the first data values and the generating the second data values from the trace data generates second data values corresponding to the first subset. The second execution only evaluates ones of the second data values that correspond to data values of the first subset.
    Type: Application
    Filed: August 7, 2019
    Publication date: November 28, 2019
    Inventors: James A. Ford, Lakshman R. Sakaray, Paul-John A. To
  • Publication number: 20190294607
    Abstract: Trace data is received that was captured for an execution of a query on first tables when execution trouble occurs during an execution of the query on the first tables. Trace data includes counts of evaluation states caused by the execution and includes identifications of portions of the query that reference variables of the first tables and that correspond with the evaluation states. Second tables are generated from the evaluation state counts and the identifications of the trace data without accessing data values of the first tables, so that the first tables are kept private. Evaluation states are reproduced from the execution of the query on the first tables by executing the query on the second tables without accessing the data values of the first tables.
    Type: Application
    Filed: June 10, 2019
    Publication date: September 26, 2019
    Inventors: James A. Ford, Lakshman R. Sakaray, Paul-John A. To
  • Patent number: 10394808
    Abstract: Trace data is received that was captured for a execution of a first query on first input data. The trace data associates clauses of the first query with respective evaluation states that arise during the execution. Second input data is generated from the trace data without accessing the first input data. An execution of a second query is performed on the second input data, wherein performing the execution of the second query on the second input data reproduces evaluation states from the execution of the first query on the first input data.
    Type: Grant
    Filed: February 26, 2015
    Date of Patent: August 27, 2019
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: James A. Ford, Lakshman R. Sakaray, Paul-John A. To
  • Patent number: 10380109
    Abstract: Trace data is received that was captured for an execution of a first query on first input data. The trace data associates clauses of the first query with respective evaluation states that arise during the execution. Second input data is generated from the trace data without accessing the first input data. An execution of a second query is performed on the second input data, wherein performing the execution of the second query on the second input data reproduces evaluation states from the execution of the first query on the first input data.
    Type: Grant
    Filed: February 27, 2016
    Date of Patent: August 13, 2019
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: James A. Ford, Lakshman R. Sakaray, Paul-John A. To
  • Patent number: 10176231
    Abstract: Provided are techniques for estimating most frequent values. A sample of values made up of rows is received from each of multiple nodes. The sample of values from each of the multiple nodes are aggregated to generate a sample table storing the rows. A descending list of most frequent values and associated frequencies is obtained using the sample table. Most frequent values are pruned from the descending list whose associated frequencies are below a minimum absolute frequency. The remaining most frequent values are extrapolated to reflect a data set.
    Type: Grant
    Filed: February 5, 2016
    Date of Patent: January 8, 2019
    Assignee: International Business Machines Corporation
    Inventors: James L. Finnerty, Venkatesh S. Gopal, Venkannababu Tammisetti, Paul-John A. To
  • Publication number: 20160253379
    Abstract: Trace data is received that was captured for a execution of a first query on first input data. The trace data associates clauses of the first query with respective evaluation states that arise during the execution. Second input data is generated from the trace data without accessing the first input data. An execution of a second query is performed on the second input data, wherein performing the execution of the second query on the second input data reproduces evaluation states from the execution of the first query on the first input data.
    Type: Application
    Filed: February 26, 2015
    Publication date: September 1, 2016
    Inventors: James A. Ford, Lakshman R. Sakaray, Paul-John A. To
  • Publication number: 20160253377
    Abstract: Trace data is received that was captured for an execution of a first query on first input data. The trace data associates clauses of the first query with respective evaluation states that arise during the execution. Second input data is generated from the trace data without accessing the first input data. An execution of a second query is performed on the second input data, wherein performing the execution of the second query on the second input data reproduces evaluation states from the execution of the first query on the first input data.
    Type: Application
    Filed: February 27, 2016
    Publication date: September 1, 2016
    Inventors: James A. Ford, Lakshman R. Sakaray, Paul-John A. To
  • Publication number: 20160154805
    Abstract: Provided are techniques for estimating most frequent values. A sample of values made up of rows is received from each of multiple nodes. The sample of values from each of the multiple nodes are aggregated to generate a sample table storing the rows. A descending list of most frequent values and associated frequencies is obtained using the sample table. Most frequent values are pruned from the descending list whose associated frequencies are below a minimum absolute frequency. The remaining most frequent values are extrapolated to reflect a data set.
    Type: Application
    Filed: February 5, 2016
    Publication date: June 2, 2016
    Inventors: James L. Finnerty, Venkatesh S. Gopal, Venkannababu Tammisetti, Paul-John A. To
  • Patent number: 9286350
    Abstract: Provided are techniques for estimating most frequent values. A sample of values made up of rows is received from each of multiple nodes. The sample of values from each of the multiple nodes are aggregated to generate a sample table storing the rows. A descending list of most frequent values and associated frequencies is obtained using the sample table. Most frequent values are pruned from the descending list whose associated frequencies are below a minimum absolute frequency. The remaining most frequent values are extrapolated to reflect a data set.
    Type: Grant
    Filed: June 28, 2013
    Date of Patent: March 15, 2016
    Assignee: International Business Machines Corporation
    Inventors: James L. Finnerty, Venkatesh S. Gopal, Venkannababu Tammisetti, Paul-John A. To
  • Publication number: 20150006567
    Abstract: Provided are techniques for estimating most frequent values. A sample of values made up of rows is received from each of multiple nodes. The sample of values from each of the multiple nodes are aggregated to generate a sample table storing the rows. A descending list of most frequent values and associated frequencies is obtained using the sample table. Most frequent values are pruned from the descending list whose associated frequencies are below a minimum absolute frequency. The remaining most frequent values are extrapolated to reflect a data set.
    Type: Application
    Filed: June 28, 2013
    Publication date: January 1, 2015
    Inventors: James L. Finnerty, Venkatesh S. Gopal, Venkannababu Tammisetti, Paul-John A. To