公开(公告)号：US20190079864A1

公开(公告)日：2019-03-14

申请号：US15705166

申请日：2017-09-14

Applicant: Oracle International Corporation

Inventor： Jia Shi ,  Wei Zhang ,  Kothanda Umamageswaran ,  Neil J.S. MacNaughton ,  Vijayakrishnan Nagarajan

IPC: G06F12/0808 ,  G06F13/28 ,  G06F17/30

Abstract: Techniques related to a server-side extension of client-side caches are provided. A storage server computer receives, from a database server computer, an eviction notification indicating that a data block has been evicted from the database server computer's cache. The storage server computer comprises a memory hierarchy including a volatile cache and a persistent cache. Upon receiving the eviction notification, the storage server computer retrieves the data block from the persistent cache and stores it in the volatile cache. When the storage server computer receives, from the database server computer, a request for the data block, the storage server computer retrieves the data block from the volatile cache. Furthermore, the storage server computer sends the data block to the database server computer, thereby causing the data block to be stored in the database server computer's cache. Still further, the storage server computer evicts the data block from the volatile cache.

公开(公告)号：US10831666B2

公开(公告)日：2020-11-10

申请号：US16153674

申请日：2018-10-05

Applicant: Oracle International Corporation

Inventor： Jia Shi ,  Wei Zhang ,  Vijayakrishnan Nagarajan ,  Shih-Yu Huang ,  Kothanda Umamageswaran

IPC: G06F12/084 ,  G06F11/14 ,  G06F12/0897 ,  G06F16/2455

Abstract: Techniques related to failover to the secondary storage server from a primary storage server of a database server without degrading the performance of servicing storage requests for client applications are provided. In an embodiment, the secondary storage server receives, from the database server, an eviction notification indicating that a set of data blocks has been evicted from a cache. The secondary storage server's memory hierarchy includes a secondary cache and a secondary persistent storage that stores a second copy of the set of data blocks. The secondary storage server persistently stores a copy of data, which is also persistently stored on the primary storage server, which includes a first copy of the set of data blocks. In an embodiment, upon receiving the eviction notification, the secondary storage server retrieves the second copy of the set of data blocks from the secondary persistent storage of the secondary storage server and loads the second copy of the set of data blocks into the secondary cache. After an interruption event, the secondary storage receives a request for a subset of the set of data blocks based on a request for data, at the database server. Upon receiving the request for the subset of the set of data blocks, the second storage server retrieves the subset of the set of data blocks from the second copy of the set of data blocks stored on the secondary cache of the secondary storage server without retrieving any of such data blocks from the second copy of the set of data blocks stored on the persistent storage of the secondary storage server. The second storage server sends the subset of the set of data blocks to the database server.

公开(公告)号：US11455219B2

公开(公告)日：2022-09-27

申请号：US17077028

申请日：2020-10-22

Applicant: Oracle International Corporation

Inventor： Krishna Kantikiran Pasupuleti ,  Boris Klots ,  Vijayakrishnan Nagarajan ,  Anantha Kiran Kandukuri ,  Nipun Agarwal

IPC: G06F11/00 ,  G06F11/20 ,  G06F16/2453 ,  G06F16/2455

Abstract: Herein are acceleration techniques for resuming offloaded execution by replacing a failed computer with a hot spare computer. In an embodiment, a distributed system configures a DBMS, a set of participating computers, and a set of spare computers. The DBMS receives a query of a database. From the query, an offload query plan is generated for distributed execution. The DBMS sends the offload query plan and a respective portion of the database to each participating computer. The distributed system detects that a participating computer failed after the offload query plan was sent. Responsively, the DBMS sends the same offload query plan and same respective portion of the database of the failed computer to a replacement computer from the spare computers. Despite the computer failure, the DBMS receives results of successful distributed execution of the offload query plan that include a result from the replacement computer.

公开(公告)号：US11327887B2

公开(公告)日：2022-05-10

申请号：US15705166

申请日：2017-09-14

Applicant: Oracle International Corporation

Inventor： Jia Shi ,  Wei Zhang ,  Kothanda Umamageswaran ,  Neil J. S. MacNaughton ,  Vijayakrishnan Nagarajan

IPC: G06F15/167 ,  G06F12/0808 ,  G06F13/28 ,  G06F16/10 ,  G06F16/172

Abstract: Techniques related to a server-side extension of client-side caches are provided. A storage server computer receives, from a database server computer, an eviction notification indicating that a data block has been evicted from the database server computer's cache. The storage server computer comprises a memory hierarchy including a volatile cache and a persistent cache. Upon receiving the eviction notification, the storage server computer retrieves the data block from the persistent cache and stores it in the volatile cache. When the storage server computer receives, from the database server computer, a request for the data block, the storage server computer retrieves the data block from the volatile cache. Furthermore, the storage server computer sends the data block to the database server computer, thereby causing the data block to be stored in the database server computer's cache. Still further, the storage server computer evicts the data block from the volatile cache.

公开(公告)号：US20220129358A1

公开(公告)日：2022-04-28

申请号：US17077028

申请日：2020-10-22

Applicant: Oracle International Corporation

Inventor： Krishna Kantikiran Pasupuleti ,  Boris Klots ,  Vijayakrishnan Nagarajan ,  Anantha Kiran Kandukuri ,  Nipun Agarwal

IPC: G06F11/20 ,  G06F16/2455 ,  G06F16/2453

Abstract: Herein are acceleration techniques for resuming offloaded execution by replacing a failed computer with a hot spare computer. In an embodiment, a distributed system configures a DBMS, a set of participating computers, and a set of spare computers. The DBMS receives a query of a database. From the query, an offload query plan is generated for distributed execution. The DBMS sends the offload query plan and a respective portion of the database to each participating computer. The distributed system detects that a participating computer failed after the offload query plan was sent. Responsively, the DBMS sends the same offload query plan and same respective portion of the database of the failed computer to a replacement computer from the spare computers. Despite the computer failure, the DBMS receives results of successful distributed execution of the offload query plan that include a result from the replacement computer.