Oracle International Corporation

Varun Malhotra

Tirthankar Lahiri

Juan R Loaiza

Daniel ManHung Wong

Sumanta Kumar Chatterjee

Hakan Jakobsson

Sanjay Kaluskar

Margaret Susairaj

Dmitry Mikhailovich Potapov

Neil MacNaughton

Paul Youn

Kiran Badrinarain Goyal

Adam Y Lee

One embodiment of the present invention provides a system for performing selective encryption/decryption in a data storage system. During operation, the system receives a data block from a storage medium at an input/output layer, wherein the input/output layer serves as an interface between the storage medium and a buffer cache. Next, the system determines whether the data block is an encrypted data block. If not, the system stores the data block in the buffer cache. Otherwise, if the data block is an encrypted data block, the system retrieves a storage-key, wherein the storage-key is associated with a subset of storage, which is associated with the encrypted data block. Using the storage-key, the system then decrypts the encrypted data block to produce a decrypted data block. Finally, the system stores the decrypted data block in the buffer cache, wherein the data block remains encrypted in the storage medium.

Method and apparatus for performing selective encryption/decryption in a data storage system

A method, system, and computer program product for cost based analysis for data access in a database management system. In one approach, the method, system, and computer program product identifies data to access. A first cost for direct I/O storage access and a second cost for cache access are then determined for accessing the data. A comparison between the first cost and the second cost is then performed. Finally, a first portion of identified data is accessed based at least in part upon the comparison.

Cost based analysis of direct I/O access

Described herein are techniques for generating a global checkpoint system change number and computing a snapshot query using the global checkpoint system change number without a need to acquire global locks. In many cases, the need to acquire global locks is eliminated, thereby saving the overhead attendant to processing global locks.

Global checkpoint SCN

Growing community of inventors

Palo Alto, CA, United States of America

Varun Malhotra