Invention Grant
- Patent Title: Table scan predicate with integrated semi-join filter
-
Application No.: US17751296Application Date: 2022-05-23
-
Publication No.: US12099490B2Publication Date: 2024-09-24
- Inventor: Manuel Mayr , Wolfgang Stephan , Till Merker
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Mintz Levin Cohn Ferris Glovsky and Popeo, P.C.
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/242 ; G06F16/2455

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.
Public/Granted literature
- US20230376474A1 TABLE SCAN PREDICATE WITH INTEGRATED SEMI-JOIN FILTER Public/Granted day:2023-11-23
Information query