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).
-
Patent number: 10997171Abstract: 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: GrantFiled: July 1, 2018Date of Patent: May 4, 2021Assignee: Oracle International CorporationInventors: Arvind Kumar Maheshwari, Uri Shaft, Karl Dias, Vishwanath Karra, Stephen Wexler, Anil Kumar Kothuri
-
Publication number: 20200004860Abstract: 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: ApplicationFiled: July 1, 2018Publication date: January 2, 2020Applicant: Oracle International CorporationInventors: Arvind Kumar Maheshwari, Uri Shaft, Karl Dias, Vishwanath Karra, Stephen Wexler, Anil Kumar Kothuri
-
Patent number: 7587568Abstract: 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: GrantFiled: June 24, 2004Date of Patent: September 8, 2009Assignee: Oracel International CorporationInventors: Sujatha Muthulingam, Alex Tsukerman, Vishwanath Karra, Nicholas Whyte
-
Patent number: 7526508Abstract: 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: GrantFiled: September 3, 2004Date of Patent: April 28, 2009Assignee: Oracle International CorporationInventors: 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: 7480662Abstract: 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: GrantFiled: November 20, 2003Date of Patent: January 20, 2009Assignee: Oracle International CorporationInventors: Dmitry Potapov, Vishwanath Karra, Amit Ganesh, Jonathan Klein
-
Patent number: 7249152Abstract: 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: GrantFiled: May 8, 2003Date of Patent: July 24, 2007Assignee: Oracle International CorporationInventors: Sujatha Muthulingam, Alexander Tsukerman, Vishwanath Karra
-
Publication number: 20050086195Abstract: 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: ApplicationFiled: September 3, 2004Publication date: April 21, 2005Inventors: 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: 20050055492Abstract: 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: ApplicationFiled: June 24, 2004Publication date: March 10, 2005Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Sujatha Muthulingam, Alex Tsukerman, Vishwanath Karra, Nicholas Whyte
-
Publication number: 20050004936Abstract: 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: ApplicationFiled: November 20, 2003Publication date: January 6, 2005Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Dmitry Potapov, Vishwanath Karra, Amit Ganesh, Jonathan Klein
-
Publication number: 20030220951Abstract: 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: ApplicationFiled: May 8, 2003Publication date: November 27, 2003Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Sujatha Muthulingam, Alexander Tsukerman, Vishwanath Karra