External access to ALICE controls conditions data

20th International Conference on Computing in High Energy and Nuclear Physics

物理学;计算机科学

Jadlovský, J.^1 ; Jadlovská, A.^1 ; Sarnovský, J.^1 ; Jajiin, Š.^1 ; opík, M.^1 ; Jadlovská, S.^1 ; Papcun, P.^1 ; Bielek, R.^1 ; erkala, J.^1 ; Kopík, M.^1 ; Chochula, P.^2 ; Augustinus, A.^2

Technical University of Koice, Faculty of Electrical Engineering and Informatics, Department of Cybernetics and Artificial Intelligence, Koice, Slovakia^1

CERN, European Organization for Nuclear Research, Geneva, Switzerland^2

关键词: Advanced analysis;    Authentication mechanisms;    Caching mechanism;    Database structures;    Historical data;    Interactive interfaces;    Operational conditions;    Oracle database;   

Others  :  https://iopscience.iop.org/article/10.1088/1742-6596/513/1/012015/pdf
DOI  :  10.1088/1742-6596/513/1/012015

学科分类：计算机科学（综合）

来源: IOP

【 摘 要 】

ALICE Controls data produced by commercial SCADA system WINCCOA is stored in ORACLE database on the private experiment network. The SCADA system allows for basic access and processing of the historical data. More advanced analysis requires tools like ROOT and needs therefore a separate access method to the archives. The present scenario expects that detector experts create simple WINCCOA scripts, which retrieves and stores data in a form usable for further studies. This relatively simple procedure generates a lot of administrative overhead-users have to request the data, experts needed to run the script, the results have to be exported outside of the experiment network. The new mechanism profits from database replica, which is running on the CERN campus network. Access to this database is not restricted and there is no risk of generating a heavy load affecting the operation of the experiment. The developed tools presented in this paper allow for access to this data. The users can use web-based tools to generate the requests, consisting of the data identifiers and period of time of interest. The administrators maintain full control over the data-an authorization and authentication mechanism helps to assign privileges to selected users and restrict access to certain groups of data. Advanced caching mechanism allows the user to profit from the presence of already processed data sets. This feature significantly reduces the time required for debugging as the retrieval of raw data can last tens of minutes. A highly configurable client allows for information retrieval bypassing the interactive interface. This method is for example used by ALICE Offline to extract operational conditions after a run is completed. Last but not least, the software can be easily adopted to any underlying database structure and is therefore not limited to WINCCOA.