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

公开(公告)号：WO2016182635A1

公开(公告)日：2016-11-17

申请号：PCT/US2016/023529

申请日：2016-03-22

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： LAHIRI, Tirthankar ,  TAYLOR, Derek ,  BANDI, Nagender ,  MILLER, John ,  HOANG, Chi-Kim ,  RISHEL, Ryder ,  ARAVAMUDHAN, Varadarajan ,  WANG, Chih-Ping ,  CHEUNG, Susan ,  DRAKE, Samuel ,  TUCK, Paul ,  ASPINWALL, David

IPC: G06F17/30

CPC classification number: G06F17/30377 ,  G06F17/30575

Abstract: A database is stored as a plurality of database shards in a distributed database grid comprising a plurality of grid elements, each including a mid-tier database system. A first grid element receives, from an application executing in the same memory as a mid-tier database system of the first grid element, a first database transaction including at least one database operation on specific data stored in a first database shard that belongs to the first grid element. The first grid element performs and commits the first database transaction without participation of another grid element. The first grid element receives a second database transaction that requires access to another database shard that does not belong to the first grid element. Multiple grid elements of the plurality of grid elements perform the second database transaction and commit the second database transaction using a two-phase commit protocol.

Abstract translation: 数据库作为多个数据库分片存储在包括多个网格元素的分布式数据库网格中，每个网格元素包括中间层数据库系统。 第一网格元件从与第一网格元素的中间层数据库系统在同一存储器中执行的应用接收第一数据库事务，该第一数据库事务包括存储在第一数据库分片中的特定数据的至少一个数据库操作，该数据库操作属于 第一个网格元素 第一个网格元素执行并提交第一个数据库事务而不参与另一个网格元素。 第一个网格元素接收需要访问不属于第一个网格元素的另一个数据库分片的第二个数据库事务。 多个网格元素的多个网格元素执行第二数据库事务并使用两阶段提交协议提交第二数据库事务。

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

公开(公告)号：WO2017070627A1

公开(公告)日：2017-04-27

申请号：PCT/US2016/058329

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

Abstract translation: 提供了用于在较低存储层中的内存单元（IMU）中存储以及在需要进行查询处理时将IMU复制到DRAM的技术。 还提供了一些技术，用于将IMU复制到从较高层存储缓存中逐出时的较低存储层。 提供了用于在存储系统内实现IMU的功能的技术，以使数据库服务器能够将诸如过滤之类的任务推送到存储系统，其中存储系统可以访问其自己的存储器内的IMU以执行任务。 与一组数据相关联的元数据可以用于指示数据的IMU应该由数据库服务器机器还是存储系统创建。

公开(公告)号：WO2013033030A1

公开(公告)日：2013-03-07

申请号：PCT/US2012/052547

申请日：2012-08-27

Applicant: ORACLE INTERNATIONAL CORPORATION ,  LAHIRI, Tirthankar ,  HOANG, Chi-Kim ,  THOMAS, Dina ,  EDSON, Kirk Meredith ,  SARKAR, Subhradyuti ,  MCAULIFFE, Mark ,  NEIMAT, Marie-Anne ,  WANG, Chih-Ping

Inventor： LAHIRI, Tirthankar ,  HOANG, Chi-Kim ,  THOMAS, Dina ,  EDSON, Kirk Meredith ,  SARKAR, Subhradyuti ,  MCAULIFFE, Mark ,  NEIMAT, Marie-Anne ,  WANG, Chih-Ping

IPC: G06F17/30 ,  H03M7/42 ,  H03M7/30 ,  G06F7/00

CPC classification number: H03M7/42 ,  G06F17/30315 ,  H03M7/3088

Abstract: In column domain dictionary compression, column values in one or more columns are tokenized by a single dictionary. The domain of the dictionary is the entire set of columns. A dictionary may not only map a token to a tokenized value, but also to a count ("token count") of the number of occurrences of the token and corresponding tokenized value in the dictionary's domain. Such information may be used to compute queries on the base table.

Abstract translation: 在列域字典压缩中，一个或多个列中的列值由单个字典进行标记化。 字典的域是整个列的集合。 字典不仅可以将令牌映射到标记值，还可以映射令牌的出现次数和字典域中相应的标记值的计数（“令牌计数”）。 此类信息可用于计算基表上的查询。

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

公开(公告)号：WO2015042072A1

公开(公告)日：2015-03-26

申请号：PCT/US2014/055946

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

