公开(公告)号：US20230134358A1

公开(公告)日：2023-05-04

申请号：US17457010

申请日：2021-11-30

Applicant: Snowflake Inc.

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

IPC: G06F16/2453 ,  G06F21/62 ,  G06F16/23 ,  G06F16/22

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.

公开(公告)号：US11636110B1

公开(公告)日：2023-04-25

申请号：US17457010

申请日：2021-11-30

Applicant: Snowflake Inc.

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

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

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.

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

公开(公告)号：US20240289333A1

公开(公告)日：2024-08-29

申请号：US18656126

申请日：2024-05-06

Applicant: Snowflake Inc.

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

IPC: G06F16/2453 ,  G06F7/14 ,  G06F16/22 ,  G06F16/23 ,  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.