Time Series Database (TSDB)

TSDB is a stable, reliable, and cost-effective online high-performance time series database service.

Time Series Database (TSDB) supports high-speed data reading and writing. It offers high compression ratios for cost-efficient data storage. This service also supports visualization of precision reduction, interpolation, multi-metric aggregate computing, and query results. The TSDB service reduces storage costs and improves the efficiency of data writing, query, and analysis. This enables you to handle large amounts of data points and collect data more frequently. This service has been widely applied to systems in different industries, such as IoT monitoring systems, enterprise energy management systems (EMSs), production security monitoring systems, and power supply monitoring systems.

Benefits

High Performance
Optimizes database architectures and algorithms. TSDB can read or write millions of data points within seconds.
Cost Efficiency
Applies an efficient compression algorithm to reduce the size of each data point to 2 bytes, saving more than 90% in storage costs.
Strong Data Analysis Capability
Supports precision reduction, interpolation, and multiple aggregate functions.
Easy to Use
TSDB is easy to use. It supports generic time series protocols and allows you to monitor operations and maintenance.

Features

  • High-speed Reading and Writing of Time Series Data

    Supports high-speed data reading and writing. TSDB can write tens of millions of data points within seconds.


    High-speed Data Reading

    Reads millions of data points within seconds.


    High-speed Data Writing

    Writes tens of millions of data points within seconds.

  • Time Series Data Management

    Supports the data validity feature. TSDB allows you to customize metrics to delete expired data.


    Time Validity

    Allows you to create sliding windows to automatically delete expired data and free up storage space.


    Timeline Query with Multiple Metrics

    Supports timeline query by metric, group, time zone, and specified precision.

  • Cost-efficient Storage

    Supports high compression ratios to reduce storage costs.


    Data Compression Technology

    Reduces the size of each data point to 2 bytes.

  • Time Series Data Computing

    Supports multiple types of time series data computing.


    Interpolation

    Supports linear interpolation to create data points if any data points are missing.


    Precision Reduction

    Supports pre-precision reduction and real-time precision reduction computing for efficient query.


    Space Aggregation

    Aggregates space by tag and computes by group.


    Multiple Aggregate Functions

    Supports multiple aggregate functions, including AVG, SUM, MAX, and MIN.

  • Visualization of Time Series Data Query

    Displays query results in charts and tables.


    Visualization

    Visualizes timeline query results in the console.

  • Instance Monitoring and Maintenance

    Monitors instance usage information, including resources and capabilities of instances.


    Data Point Writing Monitoring

    Monitors data point writing and reports data writing progress in real time.


    Storage Space Monitoring

    Allows you to obtain storage space usage information at anytime so that you can scale up or free up the storage space before the storage space is exhausted.

  • Instance Security Management

    Provides instance and data security plans.


    VPCs

    Instances are isolated from the Internet and accessible only through VPCs for security.


    Instance Whitelists

    Supports whitelists to control access to instances from the internal network, improving data security.

How it works

  • IoT Device Monitoring and Diagnostics
  • Monitoring and Management of Industrial, Energy, and Chemical Industry Devices
  • Application and Business Monitoring
IoT Device Monitoring and Diagnostics

IoT Device Monitoring and Diagnostics

Supports real-time monitoring of connected IoT devices and integration of monitoring and analysis data

IoT devices connect to the cloud through Alibaba Cloud IoT service. Device data and analysis results are written into TSDB in real time for storage and computing. TSDB then outputs the time series data to the frontend monitoring system so that you can monitor and analyze IoT devices in real time.

Benefits

  • Easy Connection

    TSDB applies the OpenTSDB protocol to work with Alibaba Cloud IoT, message systems, and real-time computing systems, helping reduce costs associated with IoT device connection development.

  • High-speed Data Reading and Writing

    TSDB's high-performance time series data reading and writing enables fast reading and writing of large amounts of IoT device data.

  • Data Integration

    TSDB integrates with big data analysis systems and BI systems to achieve big data analysis.

Recommended Products and Services

Monitoring and Management of Industrial, Energy, and Chemical Industry Devices

Monitoring and Management of Industrial, Energy, and Chemical Industry Devices

Monitoring and Management of Industrial, Energy, and Chemical Industry Devices

