Vasudha Krishnaswamy from 287 Muscat Ct, Fremont, CA 94539, age 66, Phone: 510 657-6037

Us Patents

Online Recovery Of User Tables Using Flashback Table
view source
US Patent:

7499953, Mar 3, 2009
Filed:

Apr 23, 2004
Appl. No.:

10/831449
Inventors:

Vasudha Krishnaswamy - Fremont CA, US
Amit Ganesh - San Jose CA, US
Assignee:

Oracle International Corporation - Redwood Shores CA
International Classification:

G06F 17/30
G06F 7/00
US Classification:

707202, 707101, 707 3
Abstract:

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.

Self-Managing Database Architecture
view source
US Patent:

7526508, Apr 28, 2009
Filed:

Sep 3, 2004
Appl. No.:

10/934076
Inventors:

Leng Leng Tan - Sunnyvale CA, US
Gianfranco Putzolu - San Francisco CA, US
Richard Sarwal - Portola Valley CA, US
Alex Tsukerman - Foster City CA, US
Gary C. Ngai - Saratoga CA, US
Graham Stephen Wood - El Granada CA, US
Karl Dias - Foster City CA, US
Mark Ramacher - San Carlos CA, US
Benoit Dageville - Foster City CA, US
Mohamed Ziauddin - Pleasanton CA, US
Tirthankar Lahiri - Santa Clara CA, US
Sujatha Muthulingam - Mountain View CA, US
Vishwanath Karra - San Jose CA, US
Francisco Sanchez - San Carlos CA, US
Hsiao-Te Su - Milpitas CA, US
Wanli Yang - San Mateo CA, US
Vasudha Krishnaswamy - Fremont CA, US
Sushil Kumar - San Jose CA, US
Assignee:

Oracle International Corporation - Redwood Shores CA
International Classification:

G06F 17/30
US Classification:

707200, 707 2
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.

Automatic Tuning Of Undo Retention
view source
US Patent:

7574419, Aug 11, 2009
Filed:

May 13, 2004
Appl. No.:

10/846099
Inventors:

Vasudha Krishnaswamy - Fremont CA, US
Amit Ganesh - San Jose CA, US
Assignee:

Oracle International Corporation - Redwood Shores CA
International Classification:

G06F 17/30
US Classification:

707 1, 707 3, 707 4, 707 5
Abstract:

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.

Avoiding Lock Contention By Using A Wait For Completion Mechanism
view source
US Patent:

7644106, Jan 5, 2010
Filed:

Jul 30, 2007
Appl. No.:

11/830538
Inventors:

Shrikanth Shankar - San Francisco CA, US
Ramesh Kumar - Foster City CA, US
Amirali S. Valiani - San Jose CA, US
Vasudha Krishnaswamy - Fremont CA, US
Ananth Raghavan - San Francisco CA, US
Juan R. Loaiza - Woodside CA, US
Assignee:

Oracle International Corporation - Redwood Shores CA
International Classification:

G06F 17/30
US Classification:

707201, 707 8
Abstract:

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.

Undo Hints To Speed Up Segment Extension And Tuning Of Undo Retention
view source
US Patent:

7801932, Sep 21, 2010
Filed:

Oct 11, 2005
Appl. No.:

11/249149
Inventors:

Vasudha Krishnaswamy - Fremont CA, US
Assignee:

Oracle International Corporation - Redwood Shores CA
International Classification:

G06F 7/00
G06F 17/00
US Classification:

707999001, 707609, 707661, 707662, 707663, 707678, 707684
Abstract:

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.

Longest Query Duration For Auto Tuning Undo Retention
view source
US Patent:

7885939, Feb 8, 2011
Filed:

Oct 11, 2005
Appl. No.:

11/249150
Inventors:

Vasudha Krishnaswamy - Fremont CA, US
Dheeraj Pandey - Santa Clara CA, US
Bipul Sinha - Foster City CA, US
Assignee:

Oracle International Corporation - Redwood Shores CA
International Classification:

G06F 7/00
US Classification:

707684, 707662
Abstract:

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.

Techniques For Automatically Tracking And Archiving Transactional Data Changes
view source
US Patent:

8589357, Nov 19, 2013
Filed:

Sep 28, 2007
Appl. No.:

11/863310
Inventors:

Venkatesh Radhakrishnan - Cupertino CA, US
Vasudha Krishnaswamy - Fremont CA, US
Liang Guo - San Jose CA, US
Bipul Sinha - Foster City CA, US
Amit Ganesh - San Jose CA, US
Assignee:

Oracle International Corporation - Redwood Shores CA
International Classification:

G06F 17/00
G06F 17/30
G06F 11/00
US Classification:

707684, 707638, 707672, 707703, 707751, 707754, 707758, 714 19
Abstract:

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.

Techniques For Providing Locks For File Operations In A Database Management System
view source
US Patent:

20060136508, Jun 22, 2006
Filed:

Dec 16, 2004
Appl. No.:

11/013519
Inventors:

Sam Idicula - San Jose CA, US
Namit Jain - San Jose CA, US
Syam Pannala - Fremont CA, US
Vasudha Krishnaswamy - Fremont CA, US
Eric Sedlar - San Francisco CA, US
Nipun Agarwal - Santa Clara CA, US
Bipul Sinha - Foster City CA, US
Ravi Murthy - Fremont CA, US
International Classification:

G06F 17/30
US Classification:

707203000
Abstract:

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.