-
公开(公告)号：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或基于向量的分区扫描。 随后，将每个范围分隔的索引行集合分配给多个工作线程中的工作线程。 因此，从多个工作线程生成的子索引被合并以构建数据库表的索引。
-
公开(公告)号：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或基于向量的分区扫描。 随后，将每个范围分隔的索引行集合分配给多个工作线程中的工作线程。 因此，从多个工作线程生成的子索引被合并以构建数据库表的索引。
-
公开(公告)号：US09710516B2
公开(公告)日：2017-07-18
申请号：US14277284
申请日：2014-05-14
IPC分类号： G06F17/30
CPC分类号： G06F17/30498 , G06F17/30339 , G06F17/30454 , G06F17/30595 , G06F17/30864
摘要： A system includes reception of a client query including a JOIN between a local database table of a first computing system and a remote table of a second computing system, transmission of an instruction to the second computing system to define a new table in the second computing system, the new table associated with a storage handler for retrieving data of the local database table, generation of a remote query of the second computing system, the remote query including a second JOIN between the new table and the remote table, transmission of the remote query to the second computing system, and reception of results of the remote query from the second computing system.
-
公开(公告)号：US20150331912A1
公开(公告)日：2015-11-19
申请号：US14277284
申请日：2014-05-14
IPC分类号： G06F17/30
CPC分类号： G06F17/30498 , G06F17/30339 , G06F17/30454 , G06F17/30595 , G06F17/30864
摘要： A system includes reception of a client query including a JOIN between a local database table of a first computing system and a remote table of a second computing system, transmission of an instruction to the second computing system to define a new table in the second computing system, the new table associated with a storage handler for retrieving data of the local database table, generation of a remote query of the second computing system, the remote query including a second JOIN between the new table and the remote table, transmission of the remote query to the second computing system, and reception of results of the remote query from the second computing system.
摘要翻译： 一种系统包括接收包括第一计算系统的本地数据库表和第二计算系统的远程表之间的JOIN的客户端查询，向第二计算系统发送指令以在第二计算系统中定义新表 与用于检索本地数据库表的数据的存储处理器相关联的新表，第二计算系统的远程查询的生成，包括新表和远程表之间的第二JOIN的远程查询，远程查询的传输 到第二计算系统，以及从第二计算系统接收远程查询的结果。
-
公开(公告)号：US08515945B2
公开(公告)日：2013-08-20
申请号：US12947303
申请日：2010-11-16
IPC分类号： G06F7/00
CPC分类号： G06F17/30486 , G06F17/30498
摘要： System, methods and articles of manufacture for joining data in the database tables comprising, performing an index scan on a global index of a first database table, determining rows in the first database table that may be joined with a second database table based on a needed partitioning, wherein the needed partitioning is determined using an index scan, determining a number of partitions in the second database table, and joining each of the corresponding partitions in the first database table with a corresponding partitions in the second database table.
摘要翻译： 用于在数据库表中加入数据的系统，方法和制品，包括：对第一数据库表的全局索引进行索引扫描，基于所需的第二数据库表确定可与第二数据库表结合的第一数据库表中的行 划分，其中使用索引扫描确定所需的分区，确定第二数据库表中的分区的数量，以及将第一数据库表中的每个相应分区与第二数据库表中的对应分区相连。
-
-
-
-
搜索结果
5 条记录 (耗时 0.03 秒)
