A Software Cache Mechanism for Reducing the OpenTSDB Query Time

As the volume of Internet of Things (IoT) data grows rapidly, a time series database is a major part of the system that helps in storing and retrieving the massive data for analysis and monitoring. Accord-ing to the user behaviors, the data queries often are similar or overlapped to the previous queries, especially when the user adjusts the query parameters on the same time series data for displaying on a visualization tool. Caching the previous data will help reduce the query response time, in case that the current query range is overlapping with the previous query ranges. This paper proposes a cache mechanism for an open source time series database, OpenTSDB. Exploiting our cache mechanism, the query response time can be 3-16 times faster than the original OpenTSDB depending on the user query behaviors and related parameters.