Patents by Inventor Vishwanath Karra

Vishwanath Karra 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).

  • 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
  • Patent number: 7587568
    Abstract: A method and system of reclaiming storage space in data storage systems is disclosed. In one embodiment, a high water mark of a data container is adjusted after data in the data container is compacted. As a result, unused space in the data container can be reclaimed.
    Type: Grant
    Filed: June 24, 2004
    Date of Patent: September 8, 2009
    Assignee: Oracel International Corporation
    Inventors: Sujatha Muthulingam, Alex Tsukerman, Vishwanath Karra, Nicholas Whyte
  • Patent number: 7526508
    Abstract: An intelligent database infrastructure wherein the management of all database components is performed by and within the database itself by integrating management of various components with a central management control. Each individual database component, as well as the central management control, is self-managing. A central management control module integrates and interacts with the various database components. The database is configured to automatically tune to varying workloads and configurations, correct or alert about bad conditions, and advise on ways to improve overall system performance.
    Type: Grant
    Filed: September 3, 2004
    Date of Patent: April 28, 2009
    Assignee: Oracle International Corporation
    Inventors: Leng Leng Tan, Gianfranco Putzolu, Richard Sarwal, Alex Tsukerman, Gary C. Ngai, Graham Stephen Wood, Karl Dias, Mark Ramacher, Benoit Dageville, Mohamed Ziauddin, Tirthankar Lahiri, Sujatha Muthulingam, Vishwanath Karra, Francisco Sanchez, Hsiao-Te Su, Wanli Yang, Vasudha Krishnaswamy, Sushil Kumar
  • Patent number: 7480662
    Abstract: A fact table is set up without any dimension columns. The data in the table is ordered according to an order corresponding to the ordering of the dimensions. The table is divided into segments corresponding to contiguous portions of data. The portions of the table containing non-null values for the measures are placed into the segments. The size of the segments and the location segments may be determined according to the density of discontinuities in the data. An indexed organized table is used to determine the beginning and end of each segment of the table, the locations of the discontinuities in the data, and to facilitate accessing the measures of the table.
    Type: Grant
    Filed: November 20, 2003
    Date of Patent: January 20, 2009
    Assignee: Oracle International Corporation
    Inventors: Dmitry Potapov, Vishwanath Karra, Amit Ganesh, Jonathan Klein
  • Patent number: 7249152
    Abstract: A method and apparatus for the dynamic management of disk space by multiple database server instances in a cluster configuration is disclosed. A segment is partitioned. Each partition is associated with a bitmap block. A partition's bitmap block indicates the freeness of the partition's data blocks. A partition's bitmap block may be owned by one server instance at a time. After determining from a partition's bitmap block where free disk space is located within the partition, the partition's bitmap block's owner may allocate the free disk space for the owner's use. A bitmap block may become owned by different server instances at different times. When a server instance ceases to actively use its bitmap block, another server instance may “steal” the bitmap block. Thus, multiple server instances may allocate disk space in the same partition over time, preventing disk space waste.
    Type: Grant
    Filed: May 8, 2003
    Date of Patent: July 24, 2007
    Assignee: Oracle International Corporation
    Inventors: Sujatha Muthulingam, Alexander Tsukerman, Vishwanath Karra
  • Publication number: 20050086195
    Abstract: An intelligent database infrastructure wherein the management of all database components is performed by and within the database itself by integrating management of various components with a central management control. Each individual database component, as well as the central management control, is self-managing. A central management control module integrates and interacts with the various database components. The database is configured to automatically tune to varying workloads and configurations, correct or alert about bad conditions, and advise on ways to improve overall system performance.
    Type: Application
    Filed: September 3, 2004
    Publication date: April 21, 2005
    Inventors: Leng Leng Tan, Gianfranco Putzolu, Richard Sarwal, Alex Tsukerman, Gary Ngai, Graham Wood, Karl Dias, Mark Ramacher, Benoit Dageville, Mohamed Ziauddin, Tirthankar Lahiri, Sujatha Muthulingam, Vishwanath Karra, Francisco Sanchez, Hsiao-Te Su, Wanli Yang, Vasudha Krishnaswamy, Sushil Kumar
  • Publication number: 20050055492
    Abstract: A method and system of reclaiming storage space in data storage systems is disclosed. In one embodiment, a high water mark of a data container is adjusted after data in the data container is compacted. As a result, unused space in the data container can be reclaimed.
    Type: Application
    Filed: June 24, 2004
    Publication date: March 10, 2005
    Applicant: ORACLE INTERNATIONAL CORPORATION
    Inventors: Sujatha Muthulingam, Alex Tsukerman, Vishwanath Karra, Nicholas Whyte
  • Publication number: 20050004936
    Abstract: A fact table is set up without any dimension columns. The data in the table is ordered according to an order corresponding to the ordering of the dimensions. The table is divided into segments corresponding to contiguous portions of data. The portions of the table containing non-null values for the measures are placed into the segments. The size of the segments and the location segments may be determined according to the density of discontinuities in the data. An indexed organized table is used to determine the beginning and end of each segment of the table, the locations of the discontinuities in the data, and to facilitate accessing the measures of the table.
    Type: Application
    Filed: November 20, 2003
    Publication date: January 6, 2005
    Applicant: ORACLE INTERNATIONAL CORPORATION
    Inventors: Dmitry Potapov, Vishwanath Karra, Amit Ganesh, Jonathan Klein
  • Publication number: 20030220951
    Abstract: A method and apparatus for the dynamic management of disk space by multiple database server instances in a cluster configuration is disclosed. A segment is partitioned. Each partition is associated with a bitmap block. A partition's bitmap block indicates the freeness of the partition's data blocks. A partition's bitmap block may be owned by one server instance at a time. After determining from a partition's bitmap block where free disk space is located within the partition, the partition's bitmap block's owner may allocate the free disk space for the owner's use. A bitmap block may become owned by different server instances at different times. When a server instance ceases to actively use its bitmap block, another server instance may “steal” the bitmap block. Thus, multiple server instances may allocate disk space in the same partition over time, preventing disk space waste.
    Type: Application
    Filed: May 8, 2003
    Publication date: November 27, 2003
    Applicant: ORACLE INTERNATIONAL CORPORATION
    Inventors: Sujatha Muthulingam, Alexander Tsukerman, Vishwanath Karra