Mehul Dili Bastawala

US Patent:

6963880, Nov 8, 2005

Filed:

May 10, 2002

Appl. No.:

10/144439

Inventors:

Rajendra Pingte - San Mateo CA, US
Sundeep Abraham - Belmont CA, US
Mehul Dilip Bastawala - Menlo Park CA, US
Srinath Krishnaswamy - Fremont CA, US
Ravikanth Kasamsetty - Redwood City CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F007/00

US Classification:

707103R, 707100, 707102, 7071041, 7155001, 715513

Abstract:

Schema conversion approaches convert images of complex objects. The schema conversion is performed on images of complex objects belonging to a root class, whether those objects are instances of the root class or instances of a subclass of the root class. A complex object is an object that is comprised of a collection of objects or that has another object as an attribute. The approaches use change vectors to represent changes to make to an image to convert it between the target schema version and source schema version. Change vectors are generated based on schema version records, each of which describes the properties of a schema version, including the attributes in the schema version and the data type of each of the attributes. The approaches evolve changes that includes addition, modification and deletion of object attributes. They convert from an earlier schema version to a later schema version, and vice versa, i. e.

US Patent:

6973457, Dec 6, 2005

Filed:

May 10, 2002

Appl. No.:

10/144665

Inventors:

Mehul Bastawala - Menlo Park CA, US
Sreenivas Gollapudi - Cupertino CA, US
Lakshminarayanan Chidambaran - Fremont CA, US
Srinath Krishnaswamy - Fremont CA, US

Assignee:

Oracle International Corporation - Redwood shores CA

International Classification:

G06F017/30

US Classification:

707 10, 707 3, 707101, 707102, 707104

Abstract:

A method and system for implementing scrollable cursors is described. A multi-tier caching structure is maintained, in which a partial result set is cached at the client computer and a more-complete result set is cached at the server computer. If the cursor is scrolled in either the forward or backward directions, the partial result set cached at the client computer is first checked to see if requested data is present. If so, then the requested data is fetched from the client cache and the current position of the cursor is moved to the appropriate position in the result set. If the requested data is not present in the client cache, then those data items are fetched from the cache at the server computer.

US Patent:

7587400, Sep 8, 2009

Filed:

Apr 1, 2005

Appl. No.:

11/097862

Inventors:

Mehul D. Bastawala - Menlo Park CA, US
Lakshminarayanan Chidambaran - Sunnyvale CA, US
Sreenivas Gollapudi - Cupertino CA, US
Sanjay Kaluskar - Menlo Park CA, US
Srinath Krishnaswamy - Fremont CA, US
Debashish Chatterjee - Fremont CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 7/00
G06F 17/00

US Classification:

707100, 707 10, 707202

Abstract:

A system, method, computer program and system for suspending a result set and continuing from a suspended result set for transparent session migration is disclosed. The rows from a row source are suspended into storage, so that after session migration, the client fetches can transparently continue from the suspended result set.

US Patent:

7613710, Nov 3, 2009

Filed:

Apr 1, 2005

Appl. No.:

11/097422

Inventors:

Mehul D. Bastawala - Menlo Park CA, US
Lakshminarayanan Chidambaran - Sunnyvale CA, US
Sreenivas Gollapudi - Cupertino CA, US
Sanjay Kaluskar - Menlo Park CA, US
Srinath Krishnaswamy - Fremont CA, US
Debashish Chatterjee - Fremont CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 7/00
G06F 17/30

US Classification:

707100, 707 10

Abstract:

A system, method, computer program and system for suspending a result set and continuing from a suspended result set for a cursor is disclosed. The rows from a row source corresponding to the cursor result set are suspended into storage so that when a fetch is requested the data can be sent (continued) from the suspended storage and does not depend on the original cursor row source or session to be available.

US Patent:

7743333, Jun 22, 2010

Filed:

Apr 1, 2005

Appl. No.:

11/097065

Inventors:

