公开(公告)号：WO2018063723A1

公开(公告)日：2018-04-05

申请号：PCT/US2017/049464

申请日：2017-08-30

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： MUKHERJEE, Niloy ,  KAMP, Jesse ,  LAHIRI, Tirthankar ,  COLGAN, Maria ,  RAJA, Vivekanandhan ,  KRISHNASWAMY, Vasudha ,  GUPTA, Aditi ,  KULKARNI, Kartik

IPC: G06F17/30 ,  G06F9/50

Abstract: Techniques are described herein for distributing distinct portions of a database object across volatile memories of selected nodes of a plurality of nodes in a clustered database system. The techniques involve storing a unit-to-service mapping that associates a unit (a database object or portion thereof) to one or more database services. The one or more database services are mapped to one or more nodes. The nodes to which a service is mapped may include nodes in disjoint database systems, so long as those database systems have access to a replica of the unit. The database object is treated as in-memory enabled by nodes that are associated with the service, and are treated as not in-memory enabled by nodes that are not associated with the service.

Abstract translation: 本文描述了用于跨集群数据库系统中的多个节点的选定节点的易失性存储器分布数据库对象的不同部分的技术。 这些技术涉及存储将单元（数据库对象或其部分）与一个或多个数据库服务相关联的单元到服务的映射。 一个或多个数据库服务被映射到一个或多个节点。 服务映射到的节点可以包括不相交数据库系统中的节点，只要这些数据库系统可以访问该单元的副本。 数据库对象被视为内存使能，由与服务关联的节点启用，并被视为不与服务关联的节点启用内存。

公开(公告)号：WO2022081394A1

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

申请号：PCT/US2021/053819

申请日：2021-10-06

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： KAMP, Jesse ,  HOLLOWAY, Allison L. ,  HSU, Meichun ,  KIMURA, Hideaki ,  KLOTS, Boris ,  KRISHNASWAMY, Vasudha ,  KULKARNI, Kartik ,  LEE, Teck Hua ,  LI, Yunrui ,  MISHRA, Aurosish ,  MYLAVARAPU, Ajit ,  PENDSE, Sukhada ,  SWART, Garret F. ,  CHAVAN, Shasank K. ,  LAHIRI, Tirthankar ,  LOAIZA, Juan R.

IPC: G06F16/27

Abstract: A shared-nothing database system is provided in which the rows of each table are assigned to "slices", and multiple copies ("duplicas") of each slice are stored across the persistent storage of multiple nodes. 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 are performed by the node that has the primary duplica of the slice to which the target row is assigned. The changes are then propagated other duplicas ("secondary duplicas") of the same slice.

公开(公告)号：EP4455900A3

公开(公告)日：2024-11-06

申请号：EP24194921.3

申请日：2021-10-06

Applicant: Oracle International Corporation

Inventor： KAMP, Jesse ,  HOLLOWAY, Allison L. ,  HSU, Meichun ,  KIMURA, Hideaki ,  KLOTS, Boris ,  KRISHNASWAMY, Vasudha ,  KULKARNI, Kartik ,  LEE, Teck Hua ,  LI, Yunrui ,  MISHRA, Aurosish ,  MYLAVARAPU, Ajit ,  PENDSE, Sukhada ,  SWART, Garret F. ,  CHAVAN, Shasank K. ,  LAHIRI, Tirthankar ,  LOAIZA, Juan R.

IPC: G06F16/27 ,  G06F16/23 ,  G06F16/2455

Abstract: A shared-nothing database system is provided in which the rows of each table are assigned to "slices", and multiple copies ("duplicas") of each slice are stored across the persistent storage of multiple nodes. 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 are performed by the node that has the primary duplica of the slice to which the target row is assigned. The changes are then propagated other duplicas ("secondary duplicas") of the same slice.

公开(公告)号：EP3519985A1

公开(公告)日：2019-08-07

申请号：EP17764999.3

申请日：2017-08-30

Applicant: Oracle International Corporation

Inventor： MUKHERJEE, Niloy ,  KAMP, Jesse ,  LAHIRI, Tirthankar ,  COLGAN, Maria ,  RAJA, Vivekanandhan ,  KRISHNASWAMY, Vasudha ,  GUPTA, Aditi ,  KULKARNI, Kartik

IPC: G06F17/30 ,  G06F9/50

公开(公告)号：EP4455900A2

公开(公告)日：2024-10-30

申请号：EP24194921.3

申请日：2021-10-06

Applicant: Oracle International Corporation

Inventor： KAMP, Jesse ,  HOLLOWAY, Allison L. ,  HSU, Meichun ,  KIMURA, Hideaki ,  KLOTS, Boris ,  KRISHNASWAMY, Vasudha ,  KULKARNI, Kartik ,  LEE, Teck Hua ,  LI, Yunrui ,  MISHRA, Aurosish ,  MYLAVARAPU, Ajit ,  PENDSE, Sukhada ,  SWART, Garret F. ,  CHAVAN, Shasank K. ,  LAHIRI, Tirthankar ,  LOAIZA, Juan R.

IPC: G06F16/27

Abstract: A shared-nothing database system is provided in which the rows of each table are assigned to "slices", and multiple copies ("duplicas") of each slice are stored across the persistent storage of multiple nodes. 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 are performed by the node that has the primary duplica of the slice to which the target row is assigned. The changes are then propagated other duplicas ("secondary duplicas") of the same slice.

公开(公告)号：EP4229522A1

公开(公告)日：2023-08-23

申请号：EP21801751.5

申请日：2021-10-06

Applicant: Oracle International Corporation

Inventor： KAMP, Jesse ,  HOLLOWAY, Allison L. ,  HSU, Meichun ,  KIMURA, Hideaki ,  KLOTS, Boris ,  KRISHNASWAMY, Vasudha ,  KULKARNI, Kartik ,  LEE, Teck Hua ,  LI, Yunrui ,  MISHRA, Aurosish ,  MYLAVARAPU, Ajit ,  PENDSE, Sukhada ,  SWART, Garret F. ,  CHAVAN, Shasank K. ,  LAHIRI, Tirthankar ,  LOAIZA, Juan R.

IPC: G06F16/27