中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

1753 records (took 0.029 seconds)

    System and method for global data sharing
    622.
    发明授权
    System and method for global data sharing 有权

    公开(公告)号：US10999355B1

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

    申请号：US16814875

    申请日：2020-03-10

    Applicant: Snowflake Inc.

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

    IPC: G06F15/173 ,  H04L29/08 ,  H04L29/06 ,  H04L12/24

    Abstract: Sharing data in a data exchange across multiple cloud computing platforms and/or cloud computing platform regions is described. An example computer-implemented method can include receiving data sharing information from a data provider for sharing a data set in a data exchange from a first cloud computing entity to a set of second cloud computing entities. In response to receiving the data sharing information, the method may also include creating an account with each of the set of second cloud computing entities. The method may also further include sharing the data set from the first cloud computing entity with the set of second cloud computing entities using at least the corresponding account of that second cloud computing entity.

    Maintaining states of partitions of a table for reclustering
    624.
    发明授权
    Maintaining states of partitions of a table for reclustering 有权

    公开(公告)号：US10997215B2

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

    申请号：US17030565

    申请日：2020-09-24

    Applicant: Snowflake Inc.

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

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

    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.

    Placement of adaptive aggregation operators and properties in a query plan
    625.
    发明授权
    Placement of adaptive aggregation operators and properties in a query plan 有权

    公开(公告)号：US10997173B2

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

    申请号：US16857790

    申请日：2020-04-24

    Applicant: Snowflake Inc.

    Inventor： Bowei Chen ,  Thierry Cruanes ,  Florian Andreas Funke ,  Allison Waingold Lee ,  Jiaqi Yan

    IPC: G06F16/2453

    Abstract: The subject technology receives a query plan, the query plan comprising a set of query operations, the set of query operations including at least one aggregation and at least one join operation. The subject technology analyzes the query plan to identify an aggregation that is redundant. The subject technology removes the aggregation based at least in part on the analyzing. The subject technology determines at least one aggregation property corresponding to at least one query operation of the query plan. The subject technology inserts at least one adaptive aggregation operator in the query plan based at least in part on the at least one aggregation property. The subject technology provides a modified query plan based at least in part on the inserted at least one adaptive aggregation operator in the query plan.

    Tracking intermediate changes in database data
    626.
    发明授权
    Tracking intermediate changes in database data 有权

    公开(公告)号：US10997162B2

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

    申请号：US16824676

    申请日：2020-03-19

    Applicant: Snowflake Inc.

    Inventor： Torsten Grabs ,  Istvan Cseri ,  Benoit Dageville

    IPC: G06F17/00 ,  G06F16/23 ,  G06F16/22 ,  G06F16/2455

    Abstract: Systems, methods, and devices for tracking a series of changes to database data are disclosed. A method includes executing a transaction to modify data in a micro-partition of a table of a database by generating a new micro-partition that embodies the transaction. The method includes associating transaction data with the new micro-partition, wherein the transaction data comprises a timestamp when the transaction was fully executed, and further includes associating modification data with the new micro-partition that comprises an indication of one or more rows of the table that were modified by the transaction. The method includes joining the transaction data with the modification data to generate joined data and querying the joined data to determine a listing of intermediate modifications made to the table between a first timestamp and a second timestamp.

    Transactional streaming of change tracking data
    627.
    发明授权
    Transactional streaming of change tracking data 有权

    公开(公告)号：US10997151B2

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

    申请号：US16705566

    申请日：2019-12-06

    Applicant: Snowflake Inc.

    Inventor： Subramanian Muralidhar ,  Istvan Cseri ,  Torsten Grabs ,  Benoit Dageville

    IPC: G06F16/23 ,  G06F9/46 ,  G06F16/245 ,  G06F16/27 ,  G06F16/18

    Abstract: Systems, methods, and devices for generating a transactional change tracking summary for a database. A method includes executing a transaction on a table of a database, wherein the table includes a micro-partition and the transaction is executed on the micro-partition. The method includes, in response to the transaction being fully executed, generating a change tracking entry comprising an indication of one or modifications made to the table by the transaction. The method includes storing the change tracking entry in a change tracking stream, wherein the change tracking stream includes one or more sequential change tracking entries that each correspond to a different transaction that is fully executed on the table.

    DATA SHARING USING ALIAS OBJECTS
    630.
    发明申请
    DATA SHARING USING ALIAS OBJECTS 有权

    公开(公告)号：US20210103672A1

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

    申请号：US17103786

    申请日：2020-11-24

    Applicant: SNOWFLAKE INC.

    Inventor： Benoit Dageville ,  Thierry Cruanes ,  Martin Hentschel ,  Peter Povinec

    IPC: G06F21/62 ,  G06F16/25

    Abstract: A method of 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.

Patent Agency Ranking