- 专利标题: Limiting scans of loosely ordered and/or grouped relations in a database
-
申请号: US14507028申请日: 2014-10-06
-
公开(公告)号: US09747331B2公开(公告)日: 2017-08-29
- 发明人: Garth A. Dickie
- 申请人: International Business Machines Corporation
- 申请人地址: US NY Armonk
- 专利权人: INTERNATIONAL BUSINESS MACHINES CORPORATION
- 当前专利权人: INTERNATIONAL BUSINESS MACHINES CORPORATION
- 当前专利权人地址: US NY Armonk
- 代理机构: Edell, Shapiro & Finnan, LLC
- 代理商 Erik K. Johnson
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
Data within a database object are accessed based on a query with a predicate including a plurality of conditional expressions. Elements of the database object are stored among a plurality of different storage regions along with range values for element values within each storage region. Each conditional expression of the query predicate is applied to the range values for each storage region to produce evaluation results of that conditional expression for each storage region. The evaluation result of each conditional expression for a corresponding storage region is combined to produce aggregated results for each of the storage regions, where the aggregated result for a corresponding storage region indicates results of a tri-state evaluation (e.g., true/false or unknown) of the conditional expressions for that storage region. One or more corresponding individual storage regions are scanned based on the aggregated results for those storage regions when the tri-state evaluation is unknown.
公开/授权文献
信息查询