中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

610 records (took 0.044 seconds)

    QUERYING OVER EXTERNAL TABLES IN DATABASE SYSTEMS
    191.
    发明申请
    QUERYING OVER EXTERNAL TABLES IN DATABASE SYSTEMS 有权

    公开(公告)号：US20210200754A1

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

    申请号：US17200751

    申请日：2021-03-12

    Applicant: Snowflake Inc.

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

    IPC: G06F16/242 ,  G06F3/06 ,  G06F16/2453 ,  G06F16/25 ,  G06F16/23

    Abstract: Systems, methods, and devices for querying over an external table are disclosed. A method includes connecting a database platform to an 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 receiving a query comprising a predicate, the query directed at least to data in the external table. The method includes determining, based on metadata, one or more partitions in the external table comprising data satisfying the predicate. The method includes pruning, based on the metadata, all partitions in the external table that do not comprise any data satisfying the predicate. The method includes generating a query plan comprising a plurality of discrete subtasks. The method includes assigning, based on the metadata, the plurality of discrete subtasks to one or more nodes in an execution platform.

    TRANSACTIONAL STORES OF CHANGE TRACKING DATA
    193.
    发明申请
    TRANSACTIONAL STORES OF CHANGE TRACKING DATA 有权

    公开(公告)号：US20210157785A1

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

    申请号：US17143054

    申请日：2021-01-06

    Applicant: Snowflake Inc.

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

    IPC: G06F16/23 ,  G06F16/27 ,  G06F16/245 ,  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.

    System and method for global data sharing
    195.
    发明授权
    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
    196.
    发明授权
    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.

    Tracking intermediate changes in database data
    197.
    发明授权
    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
    198.
    发明授权
    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.

Patent Agency Ranking