SCALABLE QUERY PROCESSING
    31.
    发明申请

    公开(公告)号:US20220222255A1

    公开(公告)日:2022-07-14

    申请号:US17657257

    申请日:2022-03-30

    Applicant: Snowflake Inc.

    Abstract: Embodiments of the present disclosure may provide a dynamic query execution model. This query execution model may provide acceleration by scaling out parallel parts of a query (also referred to as a fragment) to additional computing resources, for example computing resources leased from a pool of computing resources. Execution of the parts of the query may be coordinated by a parent query coordinator, where the query originated, and a fragment query coordinator.

    DATA SHARING USING ALIAS OBJECTS
    33.
    发明申请

    公开(公告)号:US20220207169A1

    公开(公告)日:2022-06-30

    申请号:US17697744

    申请日:2022-03-17

    Applicant: SNOWFLAKE INC.

    Abstract: A method of sharing data in a multi-tenant database includes inspecting, by a processing device of a multiple tenant database, a sharer account to determine a presence of a grant to a second role object, in a target account, of access rights to a first role object included in the sharer account. The method includes granting the second role object, in the target account, access rights to an alias object. The first role object having one or more grants to the one or more resources of the sharer account. The target account accesses the one or more resources using the one or more grants of the first role object and using the alias object without at least one of copying the one or more resources or transmitting the one or more resources.

    Resource provisioning in database systems

    公开(公告)号:US11360989B2

    公开(公告)日:2022-06-14

    申请号:US17462699

    申请日:2021-08-31

    Applicant: Snowflake Inc.

    Abstract: Resource provisioning systems and methods are described. In an embodiment, a system includes a plurality of shared storage devices collectively storing database data, an execution platform, and a compute service manager. The compute service manager is configured to determine a task to be executed in response to a trigger event and determine a query plan for executing the task, wherein the query plan comprises a plurality of discrete subtasks. The compute service manager is further configured to assign the plurality of discrete subtasks to one or more nodes of a plurality of nodes of the execution platform, determine whether execution of the task is complete, and in response to determining the execution of the task is complete, store a record in the plurality of shared storage devices indicating the task was completed.

    Account-level namespaces for database platforms

    公开(公告)号:US11249988B2

    公开(公告)日:2022-02-15

    申请号:US16945344

    申请日:2020-07-31

    Applicant: Snowflake Inc.

    Abstract: A database platform receives an object identifier from a client in association with a database session. The client is associated with a customer account of the database platform, and the database session is associated with the client. In response to receiving the object identifier, the database platform identifies a resolution namespace for the object identifier, where the resolution namespace for the object identifier is a namespace that is specified in the object identifier if the object identifier includes a specified namespace, and where the resolution namespace is otherwise a current account-level namespace of the database session. The database platform resolves the object identifier with reference to the identified resolution namespace for the object identifier, including identifying an object corresponding to the object identifier in the customer account.

    NOTIFYING MODIFICATIONS TO EXTERNAL TABLES IN DATABASE SYSTEMS

    公开(公告)号:US20210390095A1

    公开(公告)日:2021-12-16

    申请号:US17462435

    申请日:2021-08-31

    Applicant: Snowflake Inc.

    Abstract: The subject technology receives a notification that a modification has been made to an external table, the modification comprising inserting at least one row of new data to the external table, the at least one row corresponding to a first micro-partition that includes a first portion of data from the external table prior to the inserting. The subject technology, in response to the notification indicating the modification to the external table, generates a new micro-partition different from the first micro-partition, the new micro-partition including the inserted at least one row of new data and the first portion of data from the external table. The subject technology generates a refreshed materialized view based at least in part on the generated new micro-partition such that the refreshed materialized view comprises a representation of the external table after the modification has been made.

Patent Agency Ranking