Patent · US Active

Table scan predicate with integrated semi-join filter

US12099490B2 · kind B2 · utility

0Cited by

1References

20Claims

0Family size

Assignee

SAP SE · DE

Inventors

Manuel Mayr · Walldorf, DE
Wolfgang Stephan · Heidelberg, DE
Till Merker · Sandhausen, DE

Key dates

Filing date	May 23, 2022
Grant date	Sep 24, 2024
Priority date	—
Expiry date	Jun 2, 2042

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/2456
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

A table scan predicate with integrated semi-join filter is provided. A method includes receiving a query including: a request to join first data from a first table and second data from a second table, a first predicate for use in a table scan of the second table, and a second predicate including an expression associated with the first data from the first table and a reference to a column associated with the second data from the second table. The method may include transforming the second predicate into a dynamic predicate for execution of the query. the method may include applying the dynamic predicate to at least the first data. The method may include executing the query by at least scanning the second table based on the first predicate and filtered first data from the application of the dynamic predicate. Related systems and articles of manufacture are provided.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.