公开(公告)号：US20210216590A1

公开(公告)日：2021-07-15

申请号：US16738972

申请日：2020-01-09

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： ARNAUD DELAMARE ,  VASILEIOS TRIGONAKIS ,  JEAN-PIERRE LOZI ,  VLAD IOAN HAPRIAN ,  PETR KOUPY ,  HASSAN CHAFI ,  SUNGPACK HONG

IPC: G06F16/901 ,  G06F16/9032 ,  G06F16/903 ,  G06F16/2453

Abstract: Techniques are described herein for early pruning of potential graph query results. Specifically, based on determining that property values of a path through graph data cannot affect results of a query, the path is pruned from a set of potential query solutions prior to fully exploring the path. Early solution pruning is performed on prunable queries that project prunable functions including MIN, MAX, SUM, and DISTINCT, the results of which are not tied to a number of paths explored for query execution. A database system implements early solution pruning for a prunable query based on intermediate results maintained for the query during query execution. Specifically, when a system determines that property values of a given potential solution path cannot affect the query results reflected in intermediate results maintained for the query, the path is discarded from the set of possible query solutions without further exploration of the path.