发明名称 |
Statistics collection using path-identifiers for relational databases |
摘要 |
Disclosed are a system, method, and computer readable medium for collecting statistics associated with data in a database. The method comprises determining an amount of memory needed to collect statistics for data associated with a defined data type in a relational database. The defined data type is based upon a mark-up language using a tree structure with one or more root-to-node paths therein. The amount of memory as determined is allocated for collecting the statistics for the data of the defined data type. A statistics collection is performed for the data of the defined data type in a single pass through the database and within the amount of memory which has been allocated.
|
申请公布号 |
US8229924(B2) |
申请公布日期 |
2012.07.24 |
申请号 |
US20090557804 |
申请日期 |
2009.09.11 |
申请人 |
LIM LIPYEOW;MIHAILA GEORGE ANDREI;WANG MIN;INTERNATIONAL BUSINESS MACHINES CORPORATION |
发明人 |
LIM LIPYEOW;MIHAILA GEORGE ANDREI;WANG MIN |
分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|