公开(公告)号：US12135715B1

公开(公告)日：2024-11-05

申请号：US18309490

申请日：2023-04-28

Applicant: Snowflake Inc.

Inventor： Xuelai Cui ,  Prashant Gaharwar ,  Vineet Garg ,  Boyung Lee ,  Kevin Ye Jie Li ,  Nicola Dan Onose ,  Andrew Xue ,  Jiaqi Yan

IPC: G06F16/30 ,  G06F11/34 ,  G06F16/2452 ,  G06F16/2453

Abstract: 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.

公开(公告)号：US20240362222A1

公开(公告)日：2024-10-31

申请号：US18309490

申请日：2023-04-28

Applicant: Snowflake Inc.

Inventor： Xuelai Cui ,  Prashant Gaharwar ,  Vineet Garg ,  Boyung Lee ,  Kevin Ye Jie Li ,  Nicola Dan Onose ,  Andrew Xue ,  Jiaqi Yan

IPC: G06F16/2453 ,  G06F11/34 ,  G06F16/2452

CPC classification number: G06F16/24542 ,  G06F11/3409 ,  G06F16/24528 ,  G06F16/24539

Abstract: 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.