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

公开(公告)号：EP4229524A1

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

申请号：EP21802479.2

申请日：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

公开(公告)号：EP4229516A1

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

申请号：EP21802085.7

申请日：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

公开(公告)号：EP3834088A1

公开(公告)日：2021-06-16

申请号：EP19718483.1

申请日：2019-03-20

Applicant: Oracle International Corporation

Inventor： LAHIRI, Tirthankar ,  LOAIZA, Juan R. ,  SWART, Garret F. ,  KAMP, Jesse ,  PANT, Avneesh ,  KIMURA, Hideaki

IPC: G06F11/20

公开(公告)号：EP3688611A1

公开(公告)日：2020-08-05

申请号：EP18792664.7

申请日：2018-09-28

Applicant: Oracle International Corporation

Inventor： MACNICOL, Roger ,  HUA, Xia ,  HOLLOWAY, Allison ,  CHAVAN, Shasank ,  KAMP, Jesse ,  COLGAN, Maria ,  LAHIRI, Tirthankar

IPC: G06F16/00

公开(公告)号：EP3365811A1

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

申请号：EP16788924.5

申请日：2016-10-22

Applicant: Oracle International Corporation

Inventor： MACNICOL, Roger D. ,  SHAH, Viral ,  HUA, Xia ,  KAMP, Jesse ,  CHAVAN, Shasank K. ,  COLGAN, Maria ,  LAHIRI, Tirthankar ,  NG, Adrian Tsz Him ,  MEIYYAPPAN, Krishnan ,  GANESH, Amit ,  LOAIZA, Juan R. ,  UMAMAGESWARAN, Kothanda ,  QIN, Yiran

IPC: G06F17/30

CPC classification number: G06F17/30457 ,  G06F3/061 ,  G06F3/0647 ,  G06F3/065 ,  G06F3/067 ,  G06F12/0811 ,  G06F12/0897 ,  G06F17/30312 ,  G06F17/30315 ,  G06F2212/1016 ,  G06F2212/163 ,  G06F2212/225

Abstract: Techniques are provided for storing in in-memory unit (IMU) in a lower-storage tier and copying the IMU to DRAM when needed for query processing. Techniques are also provided for copying IMUs to lower tiers of storage when evicted from the cache of higher tiers of storage. Techniques are provided for implementing functionality of IMUs within a storage system, to enable database servers to push tasks, such as filtering, to the storage system where the storage system may access IMUs within its own memory to perform the tasks. Metadata associated with a set of data may be used to indicate whether an IMU for the data should be created by the database server machine or within the storage system.

公开(公告)号：EP3329393A1

公开(公告)日：2018-06-06

申请号：EP16748005.2

申请日：2016-07-28

Applicant: Oracle International Corporation

Inventor： MISHRA, Aurosish ,  CHAVAN, Shasank K. ,  HOLLOWAY, Allison L. ,  KAMP, Jesse ,  KUMAR, Ramesh ,  LIU, Zhen Hua ,  MUKHERJEE, Niloy ,  GANESH, Amit ,  LAHIRI, Tirthankar ,  MARWAH, Vineet

IPC: G06F17/30

CPC classification number: G06F17/30383 ,  G06F17/30339 ,  G06F17/3046 ,  G06F17/30477

Abstract: Techniques are described for materializing pre-computed results of expressions. In an embodiment, a set of one or more column units are stored in volatile or non-volatile memory. Each column unit corresponds to a column that belongs to an on-disk table within a database managed by a database server instance and includes data items from the corresponding column. A set of one or more virtual column units, and data that associates the set of one or more column units with the set of one or more virtual column units, are also stored in memory. The set of one or more virtual column units includes a particular virtual column unit storing results that are derived by evaluating an expression on at least one column of the on-disk table.

公开(公告)号：EP3047398A1

公开(公告)日：2016-07-27

申请号：EP14781740.7

申请日：2014-09-16

Applicant: Oracle International Corporation

Inventor： LAHIRI, Tirthankar ,  REAMES, Martin A. ,  EDSON, Kirk ,  GOYAL, Neelam ,  MAKINO, Kao ,  PATTHAK, Anindya ,  THOMAS, Dina ,  SARKAR, Subhradyuti ,  HOANG, Chi-Kim ,  JIANG, Qingchun

IPC: G06F17/30

Abstract: Columns of a table are stored in either row-major format or column-major format in an in-memory DBMS. For a given table, one set of columns is stored in column-major format; another set of columns for a table are stored in row-major format. This way of storing columns of a table is referred to herein as dual-major format. In addition, a row in a dual-major table is updated “in-place”, that is, updates are made directly to column-major columns without creating an interim row-major form of the column-major columns of the row. Users may submit database definition language (“DDL”) commands that declare the row-major columns and column-major columns of a table.

Abstract translation: 表的列存储在行主要格式要么或列优先格式在内存中的DBMS。 对于给定的表，一组列的存储在列优先格式; 另一组为表列存储在行主要格式。 存储表的列的这种方式被称为双大格式输入。 此外，在双主表中的一行被更新“就地”，也就是，更新直接向列为主列，而无需创建临时到行主行的列为主列的形式。 用户可以提交数据库定义语言（“DDL”）命令没有申报行主柱和一个表的列主列。

公开(公告)号：EP1393208A2

公开(公告)日：2004-03-03

申请号：EP02731964.9

申请日：2002-05-29

Applicant: Oracle International Corporation

Inventor： MUKKAMALLA, Sreedhar ,  LAHIRI, Tirthankar ,  PAREEK, Alok ,  LOAIZA, Juan ,  LEE, J. William ,  NGAI, Gary ,  NITHRAKASHYAP, Arvind

IPC: G06F17/30

CPC classification number: G06F17/30592 ,  G06F17/30 ,  G06F17/30952 ,  Y10S707/99938 ,  Y10S707/99942 ,  Y10S707/99955

Abstract: Provided herein is a mechanism that allows a given database system to access data blocks from another database system, where data blocks from the given database system and data blocks from the other database system have different sizes. According to an aspect of the present invention, a tablespace in the other database system contained the data blocks. The tablespace is detached from the other database system and integrated into the given database, which is capable of processing data stored in data blocks of a different sizes.