{"id":"https://openalex.org/W4367675809","doi":"https://doi.org/10.33333/rp.vol51n2.02","title":"Using Data Mining Techniques for the Detection of SQL Injection Attacks on Database Systems","display_name":"Using Data Mining Techniques for the Detection of SQL Injection Attacks on Database Systems","publication_year":2023,"publication_date":"2023-05-01","ids":{"openalex":"https://openalex.org/W4367675809","doi":"https://doi.org/10.33333/rp.vol51n2.02"},"language":"en","primary_location":{"id":"doi:10.33333/rp.vol51n2.02","doi":"https://doi.org/10.33333/rp.vol51n2.02","is_oa":true,"landing_page_url":"https://doi.org/10.33333/rp.vol51n2.02","pdf_url":"https://revistapolitecnica.epn.edu.ec/ojs2/index.php/revista_politecnica2/article/download/1365/615","source":{"id":"https://openalex.org/S4210220075","display_name":"Revista Polit\u00e9cnica","issn_l":"1390-0129","issn":["1390-0129","2477-8990"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["doaj","latindex","poland-20","russia-white-list-4","scielo"],"host_organization":"https://openalex.org/P4310318826","host_organization_name":"National Polytechnic School","host_organization_lineage":["https://openalex.org/P4310318826"],"host_organization_lineage_names":["National Polytechnic School"],"type":"journal"},"license":"cc-by-nc-sa","license_id":"https://openalex.org/licenses/cc-by-nc-sa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Revista Polit\u00e9cnica","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://revistapolitecnica.epn.edu.ec/ojs2/index.php/revista_politecnica2/article/download/1365/615","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5048062265","display_name":"Cesar A\u00f1asco Loor","orcid":"https://orcid.org/0000-0002-0156-3281","observed_orcids":["https://orcid.org/0000-0002-0156-3281"]},"institutions":[{"id":"https://openalex.org/I70764802","display_name":"National Polytechnic School","ror":"https://ror.org/01gb99w41","country_code":"EC","type":"education","lineage":["https://openalex.org/I70764802"]}],"countries":["EC"],"is_corresponding":false,"raw_author_name":"Cesar A\u00f1asco Loor","raw_affiliation_strings":["Escuela Polit\u00e9cnica Nacional"],"raw_orcid":"https://orcid.org/0000-0002-0156-3281","affiliations":[{"raw_affiliation_string":"Escuela Polit\u00e9cnica Nacional","institution_ids":["https://openalex.org/I70764802"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5014994822","display_name":"Karen Morocho","orcid":"https://orcid.org/0000-0003-2042-5711","observed_orcids":["https://orcid.org/0000-0003-2042-5711"]},"institutions":[{"id":"https://openalex.org/I70764802","display_name":"National Polytechnic School","ror":"https://ror.org/01gb99w41","country_code":"EC","type":"education","lineage":["https://openalex.org/I70764802"]}],"countries":["EC"],"is_corresponding":false,"raw_author_name":"Karen Morocho","raw_affiliation_strings":["Escuela Polit\u00e9cnica Nacional"],"raw_orcid":"https://orcid.org/0000-0003-2042-5711","affiliations":[{"raw_affiliation_string":"Escuela Polit\u00e9cnica Nacional","institution_ids":["https://openalex.org/I70764802"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5045275535","display_name":"Mar\u00eda Hallo","orcid":"https://orcid.org/0000-0002-6718-0603","observed_orcids":["https://orcid.org/0000-0002-6718-0603"]},"institutions":[{"id":"https://openalex.org/I70764802","display_name":"National Polytechnic School","ror":"https://ror.org/01gb99w41","country_code":"EC","type":"education","lineage":["https://openalex.org/I70764802"]}],"countries":["EC"],"is_corresponding":false,"raw_author_name":"Mar\u00eda Hallo","raw_affiliation_strings":["Escuela Polit\u00e9cnica Nacional"],"raw_orcid":"https://orcid.org/0000-0002-6718-0603","affiliations":[{"raw_affiliation_string":"Escuela Polit\u00e9cnica Nacional","institution_ids":["https://openalex.org/I70764802"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I70764802"],"apc_list":null,"apc_paid":null,"fwci":0.1791,"has_fulltext":true,"cited_by_count":1,"citation_normalized_percentile":{"value":0.50587764,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":93},"biblio":{"volume":"51","issue":"2","first_page":"19","last_page":"28"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12479","display_name":"Web Application Security Vulnerabilities","score":0.8295999765396118,"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"}},"topics":[{"id":"https://openalex.org/T12479","display_name":"Web Application Security Vulnerabilities","score":0.8295999765396118,"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/T10400","display_name":"Network Security and Intrusion Detection","score":0.14499999582767487,"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/T11689","display_name":"Adversarial Robustness in Machine Learning","score":0.0044999998062849045,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/sql-injection","display_name":"SQL injection","score":0.9039999842643738},{"id":"https://openalex.org/keywords/attack-detection","display_name":"attack detection","score":0.7409999966621399},{"id":"https://openalex.org/keywords/database-security","display_name":"database security","score":0.8690000176429749},{"id":"https://openalex.org/keywords/anomaly-detection","display_name":"anomaly detection","score":0.6809999942779541},{"id":"https://openalex.org/keywords/k-nearest-neighbor-clustering","display_name":"k-nearest neighbor clustering","score":0.8579999804496765},{"id":"https://openalex.org/keywords/transaction-logs","display_name":"transaction logs","score":0.6420000195503235},{"id":"https://openalex.org/keywords/postgresql","display_name":"PostgreSQL","score":0.9879999756813049},{"id":"https://openalex.org/keywords/web-application-security","display_name":"web application security","score":0.621999979019165},{"id":"https://openalex.org/keywords/crisp-dm","display_name":"CRISP-DM","score":0.7329999804496765}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8156111240386963},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6147043704986572},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.5369102358818054},{"id":"https://openalex.org/C2212953","wikidata":"https://www.wikidata.org/wiki/Q948454","display_name":"Transaction log","level":3,"score":0.5229530930519104},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5176644921302795},{"id":"https://openalex.org/C519991488","wikidata":"https://www.wikidata.org/wiki/Q28865","display_name":"Python (programming language)","level":2,"score":0.4528428614139557},{"id":"https://openalex.org/C179518139","wikidata":"https://www.wikidata.org/wiki/Q5140297","display_name":"Coding (social sciences)","level":2,"score":0.4380049705505371},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4097887873649597},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.35132890939712524},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.3160449266433716},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2812546491622925},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.19344300031661987},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.1062520444393158},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.10122710466384888},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.33333/rp.vol51n2.02","doi":"https://doi.org/10.33333/rp.vol51n2.02","is_oa":true,"landing_page_url":"https://doi.org/10.33333/rp.vol51n2.02","pdf_url":"https://revistapolitecnica.epn.edu.ec/ojs2/index.php/revista_politecnica2/article/download/1365/615","source":{"id":"https://openalex.org/S4210220075","display_name":"Revista Polit\u00e9cnica","issn_l":"1390-0129","issn":["1390-0129","2477-8990"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["doaj","latindex","poland-20","russia-white-list-4","scielo"],"host_organization":"https://openalex.org/P4310318826","host_organization_name":"National Polytechnic School","host_organization_lineage":["https://openalex.org/P4310318826"],"host_organization_lineage_names":["National Polytechnic School"],"type":"journal"},"license":"cc-by-nc-sa","license_id":"https://openalex.org/licenses/cc-by-nc-sa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Revista Polit\u00e9cnica","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.33333/rp.vol51n2.02","doi":"https://doi.org/10.33333/rp.vol51n2.02","is_oa":true,"landing_page_url":"https://doi.org/10.33333/rp.vol51n2.02","pdf_url":"https://revistapolitecnica.epn.edu.ec/ojs2/index.php/revista_politecnica2/article/download/1365/615","source":{"id":"https://openalex.org/S4210220075","display_name":"Revista Polit\u00e9cnica","issn_l":"1390-0129","issn":["1390-0129","2477-8990"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["doaj","latindex","poland-20","russia-white-list-4","scielo"],"host_organization":"https://openalex.org/P4310318826","host_organization_name":"National Polytechnic School","host_organization_lineage":["https://openalex.org/P4310318826"],"host_organization_lineage_names":["National Polytechnic School"],"type":"journal"},"license":"cc-by-nc-sa","license_id":"https://openalex.org/licenses/cc-by-nc-sa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Revista Polit\u00e9cnica","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4367675809.pdf","grobid_xml":"https://content.openalex.org/works/W4367675809.grobid-xml"},"referenced_works_count":15,"referenced_works":["https://openalex.org/W1986501246","https://openalex.org/W2014712522","https://openalex.org/W2036739077","https://openalex.org/W2119738171","https://openalex.org/W2145332315","https://openalex.org/W2150676350","https://openalex.org/W2163295856","https://openalex.org/W2338499078","https://openalex.org/W2897702322","https://openalex.org/W2921165666","https://openalex.org/W2946913466","https://openalex.org/W2979012297","https://openalex.org/W3006810906","https://openalex.org/W3033055162","https://openalex.org/W3096148397"],"related_works":["https://openalex.org/W3193468924","https://openalex.org/W2148488647","https://openalex.org/W2095293449","https://openalex.org/W4229009001","https://openalex.org/W7128907248","https://openalex.org/W2999058564","https://openalex.org/W2520281245","https://openalex.org/W2339647006","https://openalex.org/W2088033145","https://openalex.org/W3091136590"],"abstract_inverted_index":{"In":[0],"any":[1],"business":[2],"organization,":[3],"database":[4,139],"infrastructures":[5],"are":[6],"subject":[7],"to":[8,39,107,118],"various":[9],"structured":[10],"query":[11,98],"language":[12],"(SQL)":[13],"injection":[14,46,150],"attacks,":[15],"such":[16],"as":[17],"tautologies,":[18],"alternative":[19],"coding,":[20],"stored":[21],"procedures,":[22],"use":[23],"of":[24,43,57,69,123,136,146,151],"the":[25,41,58,90,103,120,124,133,144,174],"union":[26],"operator,":[27],"piggyback,":[28],"among":[29],"others.":[30],"This":[31],"article":[32],"describes":[33],"a":[34,137,162,171],"data":[35,63],"mining":[36,64],"project":[37,51],"developed":[38],"mitigate":[40],"problem":[42],"identifying":[44],"SQL":[45,152],"attacks":[47,125,148],"on":[48],"databases.":[49],"The":[50,80,97,127,156],"was":[52,73,84,100,116,130,166],"conducted":[53],"using":[54,87,170],"an":[55],"adaptation":[56],"cross-industry":[59],"standard":[60],"process":[61],"for":[62,75,102,159],"(CRISP-DM)":[65],"methodology.":[66],"A":[67,113],"total":[68],"12":[70],"python":[71],"libraries":[72],"used":[74],"cleaning,":[76],"transformation,":[77],"and":[78,185],"modeling.":[79],"anomaly":[81],"detection":[82],"model":[83],"carried":[85],"out":[86],"clustering":[88],"by":[89,149],"k":[91],"\u2013":[92],"nearest":[93],"neighbors":[94],"(kNN)":[95],"algorithm.":[96],"text":[99],"analyzed":[101],"groups":[104],"with":[105,173],"anomalies":[106],"identify":[108],"sentences":[109],"presenting":[110],"attack":[111],"traces.":[112],"web":[114],"interface":[115],"implemented":[117],"display":[119],"daily":[121],"summary":[122],"found.":[126],"information":[128],"source":[129],"obtained":[131],"from":[132],"transactions":[134],"log":[135,165],"PostgreSQL":[138],"server.":[140],"Our":[141],"results":[142],"allowed":[143],"identification":[145],"different":[147],"code":[153],"above":[154],"80%.":[155],"execution":[157],"time":[158],"processing":[160],"half":[161],"million":[163],"transaction":[164],"approximately":[167],"60":[168],"minutes":[169],"computer":[172],"following":[175],"characteristics:":[176],"Intel\u00ae":[177],"Core":[178],"i7":[179],"processor":[180],"7th":[181],"generation,":[182],"12GB":[183],"RAM":[184],"500GB":[186],"SSD.":[187]},"counts_by_year":[{"year":2025,"cited_by_count":1}],"updated_date":"2026-11-13T13:42:25.865203","created_date":"2023-05-03T00:00:00"}