Oracle International Corporation

Siddharth Teotia

Juan R Loaiza

Tirthankar Lahiri

Garret Frederick Swart

Jesse Kamp

Michael J Gleeson

Kam Shergill

Neil J S MacNaughton

Krishna Kunchithapadam

Neil JS Macnaughton

A hashing scheme includes a cache-friendly, latchless, non-blocking dynamically resizable hash index with constant-time lookup operations that is also amenable to fast lookups via remote memory access. Specifically, the hashing scheme provides each of the following features: latchless reads, fine grained lightweight locks for writers, non-blocking dynamic resizability, cache-friendly access, constant-time lookup operations, amenable to remote memory access via RDMA protocol through one sided read operations, as well as non-RDMA access.

Latchless, non-blocking dynamically resizable segmented hash index

Techniques are provided for enabling a requesting entity to retrieve data that is managed by a database server instance from the volatile memory of a server machine that is executing the database server instance. The techniques allow the requesting entity to retrieve the data from the volatile memory of the host server machine without involving the database server instance in the retrieval operation. Because the retrieval does not involve the database server instance, the retrieval may succeed even when the database server instance has stalled or become unresponsive. In addition, direct retrieval of data using the techniques described herein will often be faster and more efficient than retrieval of the same information through conventional interaction with the database server instance.

Method for efficient primary key based queries using atomic RDMA reads on cache friendly in-memory hash index

Growing community of inventors

Foster City, CA, United States of America

Siddharth Teotia