-
公开(公告)号：US10671605B2
公开(公告)日：2020-06-02
申请号：US15097107
申请日：2016-04-12
Applicant: SNOWFLAKE INC.
Inventor： Benoit Dageville , Jiansheng Huang , Shige Takeda , Abdul Q. Munir
IPC: G06F16/2453 , G06F16/14 , G06F16/2455 , G06F16/11 , G06F16/16
Abstract: A method, system, and apparatus for managing a persistent query result set are disclosed. A resource manager is disclosed that receives a query from a client over a computer network. A computer database server is disclosed that executes the query and generates a result set based on and in response to the received query. An execution platform is disclosed that divides the result set into a plurality of chunks, wherein each chunk comprises a portion of the generated result set. The resource manager adds metadata to each of the plurality of chunks. A first chunk of the plurality of chunks comprises metadata pointing to the plurality of chunks. The resource manager delivers at least the first chunk of the plurality of chunks to the client in response to the query. The execution platform offloads the remaining plurality of chunks to cloud storage in parallel.
-
公开(公告)号：US20200167340A1
公开(公告)日：2020-05-28
申请号：US16203322
申请日：2018-11-28
Applicant: Snowflake Inc.
Inventor： Istvan Cseri , Torsten Grabs , Benoit Dageville
Abstract: Systems, methods, and devices for executing a task on database data in response to a trigger event are disclosed. A method includes executing a transaction on a table comprising database data, wherein executing the transaction comprises generating a new table version. The method includes, in response to the transaction being fully executed, generating a change tracking entry comprising an indication of one or more modifications made to the table by the transaction and storing the change tracking entry in a change tracking stream. The method includes executing a task on the new table version in response to a trigger event.
-
公开(公告)号：US20200151193A1
公开(公告)日：2020-05-14
申请号：US16741676
申请日：2020-01-13
Applicant: Snowflake Inc.
Inventor： Benoit Dageville , Thierry Cruanes , Allison Waingold Lee
IPC: G06F16/27 , G06F9/50 , H04L29/08 , G06F9/48 , G06F16/2455 , G06F16/2453 , G06F16/9535 , G06F16/2458 , G06F16/23 , G06F16/182 , G06F16/951 , G06F16/22 , G06F16/21 , G06F16/14
Abstract: A system and method for managing data storage and data access with querying data in a distributed system without buffering the results on intermediate operations in disk storage.
-
公开(公告)号：US10642993B1
公开(公告)日：2020-05-05
申请号：US16779103
申请日：2020-01-31
Applicant: Snowflake Inc.
Inventor： Benoit Dageville , Thierry Cruanes , Martin Hentschel , Peter Povinec
Abstract: A method for sharing data in a multi-tenant database includes generating a share object in a first account comprising a share role. The method includes associating one or more access rights with the share role, wherein the one or more access rights indicate which objects in the first account are accessible based on the share object. The method includes granting, to a second account, cross-account access rights to the share role or share object in the first account. The method includes receiving a request from the second account to access data or services of the first account. The method further includes providing a response to the second account based on the data or services of the first account.
-
公开(公告)号：US10592681B2
公开(公告)日：2020-03-17
申请号：US15402906
申请日：2017-01-10
Applicant: Snowflake Inc.
Inventor： Benoit Dageville , Thierry Cruanes , Martin Hentschel , Peter Povinec
Abstract: A method for sharing data in a multi-tenant database includes generating a share object in a first account comprising a share role. The method includes associating one or more access rights with the share role, wherein the one or more access rights indicate which objects in the first account are accessible based on the share object. The method includes granting, to a second account, cross-account access rights to the share role or share object in the first account. The method includes receiving a request from the second account to access data or services of the first account. The method further includes providing a response to the second account based on the data or services of the first account.
-
Patent Agency Ranking
公开(公告)号：US10545917B2
公开(公告)日：2020-01-28
申请号：US14882024
申请日：2015-10-13
Applicant: Snowflake Inc.
Inventor： Benoit Dageville , Thierry Cruanes , Marcin Zukowski , Allison Waingold Lee , Philipp Thomas Unterbrunner
IPC: G06F16/13 , G06F16/22 , G06F16/172 , G06F16/182 , G06F16/2455
Abstract: A system, apparatus, and method for managing data storage and data access with querying data and filtering value ranges using only a constant amount of computer memory in the implementation of bloom filters based on a first consumption of a relation.
-
公开(公告)号：US10534792B2
公开(公告)日：2020-01-14
申请号：US14626853
申请日：2015-02-19
Applicant: SNOWFLAKE INC.
Inventor： Benoit Dageville , Thierry Cruanes , Allison Waingold Lee
IPC: G06F17/30 , G06F16/27 , G06F9/50 , G06F16/14 , G06F16/21 , G06F16/22 , G06F16/951 , G06F16/182 , G06F16/23 , G06F16/2455 , G06F16/2458 , G06F16/9535 , G06F16/2453 , G06F9/48 , H04L29/08
Abstract: A system and method for managing data storage and data access with querying data in a distributed system without buffering the results on intermediate operations in disk storage.
-
公开(公告)号：US20250053680A1
公开(公告)日：2025-02-13
申请号：US18928687
申请日：2024-10-28
Applicant: Snowflake Inc.
Inventor： Benoit Dageville , Peter Povinec , Philipp Thomas Unterbrunner , Martin Hentschel
Abstract: A method of preventing queries from accessing database files based on metadata. The method includes determining a first metadata associated with a particular file and a second metadata associated with a changed version of the particular file. The method includes directing, based on the first metadata associated with the particular file, a first query for the particular file to a first file that is associated with the particular file. The method includes preventing a second query for the particular file from accessing the particular file by directing, based on the second metadata associated with the changed version of the particular file, the second query to the changed version of the particular file instead of the particular file.
-
公开(公告)号：US20250023941A1
公开(公告)日：2025-01-16
申请号：US18900363
申请日：2024-09-27
Applicant: Snowflake Inc.
Inventor： Pui Kei Johnston Chu , Benoit Dageville , Matthew Glickman , Christian Kleinerman , Prasanna Krishnan , Justin Langseth
Abstract: Sharing data in a data exchange across multiple cloud computing platforms is described. An example method includes copying, to a first cloud computing entity using a consumer account of the first cloud computing entity, a first subset of a data set associated with a provider account of a second cloud computing entity, wherein the provider account of the second cloud computing entity does not have access to the first cloud computing entity, and verifying existence of the first subset of the data set at the first cloud computing entity.
-
公开(公告)号：US12158970B2
公开(公告)日：2024-12-03
申请号：US18111821
申请日：2023-02-20
Applicant: Snowflake Inc.
Inventor： Benoit Dageville , Peter Povinec , Philipp Thomas Unterbrunner , Martin Hentschel
Abstract: A method for directing queries to encrypted database files includes acquiring a mapping that links a first encrypted file with a different encrypted file. The first encrypted file is generated based on a first encryption key. The method includes generating, by one or more processors based on the mapping, an updated mapping to link a second encrypted file with the different encrypted file. The second encrypted file is generated based on a second encryption key. The method includes directing, using the mapping, a first query to the first encrypted file when the first query arrives before generating the updated mapping; and. The method includes directing, using the updated mapping, a second query to the second encrypted file when a second query arrives after generating the updated mapping.
-
-
-
-
-
-
-
-
-
Search Results
604
records
(took 0.018 seconds)
