Invention Grant
US08849871B2 Efficient pushdown of joins in a heterogeneous database system involving a large-scale low-power cluster
有权
在涉及大规模低功率集群的异构数据库系统中有效的下联连接
- Patent Title: Efficient pushdown of joins in a heterogeneous database system involving a large-scale low-power cluster
- Patent Title (中): 在涉及大规模低功率集群的异构数据库系统中有效的下联连接
-
Application No.: US13645030Application Date: 2012-10-04
-
Publication No.: US08849871B2Publication Date: 2014-09-30
- Inventor: Sam Idicula , Sabina Petride , Nipun Agarwal , Eric Sedlar
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Truong Becker Bingham Wong LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30
Abstract:
A system and method for allocating join processing between and RDBMS and an assisting cluster. In one embodiment, the method estimates a cost of performing the join completely in the RDBMS and the cost of performing the join with the assistance of a cluster coupled to the RDBMS. The cost of performing the join with the assistance of the cluster includes estimating a cost of a broadcast join or a partition join depending on the sizes of the tables. Additional costs are incurred when there is a blocking operation, which prevents the cluster from being able to process portions of the join. The RDBMS also maintains transactional consistency when the cluster performs some or all of the join processing.
Public/Granted literature
- US20140101205A1 Efficient Pushdown Of Joins In A Heterogeneous Database System Involving A Large-Scale Low-Power Cluster Public/Granted day:2014-04-10
Information query
