Data warehouse for intelligent oil wells control systems

The article considers the problems of data warehouse subsystem designing as a part of the intelligent oil well control system. It is proposed to extend the Epicentre exploration and exploitation fields data model created by POSC corporation adding new entities and the hierarchy of relations to improve the suggested data warehouse. In the development process the authors used high design patterns taking into account the specificity of the study object and the experience of industry experts. The case study results presented in this paper consider reducing labor costs for the development and provide the ability to integrate with the existing high-level information systems like MES or ERP.