| Issue |
EPJ Web of Conf.
Volume 295, 2024
26th International Conference on Computing in High Energy and Nuclear Physics (CHEP 2023)
|
|
|---|---|---|
| Article Number | 01039 | |
| Number of page(s) | 8 | |
| Section | Data and Metadata Organization, Management and Access | |
| DOI | https://doi.org/10.1051/epjconf/202429501039 | |
| Published online | 06 May 2024 | |
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.
Current usage metrics show cumulative count of Article Views (full-text article views including HTML views, PDF and ePub downloads, according to the available data) and Abstracts Views on Vision4Press platform.
Data correspond to usage on the plateform after 2015. The current usage metrics is available 48-96 hours after online publication and is updated daily on week days.
Initial download of the metrics may take a while.