Mehul D. Bastawala - Menlo Park CA, US
Lakshminarayanan Chidambaran - Sunnyvale CA, US
Sreenivas Gollapudi - Cupertino CA, US
Sanjay Kaluskar - Menlo Park CA, US
Srinath Krishnaswamy - Fremont CA, US
Debashish Chatterjee - Fremont CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 3/00

US Classification:

715738, 707662, 707713, 707802

Abstract:

A system, method, computer program and system for suspending a result set and continuing from a suspended result set for a scrollable cursor is disclosed. The rows from a row source corresponding to the scrollable cursor result set are suspended into storage so that when a fetch is requested the data can be sent (continued) from the suspended storage and does not depend on the original scrollable cursor row source or session to be available.

US Patent:

20060200469, Sep 7, 2006

Filed:

Mar 2, 2005

Appl. No.:

11/071275

Inventors:

Lakshminarayanan Chidambaran - Sunnyvale CA, US
Mehul Bastawala - Menlo Park CA, US
Sanjay Kaluskar - Menlo Park CA, US
Sreenivas Gollapudi - Cupertino CA, US

International Classification:

G06F 17/30
G06F 7/00

US Classification:

707010000

Abstract:

A method and apparatus for managing sessions across the nodes of a multi-node system is provided. When a session is first initiated on any node of a multi-node system, a global session identifier is assigned to the session. The global session identifier uniquely identifies the session relative to all other sessions managed by the multi-node system. A session monitor may use the global session identifier to collect and store cumulative statistics about the activity of the session, regardless of which node of the multi-node system is currently managing the session, since the global session identifier uniquely identifies the session relative to all other sessions managed by the multi-node system. As a session may be uniquely identified across the lifetime of the session, the session state may be cleaned-up when the session ceases to be maintained, and the activity of the session during its lifetime may be analyzed.

US Patent:

20080098041, Apr 24, 2008

Filed:

Oct 22, 2007

Appl. No.:

11/876679

Inventors:

Lakshminarayanan CHIDAMBARAN - San Jose CA, US
Mehul BASTAWALA - Sunnyvale CA, US
Srinath KRISHNASWAMY - Fremont CA, US
Tirthankar LAHIRI - Palo Alto CA, US
Juan LOAIZA - Woodside CA, US
Bipul SINHA - Foster City CA, US
Srinivas VEMURI - Santa Clara CA, US

International Classification:

G06F 17/30

US Classification:

707201000, 707E17032

Abstract:

A method, system, and computer program product is disclosed for interacting with a client supported by a client-side cache. Embodiments of a method, a system, and a computer program product are disclosed that retrieve a first snapshot, indicating a state of the database after a last database request by the client, associated with the client, determine any number of invalid cached results for the client based on the first snapshot, and transmit the any number of invalid cached results and a second snapshot, an update for the first snapshot.

US Patent:

20080098173, Apr 24, 2008

Filed:

Oct 19, 2007

Appl. No.:

11/875782

Inventors:

Lakshminarayanan CHIDAMBARAN - San Jose CA, US
Mehul BASTAWALA - Sunnyvale CA, US
Srinath KRISHNASWAMY - Fremont CA, US
Tirthankar LAHIRI - Palo Alto CA, US
Juan LOAIZA - Woodside CA, US
Bipul SINHA - Foster City CA, US
Srinivas VEMURI - Santa Clara CA, US

International Classification:

G06F 12/00
G06F 17/30

US Classification:

711118000, 707100000, 711E12001, 707E17001

Abstract:

A method, system, and computer program product is disclosed for caching results in a client-side cache. Embodiments of a method, a system, and a computer program product are disclosed that associate a first snapshot of a database with a client that indicates a state of the database after a last database request by the client, and indicate any number of invalid cached results in the client cache for the client based upon the first snapshot. In some embodiments, the method further includes receiving a second snapshot that indicates a state of the database upon receipt of a database server request by the client, and updating the first snapshot with the second snapshot.