Patents by Inventor Daniel Galvin

Daniel Galvin 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).

  • Automatic review of SQL statement complexity
    Patent number: 11099968
    Abstract: A computer-implemented method for automatically reviewing structured query language (SQL) statements comprises the steps of receiving SQL code from a user seeking to access a database, parsing the SQL code to retrieve SQL keywords, mathematical operators, and logical operators, applying a complexity score calculation algorithm to the parsed code, calculating a complexity score, and executing the SQL code on a computing system which stores the database if the complexity score is less than or equal to a threshold. On the other hand, if the complexity score is greater than the threshold, the SQL code may be flagged to be rewritten.
    Type: Grant
    Filed: December 4, 2019
    Date of Patent: August 24, 2021
    Assignee: STATE FARM MUTUAL AUTOMOBILE INSURANCE COMPANY
    Inventors: Richard Snyder, Matthew R. Anderson, Daniel Galvin
  • Automatic review of SQL statement complexity
    Patent number: 10540256
    Abstract: A computer-implemented method for automatically reviewing structured query language (SQL) statements comprises the steps of receiving SQL code from a user seeking to access a database, parsing the SQL code to retrieve SQL keywords, mathematical operators, and logical operators, applying a complexity score calculation algorithm to the parsed code, calculating a complexity score, and executing the SQL code on a computing system which stores the database if the complexity score is less than or equal to a threshold. On the other hand, if the complexity score is greater than the threshold, the SQL code may be flagged to be rewritten.
    Type: Grant
    Filed: November 2, 2018
    Date of Patent: January 21, 2020
    Inventors: Richard Snyder, Matthew R Anderson, Daniel Galvin
  • Automatic review of SQL statement complexity
    Patent number: 10162729
    Abstract: A computer-implemented method for automatically reviewing structured query language (SQL) statements comprises the steps of receiving SQL code from a user seeking to access a database, parsing the SQL code to retrieve SQL keywords, mathematical operators, and logical operators, applying a complexity score calculation algorithm to the parsed code, calculating a complexity score, and executing the SQL code on a computing system which stores the database if the complexity score is less than or equal to a threshold. On the other hand, if the complexity score is greater than the threshold, the SQL code may be flagged to be rewritten.
    Type: Grant
    Filed: January 19, 2017
    Date of Patent: December 25, 2018
    Assignee: State Farm Mutual Automobile Insurance Company
    Inventors: Richard Snyder, Matthew R Anderson, Daniel Galvin