Real-time monitoring of industrial, energy, and chemical industry devices and integration of monitoring and analysis data. Industrial devices connect to the cloud through gateway services. Device data and analysis results are written into HiTSDB in real time for storage and computing. HiTSDB outputs time series data to the frontend monitoring system. In this way, you can monitor and analyze these devices in real time.

Advantages

  • High Performance and Scalability

    TSDB supports high-speed data writing. It applies a distributed architecture that helps resolve issues of performance and scalability found in time series databases of traditional industries that use a centralized architecture.

  • Cost Efficiency

    Applies storage algorithms with a high compression ratio to help save storage costs by more than 90% and greatly lower an enterprises' initial investment.

  • Data Security

    Provides data security and backup solutions to protect industrial device data in the cloud.

Recommended Products and Services

Application and Business Monitoring

Application and Business Monitoring

Establishes a monitoring system to monitor application performance and business

Application and business performance indicators are collected through logs, messages, and other approaches, and then delivered to the computing system for real-time statistics and computing. You can then write the corresponding time series data to HiTSDB and aggregate, analyze, and display the data.

Benefits

  • Easy to Use

    Based on log collection, data analysis, storage, monitoring, and visualization, TSDB greatly reduces the costs in data storage, data analysis, and operations.

  • High Efficiency

    Allows large amounts of devices in a cluster to concurrently write data in high speed.

Recommended Products and Services

TSDB instance pricing

Time Series Database (TSDB) instance prices are calculated based on instance specifications and storage space. The formula is described as follows:
Total instance price = Price of the instance specification + Price of storage space

TSDB instances support subscription and pay-as-you-go billing methods. If you plan to use TSDB instances for a long time, we recommend that you use the subscription billing method. Compared with the pay-as-you-go billing method, the subscription billing method allows you to reduce costs by up to 60%.

Instance specifications

An instance specification is determined based on the following two elements: write TPS and the maximum number of connected data collection points.
Data collection points are the items based on which data is collected and sent to TSDB. Two examples of data collection points are the CPU usage of a server and temperature that is collected from a temperature sensor. One timeline of data is produced for each data collection point.
Write TPS indicates the maximum write rate that is supported by TSDB. The write TPS is measured by the maximum number of data points that can be written per second.

Storage space

You can store raw data that is generated by your devices for subsequent processing or analysis. We recommend that you purchase storage space based on your actual data volume. Your data volume may increase over time. If the storage space cannot meet your business needs, you can clear some data or purchase additional storage space.

Subscription

Instance specification (USD/month)
Edition Basic Edition I Basic Edition II Basic Edition III Standard Edition I Standard Edition II Flagship Edition I Flagship Edition II
Specification code tsdb.1x.basic tsdb.3x.basic tsdb.4x.basic tsdb.12x.standard tsdb.24x.standard tsdb.48x.large tsdb.96x.large
Maximum data collection points 2.4 million 4.8 million 10 million 20 million 40 million No upper limit No upper limit
Write TPS (Data points/s) 10,000 30,000 40,000 120,000 240,000 480,000 960,000
Mainland China 120.60 210.15 523.59 1045.98 1962.99 3691.05 7144.18
China (Hong Kong) 155.68 277.32 554.63 1348.51 2798.66 5226.57 10082.24
Japan (Tokyo) 174.78 301.35 602.54 1488.36 2993.44 5615.98 10861.20
India (Mumbai) 134.93 239.86 479.71 1144.63 2385.83 4452.39 8585.53
Singapore 160.00 282.69 565.38 1348.51 2798.66 5226.57 10082.24
Australia (Sydney) 164.63 294.03 588.06 1437.92 2983.89 5573.74 10753.14
Malaysia (Kuala Lumpur) 151.35 271.80 543.44 1303.89 2734.03 5098.21 9826.57
Indonesia (Jakarta) 158.96 285.68 571.20 1381.65 2891.05 5392.69 10396.12
Germany (Frankfurt) 150.75 271.20 542.39 1348.51 2798.66 5226.57 10082.24
UK (London) 141.20 244.33 488.51 1227.77 2462.24 4621.65 8940.30
UAE (Dubai) 174.18 321.95 643.89 1700.45 3528.81 6590.60 12714.18
US (Virginia) 128.96 227.47 454.93 1080.75 2239.86 4183.59 8071.35
US (Silicon Valley) 169.71 301.35 602.69 1454.48 3019.26 5639.56 10880.00
Storage space (USD/month/GB)
Mainland China China (Hong Kong) Japan (Tokyo) India (Mumbai) Singapore Australia (Sydney) Malaysia (Kuala Lumpur) Indonesia (Jakarta) Germany (Frankfurt) UK (London) UAE (Dubai) US
(Virginia)
US
(Silicon Valley)
0.1045 0.1045 0.1075 0.1015 0.1045 0.1105 0.1015 0.1045 0.1045 0.1015 0.1254 0.1045 0.1045

