公开(公告)号：US12074991B2

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

申请号：US18338909

申请日：2023-06-21

Applicant: Snowflake Inc.

Inventor： Harsh Chaturvedi ,  Harsha S. Kapre ,  Srinath Shankar

IPC: H04L9/32 ,  H04L67/1097 ,  H04L67/289

CPC classification number: H04L9/3268 ,  H04L9/3297 ,  H04L67/1097 ,  H04L67/289

Abstract: A proxy revocation service provides a reliable service for performing revocation checks. The proxy revocation service queries public certificate authorities for the revocation status of a set of digital certificates and maintains a database of the revocation statuses. The proxy revocation service provides a singular endpoint that is Application Protocol Interface (API) accessible to web clients. Web clients communicate with the proxy revocation service through use of API message to perform revocation checks, rather than communicating with the public certificate authorities using an online certificate status protocol (OCSP). Use of the proxy revocation service provides both a reliable service for performing revocation checks as well as shifts the complexity away from the web clients.

公开(公告)号：US11921733B2

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

申请号：US17813662

申请日：2022-07-20

Applicant: Snowflake Inc.

Inventor： Harsha S. Kapre ,  Mark T. Keller ,  Srinath Shankar ,  Kushan A. Zaveri

IPC: G06F16/2458 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/25

CPC classification number: G06F16/2471 ,  G06F16/24532 ,  G06F16/24561 ,  G06F16/256 ,  G06F16/258

Abstract: Techniques for fetching query result data using result batches includes generating a plurality of result batches based on query result information. The query result information is associated with query result data generated from execution of a query. Each result batch of the plurality of result batches includes a result data retrieval function for a corresponding data portion of a plurality of data portions of the query result data. The plurality of result batches are encoded for distribution to a corresponding plurality of computing nodes. The techniques further include causing retrieving of the plurality of data portions of the query result data by the corresponding plurality of computing nodes based on the result data retrieval function for each of the plurality of data portions.

公开(公告)号：US11636126B1

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

申请号：US17813539

申请日：2022-07-19

Applicant: Snowflake Inc.

Inventor： Harsha S. Kapre ,  Mark T. Keller ,  Srinath Shankar ,  Kushan A. Zaveri

IPC: G06F16/2458 ,  G06F16/25 ,  G06F16/2453 ,  G06F16/2455

Abstract: Techniques for configuring query result information associated with query result data include configuring execution of a query using a plurality of execution stages. Query result data is generated based on the execution of the query. The query result data includes a plurality of data portions. Each data portion of the plurality of data portions is obtained at a corresponding execution stage of the plurality of execution stages. Query result information is generated based on the execution of the query. The query result information includes authentication information associated with accessing the plurality of data portions.

公开(公告)号：US20230336365A1

公开(公告)日：2023-10-19

申请号：US18338909

申请日：2023-06-21

Applicant: Snowflake Inc.

Inventor： Harsh Chaturvedi ,  Harsha S. Kapre ,  Srinath Shankar

IPC: H04L9/32 ,  H04L67/289 ,  H04L67/1097

CPC classification number: H04L9/3268 ,  H04L67/289 ,  H04L9/3297 ,  H04L67/1097

Abstract: A proxy revocation service provides a reliable service for performing revocation checks. The proxy revocation service queries public certificate authorities for the revocation status of a set of digital certificates and maintains a database of the revocation statuses. The proxy revocation service provides a singular endpoint that is Application Protocol Interface (API) accessible to web clients. Web clients communicate with the proxy revocation service through use of API message to perform revocation checks, rather than communicating with the public certificate authorities using an online certificate status protocol (OCSP). Use of the proxy revocation service provides both a reliable service for performing revocation checks as well as shifts the complexity away from the web clients.

公开(公告)号：US20230205777A1

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

申请号：US18178758

申请日：2023-03-06

Applicant: Snowflake Inc.

Inventor： Harsha S. Kapre ,  Mark T. Keller ,  Srinath Shankar ,  Kushan A. Zaveri

IPC: G06F16/2458 ,  G06F16/25 ,  G06F16/2453 ,  G06F16/2455

CPC classification number: G06F16/2471 ,  G06F16/256 ,  G06F16/24532 ,  G06F16/258 ,  G06F16/24561

