Amazon Time Series Database Reaches General Availability
Written by Kay Ewbank   
Tuesday, 06 October 2020

Amazon Web Services has released Timestream, a new time series database service for IoT that is designed to make it easy to store and analyze trillions of events per day up to 1,000 times faster and at as little as 1/10th the cost of relational databases.

Timestream has been designed to give users the means to manage time series data easily, quickly and cost effectively. Amazon says that many organizations have useful data buried in industrial equipment, website clickstream logs, and many other sources, but it's too hard to get at and use. Timestream has been purpose-built to manage the scale and complexity of time series data in the cloud.

timestream

Amazon Timestream is scalable and serverless. It keeps recent data in memory and moves historical data to a cost optimized storage tier based upon user defined policies. The database has a purpose-built query engine for analyzing recent and historical data together, without needing to specify explicitly in the query whether the data resides in the in-memory or cost-optimized tier.

timescalequery

Data is automatically replicated across multiple availability zones (AZ) in the same AWS region. New data is written to the memory store, where data is replicated across three AZs. Data replication is quorum based, and data in the memory store is also continuously backed up to Amazon Simple Storage Service (S3).

Users can analyze time series data using SQL, with built-in time series functions for smoothing, approximation, and interpolation. Amazon Timestream also supports advanced aggregates, window functions, and complex data types such as arrays and rows.

Timestream will ingest data directly from AWS IoT Core, Amazon Kinesis Data Analytics for Apache Flink, and Amazon MSK, and comes with tools to use Timestream with open source platforms such as Apache Kafka, Telegraf, Prometheus, and Grafana.

timestream

More Information

Timestream website

Related Articles

RavenDB Adds Time Series Query Support

Open Source Time Series Database Released

Grafana 7 Adds New Visualizations  

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.

Banner


Django 5.2 Adds Composite Key Support
07/04/2025

Django 5.2 has been released with the addition of support for composite primary keys, and the automatic importing of all models in the shell by default.



Undefined Behavior Just Not Worth The Effort!
30/04/2025

Some very interesting research has just been published that throws a lot of light on the crazy belief that undefined behavior is useful, essential even, to certain types of optimization rather than th [ ... ]


More News

espbook

 

Comments




or email your comment to: comments@i-programmer.info