Patents by Inventor Vasudha Krishnaswamy
Vasudha Krishnaswamy 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: 20180060377Abstract: A minimum value (MV) is computed for start timestamps that each correspond to an uncommitted transaction. In an embodiment, the MV is computed for a pluggable database that is open on at least first and second instances of a database. The MV is computed for the first instance as of a first current timestamp (CT). The MV and the first CT are communicated to a second instance that has a second CT. If the first and second CTs are equal, the second instance store the MV. If the first CT is bigger, the second CT also becomes equal to the first CT. If the first CT is smaller, the MV is discarded, and the first CT becomes equal to the second CT. In an embodiment, if the MV remains unchanged for a predetermined time period, a start timestamp corresponding to the MV is advanced to a current or future timestamp.Type: ApplicationFiled: August 31, 2016Publication date: March 1, 2018Inventors: Kartik Kulkarni, Juan R. Loaiza, Vivekanandhan Raja, Kothanda Umamageswaran, Sanket Hase, Vasudha Krishnaswamy, Tirthankar Lahiri
-
Publication number: 20180060378Abstract: A minimum value (MV) is computed for start timestamps that each correspond to an uncommitted transaction. In an embodiment, the MV is computed for a pluggable database that is open on at least first and second instances of a database. The MV is computed for the first instance as of a first current timestamp (CT). The MV and the first CT are communicated to a second instance that has a second CT. If the first and second CTs are equal, the second instance store the MV. If the first CT is bigger, the second CT also becomes equal to the first CT. If the first CT is smaller, the MV is discarded, and the first CT becomes equal to the second CT. In an embodiment, if the MV remains unchanged for a predetermined time period, a start timestamp corresponding to the MV is advanced to a current or future timestamp.Type: ApplicationFiled: August 31, 2016Publication date: March 1, 2018Inventors: Kartik Kulkarni, Juan R. Loaiza, Vivekanandhan Raja, Kothanda Umamageswaran, Sanket Hase, Vasudha Krishnaswamy, Tirthankar Lahiri
-
Publication number: 20170116252Abstract: Techniques related to query execution against an in-memory standby database are disclosed. A first database includes PF data stored on persistent storage in a persistent format. The first database is accessible to a first database server that converts the PF data to a mirror format to produce MF data that is stored within volatile memory. The first database server receives, from a second database server, one or more change records indicating one or more transactions performed against a second database. The one or more change records are applied to the PF data, and a reference timestamp is advanced from a first to a second timestamp. The first database server invalidates any MF data that is changed by a subset of the one or more transactions that committed between the first and second timestamps.Type: ApplicationFiled: August 31, 2016Publication date: April 27, 2017Inventors: Vasudha Krishnaswamy, Yunrui Li, Vivekanandhan Raja, Tirthankar Lahiri, Mahesh B. Girkar, Sukhada Pendse, Kartik Kulkarni, Jing Zheng, Shruti Gautam, Henry Chau
-
Patent number: 8832038Abstract: A method and apparatus for updating databases are disclosed. In response to a flashback request, a database object is restored to a state as of a specified flashback time. The changes introduced into the database object are reversed in a sequence starting with a change introduced into the database object immediately before issuance of the flashback request and ending with a change introduced into the database object immediately after the specified flashback time.Type: GrantFiled: March 2, 2009Date of Patent: September 9, 2014Assignee: Oracle International CorporationInventors: Vasudha Krishnaswamy, Amit Ganesh
-
Patent number: 8589357Abstract: A technique for making versions of rows of a user-defined tracked table temporally queryable. The database management system of the technique permits temporal queries of user-defined tables. The queries return versions of rows in the user-defined table that are currently in an undo log maintained by the database system. Associated with the tracked table are a system history table which contains versions of the rows and temporal metadata indicating when the versions were in the tracked table and a system form history table which contains versions of the form of the tracked table and metadata indicating when the tracked table had the form. These tables are created and maintained by a background process in the database management system. A temporal query on the tracked table combines results from the undo log with results from the system history table. The results' form is determined by the system form history table.Type: GrantFiled: September 28, 2007Date of Patent: November 19, 2013Assignee: Oracle International CorporationInventors: Venkatesh Radhakrishnan, Vasudha Krishnaswamy, Liang Guo, Bipul Sinha, Amit Ganesh
-
Patent number: 7885939Abstract: Methods and systems for automatically tuning the undo retention in a database system are disclosed. The undo tablespace may be of a fixed size or may be set to be automatically extended. If the undo tablespace is of a fixed size, the undo retention is set to a “best possible” undo retention, which is calculated based on statistical data stored in the system. If the undo tablespace is configured to be automatically extensible, the undo retention may be set to be greater than the duration of the longest running query in the system. The duration of the longest running query may be calculated in a distributed process in which each instance broadcasts information about its longest running query to other instances.Type: GrantFiled: October 11, 2005Date of Patent: February 8, 2011Assignee: Oracle International CorporationInventors: Vasudha Krishnaswamy, Dheeraj Pandey, Bipul Sinha
-
Patent number: 7801932Abstract: Methods and systems for using undo hints to speed up segment extension are disclosed. While a process is searching other segments to find available space, the process collects undo hints that describe when space in a segment might become available. These undo hints are placed in a table of undo hints. When a process is not able to find available space, it may consult the table of undo hints to determine how much to decrease the undo retention. After the undo retention is decreased, the process may again consult the table of undo hints to find a segment that likely contains available space now that the undo retention time has been reduced.Type: GrantFiled: October 11, 2005Date of Patent: September 21, 2010Assignee: Oracle International CorporationInventor: Vasudha Krishnaswamy
-
Patent number: 7644106Abstract: Techniques for avoiding lock contention when processing data definition language (DDL) statements are provided. Some DDL statements modify metadata of a table and then require access to the table. After such a DDL statement modifies the metadata of a table and the updated metadata is made available (i.e., published) to other database statements, execution of the DDL statement is suspended. Data manipulation language (DML) statements acquire locks on the table. In one approach, the locks, of any DML statement, that are granted after the DDL statement is issued are timestamped. The DDL statement uses the timestamps to determine when to access the table. The timestamps are used to determine when the last DML statement (that was pending at the time the modified metadata was published) commits and releases its lock on the table.Type: GrantFiled: July 30, 2007Date of Patent: January 5, 2010Assignee: Oracle International CorporationInventors: Shrikanth Shankar, Ramesh Kumar, Amirali S. Valiani, Vasudha Krishnaswamy, Ananth Raghavan, Juan R. Loaiza
-
Patent number: 7574419Abstract: A method and apparatus for data recovery are disclosed. A plurality of queries executing in a database system are tracked. A query with a longest duration is selected and undo retention duration is calculated for supporting the longest query.Type: GrantFiled: May 13, 2004Date of Patent: August 11, 2009Assignee: Oracle International CorporationInventors: Vasudha Krishnaswamy, Amit Ganesh
-
Publication number: 20090164525Abstract: A method and apparatus for updating databases are disclosed. In response to a flashback request, a database object is restored to a state as of a specified flashback time. The changes introduced into the database object are reversed in a sequence starting with a change introduced into the database object immediately before issuance of the flashback request and ending with a change introduced into the database object immediately after the specified flashback time.Type: ApplicationFiled: March 2, 2009Publication date: June 25, 2009Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Vasudha Krishnaswamy, Amit Ganesh
-
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: 7499953Abstract: A method and apparatus for updating databases are disclosed. In response to a flashback request, a database object is restored to a state as of a specified flashback time. The changes introduced into the database object are reversed in a sequence starting with a change introduced into the database object immediately before issuance of the flashback request and ending with a change introduced into the database object immediately after the specified flashback time.Type: GrantFiled: April 23, 2004Date of Patent: March 3, 2009Assignee: Oracle International CorporationInventors: Vasudha Krishnaswamy, Amit Ganesh
-
Publication number: 20090037417Abstract: Techniques for avoiding lock contention when processing data definition language (DDL) statements are provided. Some DDL statements modify metadata of a table and then require access to the table. After such a DDL statement modifies the metadata of a table and the updated metadata is made available (i.e., published) to other database statements, execution of the DDL statement is suspended. Data manipulation language (DML) statements acquire locks on the table. In one approach, the locks, of any DML statement, that are granted after the DDL statement is issued are timestamped. The DDL statement uses the timestamps to determine when to access the table. The timestamps are used to determine when the last DML statement (that was pending at the time the modified metadata was published) commits and releases its lock on the table.Type: ApplicationFiled: July 30, 2007Publication date: February 5, 2009Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Shrikanth Shankar, Ramesh Kumar, Amirali S. Valiani, Vasudha Krishnaswamy, Ananth Raghavan, Juan R. Loaiza
-
Publication number: 20080098045Abstract: A technique for making versions of rows of a user-defined tracked table temporally queryable. The database management system of the technique permits temporal queries of user-defined tables. The queries return versions of rows in the user-defined table that are currently in an undo log maintained by the database system. Associated with the tracked table are a system history table which contains versions of the rows and temporal metadata indicating when the versions were in the tracked table and a system form history table which contains versions of the form of the tracked table and metadata indicating when the tracked table had the form. These tables are created and maintained by a background process in the database management system. A temporal query on the tracked table combines results from the undo log with results from the system history table. The results' form is determined by the system form history table.Type: ApplicationFiled: September 28, 2007Publication date: April 24, 2008Inventors: Venkatesh Radhakrishnan, Vasudha Krishnaswamy, Liang Guo, Bipul Sinha, Amit Ganesh
-
Publication number: 20070083488Abstract: Methods and systems for using undo hints to speed up segment extension are disclosed. While a process is searching other segments to find available space, the process collects undo hints that describe when space in a segment might become available. These undo hints are placed in a table of undo hints. When a process is not able to find available space, it may consult the table of undo hints to determine how much to decrease the undo retention. After the undo retention is decreased, the process may again consult the table of undo hints to find a segment that likely contains available space now that the undo retention time has been reduced.Type: ApplicationFiled: October 11, 2005Publication date: April 12, 2007Applicant: ORACLE INTERNATIONAL CORPORATIONInventor: Vasudha Krishnaswamy
-
Publication number: 20070083566Abstract: Methods and systems for automatically tuning the undo retention in a database system are disclosed. The undo tablespace may be of a fixed size or may be set to be automatically extended. If the undo tablespace is of a fixed size, the undo retention is set to a “best possible” undo retention, which is calculated based on statistical data stored in the system. If the undo tablespace is configured to be automatically extensible, the undo retention may be set to be greater than the duration of the longest running query in the system. The duration of the longest running query may be calculated in a distributed process in which each instance broadcasts information about its longest running query to other instances.Type: ApplicationFiled: October 11, 2005Publication date: April 12, 2007Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Vasudha Krishnaswamy, Dheeraj Pandey, Bipul Sinha
-
Publication number: 20060136508Abstract: A method and apparatus for performing file system operation locks at a database server is provided. A request to perform a file operation on a portion of a file managed by a database server is received at the database server. In response to receiving the request, the database server grants a lock that covers only a portion of the file that is involved in the file operation. For example, the database server may grant a lock that covers a range of bytes on the file, where the range of bytes is less than the entire file. Thereafter, the database server performs the file operation on the file. The file operation may be a NFS operation.Type: ApplicationFiled: December 16, 2004Publication date: June 22, 2006Inventors: Sam Idicula, Namit Jain, Syam Pannala, Vasudha Krishnaswamy, Eric Sedlar, Nipun Agarwal, Bipul Sinha, Ravi Murthy
-
Publication number: 20050256849Abstract: A method and apparatus for data recovery are disclosed. A plurality of queries executing in a database system are tracked. A query with a longest duration is selected and undo retention duration is calculated for supporting the longest query.Type: ApplicationFiled: May 13, 2004Publication date: November 17, 2005Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Vasudha Krishnaswamy, Amit Ganesh
-
Publication number: 20050240633Abstract: A method and apparatus for updating databases are disclosed. In response to a flashback request, a database object is restored to a state as of a specified flashback time. The changes introduced into the database object are reversed in a sequence starting with a change introduced into the database object immediately before issuance of the flashback request and ending with a change introduced into the database object immediately after the specified flashback time.Type: ApplicationFiled: April 23, 2004Publication date: October 27, 2005Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Vasudha Krishnaswamy, Amit Ganesh
-
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