ALEXANDRIA, Va., Feb. 24 -- United States Patent no. 12,561,326, issued on Feb. 24, was assigned to SAP SE (Walldorf, Germany).
"Lateral join" was invented by Paul Willems (Heidelberg, Germany), Florian Drescher (Munich), Till Merker (Sandhausen, Germany) and Manuel Mayr (Walldorf, Germany).
According to the abstract* released by the U.S. Patent & Trademark Office: "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 qu...