Snowflake inc. (20240330287). QUERY PLAN CACHE SHADOW MODES simplified abstract

From WikiPatents
Jump to navigation Jump to search

QUERY PLAN CACHE SHADOW MODES

Organization Name

snowflake inc.

Inventor(s)

Prashant Gaharwar of Fremont CA (US)

Vineet Garg of San Jose CA (US)

Nicola Dan Onose of San Jose CA (US)

Jiaqi Yan of Menlo Park CA (US)

QUERY PLAN CACHE SHADOW MODES - A simplified explanation of the abstract

This abstract first appeared for US patent application 20240330287 titled 'QUERY PLAN CACHE SHADOW MODES

The subject technology in this patent application performs various operations to optimize query plans and cache hits in a shadow cache system.

  • The technology receives a query and looks it up in a shadow cache.
  • It validates the query plan to determine a cache hit.
  • A program building process updates the query plan with additional information.
  • A compilation process compiles an updated program for the query plan.
  • The technology determines if the updated query plan is cacheable.
  • The updated query plan is registered as a new entry in the shadow cache.
  • The updated program is sent to an execution node for execution.

Potential Applications: - Database management systems - Query optimization tools - Cache management software

Problems Solved: - Improving query performance - Enhancing cache hit rates - Optimizing query execution

Benefits: - Faster query processing - Reduced system resource usage - Improved overall system performance

Commercial Applications: Optimizing query performance in large-scale database systems can benefit businesses in various industries, such as e-commerce, finance, and healthcare, by enabling faster data retrieval and analysis.

Questions about the technology: 1. How does the technology determine if an updated query plan is cacheable? 2. What are the potential drawbacks of relying heavily on shadow cache systems for query optimization?


Original Abstract Submitted

the subject technology receives a query. the subject technology performs a lookup operation on a shadow cache. the subject technology performs a validation process on the particular query plan for determining a cache hit on the shadow cache. the subject technology performs a program building process to update the particular query plan with additional information for executing the particular query plan. the subject technology performs a compilation process to compile an updated program of the updated particular query plan. the subject technology determines that the updated particular query plan is cacheable based at least in part on the compilation process. the subject technology registers the updated particular query plan as a new entry in the shadow cache. the subject technology sends the updated program to an execution node for executing the updated particular query plan.