Invention Grant
- Patent Title: Methods of cost estimation using partially applied predicates
- Patent Title (中): 使用部分应用谓词的成本估算方法
-
Application No.: US12261075Application Date: 2008-10-30
-
Publication No.: US08126872B2Publication Date: 2012-02-28
- Inventor: Vincent Corvinelli , John Frederick Hornibrook , Bingjie Miao
- Applicant: Vincent Corvinelli , John Frederick Hornibrook , Bingjie Miao
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Sughrue Mion, PLLC.
- Main IPC: G06F7/00
- IPC: G06F7/00

Abstract:
In accordance with aspects of the present invention, provided are methods for incrementally estimating the cardinality of a derived relation including statistically correlated partially applicable predicates for a range-partitioned table. During the generation of a QEP a cardinality estimate is calculated in which one or more partially applicable predicates is correlated to another partially applicable predicate and/or to one or more fully applicable predicates. The cardinality includes a number of rows expected to be returned by the QEP and is computed in an incremental fashion for each operator of the QEP.
Public/Granted literature
- US20090055352A1 METHODS OF COST ESTIMATION USING PARTIALLY APPLIED PREDICATES Public/Granted day:2009-02-26
Information query