首页>
外军国防科技报告
>Evaluating InfluxDB and ClickHouse database technologies for improvements of the ATLAS operational monitoring data archiving - CERN Document Server
【2h】
Evaluating InfluxDB and ClickHouse database technologies for improvements of the ATLAS operational monitoring data archiving - CERN Document Server
展开▼
机译：评估InfluxDB和ClickHouse数据库技术，以改进ATLAS运行监控数据归档 - CERN Document Server
The Trigger and Data Acquisition system of the ATLAS experiment at the Large Hadron Collider at CERN is composed of a large number of distributed hardware and software components which provide the data-taking functionality of the overall system. During data taking, huge amounts of operational data are created in order to constantly monitor the system. The Persistent Back-End for the ATLAS Information System of TDAQ (P-BEAST) is a system based on a custom-built time-series database and it is used to archive and retrieve any operational monitoring data for the applications requesting it. P-BEAST stores about 18 TB of highly compacted and compressed raw monitoring data per year. Since P-BEAST's creation, several promising database technologies for fast access to time-series have become available. InfluxDB and ClickHouse were the most promising candidates for improving the performance and functionality of the current implementation of P-BEAST. This paper presents a short description of main features of both technologies and a description of the tests ran on both database systems. Then, the results of the performance testing performed using a subset of archived ATLAS operational monitoring data are presented and compared.
展开▼
