公开(公告)号：US20210073226A1

公开(公告)日：2021-03-11

申请号：US17015580

申请日：2020-09-09

Applicant: Oracle International Corporation

Inventor： SHASANK KISAN CHAVAN ,  GARRET F. SWART ,  WEIWEI GONG

IPC: G06F16/2453 ,  G06F16/901 ,  G06N20/00

Abstract: The present invention relates to optimized access of a database. Herein are techniques to accelerate execution of any combination of ad hoc query, heterogenous hardware, and fluctuating workload. In an embodiment, a computer receives a data access request for data tuples and compiles the data access request into relational operators. A particular implementation of a particular relational operator is dynamically selected from multiple interchangeable implementations. Each interchangeable implementation contains respective physical operators. A particular hardware operator for a particular physical operator is selected from multiple interchangeable hardware operators that include: a first hardware operator that executes on first processing hardware, and a second hardware operator that executes on second processing hardware that is functionally different from the first processing hardware. A response to the data access request is generated based on: the data tuples, the particular implementation of the particular relational operator, and the particular hardware operator.

公开(公告)号：US20220382721A1

公开(公告)日：2022-12-01

申请号：US17334360

申请日：2021-05-28

Applicant: Oracle International Corporation

Inventor： NAGARAJAN MUTHUKRISHNAN ,  BINOY SUKUMARAN ,  GARRET F. SWART ,  SUMANTA CHATTERJEE ,  RAVI SHANKAR THAMMAIAH

IPC: G06F16/21 ,  G06F11/34 ,  G06F16/25 ,  G06F11/20 ,  H04L29/08

Abstract: Herein are resource-constrained techniques that plan ahead for resiliently moving pluggable databases between container databases after a failure in a high-availability database cluster. In an embodiment, a computer identifies many alternative placements that respectively assign each pluggable database to a respective container database. For each alternative placement, a respective resilience score is calculated for each pluggable database that is based on the container database of the pluggable database. Based on the resilience scores of the pluggable databases for the alternative placements, a particular placement is selected as an optimal placement that would maximize utilization of computer resources, minimize database latencies, maximize system throughput, and maximize the ability of the database cluster to avoid a service outage.

公开(公告)号：US20230342355A1

公开(公告)日：2023-10-26

申请号：US17728647

申请日：2022-04-25

Applicant: Oracle International Corporation

Inventor： YUNRUI LI ,  WEI-MING HU ,  JUAN R. LOAIZA ,  J. WILLIAM LEE ,  ADAM Y. LEE ,  CARLOS RUIZ ,  AMRISH SRIVASTAVA ,  GARRET F. SWART ,  MAHESH BABURAO GIRKAR

IPC: G06F16/2453 ,  G06F16/2457 ,  G06F16/248 ,  G06F13/16

CPC classification number: G06F16/24539 ,  G06F16/24573 ,  G06F16/248 ,  G06F13/1673

Abstract: Techniques are described herein for an integrated in-front database cache (“IIDC”) providing an in-memory, consistent, and automatically managed cache for primary database data. An IIDC comprises a database server instance that (a) caches data blocks from a source database managed by a second database server instance, and (b) performs recovery on the cached data using redo records for the database data. The IIDC instance implements relational algebra and is configured to run any complexity of query over the cached database data. Any cache miss results in the IIDC instance fetching the needed block(s) from a second database server instance managing the source database that provides the IIDC instance with the latest version of the requested data block(s) that is available to the second instance. Because redo records are used to continuously update the data blocks in an IIDC cache, the IIDC guarantees consistency of query results.

公开(公告)号：US20140095805A1

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

申请号：US13839525

申请日：2013-03-15

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： SANJIV KAPIL ,  GARRET F. SWART ,  AINGS AINGARAN ,  WILLIAM H. BRIDGE, JR. ,  SUMTI JAIRATH ,  JOHN G. JOHNSON

IPC: G06F12/14 ,  G06F12/08

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 system and method implementing revocable secure remote keys is disclosed. A plurality of indexed base secrets is stored in a register of a coprocessor of a local node coupled with a local memory. When it is determined that a selected base secret expired, the base secret stored in the register based on the base secret index is changed, thereby invalidating remote keys generated based on the expired base secret. A remote key with validation data and a base secret index is received from a node requesting access to the local memory. A validation base secret is obtained from the register based on the base secret index. The coprocessor performs hardware validation on the validation data based on the validation base secret. Hardware validation fails if the base secret associated with the base secret index has been changed in the register of the selected coprocessor.

Abstract translation: 公开了一种实现可撤销的安全远程键的系统和方法。 多个索引的基本秘密被存储在与本地存储器耦合的本地节点的协处理器的寄存器中。 当确定所选择的基本秘密到期时，基于所述基本秘密索引存储在所述寄存器中的所述基本秘密被改变，从而使基于所述过期的基本秘密生成的远程密钥无效。 从请求访问本地存储器的节点接收具有验证数据和基本秘密索引的远程密钥。 基于基本秘密索引从寄存器获得验证基本密码。 协处理器基于验证基础密码对验证数据执行硬件验证。 如果在所选协处理器的寄存器中改变与基本秘密索引相关联的基本秘密，则硬件验证失败。