发明名称 Performance of join operations in parallel database systems
摘要 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.
申请公布号 US7054852(B1) 申请公布日期 2006.05.30
申请号 US20010863638 申请日期 2001.05.23
申请人 NCR CORPORATION 发明人 COHEN STEVEN B.
分类号 G06F17/30 主分类号 G06F17/30
代理机构 代理人
主权项
地址