知搜-全球专利检索

  1. 登录
  2. 注册

搜索结果

37 条记录 (耗时 0.019 秒)

    Materialized views over external tables in database systems
    2.
    发明授权
    Materialized views over external tables in database systems 有权

    公开(公告)号：US11507571B2

    公开(公告)日：2022-11-22

    申请号：US16385720

    申请日：2019-04-16

    申请人： Snowflake Inc.

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

    IPC分类号： G06F16/23 ,  G06F16/248 ,  G06F16/2458 ,  G06F3/06 ,  G06F16/25

    摘要： Systems, methods, and devices for generating a materialized view over an external table. 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 generating, by the database platform, a materialized view over the external table. The method includes receiving a notification that a modification has been made to the external table, 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, in response to the external table being modified, refreshing the materialized view such that the materialized view comprises an accurate representation of the external table.

    NOTIFYING MODIFICATIONS TO EXTERNAL TABLES IN DATABASE SYSTEMS
    3.
    发明申请
    NOTIFYING MODIFICATIONS TO EXTERNAL TABLES IN DATABASE SYSTEMS 有权

    公开(公告)号：US20210390095A1

    公开(公告)日：2021-12-16

    申请号：US17462435

    申请日：2021-08-31

    申请人： Snowflake Inc.

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

    IPC分类号： G06F16/23 ,  G06F16/248 ,  G06F16/2458 ,  G06F3/06 ,  G06F16/25

    摘要： The subject technology receives a notification that a modification has been made to an external table, the modification comprising inserting at least one row of new data to the external table, the at least one row corresponding to a first micro-partition that includes a first portion of data from the external table prior to the inserting. The subject technology, in response to the notification indicating the modification to the external table, generates a new micro-partition different from the first micro-partition, the new micro-partition including the inserted at least one row of new data and the first portion of data from the external table. The subject technology generates a refreshed materialized view based at least in part on the generated new micro-partition such that the refreshed materialized view comprises a representation of the external table after the modification has been made.

    Querying over external tables in database systems
    4.
    发明授权
    Querying over external tables in database systems 有权

    公开(公告)号：US11163757B2

    公开(公告)日：2021-11-02

    申请号：US17200751

    申请日：2021-03-12

    申请人： Snowflake Inc.

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

    IPC分类号： G06F3/06 ,  G06F16/2453 ,  G06F16/25 ,  G06F16/23 ,  G06F16/242

    摘要： 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.

    Export data from tables into partitioned folders on an external data lake
    6.
    发明授权
    Export data from tables into partitioned folders on an external data lake 有权

    公开(公告)号：US11347775B2

    公开(公告)日：2022-05-31

    申请号：US17463313

    申请日：2021-08-31

    申请人： Snowflake Inc.

    发明人： Vasile Paraschiv ,  Saurin Shah ,  Marianne Shaw ,  Nileema Shingte

    IPC分类号： G06F16/27 ,  G06F16/28 ,  G06F9/30 ,  G06F16/22 ,  G06F16/2455

    摘要： A database export system exports data using a plurality of nodes that process the data to generate structured result files that are partitioned by an export parameter in an export request. The database export system distributes the data and merges the files to avoid small file creation and increase processing speed via parallelism. The database export system generates the result files of a specified maximum size in a final format, where the files are processed merged in a temporary file format. The parallel processing is optimized and constrained per the amount of processing nodes, available memory, requested final file sizes, and operation based ordering to complete data exports in a scalable multi-stage approach.

    Processing of queries over external tables
    7.
    发明授权
    Processing of queries over external tables 有权

    公开(公告)号：US11269869B2

    公开(公告)日：2022-03-08

    申请号：US17498382

    申请日：2021-10-11

    申请人： Snowflake Inc.

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

    IPC分类号： G06F16/20 ,  G06F16/242 ,  G06F3/06 ,  G06F16/2453 ,  G06F16/25 ,  G06F16/23

    摘要： Disclosed herein are systems and methods for processing queries over external tables. In an embodiment, a database platform receives a query directed at least to data in an external table stored in a storage platform that is external to the database platform. The database platform uses metadata that summarizes the data in the external table to identify one or more partitions of the external table as potentially including data satisfying the query, and generates a query plan that includes a plurality of discrete subtasks that collectively include instructions to scan the identified one or more partitions of the external table for data satisfying the query. The database platform assigns, based on the metadata, the plurality of discrete subtasks to one or more nodes in an execution platform, and refreshes the metadata in response to a threshold number of modifications being made to the external table.

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

    公开(公告)号：US20210200754A1

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

    申请号：US17200751

    申请日：2021-03-12

    申请人： Snowflake Inc.

    发明人： 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

    摘要： 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.

    MATERIALIZED VIEWS OVER EXTERNAL TABLES IN DATABASE SYSTEMS
    9.
    发明申请
    MATERIALIZED VIEWS OVER EXTERNAL TABLES IN DATABASE SYSTEMS 审中-公开

    公开(公告)号：US20200334231A1

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

    申请号：US16775110

    申请日：2020-01-28

    申请人： Snowflake Inc.

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

    IPC分类号： G06F16/23 ,  G06F16/248 ,  G06F16/2458 ,  G06F16/25 ,  G06F3/06

    摘要： Systems, methods, and devices for generating a materialized view over an external table. 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 generating, by the database platform, a materialized view over the external table. The method includes receiving a notification that a modification has been made to the external table, 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, in response to the external table being modified, refreshing the materialized view such that the materialized view comprises an accurate representation of the external table.

    Materialized Views Over External Tables in Database Systems
    10.
    发明申请
    Materialized Views Over External Tables in Database Systems 审中-公开

    公开(公告)号：US20200334230A1

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

    申请号：US16385720

    申请日：2019-04-16

    申请人： Snowflake Inc.

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

    IPC分类号： G06F16/23 ,  G06F16/25 ,  G06F16/248 ,  G06F16/2458 ,  G06F3/06

    摘要： Systems, methods, and devices for generating a materialized view over an external table. 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 generating, by the database platform, a materialized view over the external table. The method includes receiving a notification that a modification has been made to the external table, 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, in response to the external table being modified, refreshing the materialized view such that the materialized view comprises an accurate representation of the external table.