Debashis Saha, 506254 Via De Adrianna, San Jose, CA 95120

6772176, Aug 3, 2004

Nov 17, 2000

09/715956

Debashis Saha - Menlo Park CA
Amit Ganesh - Mountain View CA

Oracle International Corporation - Redwood Shores CA

G06F 700

707201, 707 8, 707 10, 709227

A data base system coordinates the execution of a distributed transaction in which a set of participant database systems participates, each of the participants executing a subtransaction of the distributed transaction. The participants include at least one database system (âincompatible database systemâ) that does not follow a two-phase commit followed by the other participant database systems. The distributed transaction is executed as long as operations performed by the incompatible database system for the distributed transaction are read-only operations. To commit the distributed transaction, the incompatible database system aborts the subtransaction it is executing as part of the distributed transaction, while other participant database systems complete the distributed transaction using a two-phase commit to commit their respective subtransactions.

7099888, Aug 29, 2006

Mar 26, 2003

10/400735

Sreenivas Gollapudi - Cupertino CA, US
Debashis Saha - Foster City CA, US

Oracle International Corporation - Redwood Shores CA

G06F 7/00

707103, 707 1, 707 2, 707 3, 707 10

A method and apparatus are provided for providing access to a remotely located nested object in a distributed database system. For example, a first server receives a request to access a complex database object that is not situated at the first server. When this occurs, the first server sends a second request to a second server. When the first server receives data in response to the second request, it detects whether the received data includes a reference to a nested object. If the first server detects a reference to a nested object, the first server modifies the received data by replacing the reference with a virtual reference to the nested object. The first server stores mapping data that associates the virtual reference with the reference and with an associated server, wherein the associated server is capable of resolving the reference. The first server forwards the modified data to the requestor.

7133902, Nov 7, 2006

Aug 14, 2003

10/641513

Debashis Saha - Foster City CA, US
John Ciminski - Redwood City CA, US

Oracle International Corporation - Redwood Shores CA

G06F 15/167
G06F 15/16

709212, 709229, 710 22

Direct memory accessed is used to perform database operations between two or more machines. Data is read from a first buffer located on a first machine. The data was written into the first buffer in response to the data being written into a second buffer at a second machine. In one embodiment, based, at least in part, on whether the data represents a partial read, a determination is made as to whether to transmit, to the second machine, an explicit acknowledgement that the data was read from the first buffer. In another embodiment, based on whether the amount of unacknowledged data received by the first machine from the second machine exceeds a threshold quantity, a determination is made as to whether to transmit, in response to the data being read from the first buffer, any acknowledgement that the data was read from the first buffer.

7178153, Feb 13, 2007

May 10, 2002

10/144688

Kapil Surlaker - Mountain View CA, US
Sreenivas Gollapudi - Cupertino CA, US
Lakshminarayanan Chidambaran - Fremont CA, US
Debashis Saha - Foster City CA, US

Oracle International Corporation - Redwood Shores CA

G06F 13/00

719328, 719310, 719321, 707 1, 707100

A method and system for implementing an improved access interface infrastructure is disclosed. In one approach, an access interface methods is directly supported by an application. The directly supported access interface method corresponds to an access interface implementation. Other access interface methods are transparently processed by being converted or mapped into a generic interface format, which is then translated into the directly supported format.

7251657, Jul 31, 2007

Apr 30, 2003

10/427838

Debashis Saha - Foster City CA, US
Srinath Krishnaswamy - Fremont CA, US
Lakshminarayanan Chidambaran - Fremont CA, US

Oracle International Corporation - Redwood Shores CA

G06F 17/30

707 10, 7071041

Disclosed are improved methods, systems, and mediums for implementing a dynamic cursor cache. Cached cursors are tagged to facilitate identification and reuse of cursors from a cursor cache. Cursor caches and cursor usage are managed in an integrated and/or coordinated manner between multiple nodes that have related sets of cursors or cursor resources.

7337226, Feb 26, 2008

Apr 30, 2003

10/427701

Debashis Saha - Foster City CA, US
Srinath Krishnaswamy - Fremont CA, US
Lakshminarayanan Chidambaran - Fremont CA, US

Oracle International Corporation - Redwood Shores CA

G06F 15/16
G06F 15/173

709226, 709223, 709224, 709227, 709228

An improved method, mechanism, and system for implementing, generating, and maintaining for implementing session pools is disclosed. Disclosed is a method, mechanism, and system for dynamic sizing of session pools, in which the number of sessions in a given session pool or sub-session pool can be dynamically adjusted upwards or downwards. Also disclosed is an approach for customizing a session in a session pool with a specific set of affinities and attributes, in which tags can be associated with the customized sessions. Tagging can be used to identify sessions to deallocate/reallocate to dynamically size the session or sub-session pools.

7386615, Jun 10, 2008

May 10, 2002

10/144246

Kapil Surlaker - Mountain View CA, US
Sreenivas Gollapudi - Cupertino CA, US
Lakshminarayanan Chidambaran - Fremont CA, US
Debashis Saha - Foster City CA, US

Oracle International Corporation - Redwood Shores CA

G06F 15/173

709226, 709222, 709228, 714 2, 714 4, 714 48, 714100

A system and method is disclosed that allows resources to be shared among multiple entities, but which can appropriately release system resources after the failure or shutdown of the calling entity. In one approach, a monitoring entity is available to check for session failures. If a session failure is detected, the session is identified in a shared list that is accessible to other related entities. The related entities can be configured to piggyback a message to an appropriate node to kill, shutdown, or release resources associated with the failed session. Alternatively, a related entity can be specifically initiated to send a message to the appropriate node to kill, shutdown, or release the resources.

7389284, Jun 17, 2008

May 10, 2002

10/144382

Kapil Surlaker - Mountain View CA, US
Sreenivas Gollapudi - Cupertino CA, US
Lakshminarayanan Chidambaran - Fremont CA, US
Debashis Saha - Foster City CA, US

Oracle International Corporation - Redwood Shores CA

G06F 17/30

707 3, 707 4, 709202, 709203, 709247

A method and mechanism for reducing the expense of data transmissions and storage between a first node and a second for a remote-mapped query or a query involving a distributed join operation is disclosed. Data prefetching can be utilized to predictably retrieve information. Data redundancy management can be employed to reduce the expense of transmitting and storing redundant data.