Patents by Inventor Michael Crampon

Michael Crampon 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).

  • Systems and methods for SQL value evaluation to detect evaluation flaws
    Patent number: 10025936
    Abstract: Methods and apparatuses for detecting an evaluation flaw in a SQL query, the SQL query configured to access data in a database table are disclosed. The method includes creating a parse tree from the SQL query and evaluating the parse tree to ascertain whether a condition of the SQL query results in a type or value that is independent of contents of the database table. For type evaluation, if, responsive to the evaluating, the condition is found, designating the SQL query at risk for having the tautology in the SQL query. For value evaluation, if, responsive to the evaluating, the condition is found, determining whether the condition is always true or whether the condition is always false; and if, responsive to the determining, the condition is found to be always true or always false, designating the SQL query at risk for having the evaluation flaw in the SQL query.
    Type: Grant
    Filed: September 16, 2016
    Date of Patent: July 17, 2018
    Assignee: PREVOTY, INC.
    Inventors: Kunal Anand, Michael Crampon, Richard Meester, Joseph Rozner, Joshua Chase
  • Systems and methods for SQL type evaluation to detect evaluation flaws
    Patent number: 10002254
    Abstract: Methods and apparatuses for detecting an evaluation flaw in a SQL query, the SQL query configured to access data in a database table are disclosed. The method includes creating a parse tree from the SQL query and evaluating the parse tree to ascertain whether a condition of the SQL query results in a type or value that is independent of contents of the database table. For type evaluation, if, responsive to the evaluating, the condition is found, designating the SQL query at risk for having the tautology in the SQL query. For value evaluation, if, responsive to the evaluating, the condition is found, determining whether the condition is always true or whether the condition is always false; and if, responsive to the determining, the condition is found to be always true or always false, designating the SQL query at risk for having the evaluation flaw in the SQL query.
    Type: Grant
    Filed: September 16, 2016
    Date of Patent: June 19, 2018
    Assignee: PREVOTY, INC.
    Inventors: Kunal Anand, Michael Crampon, Richard Meester, Joseph Rozner, Joshua Chase
  • SYSTEMS AND METHODS FOR SQL TYPE EVALUATION TO DETECT EVALUATION FLAWS
    Publication number: 20170068819
    Abstract: Methods and apparatuses for detecting an evaluation flaw in a SQL query, the SQL query configured to access data in a database table are disclosed. The method includes creating a parse tree from the SQL query and evaluating the parse tree to ascertain whether a condition of the SQL query results in a type or value that is independent of contents of the database table. For type evaluation, if, responsive to the evaluating, the condition is found, designating the SQL query at risk for having the tautology in the SQL query. For value evaluation, if, responsive to the evaluating, the condition is found, determining whether the condition is always true or whether the condition is always false; and if, responsive to the determining, the condition is found to be always true or always false, designating the SQL query at risk for having the evaluation flaw in the SQL query.
    Type: Application
    Filed: September 16, 2016
    Publication date: March 9, 2017
    Inventors: Kunal Anand, Michael Crampon, Richard Meester, Joseph Rozner, Joshua Chase
  • SYSTEMS AND METHODS FOR SQL VALUE EVALUATION TO DETECT EVALUATION FLAWS
    Publication number: 20170068820
    Abstract: Methods and apparatuses for detecting an evaluation flaw in a SQL query, the SQL query configured to access data in a database table are disclosed. The method includes creating a parse tree from the SQL query and evaluating the parse tree to ascertain whether a condition of the SQL query results in a type or value that is independent of contents of the database table. For type evaluation, if, responsive to the evaluating, the condition is found, designating the SQL query at risk for having the tautology in the SQL query. For value evaluation, if, responsive to the evaluating, the condition is found, determining whether the condition is always true or whether the condition is always false; and if, responsive to the determining, the condition is found to be always true or always false, designating the SQL query at risk for having the evaluation flaw in the SQL query.
    Type: Application
    Filed: September 16, 2016
    Publication date: March 9, 2017
    Inventors: Kunal Anand, Michael Crampon, Richard Meester, Joseph Rozner, Joshua Chase