公开(公告)号：US20190102426A1

公开(公告)日：2019-04-04

申请号：US16007777

申请日：2018-06-13

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Atif Chaudhry ,  Lei Sheng ,  Shashaanka Agrawal

IPC: G06F17/30

Abstract: Described is an approach for performing an efficient processing of table functions/polymorphic table functions. The approach does not create additional cursors for processing a table or polymorphic table function invoked within a SQL statement. Instead, the approach handles the SQL statement that invokes the table/polymorphic table function as a single cursor.

公开(公告)号：US12242487B2

公开(公告)日：2025-03-04

申请号：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

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.

公开(公告)号：US11989178B2

公开(公告)日：2024-05-21

申请号：US17080700

申请日：2020-10-26

Applicant: Oracle International Corporation

Inventor： Vlad Haprian ,  Laurent Daynes ,  Zhen Hua Liu ,  Lei Sheng ,  Hugo Kapp ,  Marco Arnaboldi ,  Jean-Pierre Lozi ,  Andrew Witkowski ,  Hassan Chafi ,  Sungpack Hong

IPC: G06F16/2453 ,  G06F16/2455 ,  G06F16/901

CPC classification number: G06F16/24537 ,  G06F16/24558 ,  G06F16/9024

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 into a SQL query that can then be executed by the relational engine. As a result, techniques enable execution of graph pattern matching queries on top of the relational engine by avoiding any change in the existing SQL engine.

公开(公告)号：US11507579B2

公开(公告)日：2022-11-22

申请号：US17080719

申请日：2020-10-26

Applicant: Oracle International Corporation

Inventor： Vlad Haprian ,  Laurent Daynes ,  Zhen Hua Liu ,  Lei Sheng ,  Hugo Kapp ,  Marco Arnaboldi ,  Jean-Pierre Lozi ,  Andrew Witkowski ,  Hassan Chafi ,  Sungpack Hong

IPC: G06F16/2455 ,  G06F16/2453

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 into a SQL query that can then be executed by the relational engine. As a result, techniques enable execution of graph pattern matching queries on top of the relational engine by avoiding any change in the existing SQL engine.

公开(公告)号：US20220129451A1

公开(公告)日：2022-04-28

申请号：US17080698

申请日：2020-10-26

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Vlad Haprian ,  Laurent Daynes ,  Zhen Hua Liu ,  Lei Sheng ,  Hugo Kapp ,  Marco Arnaboldi ,  Jean-Pierre Lozi ,  Andrew Witkowski ,  Hassan Chafi ,  Sungpack Hong

IPC: G06F16/242 ,  G06F16/2455 ,  G06F16/22 ,  G06F16/25 ,  G06F16/2452

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 into a SQL query that can then be executed by the relational engine. As a result, techniques enable execution of graph pattern matching queries on top of the relational engine by avoiding any change in the existing SQL engine.

公开(公告)号：US11567932B2

公开(公告)日：2023-01-31

申请号：US17080698

申请日：2020-10-26

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Vlad Haprian ,  Laurent Daynes ,  Zhen Hua Liu ,  Lei Sheng ,  Hugo Kapp ,  Marco Arnaboldi ,  Jean-Pierre Lozi ,  Andrew Witkowski ,  Hassan Chafi ,  Sungpack Hong

IPC: G06F16/242 ,  G06F16/2455 ,  G06F16/2452 ,  G06F16/25 ,  G06F16/22

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 into a SQL query that can then be executed by the relational engine. As a result, techniques enable execution of graph pattern matching queries on top of the relational engine by avoiding any change in the existing SQL engine.

公开(公告)号：US20220129465A1

公开(公告)日：2022-04-28

申请号：US17080719

申请日：2020-10-26

Applicant: Oracle International Corporation

Inventor： Vlad Haprian ,  Laurent Daynes ,  Zhen Hua Liu ,  Lei Sheng ,  Hugo Kapp ,  Marco Arnaboldi ,  Jean-Pierre Lozi ,  Andrew Witkowski ,  Hassan Chafi ,  Sungpack Hong

IPC: G06F16/2455 ,  G06F16/2453

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 into a SQL query that can then be executed by the relational engine. As a result, techniques enable execution of graph pattern matching queries on top of the relational engine by avoiding any change in the existing SQL engine.

公开(公告)号：US20220129461A1

公开(公告)日：2022-04-28

申请号：US17080700

申请日：2020-10-26

Applicant: Oracle International Corporation

Inventor： Vlad Haprian ,  Laurent Daynes ,  Zhen Hua Liu ,  Lei Sheng ,  Hugo Kapp ,  Marco Arnaboldi ,  Jean-Pierre Lozi ,  Andrew Witkowski ,  Hassan Chafi ,  Sungpack Hong

IPC: G06F16/2453 ,  G06F16/901 ,  G06F16/2455

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 into a SQL query that can then be executed by the relational engine. As a result, techniques enable execution of graph pattern matching queries on top of the relational engine by avoiding any change in the existing SQL engine.

公开(公告)号：US11151134B2

公开(公告)日：2021-10-19

申请号：US16007777

申请日：2018-06-13

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Atif Chaudhry ,  Lei Sheng ,  Shashaanka Agrawal

IPC: G06F16/00 ,  G06F16/2453

Abstract: Described is an approach for performing an efficient processing of table functions/polymorphic table functions. The approach does not create additional cursors for processing a table or polymorphic table function invoked within a SQL statement. Instead, the approach handles the SQL statement that invokes the table/polymorphic table function as a single cursor.

公开(公告)号：US20180101573A1

公开(公告)日：2018-04-12

申请号：US15726030

申请日：2017-10-05

Applicant: Oracle International Corporation

Inventor： Lei Sheng ,  Rafi Ahmed ,  Andrew Witkowski ,  Sankar Subramanian

IPC: G06F17/30

CPC classification number: G06F16/24544 ,  G06F16/24537

Abstract: Techniques herein optimize sort-merge join method for a band join. In an embodiment, for a query comprising a query block specifying a join between a first table and a second table, a band join condition is detected between the first table and the second table. Once the band join condition in detected, an execution plan is generated and executed. The execution of the execution plan includes: for a first row of at least a subset of first sorted rows, scanning second rows from a set of second sorted rows, joining each of said second rows with said first row, and ceasing to scan when encountering a row from the second sorted rows that falls outside a bound of said band join condition. Techniques also include parallelizing a workload by overlapping the distribution of rows to the same slave process and computing cost and cardinality estimation for enhanced band join.