公开(公告)号：US20240330296A1

公开(公告)日：2024-10-03

申请号：US18128152

申请日：2023-03-29

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Lyuping Du ,  Martin Hentschel ,  Elkhan Mammedov ,  Lukas Moll ,  Vikram Wakade

IPC: G06F16/2455 ,  G06F16/23

CPC classification number: G06F16/24552 ,  G06F16/2358 ,  G06F16/2365

Abstract: 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.

公开(公告)号：US12045221B1

公开(公告)日：2024-07-23

申请号：US18362343

申请日：2023-07-31

Applicant: Snowflake Inc.

Inventor： Rishabh Singh Ahluwalia ,  Lin Chan ,  Benoit Dageville ,  Yi Fang ,  Yiming Kang ,  Nithin Mahesh ,  Subramanian Muralidhar ,  Vikram Wakade

IPC: G06F16/22

CPC classification number: G06F16/2282 ,  G06F16/221

Abstract: Described herein are techniques for compact representation of table columns via templatization. Column templates can model the collection of columns in a table as a logical entity. The logical entity can be split into two objects. A first object can contain a subset of column attributes (e.g., fields) that can be shared with other tables, such as name and data type. A second object can contain another subset of column attributes that are unique to a table, such as time stamps and created-on information.

公开(公告)号：US12210527B2

公开(公告)日：2025-01-28

申请号：US18128152

申请日：2023-03-29

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Lyuping Du ,  Martin Hentschel ,  Elkhan Mammedov ,  Lukas Moll ,  Vikram Wakade

IPC: G06F7/00 ,  G06F16/23 ,  G06F16/2455 ,  G06F17/00

Abstract: 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.