Patents by Inventor Lawrence E. Schapker

Lawrence E. Schapker 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).

  • Multi-database, runtime database query performance monitoring
    Patent number: 8700602
    Abstract: A method to monitor database performance includes gathering information from a remote, monitored database related to the monitored database performance during a predetermined time, collecting statistics corresponding to any queries executed during the predetermined time, testing at least one rule against the statistics corresponding to each query, and if the testing results in a rule violation, identifying the query that caused the rule violation. A method to monitor database performance includes gathering statistics related to execution of a query statement, comparing at least one of the statistics against at least one rule to determine if the statistics violates a threshold established by the rule, if the statistic violates the threshold, identifying the query statement as a violating query statement, and repeating the comparing and identifying until all rules have been compared.
    Type: Grant
    Filed: September 29, 2008
    Date of Patent: April 15, 2014
    Assignee: Oracle International Corporation
    Inventors: Lawrence E. Schapker, Jayagopal Theranikal
  • MULTI-DATABASE, RUNTIME DATABASE QUERY PERFORMANCE MONITORING
    Publication number: 20100082517
    Abstract: A method to monitor database performance includes gathering information from a remote, monitored database related to the monitored database performance during a predetermined time, collecting statistics corresponding to any queries executed during the predetermined time, testing at least one rule against the statistics corresponding to each query, and if the testing results in a rule violation, identifying the query that caused the rule violation. A method to monitor database performance includes gathering statistics related to execution of a query statement, comparing at least one of the statistics against at least one rule to determine if the statistics violates a threshold established by the rule, if the statistic violates the threshold, identifying the query statement as a violating query statement, and repeating the comparing and identifying until all rules have been compared.
    Type: Application
    Filed: September 29, 2008
    Publication date: April 1, 2010
    Applicant: ORACLE INTERNATIONAL CORPORATION
    Inventors: LAWRENCE E. SCHAPKER, II, JAYAGOPAL THERANIKAL