发明授权
- 专利标题: Performance of join operations in parallel database systems
- 专利标题(中): 并行数据库系统中连接操作的性能
-
申请号: US09863638申请日: 2001-05-23
-
公开(公告)号: US07054852B1公开(公告)日: 2006-05-30
- 发明人: Steven B. Cohen
- 申请人: Steven B. Cohen
- 申请人地址: US OH Dayton
- 专利权人: NCR Corporation
- 当前专利权人: NCR Corporation
- 当前专利权人地址: US OH Dayton
- 代理机构: Trop, Pruner, Hu P.C.
- 代理商 Harden Stevens
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
A database system includes a plurality of storage modules, with a first storage module storing rows of a first table and a second storage module storing rows of a second table, and a plurality of access modules adapted to manage access of respective storage modules. A first access module corresponds to the first storage module, and a second access module corresponds to the second storage module. The first access module is adapted to distribute rows of the first table to the second access module in response to a join request, and the first access module is adapted to further distribute row identifiers with the distributed rows. The distributed rows contain one or more columns that are part of one or more join conditions of the join request, but does not contain one or more columns that are in a specified result list of the join request or that are part of a subsequent operation specified in the join request.
信息查询