OMS data aggregation and management in the CMS experiment

Jaafar Alawieh; Kareen Arutjunjan; Miguel Bacharov Durasov; Ulf Behrens; Andrea Bocci; James Branson; Philipp Maximilian Brummer; Jan Andrzej Bugajski; Eric Cano; Sergio Cittolin; Albert Corominas I Mariscot; Georgiana-Lavinia Darlea; Christian Deldicque; Marc Dobson; Antonin Dvorak; Christos Emmanouil; Antra Gaile; Dominique Gigi; Frank Glege; Guillelmo Gomez-Ceballos; Patrycja Gorniak; Jeroen Hegeman; Guillermo Izquierdo Moreno; Thomas Owen James; Tejeswini Jayakumar; Wassef Karimeh; Dimitra Kostala; Rafał Krawczyk; Wei Li; Kenneth Long; Frans Meijers; Emilio Meschi; Srećko Morović; Babatunde John Odetayo; Luciano Orsini; Christoph Paus; Andrea Petrucci; Marco Pieri; Dinyar Sebastian Rabady; Attila Racz; Theodoros Rizopoulos; Hannes Sakulin; Christoph Schwick; Dainius Šimelevičius; Polyneikis Tzanis; Cristina Vazquez Velez; Petr Žejdl

doi:10.1051/epjconf/202533701132

Title	OMS data aggregation and management in the CMS experiment
Authors	Alawieh, Jaafar ; Arutjunjan, Kareen ; Durasov, Miguel Bacharov ; Behrens, Ulf ; Bocci, Andrea ; Branson, James ; Brummer, Philipp Maximilian ; Bugajski, Jan Andrzej ; Cano, Eric ; Cittolin, Sergio ; Mariscot, Albert Corominas I ; Darlea, Georgiana-Lavinia ; Deldicque, Christian ; Dobson, Marc ; Dvorak, Antonin ; Emmanouil, Christos ; Gaile, Antra ; Gigi, Dominique ; Glege, Frank ; Gomez-Ceballos, Guillelmo ; Gorniak, Patrycja ; Hegeman, Jeroen ; Moreno, Guillermo Izquierdo ; James, Thomas Owen ; Jayakumar, Tejeswini ; Karimeh, Wassef ; Kostala, Dimitra ; Krawczyk, Rafał ; Li, Wei ; Long, Kenneth ; Meijers, Frans ; Meschi, Emilio ; Morović, Srećko ; Odetayo, Babatunde John ; Orsini, Luciano ; Paus, Christoph ; Petrucci, Andrea ; Pieri, Marco ; Rabady, Dinyar Sebastian ; Racz, Attila ; Rizopoulos, Theodoros ; Sakulin, Hannes ; Schwick, Christoph ; Šimelevičius, Dainius ; Tzanis, Polyneikis ; Velez, Cristina Vazquez ; Žejdl, Petr
DOI	10.1051/epjconf/202533701132
Full Text
Is Part of	27th international conference on Computing in High Energy and Nuclear Physics, CHEP 2024, October 19-25, 2024, Krakow.. Les Ulis : EDP Sciences. 2025, art. no. 01132, p. [1-8]
Abstract [eng]	The Online Monitoring System (OMS) at the Compact Muon Solenoid (CMS) experiment at CERN collects and combines various non-event data sources, allowing users to view, compare, and correlate real-time and historical information. The OMS data warehouse (DWH) constitutes the foundation of the Online Monitoring System (OMS) architecture within CMS, responsible for the storage and manipulation of non-event data within ORACLE databases. Using PL/SQL code, the DWH orchestrates the data aggregation and processing from several sources, inheriting and revamping code from a previous project known as Web Based Monitoring (WBM) to meet evolving requirements. The main goals of the WBM databases restructuring were: the modernization of inherited PL/SQL code, necessitating the creation of new aggregation tables and the implementation of enhancements such as standardized naming conventions, improved development workflows, and continuous integration strategies. DWH is composed of multiple Oracle schemas and integrates external PL/SQL libraries, particularly the CERN Beams Common4Oracle library, which consolidates common functionalities from various CERN Beams department databases into a unified codebase for widespread application. This article describes into the architecture and development strategies employed within the OMS data warehouse, underscoring its role in facilitating efficient data aggregation and management within the OMS project in the CMS experiment at CERN.
Published	Les Ulis : EDP Sciences
Type	Conference paper
Language	English
Publication date	2025
CC license

„OMS data aggregation and management in the CMS experiment“