中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

17 records (took 0.011 seconds)

    INCREMENTAL FEATURE DEVELOPMENT AND WORKLOAD CAPTURE IN DATABASE SYSTEMS
    1.
    发明申请
    INCREMENTAL FEATURE DEVELOPMENT AND WORKLOAD CAPTURE IN DATABASE SYSTEMS 审中-公开

    公开(公告)号：WO2019183219A1

    公开(公告)日：2019-09-26

    申请号：PCT/US2019/023162

    申请日：2019-03-20

    Applicant: SNOWFLAKE COMPUTING INC.

    Inventor： YAN, Jiaqi ,  JIN, Qiuye ,  JAIN, Shrainik ,  VIGLAS, Stratis ,  LEE, Allison

    IPC: G06F11/34 ,  G06F17/30 ,  G06F15/16

    Abstract: Systems, methods, and devices for incremental feature development and workload capture in database systems are disclosed. A method includes determining a workload having one or more historical client queries to be rerun for testing the feature, wherein the feature comprises procedural logic. The method further includes executing a baseline run of the workload that does not implement the feature and executing a target run of the workload while implementing the feature. The method further includes comparing the baseline run and the target run to identify whether there is a performance regression in the target run. The method further includes, in response to identifying the performance regression, rerunning the target run to identify whether the performance regression still exists.

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

    DATA SHARING IN A MULTI-TENANT DATABASE SYSTEM
    6.
    发明申请
    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
    7.
    发明申请
    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
    8.
    发明申请
    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