CPC classification number: G06F17/30292 ,  G06F17/30289 ,  G06F17/30584

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: 表的列以存储器内DBA中的行主格式或列主格式存储。 对于给定的表，一列列以列主格式存储; 表的另一组列以行主格式存储。 这种存储表的​​列的方式在本文中被称为双主格式。 此外，双主表中的一行更新为“就地”，即直接对列主列进行更新，而不创建该行的主列列的主要行。 用户可以提交数据库定义语言（“DDL”）命令，声明表的行主列和列主列。

公开(公告)号：WO2015041967A1

公开(公告)日：2015-03-26

申请号：PCT/US2014/055569

申请日：2014-09-15

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： KAMP, Jesse ,  GANESH, Amit ,  MARWAH, Vineet ,  RAJA, Vivekanandhan ,  LAHIRI, Tirthankar ,  HOLLOWAY, Allison L. ,  HASE, Sanket ,  CHAVAN, Shasank K. ,  MUKHERJEE, Niloy ,  LEE, Teck Hua ,  GLEESON, Michael J. ,  KUNCHITHAPADAM, Krishna

IPC: G06F17/30

CPC classification number: G06F17/30377 ,  G06F3/0619 ,  G06F3/065 ,  G06F3/0665 ,  G06F3/0689 ,  G06F11/2058 ,  G06F17/30315 ,  G06F17/30442 ,  G06F17/30575 ,  G06F17/30581 ,  G06F2201/80 ,  G06F2201/855

Abstract: Techniques are provided for maintaining data persistently in one format, but making that data available to a database server in more than one format. For example, one of the formats in which the data is made available for query processing is based on the on-disk format, while another of the formats in which the data is made available for query processing is independent of the on-disk format. Data that is in the format that is independent of the disk format may be maintained exclusively in volatile memory to reduce the overhead associated with keeping the data in sync with the on-disk format copies of the data.

Abstract translation: 提供的技术用于以一种格式持续地维护数据，但是以多种格式使数据库可用于数据库服务器。 例如，数据可用于查询处理的格式之一是基于磁盘格式，而数据可用于查询处理的另一种格式与磁盘格式无关。 独立于磁盘格式的格式的数据可以专门保存在易失性存储器中，以减少与保持数据与数据的磁盘格式副本同步的开销。

公开(公告)号：WO2005024669A1

公开(公告)日：2005-03-17

申请号：PCT/US2004/029069

申请日：2004-09-03

Applicant: ORACLE INTERNATIONAL CORPORATION ,  TAN, Leng, Leng ,  PUTZOLU, Gianfranco ,  SARWAL, Richard ,  TSUKERMAN, Alex ,  NGAI, Gary, C. ,  WOOD, Graham, Stephen ,  DIAS, Karl ,  RAMACHER, Mark ,  DAGEVILLE, Benoit ,  ZIAUDDIN, Mohamed ,  LAHIRI, Tirthankar ,  MUTHULINGAM, Sujatha ,  KARRA, Vishwanath ,  SANCHEZ, Francisco ,  SU, Hsiao-Te ,  YANG, Wanli ,  KRISHNASWAMY, Vasudha ,  KUMAR, Sushil

Inventor： TAN, Leng, Leng ,  PUTZOLU, Gianfranco ,  SARWAL, Richard ,  TSUKERMAN, Alex ,  NGAI, Gary, C. ,  WOOD, Graham, Stephen ,  DIAS, Karl ,  RAMACHER, Mark ,  DAGEVILLE, Benoit ,  ZIAUDDIN, Mohamed ,  LAHIRI, Tirthankar ,  MUTHULINGAM, Sujatha ,  KARRA, Vishwanath ,  SANCHEZ, Francisco ,  SU, Hsiao-Te ,  YANG, Wanli ,  KRISHNASWAMY, Vasudha ,  KUMAR, Sushil

IPC: G06F17/30

CPC classification number: G06F17/30289 ,  Y10S707/99932 ,  Y10S707/99945

Abstract: An intelligent database infrastructure (125) wherein the management of all database components (124) is performed by and within the database (116) itself by integrating management of various components (124) with a central management control (120). Each individual database component, as well as the central management control (120), is self-managing. A central management control module (120) integrates and interacts with the various database components. The database (116) is configured to automatically tune to varying workloads and configurations, correct or alert about bad conditions, and advise on ways to improve overall system performance.

Abstract translation: 智能数据库基础设施（125），其中通过将各种组件（124）与中央管理控制（120）的管理集成在一起，其中所有数据库组件（124）的管理由数据库（116）自身执行。 每个单独的数据库组件以及中央管理控制（120）都是自我管理的。 中央管理控制模块（120）集成并与各种数据库组件进行交互。 数据库（116）被配置为自动调整到不同的工作负载和配置，纠正或警告恶劣条件，并提供改进整体系统性能的方法。

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