EventDB: an event-based indexer and caching system for BESIII experiment

Cheng, Yaodong; Li, Haibo; Xu, Qi; Cheng, Ziyong; Huang, Qiulan

doi:10.1051/epjconf/201921404011

Cited by 3 publications

(1 citation statement)

References 11 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Similar systems have been previously developed for other experiments, including ATLAS EventIndex [3], CMS Data Bookkeeping Service [4], LHCb Event Search System [5], BES III EventDB [6]. The overall architecture of those systems as well as database management systems used for such event storage differ quite radically between solutions, due to different operational environments, data volume, and available expertise.…”

Section: Introductionmentioning

confidence: 99%

Implementation of the Event Metadata System for physics analysis in the NICA experiments

Alexandrov

Aleksandrov²,

Chebotov³

et al. 2023

J. Phys.: Conf. Ser.

View full text Add to dashboard Cite

NICA (Nuclotron-based Ion Collider fAcility) is a new accelerator complex, which is under construction at the Joint Institute for Nuclear Research in Dubna to study properties of dense baryonic matter. The experiments of the NICA projects have already generated and obtained substantial volumes of event data, and it is expected that the overall number of stored events will increase from the current value of hundreds of millions to several billion events per year. The developed Event Metadata System is required to store and index experimental event records obtained at NICA facilities, allowing to quickly search for only necessary events based on various criteria for further processing and physics analyses. The main aim of the information system that is described is to speed up desired physics analyses and data quality checks. In addition, it allows reducing the load of the NICA computing infrastructure. The Event Metadata System, which is presented in the paper, is integrated with other experimental and software systems, in particular, NICA ROOT-based frameworks and implemented Condition Database. An access and management of the event metadata in the Event Catalogue being used to select only events for a particular physics analysis are provided via several interfaces, such as REST API, Web UI, and a dedicated C++/ROOT interface. The detailed architecture of the system and developed services including monitoring are also presented.

show abstract

Section: Introductionmentioning

confidence: 99%

Implementation of the Event Metadata System for physics analysis in the NICA experiments

Alexandrov

Aleksandrov²,

Chebotov³

et al. 2023

J. Phys.: Conf. Ser.

View full text Add to dashboard Cite

show abstract

Design of the Event Metadata System for the Experiments at NICA

Alexandrov

Aleksandrov

Degtyarev

et al. 2021

Phys. Part. Nuclei Lett.

View full text Add to dashboard Cite

Optimizing Database Performance in Complex Event Processing through Indexing Strategies

Abbasi,

Bernardo,

Váz

et al. 2024

Data

View full text Add to dashboard Cite

Complex event processing (CEP) systems have gained significant importance in various domains, such as finance, logistics, and security, where the real-time analysis of event streams is crucial. However, as the volume and complexity of event data continue to grow, optimizing the performance of CEP systems becomes a critical challenge. This paper investigates the impact of indexing strategies on the performance of databases handling complex event processing. We propose a novel indexing technique, called Hierarchical Temporal Indexing (HTI), specifically designed for the efficient processing of complex event queries. HTI leverages the temporal nature of event data and employs a multi-level indexing approach to optimize query execution. By combining temporal indexing with spatial- and attribute-based indexing, HTI aims to accelerate the retrieval and processing of relevant events, thereby improving overall query performance. In this study, we evaluate the effectiveness of HTI by implementing complex event queries on various CEP systems with different indexing strategies. We conduct a comprehensive performance analysis, measuring the query execution times and resource utilization (CPU, memory, etc.), and analyzing the execution plans and query optimization techniques employed by each system. Our experimental results demonstrate that the proposed HTI indexing strategy outperforms traditional indexing approaches, particularly for complex event queries involving temporal constraints and multi-dimensional event attributes. We provide insights into the strengths and weaknesses of each indexing strategy, identifying the factors that influence performance, such as data volume, query complexity, and event characteristics. Furthermore, we discuss the implications of our findings for the design and optimization of CEP systems, offering recommendations for indexing strategy selection based on the specific requirements and workload characteristics. Finally, we outline the potential limitations of our study and suggest future research directions in this domain.

show abstract

EventDB: an event-based indexer and caching system for BESIII experiment

Cited by 3 publications

References 11 publications

Implementation of the Event Metadata System for physics analysis in the NICA experiments

Implementation of the Event Metadata System for physics analysis in the NICA experiments

Design of the Event Metadata System for the Experiments at NICA

Optimizing Database Performance in Complex Event Processing through Indexing Strategies

Contact Info

Product

Resources

About