{"id":"https://openalex.org/W2757081350","doi":"https://doi.org/10.23919/spects.2017.8046771","title":"Dimensional data model for early alerts of malicious activities in a CSIRT","display_name":"Dimensional data model for early alerts of malicious activities in a CSIRT","publication_year":2017,"publication_date":"2017-07-01","ids":{"openalex":"https://openalex.org/W2757081350","doi":"https://doi.org/10.23919/spects.2017.8046771","mag":"2757081350"},"language":"en","primary_location":{"id":"doi:10.23919/spects.2017.8046771","is_oa":false,"landing_page_url":"https://doi.org/10.23919/spects.2017.8046771","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2017 International Symposium on Performance Evaluation of Computer and Telecommunication Systems (SPECTS)","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5059912393","display_name":"Pa\u00fal Valladares","orcid":null},"institutions":[{"id":"https://openalex.org/I118946981","display_name":"Universidad de las Fuerzas Armadas ESPE","ror":"https://ror.org/05j136930","country_code":"EC","type":"education","lineage":["https://openalex.org/I118946981"]}],"countries":["EC"],"is_corresponding":false,"raw_author_name":"Paul Valladares","raw_affiliation_strings":["Computer Sciences Department, Universidad de las Fuerzas Armadas ESPE, Sangolqui, Ecuador"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Sciences Department, Universidad de las Fuerzas Armadas ESPE, Sangolqui, Ecuador","institution_ids":["https://openalex.org/I118946981"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5016435353","display_name":"Walter Fuertes","orcid":"https://orcid.org/0000-0001-9427-5766"},"institutions":[{"id":"https://openalex.org/I118946981","display_name":"Universidad de las Fuerzas Armadas ESPE","ror":"https://ror.org/05j136930","country_code":"EC","type":"education","lineage":["https://openalex.org/I118946981"]}],"countries":["EC"],"is_corresponding":false,"raw_author_name":"Walter Fuertes","raw_affiliation_strings":["Computer Sciences Department, Universidad de las Fuerzas Armadas ESPE, Sangolqui, Ecuador"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Sciences Department, Universidad de las Fuerzas Armadas ESPE, Sangolqui, Ecuador","institution_ids":["https://openalex.org/I118946981"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5077541313","display_name":"Freddy Tapia","orcid":"https://orcid.org/0000-0001-9591-3563"},"institutions":[{"id":"https://openalex.org/I118946981","display_name":"Universidad de las Fuerzas Armadas ESPE","ror":"https://ror.org/05j136930","country_code":"EC","type":"education","lineage":["https://openalex.org/I118946981"]}],"countries":["EC"],"is_corresponding":false,"raw_author_name":"Freddy Tapia","raw_affiliation_strings":["Computer Sciences Department, Universidad de las Fuerzas Armadas ESPE, Sangolqui, Ecuador"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Sciences Department, Universidad de las Fuerzas Armadas ESPE, Sangolqui, Ecuador","institution_ids":["https://openalex.org/I118946981"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018344676","display_name":"Theofilos Toulkeridis","orcid":"https://orcid.org/0000-0003-1903-7914"},"institutions":[{"id":"https://openalex.org/I118946981","display_name":"Universidad de las Fuerzas Armadas ESPE","ror":"https://ror.org/05j136930","country_code":"EC","type":"education","lineage":["https://openalex.org/I118946981"]}],"countries":["EC"],"is_corresponding":false,"raw_author_name":"Theofilos Toulkeridis","raw_affiliation_strings":["Computer Sciences Department, Universidad de las Fuerzas Armadas ESPE, Sangolqui, Ecuador"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Sciences Department, Universidad de las Fuerzas Armadas ESPE, Sangolqui, Ecuador","institution_ids":["https://openalex.org/I118946981"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5040309664","display_name":"Ernesto P\u00e9rez","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ernesto Perez","raw_affiliation_strings":["Consortium for Advanced Internet Development, CEDIA, Cuenca, Ecuador"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Consortium for Advanced Internet Development, CEDIA, Cuenca, Ecuador","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.8414,"has_fulltext":false,"cited_by_count":11,"citation_normalized_percentile":{"value":0.77340853,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"8"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10400","display_name":"Network Security and Intrusion Detection","score":0.9990000128746033,"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"}},"topics":[{"id":"https://openalex.org/T10400","display_name":"Network Security and Intrusion Detection","score":0.9990000128746033,"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/T10734","display_name":"Information and Cyber Security","score":0.9929999709129333,"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"}},{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9894000291824341,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.8043839931488037},{"id":"https://openalex.org/keywords/malware","display_name":"Malware","score":0.7811935544013977},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7592815160751343},{"id":"https://openalex.org/keywords/computer-security","display_name":"Computer security","score":0.755496084690094},{"id":"https://openalex.org/keywords/botnet","display_name":"Botnet","score":0.6122027635574341},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.49528947472572327},{"id":"https://openalex.org/keywords/business-intelligence","display_name":"Business intelligence","score":0.4810776710510254},{"id":"https://openalex.org/keywords/intrusion-detection-system","display_name":"Intrusion detection system","score":0.47004690766334534},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.4649929106235504},{"id":"https://openalex.org/keywords/the-internet","display_name":"The Internet","score":0.4593214988708496},{"id":"https://openalex.org/keywords/data-breach","display_name":"Data breach","score":0.4210444986820221},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.21164271235466003},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.19849881529808044}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.8043839931488037},{"id":"https://openalex.org/C541664917","wikidata":"https://www.wikidata.org/wiki/Q14001","display_name":"Malware","level":2,"score":0.7811935544013977},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7592815160751343},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.755496084690094},{"id":"https://openalex.org/C22735295","wikidata":"https://www.wikidata.org/wiki/Q317671","display_name":"Botnet","level":3,"score":0.6122027635574341},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.49528947472572327},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.4810776710510254},{"id":"https://openalex.org/C35525427","wikidata":"https://www.wikidata.org/wiki/Q745881","display_name":"Intrusion detection system","level":2,"score":0.47004690766334534},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.4649929106235504},{"id":"https://openalex.org/C110875604","wikidata":"https://www.wikidata.org/wiki/Q75","display_name":"The Internet","level":2,"score":0.4593214988708496},{"id":"https://openalex.org/C165609540","wikidata":"https://www.wikidata.org/wiki/Q1172486","display_name":"Data breach","level":2,"score":0.4210444986820221},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.21164271235466003},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.19849881529808044},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.23919/spects.2017.8046771","is_oa":false,"landing_page_url":"https://doi.org/10.23919/spects.2017.8046771","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2017 International Symposium on Performance Evaluation of Computer and Telecommunication Systems (SPECTS)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","score":0.7799999713897705,"id":"https://metadata.un.org/sdg/16"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":32,"referenced_works":["https://openalex.org/W106726878","https://openalex.org/W271321322","https://openalex.org/W1823733140","https://openalex.org/W2031999883","https://openalex.org/W2070901481","https://openalex.org/W2077121139","https://openalex.org/W2078401208","https://openalex.org/W2078897006","https://openalex.org/W2108142795","https://openalex.org/W2251157814","https://openalex.org/W2296718798","https://openalex.org/W2331672670","https://openalex.org/W2395615675","https://openalex.org/W2460071091","https://openalex.org/W2498993573","https://openalex.org/W2507383779","https://openalex.org/W2533811343","https://openalex.org/W2536418942","https://openalex.org/W2541511557","https://openalex.org/W2547978208","https://openalex.org/W2549404987","https://openalex.org/W2557140617","https://openalex.org/W2558110944","https://openalex.org/W2564160651","https://openalex.org/W2617200927","https://openalex.org/W2617416222","https://openalex.org/W2728454403","https://openalex.org/W2972007171","https://openalex.org/W6609967695","https://openalex.org/W6697088366","https://openalex.org/W6729016501","https://openalex.org/W6729758775"],"related_works":["https://openalex.org/W208715492","https://openalex.org/W2771198651","https://openalex.org/W2929621094","https://openalex.org/W23190051","https://openalex.org/W2093401155","https://openalex.org/W2902215642","https://openalex.org/W3036889819","https://openalex.org/W2382121517","https://openalex.org/W2512673303","https://openalex.org/W1980110217"],"abstract_inverted_index":{"The":[0,156],"growth":[1],"and":[2,7,12,51,60,69,113,130,134,149,154,193],"evolution":[3],"of":[4,29,40,65,67,92,99,108,120,162,173,183,185],"threats,":[5],"vulnerabilities":[6],"cyber-attacks":[8],"increase":[9],"security":[10,66,101,125,184],"incidents":[11],"generate":[13],"negative":[14],"impacts":[15],"on":[16],"organizations.":[17],"We":[18],"present":[19],"an":[20],"online":[21],"analytical":[22],"processing":[23],"(OLAP)":[24],"system":[25],"for":[26],"early":[27,73,176],"alerts":[28,112],"upcoming":[30],"malicious":[31],"activities.":[32],"This":[33,103],"study":[34],"aims":[35],"to":[36,54,58,78,95,169],"systematize":[37],"the":[38,62,90,97,146,160,163,175,181,186,190],"support":[39,96],"cybersecurity":[41],"granted":[42],"by":[43,71],"a":[44,56,82,105,117],"Computer":[45],"Security":[46],"Incident":[47],"Response":[48],"Team":[49],"(CSIRT)":[50],"shall":[52],"help":[53],"establish":[55],"mechanism":[57],"analyze":[59],"improve":[61],"overall":[63],"level":[64,182],"networks":[68],"equipment":[70],"providing":[72],"warning":[74],"services.":[75],"In":[76],"order":[77],"accomplish":[79],"this":[80],"task,":[81],"Business":[83],"Intelligence":[84],"solution":[85],"has":[86],"been":[87],"developed":[88],"adapting":[89],"methodology":[91],"Ralph":[93],"Kimball":[94],"analysis":[98],"computer":[100],"incidents.":[102],"generates":[104],"data":[106,121,144],"warehouse":[107],"information":[109],"collected":[110],"from":[111,116,122],"events":[114],"recorded":[115],"continuous":[118],"transmission":[119],"various":[123],"Internet":[124],"sources":[126],"that":[127],"gather,":[128],"trace":[129],"report":[131],"malware,":[132],"botnet,":[133],"electronic":[135],"fraud.":[136],"Furthermore,":[137],"we":[138],"constructed":[139],"with":[140,171],"Pentaho":[141],"BI":[142],"load":[143],"into":[145],"dimensions,":[147],"measures":[148],"facts,":[150],"OLAP":[151],"cubes,":[152],"reports":[153],"dashboards.":[155],"acquired":[157],"results":[158],"demonstrate":[159],"functionality":[161],"application":[164],"where":[165],"it":[166],"is":[167],"possible":[168],"visualize":[170],"certainty":[172],"both,":[174],"warnings,":[177],"as":[178,180],"well":[179],"participant":[187],"Institutions,":[188],"about":[189],"registered":[191],"threats":[192],"vulnerabilities.":[194]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":3},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}