3 Citations (Scopus)

Abstract

Time series data is created in a variety of application areas such as sensors in cars, smartwatches or IoT devices. This kind of data is often characterized by high resource demand due to the frequency the information is measured, with data points once a day, hour and even down to milliseconds. While real-time processing of such data is often sufficient, there are also many use cases, where batch processing and consequently the storage and managed access of measurements is required. For this reason, this work evaluates different database management systems in the context of storing time related data using different data models such as classical relational models, non-relational models using NoSQL database systems and the recently upcoming group of NewSQL databases. The evaluation shows that a highly optimized time series databases such as InfluxDB is able to outperform the other tested systems regarding write-throughput and RAM as well as disk utilization in a single server setup.
Original languageEnglish
Title of host publicationInternational Conference on Electrical, Computer, Communications and Mechatronics Engineering, ICECCME 2022
PublisherInstitute of Electrical and Electronics Engineers Inc.
ISBN (Electronic)9781665470957
DOIs
Publication statusPublished - 2022
Event2022 International Conference on Electrical, Computer, Communications and Mechatronics Engineering, ICECCME 2022 - Male, Maldives
Duration: 16 Nov 202218 Nov 2022

Publication series

NameInternational Conference on Electrical, Computer, Communications and Mechatronics Engineering, ICECCME 2022

Conference

Conference2022 International Conference on Electrical, Computer, Communications and Mechatronics Engineering, ICECCME 2022
Country/TerritoryMaldives
CityMale
Period16.11.202218.11.2022

Keywords

  • Big Data
  • Database
  • SQL
  • Time Series

Fingerprint

Dive into the research topics of 'A Comparison of Relational, NoSQL and NewSQL Database Management Systems for the Persistence of Time Series Data'. Together they form a unique fingerprint.

Cite this