Invention Grant
- Patent Title: SQL implication decider for materialized view selection
-
Application No.: US17392728Application Date: 2021-08-03
-
Publication No.: US11625396B2Publication Date: 2023-04-11
- Inventor: Caleb Levine , Leonid Lyakhovitskiy , Ting Cheung Lee
- Applicant: Google LLC
- Applicant Address: US CA Mountain View
- Assignee: Google LLC
- Current Assignee: Google LLC
- Current Assignee Address: US CA Mountain View
- Agency: Lerner David LLP
- Main IPC: G06F16/24
- IPC: G06F16/24 ; G06F16/2453 ; G06F16/27 ; G06F16/242

Abstract:
A system and method for managing queries including receiving a new query comprising a first plurality of conjoined terms, accessing a filtered view of a database from memory, the filtered view being filtered by the previously received query according to a filter represented by a second plurality of conjoined terms, at least one of the first plurality of conjoined terms or the second plurality of conjoined terms including at least one NULL value, determining that the filter of the new query implies a filter of the previously received query, and based on the determination that the filter of the new query implies the filter of the previously received query, executing the new query using the filtered view of the previously received query.
Public/Granted literature
- US20220067043A1 SQL Implication Decider For Materialized View Selection Public/Granted day:2022-03-03
Information query