Update techniques for materialized views generated from tables shared from external databases

    公开(公告)号:US12210524B1

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

    申请号:US18067498

    申请日:2022-12-16

    Abstract: A materialized view created from one or more shared producer tables in separate producer clusters may be stored in a consumer cluster. The materialized view May undergo faster a refresh using an incremental refresh by obtaining snapshots of the producer table and incrementally refreshing based on deltas obtained by the snapshot. The materialized view may undergo various checks to determine whether the materialized view in the consumer resource is refreshable or unrefreshable based on schema compatibility. The materialized view may undergo further checks to determine whether the materialized view in the consumer resource is available or unavailable for incremental refresh based on detection of schema/data rearrangement operations on the producer table.

    Resource usage restrictions in a time-series database

    公开(公告)号:US11513854B1

    公开(公告)日:2022-11-29

    申请号:US16453914

    申请日:2019-06-26

    Abstract: Methods, systems, and computer-readable media for resource usage restrictions in a time-series database are disclosed. Elements of a plurality of time series are stored into one or more storage tiers of a time-series database. The time series are associated with a plurality of clients of the time-series database. Execution of tasks is initiated using one or more resources of one or more hosts. The time-series elements represent inputs to the tasks. The tasks comprise a first task and a second task. A usage of the one or more resources by the first task is determined to violate one or more resource usage restrictions. Based at least in part on the usage, one or more actions are performed to modify the execution of the first task. The one or more actions increase an amount of the one or more resources available to the second task.

Patent Agency Ranking