https://doi.org/10.1051/epjconf/202429501039
Multidatabase The Future of the data storage in Particle Physics and Astronomy
Université Paris-Saclay, CNRS/IN2P3, IJCLab, 91405 Orsay, France
* e-mail: Julius.Hrivnac@cern.ch
Published online: 6 May 2024
Particle Physics experiments and Astronomy telescopes store alarge amount of data, most of those data are usually stored in simple files in various formats. Databases are used only to a limited extend, while database technology has made a tremendous progress in recent years, offering a large spectrum of applications in all possible domains. Those possibilities are still largely underused.
The article demonstrates the data architecture transparently using multiple database types, namely SQL database, NoSQL database and Graph database. Each database is used for the domain where it is the most appropriate and the cross-technology access is offered to users. The strong and weak points of all three technologies are discussed. Several possible ways of organizing interactionbetweendatabases aredescribed.
The architecture is illustrated on the concrete implementation of the data storage oftheFinkproject, usingJanusGraph andHBasetechnologiesto store alerts from theRubinObservatory. HBaseis used to store thebulkdata and the structuralinformationis storedinGraphs, allowing transparent access to alldata and deep analyses of relationbetween alerts and other objects. Ways for implementing heterogeneous database architecture in general HEP applications are outlined.
© The Authors, published by EDP Sciences, 2024
This is an Open Access article distributed under the terms of the Creative Commons Attribution License 4.0, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
