-
公开(公告)号：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.
摘要翻译： 用于在数据库表中加入数据的系统，方法和制品，包括：对第一数据库表的全局索引进行索引扫描，基于所需的第二数据库表确定可与第二数据库表结合的第一数据库表中的行 划分，其中使用索引扫描确定所需的分区，确定第二数据库表中的分区的数量，以及将第一数据库表中的每个相应分区与第二数据库表中的对应分区相连。
-
公开(公告)号：US20120124045A1
公开(公告)日：2012-05-17
申请号：US12947303
申请日：2010-11-16
IPC分类号： G06F17/30
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.
摘要翻译： 用于在数据库表中加入数据的系统，方法和制品，包括：对第一数据库表的全局索引进行索引扫描，基于所需的第二数据库表确定可与第二数据库表结合的第一数据库表中的行 划分，其中使用索引扫描确定所需的分区，确定第二数据库表中的分区的数量，以及将第一数据库表中的每个相应分区与第二数据库表中的对应分区相连。
-
公开(公告)号：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的远程查询，远程查询的传输 到第二计算系统，以及从第二计算系统接收远程查询的结果。
-
5.发明申请Database System with Methodology for Parallel Schedule Generation in a Query Optimizer 有权具有查询优化器中并行计划生成方法的数据库系统公开(公告)号：US20060080285A1
公开(公告)日：2006-04-13
申请号：US10711931
申请日：2004-10-13
申请人： Sudipto Chowdhuri
发明人： Sudipto Chowdhuri
IPC分类号： G06F17/30
CPC分类号： G06F17/30445 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99938
摘要： A database system with methodology for parallel schedule generation in a query optimizer is described. In one embodiment, for example, in a database system, a method is described for parallel optimization of a query, the method comprises steps of: generating a plurality of parallel plans for obtaining data requested by the query, the parallel plans including parallel operators for executing portions of the query in parallel; adjusting parallel operators of each parallel plan if necessary based on resources available for executing the query; creating a schedule for each parallel plan indicating a sequence for execution of operators of each parallel plan; determining execution cost of each parallel plan based on its schedule; and selecting a particular parallel plan having lowest execution cost for obtaining data requested by the query.
摘要翻译： 描述了一种在查询优化器中具有并行计划生成方法的数据库系统。 在一个实施例中，例如，在数据库系统中，描述了用于查询的并行优化的方法，所述方法包括以下步骤：生成用于获取查询请求的数据的多个并行计划，并行计划包括用于 并行执行查询的部分; 根据可用于执行查询的资源，根据需要调整每个并行计划的并行运算符; 创建每个并行计划的时间表，指示执行每个并行计划的运营商的顺序; 根据其计划确定每个并行计划的执行成本; 以及选择具有最低执行成本的特定并行计划，以获得由查询请求的数据。
-
公开(公告)号：US20100010976A1
公开(公告)日：2010-01-14
申请号：US12170887
申请日：2008-07-10
IPC分类号： G06F17/30
CPC分类号： G06F17/30498
摘要： A system, method, and computer program product are provided for performing a join operation between a local table at a local server and a remote table at a remote server. In accordance with an embodiment of the present invention, a query instruction to join the local table and the remote table is received at the remote server. Qualifying rows of the local table are then retrieved to the remote server, and the remote table is joined with the qualifying rows to generate a result table, which is then sent to the local server.
摘要翻译： 提供了一种系统，方法和计算机程序产品，用于在本地服务器的本地表和远程服务器的远程表之间执行连接操作。 根据本发明的实施例，在远程服务器处接收到加入本地表和远程表的查询指令。 然后将本地表的限定行检索到远程服务器，并且远程表与限定行连接以生成结果表，然后将其发送到本地服务器。
-
7.发明申请System and Methodology for Parallel Query Optimization Using Semantic-Based Partitioning 有权使用基于语义分割的并行查询优化的系统和方法公开(公告)号：US20060218123A1
公开(公告)日：2006-09-28
申请号：US10908956
申请日：2005-06-02
申请人： Sudipto Chowdhuri , Mihnea Andrei
发明人： Sudipto Chowdhuri , Mihnea Andrei
IPC分类号： G06F17/30
CPC分类号： G06F17/30445
摘要： A system and methodology for parallel query optimization using semantic-based partitioning is described. In one embodiment, for example, in a database system comprising a database storing data in database tables, a method is described for improving query performance by dynamically partitioning the data, the method comprises steps of: receiving a query requesting data from the database; generating a plurality of subplans for executing the query, each subplan including one or more operators for performing relational operations; adding operators for partitioning data and performing a given relational operation in parallel to at least some of the plurality of subplans; and building a plan for execution of the query based, at least in part, upon selecting subplans having favorable execution costs
摘要翻译： 描述了使用基于语义的分区的并行查询优化的系统和方法。 在一个实施例中，例如，在包括在数据库表中存储数据的数据库的数据库系统中，描述了通过动态划分数据来提高查询性能的方法，所述方法包括以下步骤：从数据库接收请求数据的查询; 生成用于执行查询的多个子程序，每个子程序包括用于执行关系操作的一个或多个操作符; 添加用于划分数据的操作符并且与所述多个子计划中的至少一些并行执行给定的关系操作; 并且至少部分地基于选择具有有利执行成本的子计划来构建用于执行查询的计划
-
公开(公告)号：US09104731B2
公开(公告)日：2015-08-11
申请号：US12170887
申请日：2008-07-10
IPC分类号： G06F17/30
CPC分类号： G06F17/30498
摘要： A system, method, and computer program product are provided for performing a join operation between a local table at a local server and a remote table at a remote server. In accordance with an embodiment of the present invention, a query instruction to join the local table and the remote table is received at the remote server. Qualifying rows of the local table are then retrieved to the remote server, and the remote table is joined with the qualifying rows to generate a result table, which is then sent to the local server.
摘要翻译： 提供了一种系统，方法和计算机程序产品，用于在本地服务器的本地表和远程服务器的远程表之间执行连接操作。 根据本发明的实施例，在远程服务器处接收到加入本地表和远程表的查询指令。 然后将本地表的限定行检索到远程服务器，并且远程表与限定行连接以生成结果表，然后将其发送到本地服务器。
-
-
-
-
-
-
-
搜索结果
8 条记录 (耗时 0.018 秒)
