Adaptive querying of time-series data over tiered storage

    公开(公告)号:US11461347B1

    公开(公告)日:2022-10-04

    申请号:US17349790

    申请日:2021-06-16

    摘要: Methods, systems, and computer-readable media for adaptive querying of time-series data over tiered storage are disclosed. A distributed time-series database receives a query indicating spatial and temporal boundaries of requested time-series data in a table. The time-series database stores time-series data using a plurality of storage resources, wherein a first storage tier is accessible using a first access interface and a second storage tier is accessible using a second access interface. The time-series database determines, in the plurality of storage resources, one or more storage locations corresponding to the spatial and temporal boundaries of the query. Using the first access interface, the time-series database reads one or more elements of the requested time-series data from storage locations in the first storage tier. Using the second access interface, the time-series database reads one or more additional elements of the requested time-series data from storage locations in the second storage tier.

    Rate-limiting secondary index creation for an online table

    公开(公告)号:US10102230B1

    公开(公告)日:2018-10-16

    申请号:US14859069

    申请日:2015-09-18

    摘要: A data storage system may implement rate-limiting secondary index creation for an online table. A secondary index may be generated for a table stored in a data store. The table may be incrementally indexed, maintaining the updates determined according to indexing different portions of the table in a queue of pending updates that are subsequently applied at the secondary index. Prior to indexing a portion of the table, an evaluation of a current number of pending updates in the queue of pending updates may be performed with respect to a throttle threshold. If the current number of pending updates exceeds the throttle threshold, then indexing the portion of the table may be throttled. Received updates to previously indexed portions of the table, may be applied to the table and placed in the queue of pending updates without an evaluation of the current number of pending requests.