Snowflake inc. (20250021556). MULTI-PHASE QUERY PLAN CACHING
MULTI-PHASE QUERY PLAN CACHING
Organization Name
Inventor(s)
Prashant Gaharwar of Fremont CA US
Nicola Dan Onose of San Jose CA US
Andrew Z. Xue of San Mateo CA US
MULTI-PHASE QUERY PLAN CACHING
This abstract first appeared for US patent application 20250021556 titled 'MULTI-PHASE QUERY PLAN CACHING
Original Abstract Submitted
the subject technology receives a query, the query including a statement for performing the query. the subject technology performs a first lookup operation on a multi-phase cache based on the query. the subject technology performs, in response to a first cache miss of the multi-phase cache, parsing of the statement from the query. the subject technology performs, based on the parsing, a compilation process on the query to generate a compiled query plan, the compilation process determining an optimization and a generalization for the query. the subject technology determines that the compiled query plan is cacheable. the subject technology registers, in response to the compiled query plan being cacheable, a dummy entry in the multi-phase cache.
- Snowflake inc.
- Xuelai Cui of Seattle WA US
- Prashant Gaharwar of Fremont CA US
- Vineet Garg of San Jose CA US
- Boyung Lee of Kirkland WA US
- Kevin Ye Jie Li of Burnaby CA
- Nicola Dan Onose of San Jose CA US
- Andrew Z. Xue of San Mateo CA US
- Jiaqi Yan of Menlo Park CA US
- G06F16/2453
- G06F11/34
- G06F16/2452
- CPC G06F16/24542