中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

610 records (took 0.029 seconds)

    DATA PRUNING BASED ON METADATA
    342.
    发明申请
    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.

    Multi-cluster warehouse
    345.
    发明授权
    Multi-cluster warehouse 有权

    公开(公告)号：US12267390B2

    公开(公告)日：2025-04-01

    申请号：US18617083

    申请日：2024-03-26

    Applicant: Snowflake Inc.

    Inventor： Thierry Cruanes ,  Benoit Dageville ,  Florian Andreas Funke ,  Peter Povinec

    IPC: H04L67/1097 ,  G06F9/50 ,  G06F16/2455 ,  G06F16/28 ,  H04L41/0896 ,  H04L41/5025 ,  H04L43/0817 ,  H04L67/1008

    Abstract: A method implementing a fault-tolerant data warehouse including allocating a plurality of processing units to a data warehouse, the processing units located in different availability zones, an availability zone comprising one or more data centers. The method further includes, as a result of monitoring a number of queries running at an input degree of parallelism on the plurality of processing units of the data warehouse, determining that the number of queries is serviceable by one fewer processing units. The method further includes routing a query from a first processing unit to a second processing unit within the data warehouse, the query having a common session identifier with another query previously provided to the second processing unit, the second processing unit determined to be caching a data segment associated with a cloud storage resource, usable by the query, and removing the first processing unit from the data warehouse.

    Active invalidation of metadata cache entries
    346.
    发明授权
    Active invalidation of metadata cache entries 有权

    公开(公告)号：US12210527B2

    公开(公告)日：2025-01-28

    申请号：US18128152

    申请日：2023-03-29

    Applicant: Snowflake Inc.

    Inventor： Benoit Dageville ,  Lyuping Du ,  Martin Hentschel ,  Elkhan Mammedov ,  Lukas Moll ,  Vikram Wakade

    IPC: G06F7/00 ,  G06F16/23 ,  G06F16/2455 ,  G06F17/00

    Abstract: Techniques for active invalidation of cache entries are described. A first timestamp and a second timestamp are stored by a compute instance, the first timestamp corresponding to an initial time the computing instance read from a version update log in a database and the second timestamp corresponding to a last time the computing instance read from the version update log in the database. The compute instance can read records from the version update log that are associated with version timestamps greater than the second timestamp. The compute instance can invalidate a first set of cache entries with older versions stored in a cache based on reading the records, retaining a second set of cache entries, and then execute a query using the second set of cache entries.

    Serialization of data in a concurrent transaction processing distributed database
    347.
    发明授权
    Serialization of data in a concurrent transaction processing distributed database 有权

    公开(公告)号：US12189614B2

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

    申请号：US18477834

    申请日：2023-09-29

    Applicant: Snowflake Inc.

    Inventor： Khaled Yagoub ,  Wumengjian Zhu ,  Benoit Dageville ,  William Waddington

    IPC: G06F16/00 ,  G06F11/14 ,  G06F16/22 ,  G06F16/23 ,  G06F16/28

    Abstract: The subject technology serializes, by at least one hardware processor, non-primary key data of column-organized data into compressed serialized value data that is in a row-organized sequence, the compressed serialized value data compressed using at least one bitmap, the non-primary key data comprising a schema identifier, the column-organized data being stored in a columnar database system, the column-organized data comprising primary key data and the non-primary key data. The subject technology stores the compressed serialized value data in a key-value data store of a key-value database system, the key-value database system processing key-value data in a key-value format. The subject technology receives a query by the columnar database system. The subject technology deserializes a portion of the compressed serialized value data that corresponds to the query. The subject technology processes the query using the columnar database system.

    FRAMEWORK TO REQUEST AND GRANT ACCESS TO PROTECTED RESOURCES
    348.
    发明申请
    FRAMEWORK TO REQUEST AND GRANT ACCESS TO PROTECTED RESOURCES 有权

    公开(公告)号：US20240419817A1

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

    申请号：US18478539

    申请日：2023-09-29

    Applicant: Snowflake Inc.

    Inventor： Karol Pawel Bienkowski ,  Benoit Dageville ,  Scott C. Gray ,  Unmesh Jagtap ,  Anton Yafremau ,  Alan Jinsoo Yu

    IPC: G06F21/60 ,  G06F9/451

    Abstract: A data platform grants privileges to applications accessing resources of the data platform in a secure and efficient way. The data platform determines whether a privilege has been granted to an application and, if not, generates a validation of the request to grant the privilege using a manifest of the application. The data platform generates a grant privilege request user interface, presents the grant privilege user interface to a consumer of the data platform, receives a privilege grant authorization from the consumer, and grants the privilege to the application. The granted privilege is then used by the application to access the resource.

Patent Agency Ranking