Scalable database system for querying time-series data

    公开(公告)号:US10073903B1

    公开(公告)日:2018-09-11

    申请号:US15907105

    申请日:2018-02-27

    申请人: Timescale, Inc.

    IPC分类号: G06F17/30

    摘要: A database system stores data as hypertables that represent partitioned database tables. Each hypertable comprises chunks of data that may be distributed across multiple locations, each location comprising at least a storage device. The database system provides an interface that allows database queries seamlessly to hypertables as well as standard tables. The database system dynamically creates chunks as records are added to a hypertable. The database system defines a new partitioning strategy if the storage configuration of the database system is changed by adding new locations or removing existing locations. The records added to the hypertable before the storage configuration was changed continue to be stored as chunks distributed according to the previous partitioning policy.

    Adjusting partitioning policies of a database system in view of storage reconfiguration

    公开(公告)号:US10073888B1

    公开(公告)日:2018-09-11

    申请号:US15907114

    申请日:2018-02-27

    申请人: Timescale, Inc.

    IPC分类号: G06F17/30

    摘要: A database system stores data as hypertables that represent partitioned database tables. Each hypertable comprises chunks of data that may be distributed across multiple locations, each location comprising at least a storage device. The database system provides an interface that allows database queries seamlessly to hypertables as well as standard tables. The database system dynamically creates chunks as records are added to a hypertable. The database system defines a new partitioning strategy if the storage configuration of the database system is changed by adding new locations or removing existing locations. The records added to the hypertable before the storage configuration was changed continue to be stored as chunks distributed according to the previous partitioning policy.

    Policy-driven data manipulation in time-series database systems

    公开(公告)号:US10509785B2

    公开(公告)日:2019-12-17

    申请号:US16109644

    申请日:2018-08-22

    申请人: Timescale, Inc.

    摘要: A database system stores data as hypertables that represent partitioned database tables. Each hypertable comprises chunks of data that may be distributed across multiple locations, each location comprising at least a storage device. The database system provides an interface that allows database queries seamlessly to hypertables as well as standard tables. The database system dynamically creates chunks as records are added to a hypertable. The database system defines a new partitioning strategy if the storage configuration of the database system is changed by adding new locations or removing existing locations. The records added to the hypertable before the storage configuration was changed continue to be stored as chunks distributed according to the previous partitioning policy.

    SCALABLE DATABASE SYSTEM FOR QUERYING TIME-SERIES DATA

    公开(公告)号:US20190188204A1

    公开(公告)日:2019-06-20

    申请号:US16109644

    申请日:2018-08-22

    申请人: Timescale, Inc.

    摘要: A database system stores data as hypertables that represent partitioned database tables. Each hypertable comprises chunks of data that may be distributed across multiple locations, each location comprising at least a storage device. The database system provides an interface that allows database queries seamlessly to hypertables as well as standard tables. The database system dynamically creates chunks as records are added to a hypertable. The database system defines a new partitioning strategy if the storage configuration of the database system is changed by adding new locations or removing existing locations. The records added to the hypertable before the storage configuration was changed continue to be stored as chunks distributed according to the previous partitioning policy.