公开(公告)号：WO2022081396A1

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

申请号：PCT/US2021/053822

申请日：2021-10-06

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： KRISHNASWAMY, Vasudha ,  PENDSE, Sukhada ,  KOLAHI, Solmaz ,  KUMAR, Ankita ,  MYLAVARAPU, Ajit ,  SWART, Garret F. ,  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.

公开(公告)号：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.

公开(公告)号：WO2014052917A1

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

申请号：PCT/US2013/062451

申请日：2013-09-27

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： MARWAH, Vineet ,  LAKSHMANAN, Hariharan ,  MYLAVARAPU, Ajit ,  GAHARWAR, Prashant ,  GANESH, Amit

IPC: G06F17/30

CPC classification number: G06F17/30221 ,  G06F3/0649 ,  G06F17/30073 ,  G06F17/30289 ,  G06F17/30306 ,  G06F17/30312 ,  G06F17/30575

Abstract: A method, apparatus, and system for policy driven data placement and information lifecycle management in a database management system are provided. A user or database application can specify declarative policies that define the movement and transformation of stored database objects. The policies are associated with a database object and may also be inherited. A policy defines, for a database object, an archiving action to be taken, a scope, and a condition before the archiving action is triggered. Archiving actions may include compression, data movement, table clustering, and other actions to place the database object into an appropriate storage tier for a lifecycle phase of the database object. Conditions may optionally invoke user-defined functions, and may be based on access statistics specified at the row level and may use segment or block level heatmaps. Policy evaluation occurs periodically in the background, with actions queued as tasks for a task scheduler.

Abstract translation: 提供了一种用于数据库管理系统中的策略驱动数据放置和信息生命周期管理的方法，装置和系统。 用户或数据库应用程序可以指定定义存储的数据库对象的移动和转换的声明性策略。 策略与数据库对象相关联，也可以被继承。 在触发归档操作之前，策略为数据库对象定义要执行的归档操作，作用域和条件。 归档操作可能包括压缩，数据移动，表集群和其他操作，以将数据库对象放入适用于数据库对象生命周期阶段的存储层。 条件可以可选地调用用户定义的功能，并且可以基于在行级别指定的访问统计信息，并且可以使用段或块级散热图。 策略评估在后台定期进行，操作会作为任务调度程序的任务进行排队。

公开(公告)号：WO2022081397A1

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

申请号：PCT/US2021/053824

申请日：2021-10-06

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： MYLAVARAPU, Ajit ,  KRISHNASWAMY, Vasudha ,  PENDSE, Sukhada ,  KOLAHI, Solmaz ,  KUMAR, Ankita ,  SWART, Garret F. ,  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.

公开(公告)号：WO2022081395A1

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

申请号：PCT/US2021/053820

申请日：2021-10-06

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： BRIDGE, William H. Jr. ,  BROWER, David ,  HSU, Meichun ,  KLOTS, Boris ,  MACNAUGHTON, Neil J S ,  MYLAVARAPU, Ajit ,  PANCHAKSHARAIAH, Umesh ,  SWART, Garret F. ,  LAHIRI, Tirthankar ,  LOAIZA, Juan R.

IPC: G06F16/21 ,  G06F16/215

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.

公开(公告)号：EP4229523A1

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

申请号：EP21801752.3

申请日：2021-10-06

Applicant: Oracle International Corporation

Inventor： KRISHNASWAMY, Vasudha ,  PENDSE, Sukhada ,  KOLAHI, Solmaz ,  KUMAR, Ankita ,  MYLAVARAPU, Ajit ,  SWART, Garret F. ,  LAHIRI, Tirthankar ,  LOAIZA, Juan R.

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

公开(公告)号：EP2901323B1

公开(公告)日：2020-07-29

申请号：EP13776657.2

申请日：2013-09-27

Applicant: Oracle International Corporation

Inventor： MARWAH, Vineet ,  LAKSHMANAN, Hariharan ,  MYLAVARAPU, Ajit ,  GAHARWAR, Prashant ,  GANESH, Amit

IPC: G06F16/21

公开(公告)号：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

公开(公告)号：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.