Invention Grant
- Patent Title: Database system with multiple processing nodes
- Patent Title (中): 具有多个处理节点的数据库系统
-
Application No.: US11414068Application Date: 2006-04-28
-
Publication No.: US07685193B2Publication Date: 2010-03-23
- Inventor: Ben Cohen
- Applicant: Ben Cohen
- Applicant Address: GB Marlow, Bucks
- Assignee: Kognitio Limited
- Current Assignee: Kognitio Limited
- Current Assignee Address: GB Marlow, Bucks
- Agency: Park, Vaughan & Fleming LLP
- Main IPC: G06F7/00
- IPC: G06F7/00

Abstract:
A method and apparatus are provided for distributing a database join operation across a plurality of processing nodes. The database join operation is performed between a first table having M1 rows and a second table have M2 rows and involves forming M1×M2 combinations of rows from the first and second tables. The method includes allocating across the plurality of processing nodes the M1×M2 combinations of rows from the first and second tables. Each of the M1×M2 combinations is present on one of the nodes, and each node stores combinations corresponding to a subset of the M1 rows from the first table and a subset of the M2 rows from the second table. The method further comprises performing for each processing node the join operation in respect of all combinations of rows allocated to that processing node and collating results across all the processing nodes to complete the join operation.
Public/Granted literature
- US20070276788A1 Database system with multiple processing nodes Public/Granted day:2007-11-29
Information query