Logo do repositório
 
Publicação

Optimizing Database Performance in Complex Event Processing through Indexing Strategies

2024Texto Acesso aberto
Ver registo simples
datacite.subject.fosCiências Naturais::Ciências da Computação e da Informação
datacite.subject.sdg09:Indústria, Inovação e Infraestruturas
dc.contributor.authorAbbasi, Maryam
dc.contributor.authorBernardo, Marco V.
dc.contributor.authorANTUNES VAZ, PAULO JOAQUIM
dc.contributor.authorSilva, José
dc.contributor.authorMartins, Pedro
dc.date.accessioned2026-03-04T15:58:41Z
dc.date.available2026-03-04T15:58:41Z
dc.date.issued2024
dc.description.abstractComplex 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.por
dc.identifier.doihttps://doi.org/10.3390/data9080093
dc.identifier.eissn2306-5729
dc.identifier.urihttp://hdl.handle.net/10400.19/9727
dc.language.isoeng
dc.peerreviewedyes
dc.publisherMDPI
dc.relationCentre for Research in Digital Services
dc.relation.hasversionhttps://www.mdpi.com/2306-5729/9/8/93
dc.rights.urihttp://creativecommons.org/licenses/by/4.0/
dc.subjectcomplex event processing (CEP)
dc.subjectindexing strategies
dc.subjecthierarchical temporal indexing (HTI)
dc.subjecttemporal indexing
dc.subjectperformance evaluation
dc.subjectquery optimization
dc.titleOptimizing Database Performance in Complex Event Processing through Indexing Strategiespor
dc.typetext
dspace.entity.typePublication
oaire.awardNumberUIDB/05583/2020
oaire.awardTitleCentre for Research in Digital Services
oaire.awardURIinfo:eu-repo/grantAgreement/FCT/6817 - DCRRNI ID/UIDB%2F05583%2F2020/PT
oaire.citation.issue8
oaire.citation.titleData
oaire.citation.volume9
oaire.fundingStream6817 - DCRRNI ID
oaire.versionhttp://purl.org/coar/version/c_970fb48d4fbd8a85
person.familyNameANTUNES VAZ
person.familyNameSilva
person.givenNamePAULO JOAQUIM
person.givenNameJosé
person.identifier.ciencia-id351C-9899-0EE7
person.identifier.ciencia-id4A14-D3E7-5B32
person.identifier.orcid0000-0002-1745-8937
person.identifier.orcid0000-0001-7285-8282
person.identifier.scopus-author-id55447844100
project.funder.identifierhttp://doi.org/10.13039/501100001871
project.funder.nameFundação para a Ciência e a Tecnologia
relation.isAuthorOfPublication702e79ee-5b0b-47ff-989d-12e6d8ea1e89
relation.isAuthorOfPublicatione9d8719e-af47-4008-b854-817801bb3964
relation.isAuthorOfPublication.latestForDiscovery702e79ee-5b0b-47ff-989d-12e6d8ea1e89
relation.isProjectOfPublicationa2335235-05b4-404c-a71e-cc37ae7fbf2c
relation.isProjectOfPublication.latestForDiscoverya2335235-05b4-404c-a71e-cc37ae7fbf2c

Ficheiros

Principais
A mostrar 1 - 1 de 1
Miniatura
Nome:
Optimizing Database Performance in Complex Event Processing through Indexing Strategies.pdf
Tamanho:
379.29 KB
Formato:
Adobe Portable Document Format
Ver/Abrir
Licença
A mostrar 1 - 1 de 1
Miniatura indisponível
Nome:
license.txt
Tamanho:
1.79 KB
Formato:
Item-specific license agreed upon to submission
Descrição:
Ver/Abrir

Coleções

ESTGV - DEMGI - Artigo em revista científica, indexada ao WoS/Scopus
CISeD - Artigo em revista científica, indexada ao WoS/Scopus
ESTGV - DI - Artigo em revista científica, indexada ao WoS/Scopus