发明名称 |
COLLECTION OF STATISTICS FOR SPATIAL COLUMNS OR R-TREE INDEXES |
摘要 |
Techniques for collecting statistics of column data or R-Tree indexes are provided. A distributed database system includes a plurality of processing nodes controlling portions of spatial data. The nodes are instructed to create minimum bounding rectangles (MBR's) for their spatial data or R-Trees. The individual MBR's are merged and reformatted into a grid of equally sized cells. Each processing node is provided a copy of the grid to update based on statistics of each processing node's spatial data for a target table. The updated grids are then merged into a single grid and used by an optimizer to evaluate queries before the queries are executed. |
申请公布号 |
US2012166423(A1) |
申请公布日期 |
2012.06.28 |
申请号 |
US20100979740 |
申请日期 |
2010.12.28 |
申请人 |
MILBY GREGORY HOWARD;TERADATA US, INC. |
发明人 |
MILBY GREGORY HOWARD |
分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|