Oracle International Corporation

Rubrik, Inc.

Oracel International Corporation

Bipul Sinha

Amit Ganesh

Srinivas Vemuri

Lakshminarayanan Luxi Chidambaran

Wanli Yang

Vivekanandhan Raja

Juan R Loaiza

Arvind Jain

Soham Mazumdar

Adam Gee

Arvind Nithrakashyap

Jonathan Carlyle Derryberry

Kenny To

Tirthankar Lahiri

Jonathan D Klein

Srinath Krishnaswamy

Manosiz Bhattacharyya

Vasudha Krishnaswamy

Mehul Dilip Bastawala

Daniel ManHung Wong

Namit Jain

Dieter Gawlick

Niloy Mukherjee

Dheeraj Pandey

William Bridge

J William Lee

Hardik Vohra

Dmitry Mikhailovich Potapov

Alok Pareek

Wei Ming Hu

Biswaroop Palit

Atrayee Mullick

Michael John De Groot

Steven Wertheimer

Pranava Kumar Adduri

Eshwar Belani

Kenneth R Jacobs

Chi Ching Chui

Aravind Menon

Archna Kalra Johnson

Francisco Sanchez

Liang Guo

Claudia Yu

Alexander Hwang

Jayanth Madheswaran

Venkatesh Radhakrishnan

Shen-Ban Meng

Subramanyam B Chitti

Eric W Bing

Yong Hu

Adam Weitz Goldberg

Tanveer Junayed

Raylin Marie Wright

Raymond Carino

Methods and systems for managing, storing, and serving data within a virtualized environment are described. In some embodiments, a data management system may manage the extraction and storage of virtual machine snapshots, provide near instantaneous restoration of a virtual machine or one or more files located on the virtual machine, and enable secondary workloads to directly use the data management system as a primary storage target to read or modify past versions of data. The data management system may allow a virtual machine snapshot of a virtual machine stored within the system to be directly mounted to enable substantially instantaneous virtual machine recovery of the virtual machine.

Data management system

A query result set is an example of a type of body of data whose content is defined by a query. Modifications to a database can change the result of a query and therefore what the content of such a body of data, such as a result set, should be. Active Queries is an approach that enables a database server to detect database changes that alter the result of a query registered for a client and to notify a client of those changes. The notifications may be sent to, for example, a cache manager responsible for maintaining coherency of a result set cache generated by the query. The notification notifies the cache manager of when and/or what changes are needed to maintain the coherency of the cache.

Active queries filter extraction

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.

Server supporting a consistent client-side cache

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.

Consistent client-side cache

Display screen or portion thereof with graphical user interface

Disclosed is a mechanism, system, interface, and process to determine one or more life intervals when given a key. In addition, one or more life intervals can be determined for each key within a range of keys. This type of process is useful for auditing purposes or if it is desire to implement a query upon past versions when a key or range of keys is specified for the data for which past versions is desired. This facilitates algorithms, mechanisms, and processes to implement a query upon past versions.

Method and mechanism for determining life intervals for a key in an index

A bulk delete operation with reduced latency allows for retrieval of deleted data. Each database object holds a Delete SCN indicating when a bulk delete operation was last performed. Each row in the database object holds a Row Modification SCN indicating when the row was last updated. A bulk delete is performed by writing the old value of the Delete SCN to the undo tablespace and updating the Delete SCN. No undo information is stored for the rows. A write is performed by finding a deleted row, storing undo information for the deleted row and writing over the deleted row. To read from the database object, a rollback operation is performed, if necessary. Those rows are then retrieved for which the Row Modification SCN is higher than the Delete SCN and is less than or equal to the timestamp for the requested data.

Framework to optimize delete all row operations on database objects to improve throughput, query ability and flashback

A method, system and computer program product for transparent support for distributed transactions in a clustered disk-sharing database environment is disclosed. In one approach, a method, a system and a computer program product are disclosed that disassociate a transaction with a session at a first resource manger, send a request to a second resource manager for the transaction that requires access to stored transaction information from prior requests for the transaction, determine whether the second resource manager has access to transaction information for the transaction stored using the session that has been disassociated with the transaction, obtain an identity of the first resource manager in data shared by the first and the second resource managers, and request access to the transaction information at the first resource manager.

Transparent support for distributed transactions in a clustered disk-sharing database environment

A method and apparatus for data recovery are disclosed. Undo tablespace size is calculated for user-specified undo retention time based on system statistics collected over a period of time specified by a history time parameter.

Undo advisor

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 automatically tracking and archiving transactional data changes

Techniques are disclosed for creating and using a filter index in order to identify registered queries whose result sets are likely to have been changed by changes made to tables. The filter index entries are based on filter conditions. The filter conditions are created based on predicates contained in the registered queries. The filter conditions may include exclusive predicates and join predicates. Join predicates that join a table Twith a table Tmay be instantiated by replacing references to table Twith values extracted from table T. Various techniques are described for recognizing situations in which a query can be included in, or excluded from, the set of likely-changed queries, without fully evaluating the filter conditions that correspond to the queries.

Adaptive filter index for determining queries affected by a DML operation

Techniques are described to allow a query to be registered as a persistent stored entity within the database, and to generate notifications as and when the query result changes continuously as long as the query continues to be registered with the database. According to one aspect, for a table referenced in a query, a filter condition is generated based, at least in part, on a predicate of the query. Then, the database server determines whether the filter condition is satisfied by either a before image of a row, or an after image of the row, that was modified by a transaction. If the filter condition is satisfied by either the before image or the after image, then the query is added to a first set of queries whose result sets may have been affected by the transaction. From among the first set of queries, a second set of queries that have result sets that were actually affected by the transaction is determined. Notifications are then sent based on the second set of queries.

Generating continuous query notifications

Disclosed are algorithms, mechanisms, processes, mechanisms, and systems to implement a query upon past versions. In one approach, the version query can be defined as either 'rowid'-based access or non-rowid based access. With rowid based access, a given rowid is used to identify the data for which past versions are desired. Also disclosed is a mechanism, system, interface, and process to allow specification of a new table decoration clause to obtain one or more past version of one or more data items. The version query provides for a direct interface to get multiple versions of the row(s). In addition, information about the past versions can be retrieved and displayed along with the past versions.

Method and mechanism for row versioning

Growing community of inventors

Foster City, CA, United States of America

Bipul Sinha