Usage monitoring and usage based data pricing

    公开(公告)号:US11869051B2

    公开(公告)日:2024-01-09

    申请号:US17710598

    申请日:2022-03-31

    Applicant: Snowflake Inc.

    CPC classification number: G06Q30/04 G06F9/547 G06F16/256 G06Q20/145

    Abstract: Embodiments of the present disclosure describe techniques for monitoring usage of data listings and pricing data listings based thereon. Metadata comprising a pricing plan may be added to a data listing to generate a monetized data listing. The monetized data listing may be imported to the consumer account. The usage data of the monetized data listing and listing data of the monetized data listing may be exported to a data warehousing and analysis module. A usage level for a set of jobs processed using the monetized data listing during a current incremental interval of a current billing interval may be calculated and combined with a usage level of all previous incremental intervals of the current billing interval to generate a cumulative usage record. An invoice for the billing interval may be generated based on the cumulative usage record.

    SCHEMA EVOLUTION
    242.
    发明公开
    SCHEMA EVOLUTION 审中-公开

    公开(公告)号:US20230401180A1

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

    申请号:US18345987

    申请日:2023-06-30

    Applicant: Snowflake Inc.

    CPC classification number: G06F16/211

    Abstract: Techniques for schema mismatch detection and evolution are described. When data is being uploaded into a source table, schema of the data to be uploaded can be compared with the schema for the source table. If a schema mismatch is detected, the schema of the source table can be modified, and the upload can be continued without data loss.

    Application versioning and upgrade
    243.
    发明授权

    公开(公告)号:US11803373B1

    公开(公告)日:2023-10-31

    申请号:US18169819

    申请日:2023-02-15

    Applicant: Snowflake Inc.

    CPC classification number: G06F8/71 G06F8/658 G06F9/4488

    Abstract: Methodologies for upgrading and patching an in-database application package and its application instances. A data platform determines a number of objects of an application instance running on the data platform at a previous version level of an application package of the application instance. In response to determining the number of objects of the application package running on the data platform at the previous version level of the application package is one or more, the data platform continues determining the number of objects running on the data platform at a previous version level of the application package. In response to determining the number of objects of the application instance running on the data platform at the previous version level of the application package is none, the data platform upgrades the application instance to the new version of the application package.

    MANAGING DATABASE FAILOVER BASED ON TRANSACTION REQUEST TIME

    公开(公告)号:US20230267131A1

    公开(公告)日:2023-08-24

    申请号:US18123108

    申请日:2023-03-17

    Applicant: Snowflake Inc.

    CPC classification number: G06F16/273 G06F16/245 H04L67/1097

    Abstract: Methods and systems of managing database failure based on transaction request time is disclosed. A method includes copying a first dataset stored in a primary deployment to a secondary deployment to generate a second dataset. The method includes determining a first arrival time of a first request to perform a first transaction. The method includes determining a second arrival time of a second request to perform a second transaction. The method includes e00000xecuting the first transaction on the first dataset at the primary deployment in response to determining the first arrival time of the first request to perform the first transaction. The method includes executing the second transaction on the second dataset at the secondary deployment in response to determining the second arrival time of the second request to perform the second transaction.

Patent Agency Ranking