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
Partnership synerleap
Accelerating Growth with ABB’s SynerLeap

akenza has been accepted into ABB's SynerLeap innovation growth hub under the recommendation of Microsoft. Thanks to our participation in the program, we expect to create new synergies between the different partners of SynerLeap, namely innovative startups and various ABB divisions.

Read the post
Akenza blogpost preview product 0422
Product Update - April 2022

Over the last 12 months, akenza constantly evolved. With this release we introduce a new navigation that makes your life easier in daily use and allows us to add many new features in the future. In addition to that, this release includes a Device Data Generator as well as an Onboarding Assistant that guides you through the first steps in akenza.

Read the post
Product update preview
Product Update - February 2022

Insightful overview metrics and Yanzi as new hardware partner onboarded to the akenza ecosystem! As you can see, we have started the new year with many exciting features available to you. Read more on this product update.

Read the post