Using a time series databases as a component оf oil pumping units monitoring

2025;
: pp. 21-28
1
Lviv Polytechnic National University
2
Lviv Polytechnic National University

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.