中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

193 records (took 0.017 seconds)

    Establishing data objects to facilitate calls to external functions
    61.
    发明授权
    Establishing data objects to facilitate calls to external functions 有权

    公开(公告)号：US10997005B1

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

    申请号：US17028466

    申请日：2020-09-22

    Applicant: Snowflake Inc.

    Inventor： Istvan Cseri ,  Isaac Kunen ,  Igor Zinkovsky

    IPC: G06F9/44 ,  G06F9/54 ,  G06F16/242 ,  H04L29/06 ,  H04L29/08

    Abstract: A query referencing a function associated with a remote software component is received by a network-based data warehouse system. Temporary security credentials corresponding to a role at a cloud computing service platform are obtained. The role has permission to send calls to a web endpoint corresponding to the remote software component. A request comprising input data and electronically signed using the temporary security credentials is sent to a web Application Programming Interface (API) management system of the cloud computing service platform. The request, when received by the web API management system, causes the web API management system to invoke external functionality provided by the remote software component at the web endpoint with respect to the input data. A response comprising a result of invoking the external functionality is received from the web API management system, and the result data is processed according to the query.

    ESTABLISHING DATA OBJECTS TO FACILITATE CALLS TO EXTERNAL FUNCTIONS
    62.
    发明申请
    ESTABLISHING DATA OBJECTS TO FACILITATE CALLS TO EXTERNAL FUNCTIONS 有权

    公开(公告)号：US20210124633A1

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

    申请号：US17028466

    申请日：2020-09-22

    Applicant: Snowflake Inc.

    Inventor： Istvan Cseri ,  Isaac Kunen ,  Igor Zinkovsky

    IPC: G06F9/54 ,  G06F16/242 ,  H04L29/06 ,  H04L29/08

    Abstract: A query referencing a function associated with a remote software component is received by a network-based data warehouse system. Temporary security credentials corresponding to a role at a cloud computing service platform are obtained. The role has permission to send calls to a web endpoint corresponding to the remote software component. A request comprising input data and electronically signed using the temporary security credentials is sent to a web Application Programming Interface (API) management system of the cloud computing service platform. The request, when received by the web API management system, causes the web API management system to invoke external functionality provided by the remote software component at the web endpoint with respect to the input data. A response comprising a result of invoking the external functionality is received from the web API management system, and the result data is processed according to the query.

    Tracking intermediate changes in database data
    63.
    发明授权
    Tracking intermediate changes in database data 有权

    公开(公告)号：US10977244B2

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

    申请号：US16182216

    申请日：2018-11-06

    Applicant: Snowflake Inc.

    Inventor： Torsten Grabs ,  Istvan Cseri ,  Benoit Dageville

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

    Abstract: Systems, methods, and devices for tracking a series of changes to database data are disclosed. A method includes executing a transaction to modify data in a micro-partition of a table of a database by generating a new micro-partition that embodies the transaction. The method includes associating transaction data with the new micro-partition, wherein the transaction data comprises a timestamp when the transaction was fully executed, and further includes associating modification data with the new micro-partition that comprises an indication of one or more rows of the table that were modified by the transaction. The method includes joining the transaction data with the modification data to generate joined data and querying the joined data to determine a listing of intermediate modifications made to the table between a first timestamp and a second timestamp.

    Automated Maintenance of External Tables in Database Systems
    64.
    发明申请
    Automated Maintenance of External Tables in Database Systems 审中-公开

    公开(公告)号：US20200334240A1

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

    申请号：US16385837

    申请日：2019-04-16

    Applicant: Snowflake Inc.

    Inventor： Subramanian Muralidhar ,  Benoit Dageville ,  Thierry Cruanes ,  Nileema Shingte ,  Saurin Shah ,  Torsten Grabs ,  Istvan Cseri

    IPC: G06F16/242 ,  G06F16/23 ,  G06F3/06 ,  G06F16/25 ,  G06F16/16 ,  G06F16/22 ,  G06F9/54

    Abstract: Systems, methods, and devices for automated maintenance of external tables in database systems are disclosed. A method includes receiving, by a database platform, read access to content in an external data storage platform that is separate from the database platform. The method includes defining an external table based on the content in the external data storage platform. The method includes connecting the database platform to the external table such that the database platform has read access for the external table and does not have write access for the external table. The method includes generating metadata for the external table, the metadata comprising information about data stored in the external table. The method includes receiving a notification that a modification has been made to the content in the external data storage platform, the modification comprising one or more of an addition of a file, a deletion of a file, or an update to a file in a source location for the external table. The method includes refreshing the metadata for the external table in response to the modification being made to the content in the external data storage platform.

    TRANSACTIONAL STREAMING OF CHANGE TRACKING DATA
    65.
    发明申请
    TRANSACTIONAL STREAMING OF CHANGE TRACKING DATA 审中-公开

    公开(公告)号：US20200183909A1

    公开(公告)日：2020-06-11

    申请号：US16705566

    申请日：2019-12-06

    Applicant: Snowflake Inc.

    Inventor： Subramanian Muralidhar ,  Istvan Cseri ,  Torsten Grabs ,  Benoit Dageville

    IPC: G06F16/23 ,  G06F16/27 ,  G06F16/18 ,  G06F16/245

    Abstract: Systems, methods, and devices for generating a transactional change tracking summary for a database. A method includes executing a transaction on a table of a database, wherein the table includes a micro-partition and the transaction is executed on the micro-partition. The method includes, in response to the transaction being fully executed, generating a change tracking entry comprising an indication of one or modifications made to the table by the transaction. The method includes storing the change tracking entry in a change tracking stream, wherein the change tracking stream includes one or more sequential change tracking entries that each correspond to a different transaction that is fully executed on the table

    TASK EXECUTION USING A STREAM OF COMMITTED TRANSACTIONS
    68.
    发明申请
    TASK EXECUTION USING A STREAM OF COMMITTED TRANSACTIONS 有权

    公开(公告)号：US20250045274A1

    公开(公告)日：2025-02-06

    申请号：US18920733

    申请日：2024-10-18

    Applicant: Snowflake Inc.

    Inventor： Istvan Cseri ,  Torsten Grabs ,  Benoit Dageville

    IPC: G06F16/23 ,  G06F9/46

    Abstract: A method includes ingesting, by at least one hardware processor, database data within a staging table of a database. The method further includes generating a task based on at least one data processing statement received from a user account. The method further includes executing the task on the database data in the staging table to generate modified data. The method further includes, in response to the task being fully executed on the database data, storing the modified data in a target table. In some aspects, the target table is configured within the database. The method further includes generating a stream of one or more transactions committed during the execution of the task to generate the modified data.

Patent Agency Ranking