The article considers the use of time series databases as part of SCADA systems for monitoring oil production facilities. The study focuses on the process of operational collection, storage and analysis of large volumes of technological parameters of the unit received in real time from sensors.
The analysis revealed that traditional relational DBMSs are insufficient for processing high-frequency data streams at the engineering level. This complicates the prediction of failures and timely response to emergency situations. To achieve this goal, modern architectures and approaches to organizing time series storage were analyzed. This includes specialized file formats, hybrid solutions (TimescaleDB) and distributed systems (InfluxDB, QuestDB, GridDB). The criteria for selecting the optimal time series database for the engineering level of SCADA systems are proposed, taking into account performance requirements, ease of deployment, compatibility with industrial protocols, visualisation and implementation costs. A comparative analysis shows the ad-vantages of using InfluxDB, which provides write operations that are 5–10 times faster, flexible integration with Grafana, and support for open data exchange standards. Examples of practical application of InfluxDB for storing and visualising the parameters of an oil pumping unit are given. Unlike the classical time representation, the dynamogram method of constructing the dependencies of the installation parameters on each other is presented. The proposed approach to using InfluxDB for collecting and analysing parameters of the oil pumping unit at the engineering level of SCADA systems can be applied to the design and operation of operational control and monitoring systems of oil fielda.
- V. Boiko, Rozrobka ta ekspluatatsiia naftovykh rodovyshch, Kyiv: Real Print, 2004. (Ukrainian)
- A. Malyar, “Study of stationary modes of sucker rod pumping unit operation”, Przeglad elektrotechniczny, no.12, pp. 255-259, 2016.
https://doi.org/10.15199/48.2016.12.65 - A.Setiawan, Sugeng, K.Koesoema, S.Bakhri, and J.Aditya, “The SCADA system using PLC and HMI to improve the effectiveness and efficiency of production processes”, IOP Conference Series: Materials Science and Engineering, no.550, 2019.
https://doi.org/10.1088/1757-899X/550/1/012008 - T. Kutta and P.Kokoszka, “Monitoring of functional time series”, Bernoulli, vol. 31, no. 4, pp. 3356-3381, 2005.
https://doi.org/10.3150/24-BEJ1850 - Zhu Zhizhou; Han Dongying; Liu Zenian; Li Bingfan; Ge Zixuan; Yin Xinrui; and Wei Xiao, “Research progress and prospects in fault diagnosis of pumping units using dynamometer cards”, Engineering Research Express, vol.7, no. 4, 2025.
https://doi.org/10.1088/2631-8695/ae0f3a - Jan L. Harrington, Relational Database Design and Implementation. Book, Fourth Edition, Published by Morgan Kaufmann, 2016. https://www.sciencedirect.com/book/monograph/9780128043998/relational-da....
https://doi.org/10.1016/B978-0-12-804399-8.00006-5 - S. Włostowska, J. Szabela, A. Chojecki, and P. Borkowski, “Comparison of SQL, NoSQL and TSDB database systems for smart buildings and smart metering applications”, Przegląd elektrotechniczny, no.11, pp.7-12, 2023.
https://doi.org/10.15199/48.2023.11.02 - T. Parmar, “Data Architectures and Methods for Fast Track Data Processing using Hot and Cold Paths”, International Journal of Core Engineering & Management, vol.7, no. 12, pp.278-286, 2024.
https://doi.org/10.5281/zenodo.14888395 - V. Bos, T. Vepsalainen, Y. Prokhorova and T. Latvala, “Time and Space Partitioning Using On-Board Software Reference Architecture”, in Proc. 2016 IEEE International Symposium on Software Reliability Engineering Workshops (ISSREW), Ottawa, ON, Canada, pp.17-20, 2016.
https://doi.org/10.1109/ISSREW.2016.49 - B. Agrawal, A. Chakravorty, C. Rong and T. W. Wlodarczyk, “R2Time: A Framework to Analyse Open TSDB Time-Series Data in HBase”, in Proc. IEEE 6th International Conference on Cloud Computing Technology and Science, Singapore, pp.970-975, 2014.
https://doi.org/10.1109/CloudCom.2014.84 - N. G. Madhusudana, “Data Partitioning: Optimizing Performance in Large Database Systems”, European Modern Studies Journal, vol.9, no.4, pp. 956-964, 2025.
https://doi.org/10.59573/emsj.9(4).2025.90 - S. Kumar and C. Saravanan, “A Comprehensive Study on Data Visualization Tool-Grafana”, Journal of Emerging Technologies and Innovative Research (JETIR), vol. 8, no. 5, p. 908, 2021 Available: http://www.jetir.org/papers/JETIR2105788.pdf.
- InfluxDB Documentation. Available at: https://docs.influxdata.com/influxdb/v2/
- Chronograf: Complete Dashboard Solution for InfluxDB. Available at: https://www.influxdata.com/time-series-platform/chronograf/
- Q.H. Le and M. Diaz, Developing Modern Database Applications with PostgreSQL, Packt Publishing Limited, 2021.
- W.Smith. QuestDB Essentials: The Complete Guide for Developers and Engineers. HiTeX Press, 2025.
- P. Grzesik and D.Mrozek, “Comparative analysis of time series databases in the context of Edge computing for low power sensor networks”, in Proc. 20th International Conference on Computational Science (ICCS 2020), Amsterdam, The Netherlands, pp.371-383, 2020.
https://doi.org/10.1007/978-3-030-50426-7_28 - Abdelouahab Khelifati, Mourad Khayati, Anton Dignös, Djellel Difallah, and Philippe Cudré-Mauroux. TSM-Bench: Benchmarking Time Series Database Systems for Monitoring Applications. Proc. VLDB Endow, vol. 16(11), July 2023, pp.3363-3376, 2023.
https://doi.org/10.14778/3611479.3611532 - What is GridDB. Available at: https://docs.griddb.net/
- Zi-Ming Feng, Jing-Jing Tan, Qi Li and Xin Fang, “A review of beam pumping energy-saving technologies”, Journal of Petroleum Exploration and Production Technology, vol. 8, no. 1, pp. 299-311, 2018.
https://doi.org/10.1007/s13202-017-0383-6