Invention Grant
- Patent Title: Caching techniques for query runtime state
-
Application No.: US16800837Application Date: 2020-02-25
-
Publication No.: US11176138B2Publication Date: 2021-11-16
- Inventor: Punit B. Shah , Douglas Doole , Rama K Korlapati , Serge P. Rielau
- Applicant: salesforce.com, inc.
- Applicant Address: US CA San Francisco
- Assignee: salesforce.com, inc.
- Current Assignee: salesforce.com, inc.
- Current Assignee Address: US CA San Francisco
- Agency: Kowert, Hood, Munyon, Rankin & Goetzel, P.C.
- Main IPC: G06F16/245
- IPC: G06F16/245 ; G06F16/2453

Abstract:
Caching runtime plan data that is determined not to change for different invocations of a query plan. In some embodiments, a computing system accesses information that specifies a query plan generated for a first database query and generates a first runtime plan for the first database query based on the query plan. In some embodiments, the system caches information generated for the first runtime plan that is determined not to change for different invocations of the query plan. For example, transformation code may include separate functions for mutable and immutable state. In some embodiments, the system retrieves and uses the cached information to generate a second runtime plan for a second database query. Disclosed techniques may improve performance of query plan transformations that hit in the runtime plan cache.
Public/Granted literature
- US20210263936A1 CACHING TECHNIQUES FOR QUERY RUNTIME STATE Public/Granted day:2021-08-26
Information query