发明名称 |
Estimation of column cardinality in a partitioned relational database |
摘要 |
The present invention is directed to a system, method and computer readable medium for estimating a column cardinality value for a column in a partitioned table stored in a plurality of nodes in a relational database. According to one embodiment of the present invention, a plurality of column values for the partitioned table stored in each node are hashed, and a hash data set for each node is generated. Each of the hash data sets from each node is transferred to a coordinator node designated from the plurality of nodes. The hash data sets are merged into a merged data set, and an estimated column cardinality value for the table is calculated from the merged data set.
|
申请公布号 |
US6732110(B2) |
申请公布日期 |
2004.05.04 |
申请号 |
US20010894222 |
申请日期 |
2001.06.27 |
申请人 |
INTERNATIONAL BUSINESS MACHINES CORPORATION |
发明人 |
RJAIBI WALID;LOHMAN GUY MARING;HAAS PETER JAY |
分类号 |
G06F17/30;(IPC1-7):G06F17/00 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|