Abstract: Techniques for configuring query result information include decoding a query received from a client device of a network-based database system. A multi-stage execution of the query is configured to obtain a plurality of query result subsets. A combined query result is generated using the plurality of query result subsets. The combined query result further includes storage location information for each of the plurality of query result subsets. The combined query result is encoded for transmission to the client device in response to the query.

公开(公告)号：US11516022B1

公开(公告)日：2022-11-29

申请号：US17515489

申请日：2021-10-31

Applicant: Snowflake Inc.

Inventor： Harsh Chaturvedi ,  Harsha S. Kapre ,  Srinath Shankar

IPC: H04L9/32 ,  H04L67/1097

Abstract: A proxy revocation service provides a reliable service for performing revocation checks. The proxy revocation service queries public certificate authorities for the revocation status of a set of digital certificates and maintains a database of the revocation statuses. The proxy revocation service provides a singular endpoint that is Application Protocol Interface (API) accessible to web clients. Web clients communicate with the proxy revocation service through use of API message to perform revocation checks, rather than communicating with the public certificate authorities using an online certificate status protocol (OCSP). Use of the proxy revocation service provides both a reliable service for performing revocation checks as well as shifts the complexity away from the web clients.

公开(公告)号：US12124462B2

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

申请号：US18178758

申请日：2023-03-06

Applicant: Snowflake Inc.

Inventor： Harsha S. Kapre ,  Mark T. Keller ,  Srinath Shankar ,  Kushan A. Zaveri

IPC: G06F16/2458 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/25

CPC classification number: G06F16/2471 ,  G06F16/24532 ,  G06F16/24561 ,  G06F16/256 ,  G06F16/258

Abstract: Techniques for configuring query result information include decoding a query received from a client device of a network-based database system. A multi-stage execution of the query is configured to obtain a plurality of query result subsets. A combined query result is generated using the plurality of query result subsets. The combined query result further includes storage location information for each of the plurality of query result subsets. The combined query result is encoded for transmission to the client device in response to the query.

公开(公告)号：US20230120159A1

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

申请号：US17813539

申请日：2022-07-19

Applicant: Snowflake Inc.

Inventor： Harsha S. Kapre ,  Mark T. Keller ,  Srinath Shankar ,  Kushan A. Zaveri

IPC: G06F16/2458 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/25

Abstract: Techniques for configuring query result information associated with query result data include configuring execution of a query using a plurality of execution stages. Query result data is generated based on the execution of the query. The query result data includes a plurality of data portions. Each data portion of the plurality of data portions is obtained at a corresponding execution stage of the plurality of execution stages. Query result information is generated based on the execution of the query. The query result information includes authentication information associated with accessing the plurality of data portions.

公开(公告)号：US20230117449A1

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

申请号：US17813662

申请日：2022-07-20

Applicant: Snowflake Inc.

Inventor： Harsha S. Kapre ,  Mark T. Keller ,  Srinath Shankar ,  Kushan A. Zaveri

IPC: G06F16/2458

Abstract: Techniques for fetching query result data using result batches includes generating a plurality of result batches based on query result information. The query result information is associated with query result data generated from execution of a query. Each result batch of the plurality of result batches includes a result data retrieval function for a corresponding data portion of a plurality of data portions of the query result data. The plurality of result batches are encoded for distribution to a corresponding plurality of computing nodes. The techniques further include causing retrieving of the plurality of data portions of the query result data by the corresponding plurality of computing nodes based on the result data retrieval function for each of the plurality of data portions.

公开(公告)号：US11436245B1

公开(公告)日：2022-09-06

申请号：US17453756

申请日：2021-11-05

Applicant: Snowflake Inc.

Inventor： Harsha S. Kapre ,  Mark T. Keller ,  Srinath Shankar ,  Kushan A. Zaveri

IPC: G06F16/2458 ,  G06F16/2455 ,  G06F16/25 ,  G06F16/2453

Abstract: Provided herein are systems and methods for query result data processing, including parallel fetching and processing of query result data. A system includes at least one hardware processor coupled to memory and configured to execute a query received from a first computing device, to obtain query result data. The at least one hardware processor is further configured to store the query result data at a storage location. The at least one hardware processor is further configured to generate query result information associated with the query result data. The query result information includes location information associated with the storage location and schema information associated with the query result data. The at least one hardware processor is further configured to encode the query result information for transmission to the first computing device.