Snowflake Inc.

Lyuping Du

Benoit Dageville

Vikram Wakade

Elkhan Mammedov

Lukas Moll

Martin Hentschel

Techniques for active invalidation of cache entries are described. A first timestamp and a second timestamp are stored by a compute instance, the first timestamp corresponding to an initial time the computing instance read from a version update log in a database and the second timestamp corresponding to a last time the computing instance read from the version update log in the database. The compute instance can read records from the version update log that are associated with version timestamps greater than the second timestamp. The compute instance can invalidate a first set of cache entries with older versions stored in a cache based on reading the records, retaining a second set of cache entries, and then execute a query using the second set of cache entries.

Growing community of inventors

Issaquah, WA, United States of America

Lyuping Du