-
公开(公告)号:US20200218736A1
公开(公告)日:2020-07-09
申请号:US16823124
申请日:2020-03-18
Applicant: Snowflake Inc.
Inventor: Thierry CRUANES , Benoit DAGEVILLE , Florian Andreas FUNKE , Peter POVINEC
IPC: G06F16/28 , H04L29/08 , G06F16/2455 , H04L12/24
Abstract: A method for a multi-cluster warehouse includes allocating processing units as part of a data warehouse. The processing units access data within one or more databases in cloud storage resources. The method also includes providing one or more queries to each processing unit within the data warehouse. In response to the queries, each processing unit performs database operations on a particular portion of a database table. The method also includes monitoring a workload of the processing units to determine that a processing capacity of the processing units has reached a threshold processing capacity. The method also includes dynamically adding additional processing units to and removing processing units from the data warehouse as needed based on a workload of the processing units.
-
公开(公告)号:US20200210449A1
公开(公告)日:2020-07-02
申请号:US16814711
申请日:2020-03-10
Applicant: Snowflake Inc.
Inventor: Ashish Motivala , Benoit Dageville
IPC: G06F16/27 , G06F16/951 , G06F9/50 , H04L29/08 , G06F16/22 , G06F16/2455 , G06F9/48 , G06F16/182 , G06F16/2453 , G06F16/21 , G06F16/2458 , G06F16/23 , G06F16/14 , G06F16/9535
Abstract: Example systems and methods for cloning catalog objects are described. In one implementation, a method includes creating a copy of a catalog object without copying a data associated with the catalog object by only coping metadata associated with the object. The method further includes modifying, by one or more processors, the data associated with the catalog object independently of the copy of the catalog object such that modified data is not visible to the copy of the catalog object and wherein the modified data is not visible to the catalog object in a database. The method further includes deleting the copy of the catalog object following completion of the modification of the data associated with the catalog object.
-
公开(公告)号:US10678753B2
公开(公告)日:2020-06-09
申请号:US16688888
申请日:2019-11-19
Applicant: Snowflake Inc.
Inventor: Marcin Zukowski , Benoit Dageville , Thierry Cruanes , Ashish Motivala
IPC: G06F16/00 , G06F16/16 , G06F16/22 , G06F16/215 , G06F16/9535 , G06F16/2453
Abstract: A system and method for pruning data based on metadata. The method may include receiving a query that includes a plurality of predicates and identifying one or more applicable files including database data satisfying at least one of the plurality of predicates. The identifying the one or more applicable files including reading metadata stored in a metadata store that is separate from the database data. The method further includes pruning inapplicable files comprising database data that does not satisfy at least one of the plurality of predicates to create a reduced set of files and reading the reduced set of files to execute the query.
-
公开(公告)号: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.
-
公开(公告)号: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.
-
-
-
-
-
-
-
-
-