公开(公告)号：US20160026684A1

公开(公告)日：2016-01-28

申请号：US14805949

申请日：2015-07-22

Applicant: Oracle International Corporation

Inventor： Niloy Mukherjee ,  Vineet Marwah ,  Hui Jin ,  Kartik Kulkarni

IPC: G06F17/30 ,  G06F12/06

CPC classification number: G06F17/30545 ,  G06F3/061 ,  G06F3/064 ,  G06F3/0644 ,  G06F3/067

Abstract: Techniques are described herein for executing queries on distinct portions of a database object that has been separate into chunks and distributed across the volatile memories of a plurality of nodes in a clustered database system. The techniques involve receiving a query that requires work to be performed on data that resides in a plurality of on disk extents. A parallel query coordinator that is aware of the in-memory distribution divides the work into granules that align with the in-memory separation. The parallel query coordinator then sends each granule to the database server instance with local in memory access to the data required by the granule and aggregates the results to respond to the query.

Abstract translation: 这里描述了用于执行已经分离成块并且分布在群集数据库系统中的多个节点的易失性存储器上的数据库对象的不同部分的技术。 这些技术涉及接收需要对位于多个磁盘盘区上的数据执行工作的查询。 意识到内存分配的并行查询协调器将工作分成与内存分离对齐的颗粒。 并行查询协调器然后将每个粒子发送到数据库服务器实例，并使用本地内存访问粒子所需的数据，并聚合结果以响应查询。

公开(公告)号：US10275184B2

公开(公告)日：2019-04-30

申请号：US14805949

申请日：2015-07-22

Applicant: Oracle International Corporation

Inventor： Niloy Mukherjee ,  Vineet Marwah ,  Hui Jin ,  Kartik Kulkarni

IPC: G06F7/02 ,  G06F16/00 ,  G06F3/06 ,  G06F16/2458

Abstract: Techniques are described herein for executing queries on distinct portions of a database object that has been separate into chunks and distributed across the volatile memories of a plurality of nodes in a clustered database system. The techniques involve receiving a query that requires work to be performed on data that resides in a plurality of on disk extents. A parallel query coordinator that is aware of the in-memory distribution divides the work into granules that align with the in-memory separation. The parallel query coordinator then sends each granule to the database server instance with local in memory access to the data required by the granule and aggregates the results to respond to the query.