中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

610 records (took 0.048 seconds)

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

    公开(公告)号：US11086840B2

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

    申请号：US16213554

    申请日：2018-12-07

    Applicant: Snowflake Inc.

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

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

    GENERATION OF PRUNING INDEX FOR PATTERN MATCHING QUERIES
    434.
    发明申请
    GENERATION OF PRUNING INDEX FOR PATTERN MATCHING QUERIES 有权

    公开(公告)号：US20210216555A1

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

    申请号：US17218962

    申请日：2021-03-31

    Applicant: Snowflake Inc.

    Inventor： Thierry Cruanes ,  Benoit Dageville ,  Ismail Oukid ,  Stefan Richter

    IPC: G06F16/2455 ,  G06F17/18 ,  G06F16/22 ,  G06F16/9035 ,  G06F16/28

    Abstract: A query directed at a source table organized into a set of batch units is received. The query includes a pattern matching predicate that specifies a search pattern. A set of N-grams are generated based on the search pattern. A pruning index associated with the source table is accessed. The pruning index comprises a set of filters that index distinct N-grams in each column of the source table. The pruning index is used to identify a subset of batch units to scan for matching data based on the set of N-grams generated for the search pattern. The query is processed by scanning the subset of batch units.

    Generating data structures for storing database metadata
    435.
    发明授权
    Generating data structures for storing database metadata 有权

    公开(公告)号：US11055291B2

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

    申请号：US17086275

    申请日：2020-10-30

    Applicant: Snowflake Inc.

    Inventor： Benoit Dageville ,  Yi Fang ,  Martin Hentschel ,  Ashish Motivala ,  Spyridon Triantafyllis ,  Yizhi Zhu

    IPC: G06F16/2455 ,  G06F16/23 ,  G06F16/2457 ,  G06F16/22 ,  G06F16/2458 ,  G06F16/27

    Abstract: The subject technology generates a first data structure including first metadata and a second data structure including second metadata, the first metadata corresponding to a set of micro-partitions, the second metadata for a grouping of the first metadata, the second data structure including information associating the second metadata to the first metadata. The subject technology stores the first data structure and the second data structure in storage as a first file and a second file. The subject technology stores third metadata for a table, the third metadata comprising: cumulative table metadata comprising global information about a plurality of micro-partitions of the table, the cumulative table metadata being stored in a metadata micro-partition associated with the table.

    DATABASE QUERY PROCESSING USING A PRUNING INDEX
    436.
    发明申请
    DATABASE QUERY PROCESSING USING A PRUNING INDEX 有权

    公开(公告)号：US20210200772A1

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

    申请号：US17161115

    申请日：2021-01-28

    Applicant: Snowflake Inc.

    Inventor： Thierry Cruanes ,  Benoit Dageville ,  Ismail Oukid ,  Stefan Richter

    IPC: G06F16/2455 ,  G06F16/28 ,  G06F16/22 ,  G06F16/9035 ,  G06F17/18

    Abstract: A source table organized into a set of micro-partitions is accessed by a network-based data warehouse. A pruning index is generated based on the source table. The pruning index comprises a set of filters that indicate locations of distinct values in each column of the source table. A query directed at the source table is received at the network-based data warehouse. The query is processed using the pruning index. The processing of the query comprises pruning the set of micro-partitions of the source table to scan for data matching the query, the pruning of the plurality of micro-partitions comprising identifying, using the pruning index, a sub-set of micro-partitions to scan for the data matching the query.

    Data sharing using alias objects
    437.
    发明授权
    Data sharing using alias objects 有权

    公开(公告)号：US11048814B2

    公开(公告)日：2021-06-29

    申请号：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.

    Receiving access rights to objects
    439.
    发明授权
    Receiving access rights to objects 有权

    公开(公告)号：US11036879B2

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

    申请号：US17005163

    申请日：2020-08-27

    Applicant: SNOWFLAKE INC.

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

    IPC: G06F21/62 ,  G06F21/60 ,  G06F16/25 ,  G06F21/54

    Abstract: A method for sharing data in a multi-tenant database includes receiving, by a target account of a multiple tenant database, access rights of a share object in a first account of the multiple tenant database, wherein the share object having access rights to a database object of the first account and wherein access to the database object of the first account by the target account is based on the access rights of the share object. The method also includes receiving, by one or more processors of the target account, access rights to an alias object, wherein the alias object references the database object of the first account.

Patent Agency Ranking