公开(公告)号：US20240370406A1

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

申请号：US18775830

申请日：2024-07-17

Applicant: Snowflake Inc.

Inventor： Lin Chan ,  Tianyi Chen ,  Robert Bengt Benedikt Gernhardt ,  Nithin Mahesh ,  Eric Robinson

IPC: G06F16/14 ,  G06F16/16

Abstract: Techniques for executing show commands are described herein. A plurality of navigation steps is utilized, each navigation step corresponding to a different layer in a database structure and each navigation step including an operator to fetch items from a metadata database up to respective bounded limits. Dependency information is also fetched for objects of the specified object type in the show command. After a set of objects from the last layer are processed, memory for the navigation steps is flushed and the next set of objects are processed.

公开(公告)号：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.

公开(公告)号：US12007997B2

公开(公告)日：2024-06-11

申请号：US18183483

申请日：2023-03-14

Applicant: Snowflake Inc.

Inventor： Lin Chan ,  Tianyi Chen ,  Benoit Dageville ,  Yiming Kang ,  Jun Luo ,  Nithin Mahesh ,  Eric Robinson ,  Brian Smith

IPC: G06F16/00 ,  G06F7/14 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2453 ,  G06F21/62

CPC classification number: G06F16/24549 ,  G06F7/14 ,  G06F16/2228 ,  G06F16/2379 ,  G06F21/6218 ,  G06F21/6227

Abstract: As described herein, a N-Gram index may be created and the search may be conducted using the index, which will lead to faster search results. The N-Gram index may also include partial N-Gram components to capture more relevant data. Moreover, as described herein, the search may also take into account recent log data that has not yet been indexed. Techniques for building an index store using log data and efficiently searching the index store and log data to process search requests are described herein.

公开(公告)号：US20230214391A1

公开(公告)日：2023-07-06

申请号：US18183483

申请日：2023-03-14

Applicant: Snowflake Inc.

Inventor： Lin Chan ,  Tianyi Chen ,  Benoit Dageville ,  Yiming Kang ,  Jun Luo ,  Nithin Mahesh ,  Eric Robinson ,  Brian Smith

IPC: G06F16/23 ,  G06F16/22 ,  G06F7/14 ,  G06F21/62

CPC classification number: G06F16/2379 ,  G06F16/2228 ,  G06F7/14 ,  G06F21/6218

Abstract: As described herein, a N-Gram index may be created and the search may be conducted using the index, which will lead to faster search results. The N-Gram index may also include partial N-Gram components to capture more relevant data. Moreover, as described herein, the search may also take into account recent log data that has not yet been indexed. Techniques for building an index store using log data and efficiently searching the index store and log data to process search requests are described herein.