- 专利标题: Cardinality estimation for database query planning
-
申请号: US15603319申请日: 2017-05-23
-
公开(公告)号: US10534775B2公开(公告)日: 2020-01-14
- 发明人: Guido Moerkotte , Alexander Boehm , Norman May
- 申请人: SAP SE
- 申请人地址: DE Walldorf
- 专利权人: SAP SE
- 当前专利权人: SAP SE
- 当前专利权人地址: DE Walldorf
- 代理机构: Mintz Levin Cohn Ferris Glovsky and Popeo, P.C.
- 主分类号: G06F16/2453
- IPC分类号: G06F16/2453
摘要:
A system for cardinality estimation for database query planning is provided. In some implementations, the system performs operations comprising selecting a subset of data from a set of data on which a database query is to be executed, the set of data including a first quantity of tuples and the subset of data including a second quantity of tuples. The operations can further comprise determining, based on evaluating one or more predicates on the subset, a third quantity of tuples in the subset which satisfy the one or more predicates. The operations can further comprise determining, based on the first quantity, the second quantity, and the third quantity, a range within the subset that comprises estimated cardinalities of the one or more predicates within a predetermined error threshold range. Related systems, methods, and articles of manufacture are also described.
公开/授权文献
- US20180341678A1 Cardinality Estimation For Database Query Planning 公开/授权日:2018-11-29
信息查询