Pay-as-you-go

Instance specification (USD/hour)
Edition Basic Edition I Basic Edition II Basic Edition III Standard Edition I Standard Edition II Flagship Edition I Flagship Edition II
Specification code tsdb.1x.basic tsdb.3x.basic tsdb.4x.basic tsdb.12x.standard tsdb.24x.standard tsdb.48x.large tsdb.96x.large
Maximum data collection points 2.4 million 4.8 million 10 million 20 million 40 million No upper limit No upper limit
Write TPS (Data points/s) 10,000 30,000 40,000 120,000 240,000 480,000 960,000
Mainland China 0.3612 0.7239 1.4523 3.5821 5.9702 11.1941 21.7911
China (Hong Kong) 0.3165 0.5568 0.8777 2.6806 5.5135 10.3075 19.8956
Japan (Tokyo) 0.3314 0.5747 0.8956 2.8583 5.7687 10.8165 20.9135
India (Mumbai) 0.2806 0.4941 0.7821 2.3702 4.9045 9.1627 17.6777
Singapore 0.3269 0.5747 0.9075 2.7747 5.7180 10.6911 20.6389
Australia (Sydney) 0.3448 0.6195 0.9941 3.1344 6.4508 12.0598 23.2792
Malaysia (Kuala Lumpur) 0.3135 0.5568 0.8896 2.6821 5.5866 10.4284 20.1120
Indonesia (Jakarta) 0.3344 0.5986 0.9612 2.8971 6.0583 11.2986 21.7806
Germany (Frankfurt) 0.3045 0.5433 0.8702 2.7284 5.6224 10.5165 20.3015
UK (London) 0.2926 0.5075 0.7911 2.5299 5.0911 9.5493 18.4672
UAE (Dubai) 0.3642 0.6732 1.1090 3.4463 7.2254 13.4747 25.9717
US (Virginia) 0.2836 0.4986 0.7851 2.3941 4.9314 9.2209 17.8000
US (Silicon Valley) 0.3448 0.6105 0.9687 2.9926 6.1717 11.5418 22.2806
Storage space (USD/hour/GB)
Mainland China China (Hong Kong) Japan (Tokyo) India (Mumbai) Singapore Australia (Sydney) Malaysia (Kuala Lumpur) Indonesia (Jakarta) Germany (Frankfurt) UK (London) UAE (Dubai) US
(Virginia)
US
(Silicon Valley)
0.000147 0.000150 0.000150 0.000150 0.000150 0.000180 0.000150 0.000150 0.000150 0.000150 0.000180 0.000150 0.000150

Example

For example, you have 10,000 devices and each device has 16 data collection points. Data is reported every 20 seconds from each data collection point. You can calculate the write TPS and the number of timelines based on the following formulas:
Number of timelines = Number of data collection points = 10,000 × 16 = 160,000
Write TPS = 160,000 × (1/20) = 8,000 data points/s
In this case, we recommend that you purchase Basic Edition I, and purchase storage space based on your actual data volume.

Upgraded Support For You

1 on 1 Presale Consultation, 24/7 Technical Support, Faster Response, and More Tickets.

1 on 1 Presale Consultation

Consulting by experienced cloud experts.Learn More

24/7 Technical Support

Extended service time from 10 hours 5 days a week to 24/7. Learn More

6 Free Tickets per Quarter

The number of free tickets doubled from 3 to 6 per quarter. Learn More

Faster Response

Shorten after-sale response time from 36 hours to 18 hours. Learn More