1-2 What is a Time Series Database?
Back in 2019, we posted a blog about the more academic natures of Time Series data. In this new and updated blog, we're offering a more practical introduction of the what, why, who, and how of Time Series databases and the data that is stored within them.Looking at above the Google Trends Chart, one can surmise that advancements in data storage systems and the big data revolution in recent years have reignited interest in Time Series databases.
What is Time Series data?
Time series data is a series of values where the time information (timestamp) corresponds to data recorded or an event that happened at that point in time. The data can have both regular and fluctuating intervals. For example, temperature recordings would be recorded at a set time, every minute or hour, while a stock price would be recorded every time a trade is completed.
Time Series data is usually a log or "append-only", records are rarely updated except upon deletion when they expire. You wouldn't update values in your web server logs and the same holds true for most Time Series data collections.
Depending on the latency required, individual records can be inserted one at a time but are often inserted in bulk. Messaging systems such as Kafka can queue individual records to be inserted in bulk or client applications can be cache configured to insert once a certain period.
What are Time Series Databases?
Simply put, a Time Series database is a database that specializes storing and querying time series data. While it's possible to store and query in other relational and NoSQL databases, a Time Series database will have specialized time-related functions such as:
What Applications Use Time Series Data?
It can be argued that nearly all data could be Time Series data. For example, you may only care about the current price of a product you wish to buy, but it could also be useful to see historical prices for that product to decide if it's worth waiting for it to go on sale. Thus product information which would typically be stored in a document oriented database is at least partially suitable for storage in a Time Series database.
Internet of Things
The Internet of Things (IoT) may be the most talked about user of Time Series data with millions of devices recording sensor data. Typical examples include temperature or producing environmental events such as doors locking and unlocking. With the vast quantity of data being recorded, it's imperative to use a Time Series database to efficiently store, process, and analyze the incoming data. GridDB's Key-Container data model works especially well for IoT workloads, where Time Series data for each device is stored in an individual container.
A ledger might be the original Time Series database, tracking credits, debits, and balances over time. Receipts or sale histories all have metrics Stock trades also fit the Time Series data model well with both the most recent value and all previous trade prices and volume all having significance.
Application MonitoringServer logs are one of the simplest, most obvious examples of Time Series data but there are many different types of application monitoring is used. Telemetry uploaded by a mobile application can be stored in a Time Series database so developers can examine usage patterns to improve their application. Server metrics can be monitored to see peak and trough usage allowing system administers to not only better plan capacity, but also look for anomalies.
How is Time Series Data Used?We've talked about why you need a Time Series database and what Time Series data is used for...
Examples of Time Series Applications
We hope we have successfully convinced you that Time Series data is more important and prominent than you may have originally imagined. Please consider the following: the entire emerging industry of IoT is entirely reliant on Time Series data. So whether you are building a vehicle management system, or planning out a next-generation smart city, Time Series data and and the management of this data will likely be a key component in ensuring everything runs properly and efficiently.
To build on that, modern logging/analytics applications have also grown increasingly complex and data-hungry. Grafana, for example, is excellent and built on top of a foundation of Time Series Database. Check out our project page to see how GridDB works well with Grafana. Get started with GridDB now and see how easy it is to Go Faster with your application and Grow BIGGER with your ever-increasing time series data.