ALEXANDRIA, Va., June 5 -- United States Patent no. 12,277,116, issued on April 15, was assigned to Snowflake Inc. (Bozeman, Mont.).

"Query plan cache shadow modes" was invented by Prashant Gaharwar (Fremont, Calif.), Vineet Garg (San Jose, Calif.), Nicola Dan Onose (San Jose, Calif.) and Jiaqi Yan (Menlo Park, Calif.).

According to the abstract* released by the U.S. Patent & Trademark Office: "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 addition...