中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

610 records (took 0.027 seconds)

    Maintaining states of partitions of a table for adjusting clustering ratios
    571.
    发明授权
    Maintaining states of partitions of a table for adjusting clustering ratios 有权

    公开(公告)号：US11106704B2

    公开(公告)日：2021-08-31

    申请号：US17219609

    申请日：2021-03-31

    Applicant: Snowflake Inc.

    Inventor： Thierry Cruanes ,  Marcin Zukowski ,  Benoit Dageville ,  Jiaqi Yan

    IPC: G06F16/22 ,  G06F16/28 ,  G06F16/21 ,  G06F16/245 ,  G06F16/00

    Abstract: The subject technology creates partitions based on changes to a table, at least one of the one or more partitions overlapping with respect to values of one or more attributes with at least one of another partition and a previous partition. The subject technology maintains states for the partitions, each state from the plurality of states representing a particular degree of clustering of the table. The subject technology determines a number of overlapping partitions and a depth of the overlapping partitions, and determines a clustering ratio based at least in part on the number of overlapping partitions and the depth. The subject technology reclusters partitions of the table to increase the clustering ratio, the clustering ratio determined by at least a proportion of rows in a layout of the table that satisfy an ordering criteria based at least in part a particular attribute of the one or more attributes.

    AUTOMATED MAINTENANCE OF EXTERNAL TABLES IN DATABASE SYSTEMS
    573.
    发明申请
    AUTOMATED MAINTENANCE OF EXTERNAL TABLES IN DATABASE SYSTEMS 有权

    公开(公告)号：US20210216541A1

    公开(公告)日：2021-07-15

    申请号：US17219854

    申请日：2021-03-31

    Applicant: Snowflake Inc.

    Inventor： Subramanian Muralidhar ,  Benoit Dageville ,  Thierry Cruanes ,  Nileema Shingte ,  Saurin Shah ,  Torsten Grabs ,  Istvan Cseri

    IPC: G06F16/242 ,  G06F3/06 ,  G06F16/23 ,  G06F16/16 ,  G06F16/25 ,  G06F9/54 ,  G06F16/22

    Abstract: Systems, methods, and devices for automated maintenance of external tables in database systems are disclosed. A method includes receiving, by a database platform, read access to content in an external data storage platform that is separate from the database platform. The method includes defining an external table based on the content in the external data storage platform. The method includes connecting the database platform to the external table such that the database platform has read access for the external table and does not have write access for the external table. The method includes generating metadata for the external table, the metadata comprising information about data stored in the external table. The method includes receiving a notification that a modification has been made to the content in the external data storage platform, the modification comprising one or more of an addition of a file, a deletion of a file, or an update to a file in a source location for the external table. The method includes refreshing the metadata for the external table in response to the modification being made to the content in the external data storage platform.

    Modifying membership rights in a data exchange
    579.
    发明授权
    Modifying membership rights in a data exchange 有权

    公开(公告)号：US10999288B2

    公开(公告)日：2021-05-04

    申请号：US17027863

    申请日：2020-09-22

    Applicant: SNOWFLAKE INC.

    Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Matthew J. Glickman ,  Christian Kleinerman ,  Prasanna Krishnan ,  Justin Langseth

    IPC: H04L29/06 ,  H04L12/58 ,  G06F16/2455 ,  H04L12/24 ,  H04L29/08

    Abstract: Systems and methods for managing membership in a private data exchange are provided herein. In one embodiment, the method comprises adding a new member to a data exchange, wherein the data exchange comprises a set of listings, each listing comprising data from one or more datasets stored on a cloud computing service. An account type is assigned to the new member, the account type comprising at least one of a consumer type, provider type, or exchange administrator type. Each of the account types associated with one or more rights with respect to the set of listings, such that the new member has a set of rights based on the account type. The set of rights of the new member are then modified with respect to one or more listings from the set of listings based on a set of visibility and access rules for each of the set of listings.

    Tracking changes in data
    580.
    发明授权
    Tracking changes in data 有权

    公开(公告)号：US10997152B2

    公开(公告)日：2021-05-04

    申请号：US16944152

    申请日：2020-07-31

    Applicant: Snowflake Inc.

    Inventor： Istvan Cseri ,  Torsten Grabs ,  Benoit Dageville

    IPC: G06F16/23 ,  G06F16/27 ,  G06F16/2455

    Abstract: The subject technology executes a change on an existing micro-partition of a table, the executing of the change comprising generating a new micro-partition that embodies the change and deleting the existing micro-partition. The subject technology receives a request for a delta for the table between a first timestamp and a second timestamp. The subject technology responsively determines the delta based on a table history, the delta including information indicating at least one operation that was performed to at least one row of a set of rows of the table, without including information as to intermediate changes made to at least one row of the set of rows of the table between the first timestamp and the second timestamp, that facilitates a reduction in storage of historical versions of the set of rows of the table.

Patent Agency Ranking