OMS Data Aggregation and Management in the CMS Experiment
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.
Authors
- Antonı́n Dvořák (ORCID: https://orcid.org/0000-0002-0611-491X)
- Philipp Brummer (ORCID: https://orcid.org/0000-0002-3857-3504)
- Antra Gaile (ORCID: https://orcid.org/0000-0003-1350-3523)
- Wassef Karimeh
- E. Cano
- Christian Deldicque
- Guillermo Izquierdo Moreno
- Christoph Paus
- J. Hegeman (ORCID: https://orcid.org/0000-0002-2938-2263)
- T. Jayakumar
- T. James (ORCID: https://orcid.org/0000-0002-3727-0202)
- F. Glege
- G. Gomez Ceballos (ORCID: https://orcid.org/0000-0003-1683-9460)
- Cristina Vazquez Velez
- P. Zejdl (ORCID: https://orcid.org/0000-0001-9554-7815)
- Theodoros Rizopoulos
- K. Long (ORCID: https://orcid.org/0000-0003-0664-1653)
- R. D. Krawczyk (ORCID: https://orcid.org/0000-0001-8664-4787)
- Patrycja Gorniak
- Wei Li
- Srećko Morović (ORCID: https://orcid.org/0000-0003-0956-4665)
- Marc Dobson
- M. Pieri (ORCID: https://orcid.org/0000-0003-3303-6301)
- Dainius Šimelevičius
- Sergio Cittolin
- Frans Meijers
- Dinyar Sebastian Rabady
- Hannes Sakulin
- D. Gigi (ORCID: https://orcid.org/0000-0003-0422-6739)
- A. Rácz (ORCID: https://orcid.org/0000-0002-7432-5911)
- L. Orsini
- Andrea Petrucci
- J. G. Branson
- U. Behrens
- A. Bocci
- Christoph Schwick
- P. Tzanis (ORCID: https://orcid.org/0000-0001-6828-1599)
- Georgiana-Lavinia Darlea
- E. Meschi (ORCID: https://orcid.org/0000-0003-4502-6151)
- Jaafar Alawieh
- Miguel Bacharov Durasov
- Dimitra Kostala
- Babatunde John Odetayo
- Jan Andrzej Bugajski
- Albert Corominas I Mariscot
- Christos Emmanouil
- Kareen Arutjunjan
Institutions
- Vilnius University (LT)
- National and Kapodistrian University of Athens (GR)
- University of California San Diego (US)
- IIT@MIT (US)
- University of Benin (NG)
- European Organization for Nuclear Research (CH)
- Rice University (US)
Publication Details
- Journal
- EPJ Web of Conferences
- Published
- 2025-01-01
- DOI
- https://doi.org/10.1051/epjconf/202533701132
- Primary Topic
- Particle Detector Development and Performance
- Type
- article
- Field-Weighted Citation Impact
- 0.00