中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

50 records (took 0.02 seconds)

    Storing multi-level metadata in database systems
    31.
    发明授权
    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.

    Multi-level metadata in database systems
    32.
    发明授权
    Multi-level metadata in database systems 有权

    公开(公告)号：US10810232B2

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

    申请号：US16775092

    申请日：2020-01-28

    Applicant: Snowflake Inc.

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

    IPC: G06F16/27 ,  G06F16/245 ,  G06F16/22

    Abstract: Systems, methods, and devices for multiple level metadata organization in database systems. A system includes a plurality of shared storage devices collectively storing database data across a plurality of tables that each comprise one or more micro-partitions including immutable storage devices. The system includes a resource manager configured to manage the storage of database data stored in a table across one or more of the plurality of shared storage devices. The resource manager is configured to manage the storage of metadata for the table. The metadata includes a column expression property with information about data stored in a column, a micro-partition expression property with information about data stored in a micro-partition, a grouping expression property with information about data stored in two or more micro-partitions, and cumulative table metadata with global information about all micro-partitions of the table.

    DATA PRUNING BASED ON METADATA
    33.
    发明申请
    DATA PRUNING BASED ON METADATA 审中-公开

    公开(公告)号：US20200089655A1

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

    申请号：US16688888

    申请日：2019-11-19

    Applicant: Snowflake Inc.

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

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

    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.

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

    公开(公告)号：US11294861B2

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

    申请号：US17141165

    申请日：2021-01-04

    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 that includes a plurality of predicates and identifying one or more applicable files including 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.

Patent Agency Ranking