Oracle International Corporation

John William Miller

Chih-Ping Wang

Nagender Bandi

Tirthankar Lahiri

Marie-Anne Neimat

Paul Tuck

Chi-Kim Hoang

Chi Kim Hoang

Rohan Aranha

Dilys Thomas

Susan Cheng

Susan Sokeng Cheung

Mark L McAuliffe

Jon Mark Holdman

Cathleen Susan Wharton

John Mitchell Black, Iii

Dina Thomas

Chad Alber

Jitesh Bakul Jhatakia

Derek Taylor

Terry Schmitt

Ryder B Rishel

Karl Kevin Nicoletti

Sudha Verma

Judith Gaye Leach

Sourav Ghosh

Varadarajan Aravamudhan

Michael Paul Abramowitz

Duc T Ho

Quentin Lee Rainsbury

Samuel Drake

David Aspinwall

Michael Patrick Kearney

A database is stored as a plurality of database shards in a distributed database grid comprising a plurality of grid elements, each including a mid-tier database system. A first grid element receives, from an application executing in the same memory as a mid-tier database system of the first grid element, a first database transaction including at least one database operation on specific data stored in a first database shard that belongs to the first grid element. The first grid element performs and commits the first database transaction without participation of another grid element of the plurality of grid elements. The first grid element receives a second database transaction that requires access to another database shard that does not belong to the first grid element. Multiple grid elements of the plurality of grid elements perform the second database transaction and commit the second database transaction using a two-phase commit protocol.

Direct-connect functionality in a distributed database grid

Techniques are described for performing dependency locking to enable parallel execution of database server processes modifying the same object. In an embodiment, a DBMS receives a request to execute an operation on its managed database. The request may include an object identifier and a version identifier for a version of a database object, which is required for the successful execution of the operation on the database. The required version of the database object may not exist and may be generated only after the execution of another, second, operation on the database. The first database server process initiates execution of the earlier received operation on the database. The first database server process queries the first database for the version of the particular database object and determines that the version of the database object does not exist yet, in one embodiment. Based on such a determination, a dependency lock is generated for the version of the object, and the first database server process is suspended, preventing the completion of execution of the earlier received operation on the database. Another, second database server process executes another operation on the database and causes the generation of the version of the object on the database. The dependency lock is thereby released for the version of the object, and the first database server process completes the execution of the first operation on the first database.

Dependency locking

A plurality of mid-tier databases form a single, consistent cache grid for data in one or more backend data sources, such as a database system. The mid-tier databases may be standard relational databases. Cache agents at each mid-tier database swap in data from the backend database as needed. Ownership locks maintain consistency in the cache grid. Cache agents prevent database operations that will modify cached data in a mid-tier database unless and until ownership of the cached data can be acquired for the mid-tier database. Cache groups define what backend data may be cached, as well as a general structure in which the backend data is to be cached. Metadata for cache groups is shared to ensure that data is cached in the same form throughout the entire grid. Ownership of cached data can then be tracked through a mapping of cached instances of data to particular mid-tier databases.

Distributed consistent grid of in-memory database caches

A system includes an active node and a standby node and zero or more replica nodes. Each of the nodes includes a database system, such as an in-memory database system. Client updates applied to the active node are written through to the standby node, and the standby node writes the updates through to a primary database and updates the replica nodes. Commit ticket numbers tag entries in transaction logs and are used to facilitate recovery if either of the active node or the standby node fails. Updates applied to the primary database are autorefreshed to the active node and written through by the active node to the standby node which propagates the updates to the replica nodes. Bookmarks are used to track updated records of the primary database and are used to facilitate recovery if either of the active node or the standby node fails.

Database system with active standby and nodes

A replication track is a designated group of transactions that are to be replicated at a destination database in a way that, with respect to any other transaction in the replication track, preserves transactional dependency. Further, transactions in a replication track can be replicated at the destination database without regard to transactional dependency of other transactions in another track. This facilitates concurrent parallel replication of transactions of different tracks. Replicating data in this manner is referred to herein as track replication. An application may request execution of transactions and designate different tracks for transactions.

User-defined parallelization in transactional replication of in-memory database

A system for monitoring and analyzing operation of a tape infrastructure. The system includes a plurality of real and virtual tape libraries each including a plurality of tape drives and tape media. The system includes a server linked to the tape library. On the server, a storage tape analytics application is provided that functions to extract raw data sets from the tape library corresponding to operations of the tape library. The data pertains to use of the drives and media during data storage operations and data about the activities of the real or virtual tape libraries. The analytics application stores the extracted data sets in an analytics database. The analytics application provides a user interface for viewing data in the analytics database, e.g., a GUI operable by monitoring personnel to view and interact with the gathered and processed tape operations monitoring data to provide historical and user-driven analysis of data for an entire data center.

Data storage tape analytics method and system

A plurality of mid-tier databases form a single, consistent cache grid for data in a one or more backend data sources, such as a database system. The mid-tier databases may be standard relational databases. Cache agents at each mid-tier database swap in data from the backend database as needed. Consistency in the cache grid is maintained by ownership locks. Cache agents prevent database operations that will modify cached data in a mid-tier database unless and until ownership of the cached data can be acquired for the mid-tier database. Cache groups define what backend data may be cached, as well as a general structure in which the backend data is to be cached. Metadata for cache groups is shared to ensure that data is cached in the same form throughout the entire grid. Ownership of cached data can then be tracked through a mapping of cached instances of data to particular mid-tier databases.

Growing community of inventors

Lafayette, CO, United States of America

John William Miller