公开(公告)号：US20180165324A1

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

申请号：US15892677

申请日：2018-02-09

Applicant: Oracle International Corporation

Inventor： Vasudha Krishnaswamy ,  Kartik Kulkarni ,  Sukhada Pendse ,  Akshay Kulkarni

IPC: G06F17/30 ,  G06F3/06

Abstract: Embodiments store transaction metadata in dedicated pools of allocated memory chunks. Portions of the pools of allocated memory chunks are dedicated to the respective apply slave processes that mine and process change records. Also, the pools of allocated memory chunks are anchored within the structure of a transaction log such that buffering and application of metadata for one transaction does not block required buffering and application of metadata for other transactions. The standby database system pre-processes transaction metadata in preparation for application of the metadata to invalidate appropriate portions of MF data. Further, embodiments divide the work of pre-processing invalidation records among the many apply slave processes that record the invalidation records. A garbage collection selects memory chunks for garbage collection in reverse order of how the chunks were allocated. Also, a deduplication algorithm ensures that typically only a single invalidation message per block is applied to invalidate MF data.

公开(公告)号：US20160026667A1

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

申请号：US14806411

申请日：2015-07-22

Applicant: Oracle International Corporation

Inventor： Niloy Mukherjee ,  Mohamed Zait ,  Juan Loaiza ,  Vineet Marwah ,  Tirthankar Lahiri ,  Jiaqi Yan ,  Kartik Kulkarni

IPC: G06F17/30 ,  G06F3/06

CPC classification number: G06F17/30339 ,  G06F3/0604 ,  G06F3/0644 ,  G06F3/0679 ,  G06F17/30498 ,  G06F17/30584

Abstract: Techniques are described herein for distributing data from one or more partitioned tables across the volatile memories of a cluster. In memory copies of data from partitioned tables are grouped based on the data falling within the same partition criteria. These groups are used for assigning data from corresponding partitions to the same node when distributing data from partitioned tables across the volatile memories of a multi-node cluster. When a query requires a join between rows of partitioned tables, the work for the join query is divided into work granules that correspond to partition-wise join operations. Those partition-wise join operations are assigned to nodes by a query coordinator based on the partition-to-node mapping located in the node of the query coordinator.

Abstract translation: 这里描述了用于在群集的易失性存储器上分布来自一个或多个分区表的数据的技术。 在内存中，来自分区表的数据的副本将根据落在相同分区标准中的数据进行分组。 当在多节点集群的易失性存储器上分配来自分区表的数据时，这些组用于将数据从相应分区分配给同一节点。 当查询需要分区表行之间的连接时，连接查询的工作被分成与分区连接操作相对应的工作颗粒。 这些分区连接操作由查询协调器基于位于查询协调器节点中的分区到节点映射分配给节点。