专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US09489411B2 High performance index creation 有权
标题翻译：高性能指标创建
公开(公告)号：US09489411B2
公开(公告)日：2016-11-08
申请号：US13953341
申请日：2013-07-29
申请人： Peter Schneider , Ming-li Rui , Santosh Pendap , Leon Xiong
发明人： Peter Schneider , Ming-li Rui , Santosh Pendap , Leon Xiong
IPC分类号： G06F17/30
CPC分类号： G06F17/30336 , G06F17/30321 , G06F17/30864
摘要： High performance index creation using parallel query plans with repartitioning scan and vector-based repartitioning scan is described. An example method includes extracting index key columns from data rows of the database table to build a set of index rows, wherein the index on the database table is defined by a plurality of index key columns including a first index key column and a second index key column. Partition boundary values are generated to divide up the index rows into range-partitioned sets, and the index rows are sorted based on values of the index key columns. A repartitioning scan, including a SARG-based or a vector-based partitioning scan is performed on the index rows, using a plurality of worker threads executing in parallel to build sub-indexes. Subsequently, each range-partitioned set of index rows are assigned to a worker thread in the plurality of worker threads. Accordingly, the sub-indexes generated from the plurality of work threads are merged to build the index for the database table.
摘要翻译：描述了使用重新分区扫描和向量重新分区扫描的并行查询计划的高性能索引创建。示例性方法包括从数据库表的数据行中提取索引关键字列以构建一组索引行，其中数据库表上的索引由包括第一索引关键字列和第二索引关键字的多个索引关键字列定义柱。生成分区边界值，以将索引行分成范围分区集，并根据索引键列的值对索引行进行排序。使用并行执行的多个工作线程来构建子索引，对索引行执行重新分区扫描，包括基于SARG或基于向量的分区扫描。随后，将每个范围分隔的索引行集合分配给多个工作线程中的工作线程。因此，从多个工作线程生成的子索引被合并以构建数据库表的索引。

2. 发明申请

US20150032758A1 High Performance Index Creation 有权
标题翻译：高性能指标创造
公开(公告)号：US20150032758A1
公开(公告)日：2015-01-29
申请号：US13953341
申请日：2013-07-29
申请人： Peter Schneider , Ming-li Rui , Santosh Pendap , Leon Xiong
发明人： Peter Schneider , Ming-li Rui , Santosh Pendap , Leon Xiong
IPC分类号： G06F17/30
CPC分类号： G06F17/30336 , G06F17/30321 , G06F17/30864
摘要： High performance index creation using parallel query plans with repartitioning scan and vector-based repartitioning scan is described. An example method includes extracting index key columns from data rows of the database table to build a set of index rows, wherein the index on the database table is defined by a plurality of index key columns including a first index key column and a second index key column. Partition boundary values are generated to divide up the index rows into range-partitioned sets, and the index rows are sorted based on values of the index key columns. A repartitioning scan, including a SARG-based or a vector-based partitioning scan is performed on the index rows, using a plurality of worker threads executing in parallel to build sub-indexes. Subsequently, each range-partitioned set of index rows are assigned to a worker thread in the plurality of worker threads. Accordingly, the sub-indexes generated from the plurality of work threads are merged to build the index for the database table.
摘要翻译：描述了使用重新分区扫描和向量重新分区扫描的并行查询计划的高性能索引创建。示例性方法包括从数据库表的数据行中提取索引关键字列以构建一组索引行，其中数据库表上的索引由包括第一索引关键字列和第二索引关键字的多个索引关键字列定义柱。生成分区边界值，以将索引行分成范围分区集，并根据索引键列的值对索引行进行排序。使用并行执行的多个工作线程来构建子索引，对索引行执行重新分区扫描，包括基于SARG或基于向量的分区扫描。随后，将每个范围分隔的索引行集合分配给多个工作线程中的工作线程。因此，从多个工作线程生成的子索引被合并以构建数据库表的索引。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式