The bachelor thesis deals mainly with the issue of data flow control in database information systems interconnected with SCADA and Embedded systems. The aim of this work is to analyze theoretical methods of design database information systems, to design and implement software product DARMA and, at the last to process scripts for visualization and archiving of data in WinCC OA environment. The purpose of DARMA is to provide access to off-line data of ALICE experiment in CERN laboratory and to improve the quality of internal processes and to simplify the work of scientific and technical staff. The thesis also describes how to integrate SCADA visualization tools with Oracle database information systems. Methodical approach for creation of distributed control systems was used at this thesis.

This bachelor thesis focuses on the hardware modernization of a ball on plate (BoP) laboratory platform, the design of a digital twin (DT) methodology, the implementation of selected control algorithms, and the development of a computer vision algorithm. The BoP system was identified as two subsystems: the servomotor subsystem parameters were identified using measured data from the physical laboratory model and a chosen linear structure, while the BoP dynamics subsystem, represented by a mathematical model in the form of a nonlinear differential equation, had its coefficient of restitution further identified. By applying the proposed identification methodology, a grey-box BoP model was obtained, which serves as a digital twin for the laboratory BoP model. Based on the resulting BoP model, which represents a DT for the laboratory model, control algorithms were designed based on the linearized model. The proposed PID and optimal state-space control algorithms (LQI/MPC) were verified through simulations in control structures, and the obtained control results using the DT for various objectives were compared with control results obtained using the physical BoP laboratory model. Furthermore, the thesis addresses software tasks within the international collaboration with the ALICE experiment at CERN, specifically the modernization of the AGRANA monitoring application and the design of the DARMA4 information system.