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

US10803039B2 · kind B2 · utility

Assignee

• Oracle International Corporation · US

Inventors

• Siddharth Teotia · Foster City, US
• Krishna Kunchithapadam · Portland, US
• Jesse Kamp · Castro Valley, US
• Tirthankar Lahiri · Palo Alto, US
• Michael J. Gleeson · Saratoga, US
• Juan R. Loaiza · Woodside, US
• Garret F. Swart · Palo Alto, US
• Neil MacNaughton · Los Gatos, US
• Kam Shergill · Maidenhead, GB

Key dates

• Filing date: May 26, 2017
• Grant date: Oct 13, 2020
• Expiry date: Oct 10, 2037

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F16/907
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

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.