中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

610 records (took 0.019 seconds)

    INCREASING CLUSTERING OF PARTITIONS OF A TABLE
    591.
    发明申请
    INCREASING CLUSTERING OF PARTITIONS OF A TABLE 有权

    公开(公告)号：US20210019335A1

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

    申请号：US17030549

    申请日：2020-09-24

    Applicant: Snowflake Inc.

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

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

    Abstract: The subject technology creates one or more 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 creating of the one or more partitions resulting in a decrease in a degree of clustering of the table. The subject technology determines, after creating the one or more partitions, that the degree of clustering of the table is below a clustering threshold, the clustering threshold corresponding to a 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. The subject technology increases the degree of clustering of the table by reclustering partitions of the table.

    Data Sharing And Materialized Views In Multiple Tenant Database Systems
    596.
    发明申请
    Data Sharing And Materialized Views In Multiple Tenant Database Systems 审中-公开

    公开(公告)号：US20200379993A1

    公开(公告)日：2020-12-03

    申请号：US16428367

    申请日：2019-05-31

    Applicant: Snowflake Inc.

    Inventor： Prasanna Rajaperumal ,  Thierry Cruanes ,  Allison Waingold Lee ,  Igor Demura ,  Jiaqi Yan ,  Benoit Dageville

    IPC: G06F16/2453

    Abstract: Systems, methods, and devices for generating and updating cross-account materialized views in multiple tenant database systems. A methods includes defining a share object in a first account wherein the share object includes data associated with the first account. The method includes granting cross-account access rights to the share object to a second account such that the second account has access to the share object without copying the share object. The method includes generating a materialized view over the share object. The method includes updating the data associated with the first account. The method includes identifying whether the materialized view is stale with respect to the share object by merging the materialized view and the share object.

    Transferring connections in a multiple deployment database
    598.
    发明授权
    Transferring connections in a multiple deployment database 有权

    公开(公告)号：US10817536B2

    公开(公告)日：2020-10-27

    申请号：US16778817

    申请日：2020-01-31

    Applicant: Snowflake Inc.

    Inventor： Eric Robinson ,  Benoit Dageville ,  Shigeyuki Takeda ,  Kristopher Wagner

    IPC: G06F16/27 ,  G06F16/23 ,  H04L29/12 ,  H04L29/08 ,  G06F16/21

    Abstract: Systems, methods, and devices for transitioning a client connection for a database from a first deployment of the database to a second deployment of the database. A method includes maintaining the client connection between a client and the first deployment such that database traffic occurs at the first deployment. The method includes generating a unique identification that references a first connection object of the first deployment and a second connection object of a second deployment. The method includes receiving a notification that the first deployment is unavailable and providing an external connection group unique identification to the second deployment for the second deployment to determine whether the client should be connected to the second deployment. The method includes receiving a uniform resource locator from the second deployment if the client should be connected to the second deployment.

    AUTOMATED MAINTENANCE OF EXTERNAL TABLES IN DATABASE SYSTEMS
    599.
    发明申请
    AUTOMATED MAINTENANCE OF EXTERNAL TABLES IN DATABASE SYSTEMS 审中-公开

    公开(公告)号：US20200334242A1

    公开(公告)日：2020-10-22

    申请号：US16842942

    申请日：2020-04-08

    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.

    QUERYING OVER EXTERNAL TABLES IN DATABASE SYSTEMS
    600.
    发明申请
    QUERYING OVER EXTERNAL TABLES IN DATABASE SYSTEMS 审中-公开

    公开(公告)号：US20200334241A1

    公开(公告)日：2020-10-22

    申请号：US16841831

    申请日：2020-04-07

    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/25 ,  G06F16/2453

    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.

Patent Agency Ranking