发明名称 |
EFFICIENT PARTITIONED JOINS IN A DATABASE WITH COLUMN-MAJOR LAYOUT |
摘要 |
A database table is partitioned with column-major layout by limiting partitioning one or more columns containing join-column values for a join operator. Join operations are executed for joining the partitioned columns. |
申请公布号 |
US2016210330(A1) |
申请公布日期 |
2016.07.21 |
申请号 |
US201615081242 |
申请日期 |
2016.03.25 |
申请人 |
International Business Machines Corporation |
发明人 |
Arndt Stefan;Attaluri Gopi K.;Barber Ronald J.;Lohman Guy M.;Qiao Lin;Raman Vijayshankar;Shekita Eugene J.;Sidle Richard S. |
分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
1. A method for joining database tables in a query, comprising:
partitioning a database table with column major layout by limiting partitioning to one or more columns containing join-column values for a join operator; and executing one or more join operations for joining the partitioned columns. |
地址 |
Armonk NY US |