The project in five facts.
Challenge, approach and results.
In the last decade, numerous time-series databases have emerged, using different technologies and approaches. The focus will be on two popular databases, namely NoSQL ** InfluxDB** and ** SQL** ** TimescaleDB**. When testing different time intervals, TimescaleDB consistently demonstrated faster response times. Nevertheless, TimescaleDB showed greater variability in response times, as evidenced by a higher standard deviation compared to InfluxDB.
Problem
In the last decade, numerous time-series databases have emerged, using different technologies and approaches. The focus will be on two popular databases, namely NoSQL ** InfluxDB** and ** SQL** ** TimescaleDB. The main objective was to understand their performance, behaviour and scalability, particularly in the context of ** Big Data.
For data writing, TimescaleDB clearly prevailed with faster response times, which is crucial for real-time applications. However, data reading was more complex. InfluxDB achieved very high response times in some cases, particularly with larger data sets, whilst being extremely efficient with smaller data sets.
Results
When testing different time intervals, TimescaleDB consistently demonstrated faster response times. Nevertheless, TimescaleDB showed greater variability in response times, as evidenced by a higher standard deviation compared to InfluxDB. Both databases showed exceptional reliability with 0% errors throughout all tests.
When examining scaling options, InfluxDB consistently achieved faster response times than TimescaleDB in all tests. At the same time, TimescaleDB showed a high error rate with a larger number of users, which is concerning. In terms of support, both databases are robust solutions with extensive support.
InfluxDB boasts an integrated ecosystem, whilst TimescaleDB combines the power of a relational database management system with time-series functionality. Regarding installation, InfluxDB may be somewhat easier to install as a "plug-and-play" solution, whilst TimescaleDB requires an additional step of installing PostgreSQL. The choice between InfluxDB and TimescaleDB depends on specific needs and usage circumstances.
Both databases have their advantages and disadvantages, so it is crucial that users or organisations carefully consider their needs before choosing one or the other.
Module, programme and stories.
Your diploma project for a real company.
A diploma thesis at Academia solves a challenge from a company – often the one where you do your 800 hours of placement. Read about the Programsko inženirstvo module or book a consultation.