The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.

The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.

Date of Patent:
Oct. 04, 2022

Filed:

Apr. 08, 2022
Applicant:

Snowflake Inc., Bozeman, MT (US);

Inventors:

Thierry Cruanes, San Mateo, CA (US);

Xuelai Cui, Seattle, WA (US);

Sangyong Hwang, Sammamish, WA (US);

Allison Waingold Lee, Pebble Beach, CA (US);

Boyung Lee, Kirkland, WA (US);

Nicola Dan Onose, San Jose, CA (US);

William Waddington, Stateline, NV (US);

Jiaqi Yan, Menlo Park, CA (US);

Li Yan, Redmond, WA (US);

Yongsik Yoon, Sammamish, WA (US);

Assignee:

Snowflake Inc., Bozeman, MT (US);

Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 16/2453 (2019.01);
U.S. Cl.
CPC ...
G06F 16/24542 (2019.01); G06F 16/24539 (2019.01);
Abstract

The subject technology receives a query, the query including a set of statements for performing the query. The subject technology populates a compilation context based at least in part the query. The subject technology provides the compilation context to a compiler. The subject technology invokes the compiler to perform a compilation process based on the compilation context, the compilation process comprising performing a lookup operation on a stored plan cache for an exact match based on information from the compilation context, the stored plan cache including a set of stored query plans, and determining whether the exact match of a particular query plan is found in the stored plan cache to avoid compiling the query using the compilation context.


Find Patent Forward Citations

Loading…