US 12,561,326 B1 · Lateral join

Abstract

A query is received from a software application, with the query including at least a first subquery. In response to receiving the query, a database management system (DBMS) generates a query execution plan for the received query. Next, the DBMS optimizes the query execution plan based on the first subquery to generate an optimized query execution plan, wherein the optimized query execution plan includes at least a first pipeline, a second pipeline, a shared subplan, and a distinct operator, wherein the distinct operator is configured to eliminate duplicate tuples. Then, the DBMS executes the optimized query execution plan to identify and retrieve first data stored in a database. Next, the DBMS provides the first data to the software application.

Claims20

Dependent claims

A system comprising:

at least one processor;
and
at least one memory storing instructions that, when executed by the at least one processor, cause operations comprising:
receiving, from a software application, a query including at least a first subquery;
generating a query execution plan for the received query;
optimizing the query execution plan based on the first subquery to generate an optimized query execution plan, wherein the optimized query execution plan comprises at least a first pipeline and a second pipeline, at least one shared subplan, and at least one distinct operator, wherein the at least one distinct operator is configured to eliminate duplicate tuples;
executing the optimized query execution plan to identify and retrieve first data stored in a database;
and
providing the first data to the software application.

6 more elements

Dependencies are inferred from the claim text.

Lateral join

Life of this patent

Lateral join

Life of this patent

Abstract

Claims20