中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

51 records (took 0.025 seconds)

    Data pruning based on metadata
    11.
    发明授权
    Data pruning based on metadata 有权

    公开(公告)号：US11163724B2

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

    申请号：US16861516

    申请日：2020-04-29

    Applicant: Snowflake Inc.

    Inventor： Thierry Cruanes ,  Benoit Dageville ,  Ashish Motivala ,  Marcin Zukowski

    IPC: G06F16/00 ,  G06F16/16 ,  G06F16/22 ,  G06F16/215 ,  G06F16/9535 ,  G06F16/2453

    Abstract: A system and method for pruning data based on metadata. The method may include receiving a query comprising a plurality of predicates and identifying one or more applicable files comprising database data satisfying at least one of the plurality of predicates. The identifying the one or more applicable files including reading metadata stored in a metadata store that is separate from the database data. The method further includes pruning inapplicable files comprising database data that does not satisfy at least one of the plurality of predicates to create a reduced set of files and reading the reduced set of files to execute the query.

    STORING METADATA USING DATA STRUCTURES IN DATABASE SYSTEMS
    14.
    发明申请
    STORING METADATA USING DATA STRUCTURES IN DATABASE SYSTEMS 有权

    公开(公告)号：US20210049179A1

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

    申请号：US17086279

    申请日：2020-10-30

    Applicant: Snowflake Inc.

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

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

    Abstract: The subject technology receives first metadata corresponding to a set of micro-partitions. The subject technology stores a first data structure and a second data structure in storage as a first file and a second file, first data structure including the 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 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.

    Cloning catalog objects
    15.
    发明授权
    Cloning catalog objects 有权

    公开(公告)号：US11928129B1

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

    申请号：US18084795

    申请日：2022-12-20

    Applicant: SNOWFLAKE INC.

    Inventor： Ashish Motivala ,  Benoit Dageville

    IPC: G06F16/00 ,  G06F16/27

    CPC classification number: G06F16/27

    Abstract: Example systems and methods for cloning catalog objects are described. In one implementation, a method includes creating a second catalog object by mapping a second portion of second metadata of the second catalog object to same data of a same data file as a first portion of first metadata of a first catalog object, and, in response to a data storage or data retrieval request directed to the second catalog object, deleting data associated with the second portion of the second metadata from the second catalog object independently of the first catalog object.

    CLONING CATALOG OBJECTS
    18.
    发明申请
    CLONING CATALOG OBJECTS 有权

    公开(公告)号：US20210205120A1

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

    申请号：US17207508

    申请日：2021-03-19

    Applicant: Snowflake, Inc.

    Inventor： Ashish Motivala ,  Benoit Dageville

    IPC: A61F5/56

    Abstract: Example systems and methods for cloning catalog objects are described. In one implementation, a method identifies an original catalog object associated with data and creates a duplicate copy of the original catalog object without copying the data itself. The method allows access to the data using the duplicate catalog object and supports modifying the data associated with the original catalog object independently of the duplicate catalog object. The duplicate catalog object can be deleted upon completion of modifying the data associated with the original catalog object.

    Storing multi-level metadata in database systems
    20.
    发明授权
    Storing multi-level metadata in database systems 有权

    公开(公告)号：US10909121B2

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

    申请号：US16863831

    申请日：2020-04-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 receives first metadata corresponding to a set of micro-partitions. The subject technology generates second metadata for a grouping of the first metadata. The subject technology generates a first data structure including the first metadata and a second data structure including the second 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 persistent storage as a first file and a second file. The subject technology receives a query on a table. Further, the subject technology analyzes the query against cumulative table metadata to determine whether data stored in the table matches the query.

Patent Agency Ranking