Amazon Timestream Specialized2018年〜
A serverless database purpose-built for storing and querying time series data
What It Does
Amazon Timestream is a serverless database for efficiently storing and querying time series data such as IoT sensor data, application metrics, and operational logs. It automatically tiers data between a memory store (recent data) and a magnetic store (historical data) to optimize costs. A SQL-compatible query language provides time series functions (moving averages, interpolation, etc.).
Use Cases
Storing IoT device sensor data, analyzing application performance metrics, managing DevOps monitoring data, and analyzing industrial equipment operational data.
Everyday Analogy
Think of a self-organizing diary. Recent entries (memory store) stay on your desk for quick access, while older entries (magnetic store) are automatically moved to the bookshelf. Both can be searched the same way (SQL).
What Is Timestream?
Amazon Timestream is a serverless database purpose-built for time series data. When handling time series data in a relational database, query performance tends to degrade as data volume grows. Timestream has a storage engine optimized for time series data storage and queries, delivering fast queries even on massive time series datasets.
Data Tiering and Time Series Functions
Timestream manages data in two tiers: memory store and magnetic store. Set retention periods and older data automatically moves from memory to magnetic store, reducing storage costs. The query language is SQL-compatible with built-in time series functions (moving averages, interpolation, differences, cumulative sums, etc.). Grafana integration makes dashboard creation straightforward. For practical know-how on data tiering and time series functions, related books on Amazon are a helpful resource.
Getting Started
Create a database and table in the Timestream console, setting retention periods for memory and magnetic stores. Write data using the AWS SDK or Timestream Write API, and query using the Timestream Query API or SQL. Build dashboards with the Grafana plugin.
Things to Watch Out For
- Pay-per-use based on write volume, storage volume, and query scan volume. Watch costs for full-scan queries on large datasets
- Timestream for InfluxDB is also available if you need InfluxDB-compatible APIs
