中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

50 records (took 0.017 seconds)

    Generating data structures for storing database metadata
    43.
    发明授权
    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.

    Storing database metadata in multiple levels
    44.
    发明授权
    Storing database metadata in multiple levels 有权

    公开(公告)号：US10997212B2

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

    申请号：US17062859

    申请日：2020-10-05

    Applicant: Snowflake Inc.

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

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

    Abstract: The subject technology stores database data in a table, the table comprising a plurality of micro-partitions each having rows and columns. The subject technology stores metadata for the table in a data structure, the metadata comprising a first level of the data structure comprising a column expression property comprising information about data stored in a column of a micro-partition of the table, a micro-partition expression property comprising information about data stored in the micro-partition of the table, and a second level of the data structure comprising a grouping expression property comprising information about data stored in the micro-partition and one or more additional micro-partitions of the table.

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

    公开(公告)号：US10977278B2

    公开(公告)日：2021-04-13

    申请号：US16283431

    申请日：2019-02-22

    Applicant: Snowflake Inc.

    Inventor： Ashish Motivala ,  Yi Fang ,  Martin Hentschel ,  Benoit Dageville ,  Spyros Triantafyllis ,  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 constituting 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.

    Multi-Level Metadata in Database Systems
    47.
    发明申请
    Multi-Level Metadata in Database Systems 审中-公开

    公开(公告)号：US20200272637A1

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

    申请号：US16283431

    申请日：2019-02-22

    Applicant: Snowflake Inc.

    Inventor： Ashish Motivala ,  Yi Fang ,  Martin Hentschel ,  Benoit Dageville ,  Spyros Triantafyllis ,  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 constituting 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.

Patent Agency Ranking