{"id":"https://openalex.org/W4400939007","doi":"https://doi.org/10.3390/data9080093","title":"Optimizing Database Performance in Complex Event Processing through Indexing Strategies","display_name":"Optimizing Database Performance in Complex Event Processing through Indexing Strategies","publication_year":2024,"publication_date":"2024-07-24","ids":{"openalex":"https://openalex.org/W4400939007","doi":"https://doi.org/10.3390/data9080093"},"language":"en","primary_location":{"id":"doi:10.3390/data9080093","is_oa":true,"landing_page_url":"https://doi.org/10.3390/data9080093","pdf_url":"https://www.mdpi.com/2306-5729/9/8/93/pdf?version=1721901284","source":{"id":"https://openalex.org/S4210226510","display_name":"Data","issn_l":"2306-5729","issn":["2306-5729"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Data","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.mdpi.com/2306-5729/9/8/93/pdf?version=1721901284","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5064251517","display_name":"Maryam Abbasi","orcid":"https://orcid.org/0000-0002-9011-0734"},"institutions":[{"id":"https://openalex.org/I293362453","display_name":"Polytechnic Institute of Coimbra","ror":"https://ror.org/01n8x4993","country_code":"PT","type":"education","lineage":["https://openalex.org/I293362453"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Maryam Abbasi","raw_affiliation_strings":["Applied Research Institute, Polytechnic of Coimbra, 3045-093 Coimbra, Portugal"],"raw_orcid":"https://orcid.org/0000-0002-9011-0734","affiliations":[{"raw_affiliation_string":"Applied Research Institute, Polytechnic of Coimbra, 3045-093 Coimbra, Portugal","institution_ids":["https://openalex.org/I293362453"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038029799","display_name":"Marco V. Bernardo","orcid":"https://orcid.org/0000-0003-0046-8685"},"institutions":[{"id":"https://openalex.org/I4210120471","display_name":"Instituto de Telecomunica\u00e7\u00f5es","ror":"https://ror.org/02ht4fk33","country_code":"PT","type":"nonprofit","lineage":["https://openalex.org/I4210120471"]},{"id":"https://openalex.org/I56125125","display_name":"Polytechnic Institute of Viseu","ror":"https://ror.org/0235kxk33","country_code":"PT","type":"education","lineage":["https://openalex.org/I56125125"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Marco V. Bernardo","raw_affiliation_strings":["Instituto de Telecomunica\u00e7\u00f5es, 6201-001 Covilh\u00e3, Portugal","Polytechnic of Viseu, Department of Informatics, 3504-510 Viseu, Portugal","Polytechnic of Viseu, Department of Informatics 3504-510 Viseu, Portugal"],"raw_orcid":"https://orcid.org/0000-0003-0046-8685","affiliations":[{"raw_affiliation_string":"Instituto de Telecomunica\u00e7\u00f5es, 6201-001 Covilh\u00e3, Portugal","institution_ids":["https://openalex.org/I4210120471"]},{"raw_affiliation_string":"Polytechnic of Viseu, Department of Informatics, 3504-510 Viseu, Portugal","institution_ids":["https://openalex.org/I56125125"]},{"raw_affiliation_string":"Polytechnic of Viseu, Department of Informatics 3504-510 Viseu, Portugal","institution_ids":["https://openalex.org/I56125125"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069470015","display_name":"Paulo V\u00e1z","orcid":"https://orcid.org/0000-0002-1745-8937"},"institutions":[{"id":"https://openalex.org/I56125125","display_name":"Polytechnic Institute of Viseu","ror":"https://ror.org/0235kxk33","country_code":"PT","type":"education","lineage":["https://openalex.org/I56125125"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Paulo V\u00e1z","raw_affiliation_strings":["Polytechnic of Viseu, Department of Informatics, 3504-510 Viseu, Portugal","Research Center in Digital Services (CISeD), Polytechnic of Viseu, 3504-510 Viseu, Portugal"],"raw_orcid":"https://orcid.org/0000-0002-1745-8937","affiliations":[{"raw_affiliation_string":"Polytechnic of Viseu, Department of Informatics, 3504-510 Viseu, Portugal","institution_ids":["https://openalex.org/I56125125"]},{"raw_affiliation_string":"Research Center in Digital Services (CISeD), Polytechnic of Viseu, 3504-510 Viseu, Portugal","institution_ids":["https://openalex.org/I56125125"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100431521","display_name":"Jos\u00e9 Silva","orcid":"https://orcid.org/0000-0001-7285-8282"},"institutions":[{"id":"https://openalex.org/I56125125","display_name":"Polytechnic Institute of Viseu","ror":"https://ror.org/0235kxk33","country_code":"PT","type":"education","lineage":["https://openalex.org/I56125125"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Jos\u00e9 Silva","raw_affiliation_strings":["Polytechnic of Viseu, Department of Informatics, 3504-510 Viseu, Portugal","Research Center in Digital Services (CISeD), Polytechnic of Viseu, 3504-510 Viseu, Portugal"],"raw_orcid":"https://orcid.org/0000-0001-7285-8282","affiliations":[{"raw_affiliation_string":"Polytechnic of Viseu, Department of Informatics, 3504-510 Viseu, Portugal","institution_ids":["https://openalex.org/I56125125"]},{"raw_affiliation_string":"Research Center in Digital Services (CISeD), Polytechnic of Viseu, 3504-510 Viseu, Portugal","institution_ids":["https://openalex.org/I56125125"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5103618208","display_name":"Pedro Martins","orcid":"https://orcid.org/0000-0002-2118-1440"},"institutions":[{"id":"https://openalex.org/I56125125","display_name":"Polytechnic Institute of Viseu","ror":"https://ror.org/0235kxk33","country_code":"PT","type":"education","lineage":["https://openalex.org/I56125125"]}],"countries":["PT"],"is_corresponding":true,"raw_author_name":"Pedro Martins","raw_affiliation_strings":["Polytechnic of Viseu, Department of Informatics, 3504-510 Viseu, Portugal","Research Center in Digital Services (CISeD), Polytechnic of Viseu, 3504-510 Viseu, Portugal"],"raw_orcid":"https://orcid.org/0000-0002-2118-1440","affiliations":[{"raw_affiliation_string":"Polytechnic of Viseu, Department of Informatics, 3504-510 Viseu, Portugal","institution_ids":["https://openalex.org/I56125125"]},{"raw_affiliation_string":"Research Center in Digital Services (CISeD), Polytechnic of Viseu, 3504-510 Viseu, Portugal","institution_ids":["https://openalex.org/I56125125"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5103618208"],"corresponding_institution_ids":["https://openalex.org/I56125125"],"apc_list":{"value":1600,"currency":"CHF","value_usd":1732},"apc_paid":{"value":1600,"currency":"CHF","value_usd":1732},"fwci":0.9718,"has_fulltext":true,"cited_by_count":3,"citation_normalized_percentile":{"value":0.73971439,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":"9","issue":"8","first_page":"93","last_page":"93"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.998199999332428,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9835000038146973,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.887986421585083},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8474618196487427},{"id":"https://openalex.org/keywords/complex-event-processing","display_name":"Complex event processing","score":0.6924988031387329},{"id":"https://openalex.org/keywords/event","display_name":"Event (particle physics)","score":0.63694828748703},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.6004688739776611},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5450842380523682},{"id":"https://openalex.org/keywords/volume","display_name":"Volume (thermodynamics)","score":0.4140915870666504},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4126124382019043},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.0856877863407135}],"concepts":[{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.887986421585083},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8474618196487427},{"id":"https://openalex.org/C123606473","wikidata":"https://www.wikidata.org/wiki/Q907918","display_name":"Complex event processing","level":3,"score":0.6924988031387329},{"id":"https://openalex.org/C2779662365","wikidata":"https://www.wikidata.org/wiki/Q5416694","display_name":"Event (particle physics)","level":2,"score":0.63694828748703},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.6004688739776611},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5450842380523682},{"id":"https://openalex.org/C20556612","wikidata":"https://www.wikidata.org/wiki/Q4469374","display_name":"Volume (thermodynamics)","level":2,"score":0.4140915870666504},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4126124382019043},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.0856877863407135},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.3390/data9080093","is_oa":true,"landing_page_url":"https://doi.org/10.3390/data9080093","pdf_url":"https://www.mdpi.com/2306-5729/9/8/93/pdf?version=1721901284","source":{"id":"https://openalex.org/S4210226510","display_name":"Data","issn_l":"2306-5729","issn":["2306-5729"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Data","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:gam:jdataj:v:9:y:2024:i:8:p:93-:d:1441944","is_oa":false,"landing_page_url":"https://www.mdpi.com/2306-5729/9/8/93/","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"},{"id":"pmh:oai:doaj.org/article:eb75dd6e98554518b4b8de638bb84fbd","is_oa":true,"landing_page_url":"https://doaj.org/article/eb75dd6e98554518b4b8de638bb84fbd","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Data, Vol 9, Iss 8, p 93 (2024)","raw_type":"article"},{"id":"pmh:oai:repositorio.ipv.pt:10400.19/9727","is_oa":true,"landing_page_url":"http://hdl.handle.net/10400.19/9727","pdf_url":null,"source":{"id":"https://openalex.org/S4306402433","display_name":"Portuguese National Funding Agency for Science, Research and Technology (RCAAP Project by FCT)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"}],"best_oa_location":{"id":"doi:10.3390/data9080093","is_oa":true,"landing_page_url":"https://doi.org/10.3390/data9080093","pdf_url":"https://www.mdpi.com/2306-5729/9/8/93/pdf?version=1721901284","source":{"id":"https://openalex.org/S4210226510","display_name":"Data","issn_l":"2306-5729","issn":["2306-5729"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Data","raw_type":"journal-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/8","display_name":"Decent work and economic growth","score":0.4099999964237213}],"awards":[{"id":"https://openalex.org/G5962587843","display_name":null,"funder_award_id":"UIDB/50008/2020","funder_id":"https://openalex.org/F4320328362","funder_display_name":"Instituto Polit\u00e9cnico de Viseu"},{"id":"https://openalex.org/G6956222374","display_name":null,"funder_award_id":"UIDB/05583/2020","funder_id":"https://openalex.org/F4320328362","funder_display_name":"Instituto Polit\u00e9cnico de Viseu"},{"id":"https://openalex.org/G7644533176","display_name":null,"funder_award_id":"CEECINST/00077/2021","funder_id":"https://openalex.org/F4320328362","funder_display_name":"Instituto Polit\u00e9cnico de Viseu"}],"funders":[{"id":"https://openalex.org/F4320328362","display_name":"Instituto Polit\u00e9cnico de Viseu","ror":"https://ror.org/0235kxk33"}],"has_content":{"grobid_xml":false,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4400939007.pdf"},"referenced_works_count":50,"referenced_works":["https://openalex.org/W313008529","https://openalex.org/W813541713","https://openalex.org/W1962790921","https://openalex.org/W1997491508","https://openalex.org/W2009602724","https://openalex.org/W2071090852","https://openalex.org/W2134161546","https://openalex.org/W2165329839","https://openalex.org/W2165824180","https://openalex.org/W2166035648","https://openalex.org/W2243233585","https://openalex.org/W2247317079","https://openalex.org/W2341491111","https://openalex.org/W2497332262","https://openalex.org/W2549017613","https://openalex.org/W2614919281","https://openalex.org/W2732579758","https://openalex.org/W2752238980","https://openalex.org/W2799244129","https://openalex.org/W2901263649","https://openalex.org/W2946750362","https://openalex.org/W2950478161","https://openalex.org/W2963962416","https://openalex.org/W2971253019","https://openalex.org/W2974622466","https://openalex.org/W3008408328","https://openalex.org/W3009807113","https://openalex.org/W3017117633","https://openalex.org/W3023950633","https://openalex.org/W3096737792","https://openalex.org/W3135300167","https://openalex.org/W3136326637","https://openalex.org/W3216491333","https://openalex.org/W4210623388","https://openalex.org/W4293193362","https://openalex.org/W4319844254","https://openalex.org/W4321764678","https://openalex.org/W4379056279","https://openalex.org/W4380607192","https://openalex.org/W4385163784","https://openalex.org/W4386768432","https://openalex.org/W4386880087","https://openalex.org/W4388002420","https://openalex.org/W4388116248","https://openalex.org/W4388276208","https://openalex.org/W4395699090","https://openalex.org/W6774463750","https://openalex.org/W6791517003","https://openalex.org/W6855483516","https://openalex.org/W6945594299"],"related_works":["https://openalex.org/W3024364549","https://openalex.org/W4206019083","https://openalex.org/W1607805252","https://openalex.org/W2397597979","https://openalex.org/W2799235612","https://openalex.org/W1835640443","https://openalex.org/W4308672222","https://openalex.org/W413387906","https://openalex.org/W2339609534","https://openalex.org/W2072592647"],"abstract_inverted_index":{"Complex":[0],"event":[1,23,34,64,85,93,142,199,206,233],"processing":[2,82,121],"(CEP)":[3],"systems":[4,44,147],"have":[5],"gained":[6],"significant":[7],"importance":[8],"in":[9,279],"various":[10,145],"domains,":[11],"such":[12,226],"as":[13,28,227],"finance,":[14],"logistics,":[15],"and":[16,31,95,111,120,163,169,174,204,214,232,246,262,274],"security,":[17],"where":[18],"the":[19,29,40,52,58,80,89,118,135,159,171,187,212,221,238,244,259,268],"real-time":[20],"analysis":[21],"of":[22,33,42,54,60,83,92,122,137,216,240,248,271],"streams":[24],"is":[25],"crucial.":[26],"However,":[27],"volume":[30],"complexity":[32],"data":[35,94,228],"continue":[36],"to":[37,101,116],"grow,":[38],"optimizing":[39],"performance":[41,59,156],"CEP":[43,146,249],"becomes":[45],"a":[46,68,97,154],"critical":[47],"challenge.":[48],"This":[49],"paper":[50],"investigates":[51],"impact":[53],"indexing":[55,70,99,108,150,190,194,218,254],"strategies":[56],"on":[57,144,258],"databases":[61],"handling":[62],"complex":[63,84,141,198],"processing.":[65],"We":[66,152,208],"propose":[67],"novel":[69],"technique,":[71],"called":[72],"Hierarchical":[73],"Temporal":[74],"Indexing":[75],"(HTI),":[76],"specifically":[77],"designed":[78],"for":[79,197,243,253],"efficient":[81],"queries.":[86],"HTI":[87,114,138,189],"leverages":[88],"temporal":[90,107,202],"nature":[91],"employs":[96],"multi-level":[98],"approach":[100],"optimize":[102],"query":[103,128,160,175,230],"execution.":[104],"By":[105],"combining":[106],"with":[109,148],"spatial-":[110],"attribute-based":[112],"indexing,":[113],"aims":[115],"accelerate":[117],"retrieval":[119],"relevant":[123],"events,":[124],"thereby":[125],"improving":[126],"overall":[127],"performance.":[129],"In":[130],"this":[131,280],"study,":[132],"we":[133,236,266],"evaluate":[134],"effectiveness":[136],"by":[139,179],"implementing":[140],"queries":[143,200],"different":[149],"strategies.":[151],"conduct":[153],"comprehensive":[155],"analysis,":[157],"measuring":[158],"execution":[161,172],"times":[162],"resource":[164],"utilization":[165],"(CPU,":[166],"memory,":[167],"etc.),":[168],"analyzing":[170],"plans":[173],"optimization":[176,247],"techniques":[177],"employed":[178],"each":[180,217],"system.":[181],"Our":[182],"experimental":[183],"results":[184],"demonstrate":[185],"that":[186,223],"proposed":[188],"strategy":[191,255],"outperforms":[192],"traditional":[193],"approaches,":[195],"particularly":[196],"involving":[201],"constraints":[203],"multi-dimensional":[205],"attributes.":[207],"provide":[209],"insights":[210],"into":[211],"strengths":[213],"weaknesses":[215],"strategy,":[219],"identifying":[220],"factors":[222],"influence":[224],"performance,":[225],"volume,":[229],"complexity,":[231],"characteristics.":[234,264],"Furthermore,":[235],"discuss":[237],"implications":[239],"our":[241,272],"findings":[242],"design":[245],"systems,":[250],"offering":[251],"recommendations":[252],"selection":[256],"based":[257],"specific":[260],"requirements":[261],"workload":[263],"Finally,":[265],"outline":[267],"potential":[269],"limitations":[270],"study":[273],"suggest":[275],"future":[276],"research":[277],"directions":[278],"domain.":[281]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1}],"updated_date":"2026-05-06T08:25:59.206177","created_date":"2025-10-10T00:00:00"}