Oil Storages and Main Oil Pipelines Pumps Database Development

Abstract

The object of research is a data model that characterizes the pumping units of main oil pipelines. The paper considers the creation of pumps database and their characteristics as a component of software systems designed to search for sources of energy saving in pipeline transportation of oil and oil products.

An overview of existing programs for calculating the joint operation of an oil pumping station and a pipeline is given. It is shown that most programs are inaccessible for analyzing the applied data storage technologies, or involve manual input of entry data without using databases. Comparative analysis of spreadsheets and relational databases is performed. It is shown that relational databases better meet the requirements of data convenience, availability, scalability, and performance. A physical model of a relational database is presented. The parent and child entities have been established, which make it possible to fully reflect all information about the pumping unit, namely:

– coefficients of hydraulic characteristics depending on the diameter of the impeller rotor;

– characteristics depending only on the pump make;

– classification of the pump by design or purpose. Relationship types and referential integrity rules are defined between entities when deleting or updating data. For data management, the SQLite system is proposed, which provides data manipulation in the SQL query language and does not require the development of additional software. The analysis of possible ways of organizing multilingualism using a database is carried out. The text of the SQL query is proposed, which allows to select the pump with its characteristics by the pump make and impeller diameter. A database structure is proposed that allows storing information about equipment for oil pipelines for various purposes, which makes it possible for automated calculations of complex technological processes. The pumping unit database is an open source project that is posted on the public web service GitHub.