公开(公告)号：US20220114058A1

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

申请号：US17137745

申请日：2020-12-30

Applicant: Oracle International Corporation

Inventor： Ajit Mylavarapu ,  Vasudha Krishnaswamy ,  Sukhada Pendse ,  Solmaz Kolahi ,  Ankita Kumar ,  Garret F. Swart ,  Tirthankar Lahiri ,  Juan R. Loaiza

IPC: G06F11/14 ,  G06F16/22

Abstract: A shared-nothing database system is provided in which parallelism and workload balancing are increased by assigning the rows of each table to “slices”, and storing multiple copies (“duplicas”) of each slice across the persistent storage of multiple nodes of the shared-nothing database system. When the data for a table is distributed among the nodes of a shared-nothing system in this manner, requests to read data from a particular row of the table may be handled by any node that stores a duplica of the slice to which the row is assigned. For each slice, a single duplica of the slice is designated as the “primary duplica”. All DML operations (e.g. inserts, deletes, updates, etc.) that target a particular row of the table are performed by the node that has the primary duplica of the slice to which the particular row is assigned. The changes made by the DML operations are then propagated from the primary duplica to the other duplicas (“secondary duplicas”) of the same slice.

公开(公告)号：US10977193B2

公开(公告)日：2021-04-13

申请号：US16542222

申请日：2019-08-15

Applicant: Oracle International Corporation

Inventor： Hideaki Kimura ,  Garret F. Swart ,  Spyros Blanas

IPC: G06F13/00 ,  G06F12/1081 ,  G06F16/23

Abstract: Techniques are described for offloading remote direct memory operations (RDMOs) to “execution candidates”. The execution candidates may be any hardware capable of performing the offloaded operation. Thus, the execution candidates may be network interface controllers, specialized co-processors, FPGAs, etc. The execution candidates may be on a machine that is remote from the processor that is offloading the operation, or may be on the same machine as the processor that is offloading the operation. Details for certain specific RDMOs, which are particularly useful in online transaction processing (OLTP) and hybrid transactional/analytical (HTAP) workloads, are provided.

公开(公告)号：US10803039B2

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

申请号：US15606322

申请日：2017-05-26

Applicant: Oracle International Corporation

Inventor： Siddharth Teotia ,  Krishna Kunchithapadam ,  Jesse Kamp ,  Tirthankar Lahiri ,  Michael J. Gleeson ,  Juan R. Loaiza ,  Garret F. Swart ,  Neil J. S. MacNaughton ,  Kam Shergill

IPC: G06F12/1045 ,  G06F15/173 ,  G06F16/22 ,  G06F16/907

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.

公开(公告)号：US20190294558A1

公开(公告)日：2019-09-26

申请号：US16435101

申请日：2019-06-07

Applicant: Oracle International Corporation

Inventor： Siddharth Teotia ,  Krishna Kunchithapadam ,  Tirthankar Lahiri ,  Jesse Kamp ,  Michael J. Gleeson ,  Juan R. Loaiza ,  Garret F. Swart ,  Neil J.S. MacNaughton ,  Kam Shergill

IPC: G06F12/1018 ,  G06F16/2453 ,  G06F16/22 ,  G06F12/126 ,  G06F12/0864 ,  G06F12/0868 ,  G06F12/128 ,  G06F16/901

Abstract: 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.

公开(公告)号：US10055224B2

公开(公告)日：2018-08-21

申请号：US14964805

申请日：2015-12-10

Applicant: Oracle International Corporation

Inventor： Kathirgamar Aingaran ,  Garret F. Swart

IPC: G06F9/30 ,  G06F17/30 ,  G06F9/54 ,  G06F9/38 ,  G06F12/0804 ,  G06F12/12 ,  G06F15/173 ,  G06F12/0817 ,  G06F12/14 ,  G06F21/62 ,  H04L29/06 ,  G06F15/78 ,  G06F13/10 ,  G06F13/362 ,  G06F13/40

CPC classification number: G06F9/30065 ,  G06F9/381 ,  G06F9/3851 ,  G06F9/3867 ,  G06F9/546 ,  G06F12/0804 ,  G06F12/082 ,  G06F12/12 ,  G06F12/1408 ,  G06F12/1475 ,  G06F13/102 ,  G06F13/362 ,  G06F13/4068 ,  G06F15/17331 ,  G06F15/7889 ,  G06F16/2237 ,  G06F16/2453 ,  G06F16/24553 ,  G06F16/24558 ,  G06F16/2456 ,  G06F16/24561 ,  G06F16/24569 ,  G06F16/273 ,  G06F16/284 ,  G06F16/9535 ,  G06F21/6209 ,  H04L69/14 ,  Y02D10/14 ,  Y02D10/151 ,  Y02D10/45

