公开(公告)号：US20240289330A1

公开(公告)日：2024-08-29

申请号：US18113475

申请日：2023-02-23

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： RAFI AHMED ,  ANDREW WITKOWSKI

IPC: G06F16/2453 ,  G06F11/34 ,  G06F16/242 ,  G06F16/2455

CPC classification number: G06F16/24535 ,  G06F11/3409 ,  G06F16/244 ,  G06F16/2456

Abstract: A mechanism is provided for performing a group-by pushdown operation or a distinct pushdown operation on a query. The query comprises an outer query block containing a view with a union-all operator, and the outer query block comprises an outer query statement referencing one or more columns of the union-all view and a group-by statement or a distinct keyword. Performing the group-by pushdown operation or the distinct pushdown operation on the query comprises modifying at least a given branch of the union-all view to include a distinct keyword in a query statement of the given branch or a group-by clause that groups results of the given branch by the one or more columns of the table of the given branch.

公开(公告)号：US20240126764A1

公开(公告)日：2024-04-18

申请号：US17965687

申请日：2022-10-13

Applicant: Oracle International Corporation

Inventor： VLAD IOAN HAPRIAN ,  LEI SHENG ,  LAURENT DAYNES ,  ZHEN HUA LIU ,  HUGO KAPP ,  MARCO ARNABOLDI ,  ANDREW WITKOWSKI ,  SUNGPACK HONG ,  HASSAN CHAFI

IPC: G06F16/2455 ,  G06F16/242

CPC classification number: G06F16/24566 ,  G06F16/2433

Abstract: Techniques support graph pattern matching queries inside a relational database management system (RDBMS) that supports SQL execution. The techniques compile a graph pattern matching query that includes a bounded recursive pattern query into a SQL query that can then be executed by the relational engine. As a result, techniques enable execution of graph pattern matching queries that include bounded recursive patterns on top of the relational engine by avoiding any change in the existing SQL engine.