Optimizing Database Performance in Complex Event Processing through Indexing Strategies

Maryam Abbasi, Marco V. Bernardo, Paulo Váz, José Silva and Pedro Martins ()
Additional contact information
Maryam Abbasi: Applied Research Institute, Polytechnic of Coimbra, 3045-093 Coimbra, Portugal
Marco V. Bernardo: Instituto de Telecomunicações, 6201-001 Covilhã, Portugal
Paulo Váz: Polytechnic of Viseu, Department of Informatics, 3504-510 Viseu, Portugal
José Silva: Polytechnic of Viseu, Department of Informatics, 3504-510 Viseu, Portugal
Pedro Martins: Polytechnic of Viseu, Department of Informatics, 3504-510 Viseu, Portugal

Data, 2024, vol. 9, issue 8, 1-24

Abstract: 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.

Keywords: complex event processing (CEP); indexing strategies; hierarchical temporal indexing (HTI); temporal indexing; performance evaluation; query optimization (search for similar items in EconPapers)
JEL-codes: C8 C80 C81 C82 C83 (search for similar items in EconPapers)
Date: 2024
References: View complete reference list from CitEc
Citations:

Downloads: (external link)
https://www.mdpi.com/2306-5729/9/8/93/pdf (application/pdf)
https://www.mdpi.com/2306-5729/9/8/93/ (text/html)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:gam:jdataj:v:9:y:2024:i:8:p:93-:d:1441944

Access Statistics for this article

Data is currently edited by Ms. Cecilia Yang

More articles in Data from MDPI
Bibliographic data for series maintained by MDPI Indexing Manager ().