Abstract: A method and apparatus for reconfiguring hardware structures to pipeline the execution of multiple special purpose hardware implemented functions, without saving intermediate results to memory, is provided. Pipelining functions in a program is typically performed by a first function saving its results (the “intermediate results”) to memory, and a second function subsequently accessing the memory to use the intermediate results as input. Saving and accessing intermediate results stored in memory incurs a heavy performance penalty, requires more power, consumes more memory bandwidth, and increases the memory footprint. Due to the ability to redirect the input and output of the hardware structures, intermediate results are passed directly from one special purpose hardware implemented function to another without storing the intermediate results in memory. Consequently, a program that utilizes the method or apparatus, reduces power consumption, consumes less memory bandwidth, and reduces the program's memory footprint.

公开(公告)号：US20140095748A1

公开(公告)日：2014-04-03

申请号：US13789524

申请日：2013-03-07

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Kathirgamar Aingaran ,  Garret F. Swart

IPC: G06F9/38

CPC classification number: G06F9/30065 ,  G06F9/381 ,  G06F9/3851 ,  G06F9/3867 ,  G06F9/546 ,  G06F12/0804 ,  G06F12/082 ,  G06F12/12 ,  G06F12/1408 ,  G06F12/1475 ,  G06F13/102 ,  G06F13/362 ,  G06F13/4068 ,  G06F15/17331 ,  G06F15/7889 ,  G06F17/30324 ,  G06F17/30442 ,  G06F17/30483 ,  G06F17/30495 ,  G06F17/30498 ,  G06F17/30501 ,  G06F17/30519 ,  G06F17/30578 ,  G06F17/30595 ,  G06F17/30867 ,  G06F21/6209 ,  H04L69/14 ,  Y02D10/14 ,  Y02D10/151 ,  Y02D10/45

Abstract: A method and apparatus for reconfiguring hardware structures to pipeline the execution of multiple special purpose hardware implemented functions, without saving intermediate results to memory, is provided. Pipelining functions in a program is typically performed by a first function saving its results (the “intermediate results”) to memory, and a second function subsequently accessing the memory to use the intermediate results as input. Saving and accessing intermediate results stored in memory incurs a heavy performance penalty, requires more power, consumes more memory bandwidth, and increases the memory footprint. Due to the ability to redirect the input and output of the hardware structures, intermediate results are passed directly from one special purpose hardware implemented function to another without storing the intermediate results in memory. Consequently, a program that utilizes the method or apparatus, reduces power consumption, consumes less memory bandwidth, and reduces the program's memory footprint.

Abstract translation: 提供了一种用于重新配置硬件结构以管理多个专用硬件实现的功能的执行而不将中间结果保存到存储器的方法和装置。 程序中的流水线功能通常由将其结果（“中间结果”）保存到存储器的第一功能执行，而第二功能随后访问存储器以将中间结果用作输入。 保存和访问存储在内存中的中间结果会导致严重的性能损失，需要更多的电力，消耗更多的内存带宽，并增加内存占用。 由于能够重定向硬件结构的输入和输出，中间结果直接从一个专用硬件实现的功能传递到另一个而不将中间结果存储在存储器中。 因此，利用该方法或装置的程序降低功耗，消耗较少的存储器带宽，并减少程序的存储器占用。

公开(公告)号：US20140095468A1

公开(公告)日：2014-04-03

申请号：US13778009

申请日：2013-02-26

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Kathirgamar Aingaran ,  Garret F. Swart ,  Sanjiv Kapil

IPC: G06F17/30

CPC classification number: G06F9/30065 ,  G06F9/381 ,  G06F9/3851 ,  G06F9/3867 ,  G06F9/546 ,  G06F12/0804 ,  G06F12/082 ,  G06F12/12 ,  G06F12/1408 ,  G06F12/1475 ,  G06F13/102 ,  G06F13/362 ,  G06F13/4068 ,  G06F15/17331 ,  G06F15/7889 ,  G06F17/30324 ,  G06F17/30442 ,  G06F17/30483 ,  G06F17/30495 ,  G06F17/30498 ,  G06F17/30501 ,  G06F17/30519 ,  G06F17/30578 ,  G06F17/30595 ,  G06F17/30867 ,  G06F21/6209 ,  H04L69/14 ,  Y02D10/14 ,  Y02D10/151 ,  Y02D10/45

Abstract: Techniques for processing a query are provided. One or more operations that are required to process a query are performed by a coprocessor that is separate from a general purpose microprocessor that executes query processing software. The query processing software receives a query, determines one or more operations that are required to be executed to fully process the query, and issues one or more commands to one or more coprocessors that are programmed to perform one of the operations, such as a table scan operation and/or a lookup operation. The query processing software obtains results from the coprocessor(s) and performs one or more additional operations thereon to generate a final result of the query.

Abstract translation: 提供了处理查询的技术。 处理查询所需的一个或多个操作由与执行查询处理软件的通用微处理器分开的协处理器执行。 查询处理软件接收查询，确定要执行的一个或多个操作以完全处理该查询，并向被编程为执行其中一个操作的一个或多个协处理器发出一个或多个命令，诸如表 扫描操作和/或查找操作。 查询处理软件从协处理器获得结果，并在其上执行一个或多个附加操作以生成查询的最终结果。