Andrea Petrucci
(Univ. of California San Diego (US))
The OMS data warehouse (DWH) constitutes the foundation of the Online Monitoring System (OMS) architecture within the CMS experiment at CERN, responsible for the storage and manipulation of non-event data within ORACLE databases. Leveraging on PL/SQL code, the DWH orchestrates the aggregation and modification of data from several sources, inheriting and revamping code from the previous project known as Web Based Monitoring to meet evolving requirements. The main goals of the DWH 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, in particular the CERN Beams Common4Oracle library, which consolidates common functionalities from various CERN Beams department databases into a unified codebase for widespread application. This article delves 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.
Andrea Petrucci
(Univ. of California San Diego (US))
Albert Corominas I Mariscot
(University of Girona UdG (ES))
Dr
Andrea Bocci
(CERN)
Antonin Dvorak
(CERN)
Antra Gaile
(Riga Technical University (LV))
Attila Racz
(CERN)
Babatunde John Odetayo
(University of Benin (NG))
Christian Deldicque
(CERN)
Christoph Paus
(Massachusetts Inst. of Technology (US))
Christoph Schwick
(CERN)
Christos Emmanouil
Cristina Vazquez Velez
(CERN)
Dainius Simelevicius
(Vilnius University (LT))
Dinyar Rabady
(CERN)
Dominique Gigi
(CERN)
Dr
Emilio Meschi
(CERN)
Eric Cano
(CERN)
Frank Glege
(CERN)
Frans Meijers
(CERN)
Georgiana Lavinia Darlea
(Massachusetts Inst. of Technology (US))
Guillelmo Gomez Ceballos Retuerto
(Massachusetts Inst. of Technology (US))
Guillermo Izquierdo Moreno
(CERN)
Hannes Sakulin
(CERN)
Jaafar Alawieh
(American University of Beirut (LB))
James Gordon Branson
(Univ. of California San Diego (US))
Jan Andrzej Bugajski
(AGH University of Krakow (PL))
Jeroen Hegeman
(CERN)
Kareen Arutjunjan
(CERN)
Kenneth Long
(Massachusetts Inst. of Technology (US))
Luciano Orsini
(CERN)
Marc Dobson
(CERN)
Marco Pieri
(Univ. of California San Diego (US))
Miguel Bacharov Durasov
(CERN)
Patrycja Ewa Gorniak
(CERN)
Petr Zejdl
(CERN)
Philipp Brummer
(CERN)
Polyneikis Tzanis
(CERN)
Rafal Dominik Krawczyk
(Rice University (US))
Sergio Cittolin
(Univ. of California San Diego (US))
Srecko Morovic
(Univ. of California San Diego (US))
Tejeswini Jayakumar
(CERN)
Theodoros Rizopoulos
(CERN)
Thomas Owen James
(CERN)
Ulf Behrens
(Rice University (US))
Wassef Karimeh
(CERN)
Wei Li
(Rice University (US))
There are no materials yet.
