中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

13 records (took 0.017 seconds)

    MULTI-CLUSTER WAREHOUSE
    1.
    发明申请
    MULTI-CLUSTER WAREHOUSE 审中-公开
    多集群仓库

    公开(公告)号：WO2017190058A1

    公开(公告)日：2017-11-02

    申请号：PCT/US2017/030207

    申请日：2017-04-28

    Applicant: SNOWFLAKE COMPUTING INC.

    Inventor： FUNKE, Florian, Andreas ,  POVINEC, Peter ,  CRUANES, Thierry ,  DAGEVILLE, Benoit

    IPC: G06F9/445 ,  G06F9/455 ,  G06F9/50 ,  G06F15/16 ,  G06F15/173 ,  G06F17/30

    Abstract: A method for a multi-cluster warehouse includes allocating a plurality of compute clusters as part of a virtual warehouse. The compute clusters are used to access and perform queries against one or more databases in one or more cloud storage resources. The method includes providing queries for the virtual warehouse to each of the plurality of compute clusters. Each of the plurality of compute clusters of the virtual warehouse receives a plurality of queries so that the computing load is spread across the different clusters. The method also includes dynamically adding compute clusters to and removing compute clusters from the virtual warehouse as needed based on a workload of the plurality of compute clusters.

    Abstract translation: 用于多集群仓库的方法包括分配多个计算集群作为虚拟仓库的一部分。 计算集群用于访问和执行针对一个或多个云存储资源中的一个或多个数据库的查询。 该方法包括将虚拟仓库的查询提供给多个计算集群中的每一个。 虚拟仓库的多个计算集群中的每一个接收多个查询，使得计算负载分布在不同的集群上。 该方法还包括基于多个计算集群的工作负载，根据需要动态地将计算集群添加到虚拟仓库并且从虚拟仓库移除计算集群。

    BATCH DATA INGESTION IN DATABASE SYSTEMS
    4.
    发明申请
    BATCH DATA INGESTION IN DATABASE SYSTEMS 审中-公开

    公开(公告)号：WO2019104338A1

    公开(公告)日：2019-05-31

    申请号：PCT/US2018/062652

    申请日：2018-11-27

    Applicant: SNOWFLAKE COMPUTING INC

    Inventor： HUANG, Jiansheng ,  LIANG, Jiaxing ,  ZIEGLER, Scott ,  YU, Haowei ,  DAGEVILLE, Benoit ,  GANESH, Varun

    IPC: G06F16/00

    Abstract: Systems, methods, and devices for batch ingestion of data into a table of a database. A method includes determining a notification indicating a presence of a user file received from a client account to be ingested into a database. The method includes identifying data in the user file and identifying a target table of the database to receive the data in the user file. The method includes generating an ingest task indicating the data and the target table. The method includes assigning the ingest task to an execution node of an execution platform, wherein the execution platform comprises a plurality of execution nodes operating independent of a plurality of shared storage devices collectively storing database data. The method includes registering metadata concerning the target table in a metadata store after the data has been fully committed to the target table by the execution node.

    DATABASE METADATA IN IMMUTABLE STORAGE
    5.
    发明申请
    DATABASE METADATA IN IMMUTABLE STORAGE 审中-公开

    公开(公告)号：WO2019099446A1

    公开(公告)日：2019-05-23

    申请号：PCT/US2018/060922

    申请日：2018-11-14

    Applicant: SNOWFLAKE COMPUTING INC.

    Inventor： DAGEVILLE, Benoit ,  HENTSCHEL, Martin ,  WADDINGTON, William

    IPC: G06F17/00 ,  G06F17/30

    Abstract: A method for a database system includes storing table data for a database, the table data including information in rows and columns of one or more database tables. The method includes storing metadata on immutable storage, the metadata including information about the table data for the database. In one embodiment, mutable metadata may be periodically consolidated in the background to create new versions of metadata files and which allows for deletions of old metadata files and old data files.

    DATA SHARING IN A MULTI-TENANT DATABASE SYSTEM
    7.
    发明申请
    DATA SHARING IN A MULTI-TENANT DATABASE SYSTEM 审中-公开

    公开(公告)号：WO2018132478A1

    公开(公告)日：2018-07-19

    申请号：PCT/US2018/013176

    申请日：2018-01-10

    Applicant: SNOWFLAKE COMPUTING INC.

    Inventor： DAGEVILLE, Benoit ,  CRUANES, Thierry ,  HENTSCHEL, Martin ,  POVINEC, Peter

    IPC: G06F17/30 ,  G06F15/173 ,  G06F21/00 ,  H04L9/32

    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.

    INCREMENTAL CLUSTERING MAINTENANCE OF A TABLE
    8.
    发明申请
    INCREMENTAL CLUSTERING MAINTENANCE OF A TABLE 审中-公开
    增量式集群维护

    公开(公告)号：WO2018045372A1

    公开(公告)日：2018-03-08

    申请号：PCT/US2017/050075

    申请日：2017-09-05

    Applicant: SNOWFLAKE COMPUTING INC.

    Inventor： CRUANES, Thierry ,  ZUKOWSKI, Marcin ,  DAGEVILLE, Benoit ,  YAN, Jiaqi

    IPC: G06F17/30 ,  G06F3/06 ,  G06F7/00 ,  G06F13/00 ,  G06F17/00

    Abstract: A method includes storing table data for a table in a plurality of partitions and for maintaining approximate or good enough clustering. The method includes creating one or more new partitions based on changes to the table, wherein at least one of the one or more new partitions overlap with each other or previous partitions resulting in a decrease in a degree of clustering of the table. The method includes determining that a degree of clustering of the table data is below a clustering threshold. The method further includes reclustering one or more partitions of the table to improve the degree of clustering of the table in response to one or more of: determining that the degree of clustering has fallen below the clustering threshold, an explicit user command from a user, and/or as part of a DML command. Reclustering may be performed in incremental steps to iteratively improve clustering.

    Abstract translation: 一种方法包括将表格的表格数据存储在多个分区中并用于保持近似或足够好的聚类。 该方法包括基于对表格的改变创建一个或多个新分区，其中一个或多个新分区中的至少一个与彼此重叠或先前分区重叠，导致表格聚类程度的降低。 该方法包括确定表格数据的聚类程度低于聚类阈值。 该方法进一步包括：响应于以下各项中的一项或多项来重新聚集表格的一个或多个分区以提高表格的聚类度：确定聚类度已经降至聚类阈值以下，来自用户的显式用户命令， 和/或作为DML命令的一部分。 可以通过增量步骤执行重新集群，以反复改进集群。

    CLONING CATALOG OBJECTS
    9.
    发明申请
    CLONING CATALOG OBJECTS 审中-公开
    克隆目录对象

    公开(公告)号：WO2017210477A1

    公开(公告)日：2017-12-07

    申请号：PCT/US2017/035531

    申请日：2017-06-01

    Applicant: SNOWFLAKE COMPUTING INC.

    Inventor： MOTIVALA, Ashish ,  DAGEVILLE, Benoit

    IPC: G06F17/30

    Abstract: Example systems and methods for cloning catalog objects are described. In one implementation, a method identifies an original catalog object associated with a set of data and creates a duplicate copy of the original catalog object without copying the data itself. The method allows access to the set of data using the duplicate catalog object and supports modifying the data associated with the original catalog object independently of the duplicate catalog object. The duplicate catalog object can be deleted upon completion of modifying the data associated with the original catalog object.

    Abstract translation: 描述用于克隆目录对象的示例性系统和方法。 在一个实现中，方法标识与一组数据相关联的原始目录对象，并且创建原始目录对象的副本而不复制数据本身。 该方法允许使用重复的目录对象访问该组数据，并支持独立于重复的目录对象修改与原始目录对象关联的数据。 完成修改与原始目录对象关联的数据后，可以删除重复的目录对象。

Patent Agency Ranking