发明申请
- 专利标题: Approximating a database statistic
- 专利标题(中): 近似数据库统计
-
申请号: US11796102申请日: 2007-04-25
-
公开(公告)号: US20080120274A1公开(公告)日: 2008-05-22
- 发明人: Thierry Cruanes , Uri Shaft , Hong Su , Benoit Dageville , Sunil P. Chakkappen , Mohamed Zait
- 申请人: Thierry Cruanes , Uri Shaft , Hong Su , Benoit Dageville , Sunil P. Chakkappen , Mohamed Zait
- 专利权人: Oracle International Corporation
- 当前专利权人: Oracle International Corporation
- 主分类号: G06F7/00
- IPC分类号: G06F7/00
摘要:
A method and apparatus for approximating a database statistic, such as the number of distinct values (NDV) is provided. To approximate the NDV for a portion of a table, a synopsis of distinct values is constructed. Each value in the portion is mapped to a domain of values. The mapping function is implemented with a uniform hash function, in one embodiment. If the resultant domain value does not exist in the synopsis, the domain value is added to the synopsis. If the synopsis reaches its capacity, a portion of the domain values are discarded from the synopsis. The statistic is approximated based on the number (N) of domain values in the synopsis and the portion of the domain that is represented in the synopsis relative to the size of the domain.
公开/授权文献
- US07636731B2 Approximating a database statistic 公开/授权日:2009-12-22
信息查询