Innovative aspects of designing and managing database systems for modern companies in the energy sector

Sharjah Police Science Academy, Sharjah, United Arab Emirates

^* Corresponding author: salrhaimi@psa.ac.ae

Abstract

The transition to digital channels and maximum digitalization of the business of modern companies in the energy sector dictate the need to improve and develop new approaches to design and database management. The study aims to identify innovative aspects in the design and management of database systems. To achieve these goals, key aspects of database design are emphasized through the argumentation of the data modeling process. Modern types of database models are identified and the need to normalize data and get rid of their redundancy is argued. The main components of the company database management system are structured. The structure of the decision support system processes is proposed. A sequence of operations with the database has been developed in the case of registration/purchase of goods using online platforms. The structure of information systems of modern companies is highlighted with an emphasis on the main functions of database management systems, taking into account the growth of digital technologies and channels of interaction with customers. The developed approaches can be applied in practice as the basis for the theory of design and management of data warehouses, taking into account innovative aspects of development.