Abstract
A number of open source database systems have been researched and assessed in this work for the purpose of choosing the optimum technology to implement predictive maintenance systems for industrial Autonomous Guided Vehicles. An application-driven technique has been suggested as a way to achieve it. The use case and its specifications are first outlined and listed. The top five most popular time series database systems are then contrasted based on a variety of technical metrics including software support, community support, and different technical features. From this analysis the best two options are selected (InfluxDB and TimeScale DB). The performance of these two is then further examined, taking into account performance indicators like insert time, throughput, and resource consumption. Results show that TimeScale DB provides a higher performance but demands considerably more resources.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
Espinosa, F., Santos, C., Sierra-García, J.E.: Transporte multi-AGV de una carga: estado del arte y propuesta centralizada. In: Revista Iberoamericana de Automática e Informática industrial, vol. 18, no. 1, pp. 82–91 (2020)
Baruque, B., et al.: Geothermal heat exchanger energy prediction based on time series and monitoring sensors optimization. Energy 171, 49–60 (2019). issn: 0360–5442. https://www.sciencedirect.com/science/article/pii/S0360544218325817. https://doi.org/10.1016/j.energy.2018.12.207
Dama, F., Sinoquet, C.: Analysis and modeling to forecast in time series: a systematic review. CoRR abs/2104.00164 (2021). http://arxiv.org/abs/2104.00164
Grzesik, P., Mrozek, D.: Comparative analysis of time series databases in the context of edge computing for low power sensor networks. In: Krzhizhanovskaya, V.V., et al. (eds.) ICCS 2020. LNCS, vol. 12141, pp. 371–383. Springer, Cham (2020). https://doi.org/10.1007/978-3-030-50426-7_28
Struckov, A., et al.: Evaluation of modern tools and techniques for storing time-series data. Procedia Comput. Sci. 156, 19–28 (2019). ISSN: 1877–0509. https://doi.org/10.1016/j.procs.2019.08.125. https://www.sciencedirect.com/science/article/pii/S1877050919310439
DB-Engines. DB-Engines Ranking of Time Series DBMS (2023). Accessed 22 Mar 2023. https://db-engines.com/en/ranking/time+series+dbms
InfluxData. InfluxDB: Open Source Time Series Database/InfluxData (2021). https://www.influxdata.com/
KX. KX: Make Data Driven Decisions 100X Faster At 1/10th The Cost (2023). https://kx.com/
Prometheus. Prometheus - Monitoring system & time series database. https://prometheus.io/
Graphite. https://graphiteapp.org/
Time-series data simplified. https://www.timescale.com/
Docker Inc., Docker. Accessed 5 May 2023. https://www.docker.com
Functions Graphite 1.2.0 documentation. https://graphite.readthedocs.io/en/latest/functions.html
Timescale Documentation/Time-series forecasting. https://docs.timescale.com/tutorials/latest/time-series-forecast/
InfluxData. InfluxDB design principles. Accessed 22 March 2023. https://docs.influxdata.com/influxdb/cloud/reference/key-concepts/design-principles/
Prometheus community. Prometheus Pushgateway. Accessed 26 Apr 2023. https://github.com/prometheus/pushgateway#readme
InfluxData. InfluxData Unveils Future of Time Series Analytics with InfluxDB 3.0 Product Suite. Accessed 22 Mar 2023. https://www.influxdata.com/blog/influxdata-announces-influxdb-3-0/
Acknowledgement
This work was partially supported by the European Commission, under European Project 5G-Induce, grant number 101016941.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2023 The Author(s), under exclusive license to Springer Nature Switzerland AG
About this paper
Cite this paper
Burgos, G., Sierra-García, J.E., Baruque-Zanón, B. (2023). Comparative Study of Open Source Database Management Systems to Enable Predictive Maintenance of Autonomous Guided Vehicles. In: García Bringas, P., et al. 18th International Conference on Soft Computing Models in Industrial and Environmental Applications (SOCO 2023). SOCO 2023. Lecture Notes in Networks and Systems, vol 749. Springer, Cham. https://doi.org/10.1007/978-3-031-42529-5_26
Download citation
DOI: https://doi.org/10.1007/978-3-031-42529-5_26
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-031-42528-8
Online ISBN: 978-3-031-42529-5
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)