中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

41 records (took 0.021 seconds)

    PROJECTION CONSTRAINT POLICIES IN A DATABASE SYSTEM
    11.
    发明公开
    PROJECTION CONSTRAINT POLICIES IN A DATABASE SYSTEM 审中-公开

    公开(公告)号：US20240176822A1

    公开(公告)日：2024-05-30

    申请号：US18428694

    申请日：2024-01-31

    Applicant: Snowflake Inc.

    Inventor： Khalid Zaman Bijon ,  Thierry Cruanes ,  Simon Holm Jensen ,  Allison Waingold Lee ,  Daniel N. Meredith ,  Subramanian Muralidhar ,  David Schultz ,  Zixi Zhang

    IPC: G06F16/903

    CPC classification number: G06F16/90335

    Abstract: A database system facilitates secure data sharing by implementing projection constraints within a query processing framework. Upon receiving a query directed to a shared dataset, the system, utilizing hardware processors, identifies a subset of data within the dataset that is subject to a projection constraint policy. The applicability of the projection constraint is determined based on the context of the query, which is derived from a data sharing agreement. The system processes the query by selectively restricting the projection of data values from constrained columns, while allowing specific operations to be performed on the data. The output generated in response to the query is compliant with the projection constraint policy, providing derived data based on the allowed operations without revealing the actual data values. This ensures the confidentiality of sensitive information while enabling collaborative data analysis and sharing among various users of the database system.

    AUTOMATED QUERY RETRY IN A DATABASE SYSTEM
    12.
    发明申请
    AUTOMATED QUERY RETRY IN A DATABASE SYSTEM 有权

    公开(公告)号：US20220269573A1

    公开(公告)日：2022-08-25

    申请号：US17663253

    申请日：2022-05-13

    Applicant: Snowflake Inc.

    Inventor： Benoit Dageville ,  Johan Harjono ,  Simon Holm Jensen ,  Kunal Prafulla Nabar ,  Steven James Pelley

    IPC: G06F11/30 ,  G06F16/2458 ,  G06F11/34 ,  G06F16/242

    Abstract: Techniques for automated query retry in a database platform include assigning by at least one hardware processor a first execution of a query directed to database data to a first execution node of a plurality of execution nodes of an execution platform. The first execution node uses a first set of configurations during the first execution. The techniques further include determining that the first execution of the query by the first execution node results in a failed execution. The query is transferred to a second execution node of the plurality of execution nodes. A second execution of the query at the second execution node is caused. The second execution node uses a second set of configurations during the second execution. A cause of the failed execution at the first execution node is determined based on a result of the second execution of the query at the second execution node.

    Decoupling internal and external tasks in a database environment
    13.
    发明授权
    Decoupling internal and external tasks in a database environment 有权

    公开(公告)号：US11372740B2

    公开(公告)日：2022-06-28

    申请号：US17007589

    申请日：2020-08-31

    Applicant: Snowflake Inc.

    Inventor： Benoit Dageville ,  Johan Harjono ,  Simon Holm Jensen ,  Kunal Prafulla Nabar ,  Steven James Pelley

    IPC: G06F11/30 ,  G06F16/2458 ,  G06F11/34 ,  G06F16/242

    Abstract: Systems, methods, and devices for retrying a query. A method includes receiving, by a first database query manager, a query directed to database data from a client account. The method includes assigning an original execution of the query to one or more execution nodes of an execution platform. The method includes determining the original execution of the query was unsuccessful. The method includes transferring the query to a second database query manager configured to manage internal tasks for improving operation of a database platform that are not received from client accounts. The method includes assigning, by the second database query manager, a retry execution of the query to one or more execution nodes of an execution platform.

    PERFORMING GEOSPATIAL-FUNCTION JOINS USING INTERVAL JOINS
    14.
    发明申请
    PERFORMING GEOSPATIAL-FUNCTION JOINS USING INTERVAL JOINS 有权

    公开(公告)号：US20210374140A1

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

    申请号：US17389804

    申请日：2021-07-30

    Applicant: Snowflake Inc.

    Inventor： Matthias Carl Adams ,  Simon Holm Jensen ,  Spyridon Triantafyllis

    IPC: G06F16/2453

    Abstract: In an embodiment, a database platform receives query instructions for a query on a database, where the query instructions include instructions for a geospatial-function join that includes a geospatial-function predicate. The database platform generates a query-execution plan based on the query instructions, including replacing the geospatial-function join with one or more interval joins that each include one or more predicates implied by the geospatial-function predicate. The database platform inserts, into the query-execution plan above the one or more interval joins, a filter operator that applies the geospatial-function predicate. The database platform obtains results of the query at least in part by executing the query-execution plan, and returns the query results in response to the query.

    PROJECTION CONSTRAINTS IN A QUERY PROCESSING SYSTEM
    20.
    发明公开
    PROJECTION CONSTRAINTS IN A QUERY PROCESSING SYSTEM 审中-公开

    公开(公告)号：US20230401260A1

    公开(公告)日：2023-12-14

    申请号：US17934814

    申请日：2022-09-23

    Applicant: Snowflake Inc.

    Inventor： Khalid Zaman Bijon ,  Thierry Cruanes ,  Simon Holm Jensen ,  Allison Waingold Lee ,  Daniel N. Meredith ,  Subramanian Muralidhar ,  David Schultz ,  Zixi Zhang

    IPC: G06F16/903

    CPC classification number: G06F16/90335

    Abstract: A constraint system enforces projection constraints on data values stored in specified columns of a shared dataset when queries are received by a database system. A projection constraint identifies that the data in a column may be restricted from being projected (e.g., presented, read, outputted) in an output to a received query, while allowing specified operations to be performed on the data and a corresponding output to be provided. For example, the projection constraint may indicate a context for a query that triggers the constraint, such as based on the user that submitted the query. Enforcing projection constraints on queries received at the database system allows for data to be shared and used anonymously by entities to perform various operations without the need to tokenize the data.

Patent Agency Ranking