InfluxDB: Time Series Data Analysis Made Simple

Published on by Marco Mantoan

When it comes to data analysis, there are several aspects you have to consider to create a high-performance solution. Most importantly, you need to avoid working on your Production Database because:

  • An application-oriented database is built and optimized for transaction processing, but data analysis is entirely another job.

  • Data analysis requires complex queries with a vast number of tuples involved, affecting your application’s performance.

  • An abstraction layer to consolidate raw data is needed to avoid using complex queries.

The process responsible for bringing the data from the sources that run your business into an analysis tool is commonly known as ETL: Extract Transform Load.

In a standard configuration, ETL requires different stages and, most likely, different systems to transform your database from transactional into time-series.

Transactional Database Vs Time-series Database

A transactional database is commonly used to manage, well, transactions. It is the most common type of database and it is optimized to enable data updates to modify the content of its tables and manage relationships between them.

Transactional Database 1

In a transactional database, tables are linked by relations. Therefore, every transaction can affect one or more tables simultaneously.

Transactional Database 2

On the other hand, time-series databases are built for time-series analysis. This implies that once the data is written into a table, it will not be changed anymore. In a typical IoT use-case, opening a table will display a list of identical tuples where the only data that changes are the time and the value you are measuring.

time-series database

Dashboard Vs Analysis

In a standard IoT use case, you will have two choices once you have all your data available:

  • Visualize data on a Dashboard

  • Gain insights from the data through Data Analysis

Most of the time, a dashboard where you can visualize the current status of your system may be enough. It allows you to get an immediate feeling about the current situation and react to changes if needed.

The combination of akenza and InfluxDB makes it easy to build up such a visualization dashboard. With the connectivity and device management of akenza and its built-in output connector to InfluxDB, you can get started in no time; check out our step-by-step tutorial on the topic.

InfluxDB visualization dashboard

But if you want to manipulate your data and generate the real business value by defining KPIs, aggregations, etc., here is where InfluxDB makes the difference.

The process of data mining is integrated into InfluxDB thanks to Flux: a standalone data scripting and query language that increases productivity and code reuse.

With Flux, you can perform the entire ETL process into InfluxDB with all the advantages of an integrated architecture that scales with your needs.

Flux example

IoT is all about data: data-driven processes and decision-making should be the final goal of every IoT project. The integration of akenza and InfluxDB makes these kinds of solutions feasible and cost-effective, generating a positive ROI for your business.

Take the chance to try it by yourself by subscribing to a 30-day free trial here, and profit from a free account on InfluxDB here. Making your POC running couldn't be easier, faster and cheaper.

Recent blog posts
Blogpost preview image cibicom
Pushing the adoption of smart solutions in Denmark

akenza and Cibicom have joined forces to provide the perfect technological foundation for all IoT innovators in Denmark, composed of the LoRaWAN infrastructure of Cibicom and the IoT platform of akenza.

Read the post
Blogpost preview image security v2
The challenges of IoT security

Discover in this article the most common IoT security challenges and possible solutions to take into account for each new IoT venture.

Read the post
Blogpost preview image 1
Smart building cases powered by Phoenix Contact and akenza

This article describes the Smart Building case from Phoenix Contact Schweiz AG in collaboration with Akenza AG and presents the implemented use cases such as CO2- and car park monitoring, and demonstrates the ease of use of LPWAN sensor technologies in smart buildings.

Read the post