公开(公告)号：WO2018049380A1

公开(公告)日：2018-03-15

申请号：PCT/US2017/051118

申请日：2017-09-12

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： CHAVAN, Shasank K. ,  LUI, Dennis ,  HOLLOWAY, Allison L. ,  LEWIS, Sheldon A.K.

IPC: G06F17/30

CPC classification number: G06F16/24564 ,  G06F9/30018 ,  G06F9/30036 ,  G06F9/3887 ,  G06F16/221 ,  G06F16/2237 ,  G06F16/2282 ,  G06F16/24537 ,  G06F16/2455 ,  G06F16/2456 ,  G06F16/2462

Abstract: Techniques related to efficient evaluation of queries with multiple predicate expressions are disclosed. A first predicate expression (PE) is evaluated against a plurality of rows in a first column vector (CV) to determine that a subset of rows does not satisfy the first PE. The subset comprises less than all of the plurality of rows. When a query specifies the first PE in conjunction with a second PE, a selectivity of the first PE is determined. If the selectivity meets a threshold, the second PE is evaluated against all of the plurality of rows in a second CV. If the selectivity does not meet the threshold, the second PE is evaluated against only the subset of rows in the second CV. When a query specifies the first PE in disjunction with the second PE, the second PE may be evaluated against only the subset of rows in the second CV.

Abstract translation: 公开了与使用多个谓词表达式的查询的高效评估相关的技术。 针对第一列向量（CV）中的多个行评估第一谓词表达式（PE）以确定行的子集不满足第一PE。 该子集包括少于全部的多个行。 当查询指定第一PE与第二PE结合时，确定第一PE的选择性。 如果选择性满足阈值，则针对第二CV中的所有多行评估第二PE。 如果选择性不符合阈值，则仅针对第二个CV中的行子集评估第二个PE。 当一个查询指定与第二个PE分离的第一个PE时，第二个PE可能仅针对第二个CV中的行的子集进行评估。

公开(公告)号：EP3510498A1

公开(公告)日：2019-07-17

申请号：EP17771966.3

申请日：2017-09-12

Applicant: Oracle International Corporation

Inventor： CHAVAN, Shasank K. ,  LUI, Dennis ,  HOLLOWAY, Allison L. ,  LEWIS, Sheldon A.K.

IPC: G06F17/30