Patents by Inventor Anil Kumar Kothuri

Anil Kumar Kothuri 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).

  • Database performance analysis based on a random archive
    Patent number: 10997171
    Abstract: Techniques for analyzing an execution of a query statement based on a random archive are disclosed. A plurality of query statements that are executed during a particular time period are identified. A random sampling function is executed to randomly select a set of query statements from the plurality of query statements. Execution plans and/or performance metrics associated with each execution of the randomly-selected query statements are stored into a random archive. Responsive to determining that a performance metric for a current execution of a particular query statement does not satisfy a performance criteria, information associated with the particular query statement from the random archive is analyzed. A model plan characteristic associated with an execution of the particular query statement stored in the random archive is determined. An execution plan associated with the model plan characteristic is determined for another execution of the particular query statement.
    Type: Grant
    Filed: July 1, 2018
    Date of Patent: May 4, 2021
    Assignee: Oracle International Corporation
    Inventors: Arvind Kumar Maheshwari, Uri Shaft, Karl Dias, Vishwanath Karra, Stephen Wexler, Anil Kumar Kothuri
  • Database Performance Analysis Based on a Random Archive
    Publication number: 20200004860
    Abstract: Techniques for analyzing an execution of a query statement based on a random archive are disclosed. A plurality of query statements that are executed during a particular time period are identified. A random sampling function is executed to randomly select a set of query statements from the plurality of query statements. Execution plans and/or performance metrics associated with each execution of the randomly-selected query statements are stored into a random archive. Responsive to determining that a performance metric for a current execution of a particular query statement does not satisfy a performance criteria, information associated with the particular query statement from the random archive is analyzed. A model plan characteristic associated with an execution of the particular query statement stored in the random archive is determined. An execution plan associated with the model plan characteristic is determined for another execution of the particular query statement.
    Type: Application
    Filed: July 1, 2018
    Publication date: January 2, 2020
    Applicant: Oracle International Corporation
    Inventors: Arvind Kumar Maheshwari, Uri Shaft, Karl Dias, Vishwanath Karra, Stephen Wexler, Anil Kumar Kothuri