{"id":"https://openalex.org/W3217411715","doi":"https://doi.org/10.1109/tr.2021.3124331","title":"Semantic Query-Featured Ensemble Learning Model for SQL-Injection Attack Detection in IoT-Ecosystems","display_name":"Semantic Query-Featured Ensemble Learning Model for SQL-Injection Attack Detection in IoT-Ecosystems","publication_year":2021,"publication_date":"2021-11-23","ids":{"openalex":"https://openalex.org/W3217411715","doi":"https://doi.org/10.1109/tr.2021.3124331","mag":"3217411715"},"language":"en","primary_location":{"id":"doi:10.1109/tr.2021.3124331","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tr.2021.3124331","pdf_url":null,"source":{"id":"https://openalex.org/S87725633","display_name":"IEEE Transactions on Reliability","issn_l":"0018-9529","issn":["0018-9529","1558-1721"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Reliability","raw_type":"journal-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":null,"display_name":"Gowtham M","orcid":"https://orcid.org/0000-0001-9743-5358"},"institutions":[{"id":"https://openalex.org/I65674248","display_name":"Visvesvaraya Technological University","ror":"https://ror.org/00ha14p11","country_code":"IN","type":"education","lineage":["https://openalex.org/I65674248"]}],"countries":["IN"],"is_corresponding":true,"raw_author_name":"Gowtham M","raw_affiliation_strings":["Visvesvaraya Technological University, Belagavi, India","Department of Computer Science and Engineering, Rajeev Institute of Technology, Hassan, India"],"raw_orcid":"https://orcid.org/0000-0001-9743-5358","affiliations":[{"raw_affiliation_string":"Visvesvaraya Technological University, Belagavi, India","institution_ids":["https://openalex.org/I65674248"]},{"raw_affiliation_string":"Department of Computer Science and Engineering, Rajeev Institute of Technology, Hassan, India","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5071185120","display_name":"H B Pramod","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Pramod H B","raw_affiliation_strings":["Department of Computer Science and Engineering, Rajeev Institute of Technology, Hassan, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Engineering, Rajeev Institute of Technology, Hassan, India","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I65674248"],"apc_list":null,"apc_paid":null,"fwci":12.7984,"has_fulltext":false,"cited_by_count":59,"citation_normalized_percentile":{"value":0.98694963,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":100},"biblio":{"volume":"71","issue":"2","first_page":"1057","last_page":"1074"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12479","display_name":"Web Application Security Vulnerabilities","score":0.998199999332428,"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.998199999332428,"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.9900000095367432,"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/T11241","display_name":"Advanced Malware Detection Techniques","score":0.9800000190734863,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.898996114730835},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.6473284959793091},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6149609088897705},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5860458612442017},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.5601267218589783},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.49546682834625244},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.4952315390110016},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.47542932629585266},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.40559956431388855},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.39630040526390076},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.38054198026657104},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.29054585099220276},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.09611088037490845}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.898996114730835},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.6473284959793091},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6149609088897705},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5860458612442017},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.5601267218589783},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.49546682834625244},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.4952315390110016},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.47542932629585266},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.40559956431388855},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.39630040526390076},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.38054198026657104},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.29054585099220276},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.09611088037490845}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tr.2021.3124331","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tr.2021.3124331","pdf_url":null,"source":{"id":"https://openalex.org/S87725633","display_name":"IEEE Transactions on Reliability","issn_l":"0018-9529","issn":["0018-9529","1558-1721"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Reliability","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":59,"referenced_works":["https://openalex.org/W1612741463","https://openalex.org/W1978584859","https://openalex.org/W1980276147","https://openalex.org/W1985424295","https://openalex.org/W1988033384","https://openalex.org/W2004684124","https://openalex.org/W2022597053","https://openalex.org/W2041243407","https://openalex.org/W2060995180","https://openalex.org/W2064703126","https://openalex.org/W2067195038","https://openalex.org/W2079120681","https://openalex.org/W2131723927","https://openalex.org/W2171965795","https://openalex.org/W2180416324","https://openalex.org/W2246779271","https://openalex.org/W2247541406","https://openalex.org/W2406349003","https://openalex.org/W2468256555","https://openalex.org/W2493348813","https://openalex.org/W2495778067","https://openalex.org/W2517094560","https://openalex.org/W2528169216","https://openalex.org/W2559495752","https://openalex.org/W2594223590","https://openalex.org/W2735916625","https://openalex.org/W2736668610","https://openalex.org/W2740052274","https://openalex.org/W2766636994","https://openalex.org/W2767518476","https://openalex.org/W2769204985","https://openalex.org/W2773521981","https://openalex.org/W2780416612","https://openalex.org/W2782994466","https://openalex.org/W2783309654","https://openalex.org/W2787223421","https://openalex.org/W2800306076","https://openalex.org/W2905032193","https://openalex.org/W2908909566","https://openalex.org/W2923928864","https://openalex.org/W2940381459","https://openalex.org/W2945594226","https://openalex.org/W2951694401","https://openalex.org/W2957734310","https://openalex.org/W2963314580","https://openalex.org/W2978612193","https://openalex.org/W2994290762","https://openalex.org/W2997326948","https://openalex.org/W2998114121","https://openalex.org/W2999058564","https://openalex.org/W3010537694","https://openalex.org/W3015185939","https://openalex.org/W3015471529","https://openalex.org/W3037565679","https://openalex.org/W3047291452","https://openalex.org/W3088149887","https://openalex.org/W3089043621","https://openalex.org/W3095371060","https://openalex.org/W4234640314"],"related_works":["https://openalex.org/W2026738364","https://openalex.org/W2572349046","https://openalex.org/W2901901036","https://openalex.org/W8514837","https://openalex.org/W2388669825","https://openalex.org/W4381740310","https://openalex.org/W2955368753","https://openalex.org/W227397245","https://openalex.org/W2363027842","https://openalex.org/W2406556739"],"abstract_inverted_index":{"Structured":[0],"query":[1,175,179,208],"language":[2],"(SQL)":[3],"has":[4,55],"emerged":[5],"as":[6,176,239,328],"one":[7],"of":[8,16,47,70,79,84,112,191,212,244,310,338,346],"the":[9,45,52,71,95,101,105,113,130,177,181,242,268,283,304,329,332,339],"most":[10,111],"used":[11],"databases,":[12],"serving":[13],"an":[14,168],"array":[15],"Internet-of-Things":[17],"(IoTs)-enabled":[18],"services":[19],"including":[20],"web-transactions,":[21],"grid":[22],"networks,":[23],"industrial":[24],"activity":[25],"log":[26],"and":[27,90,108,195,215,223,246,261,275],"proactive":[28],"decision":[29],"systems,":[30],"smart-home,":[31],"financial":[32],"transactions,":[33],"business":[34],"communication":[35],"etc.":[36],"With":[37],"high":[38],"pace":[39],"increase":[40],"in":[41,77,344],"SQL-driven":[42,358],"IoT":[43],"applications,":[44],"threat":[46],"SQL-injection":[48],"attacks":[49],"(SQLIAs)":[50],"at":[51],"middleware":[53],"layer":[54],"increased":[56],"significantly.":[57],"To":[58,117,248],"address":[59],"such":[60,119],"issues,":[61],"machine":[62],"learning-based":[63,115],"SQLIA-prediction":[64,157],"systems":[65],"are":[66,74],"proposed;":[67],"however,":[68],"majority":[69],"existing":[72],"methods":[73],"found":[75],"limited":[76],"terms":[78,345],"intrusion":[80],"detection":[81],"accuracy":[82,347],"because":[83],"their":[85],"complete-reliance":[86],"on":[87,124],"structural":[88],"features":[89,127,162,226,232,285],"inferior":[91],"learning":[92,143,170,291,298],"model(s).":[93],"On":[94],"contrary,":[96],"intruders":[97],"these":[98],"days":[99],"intrude":[100],"system":[102],"by":[103],"mimicking":[104],"normal":[106,178],"queries":[107],"hence":[109],"confuses":[110],"classical":[114,149],"methods.":[116],"alleviate":[118,241,249],"problems,":[120],"this":[121],"article":[122],"emphasizes":[123],"exploiting":[125],"semantic":[126,140,161,225],"along":[128],"with":[129],"state-of-art":[131,294],"highly":[132],"robust":[133,139,295],"computing":[134],"environment.":[135],"We":[136],"proposed":[137,156,305,322,340],"a":[138,293,308],"query-featured":[141],"ensemble":[142,169,297],"model":[144,158,171,343],"for":[145,235,290],"SQLIA":[146,182,341],"prediction.":[147,320],"Unlike":[148,300],"(query's)":[150],"template-matching":[151],"or":[152,180,331],"term-assessment-based":[153],"methods,":[154],"our":[155],"exploits":[159],"latent":[160],"from":[163,227],"large":[164,189],"SQL-queries":[165,192],"to":[166,240,272,315],"train":[167],"that":[172],"classifies":[173],"each":[174,207,228,326],"query.":[183],"Functionally,":[184],"it":[185,200],"performs":[186],"preprocessing":[187],"over":[188,206,267,282],"set":[190,309],"using":[193,209,292],"count-vectorizer":[194],"stopping":[196],"word":[197],"removal.":[198],"Subsequently,":[199],"applies":[201],"Word2Vec":[202],"feature":[203,253],"extraction":[204],"method":[205,324],"continuous":[210],"bag":[211],"words":[213],"(CBOW)":[214],"N-skip":[216],"gram":[217],"(SKG)":[218],"algorithms,":[219],"which":[220,286],"obtained":[221],"CBOW":[222],"SKG":[224],"SQL-query.":[229],"The":[230,321],"extracted":[231],"were":[233,265,287],"processed":[234,289],"data":[236],"resampling":[237],"so":[238],"problem":[243],"class-imbalance":[245],"skewness.":[247],"redundant":[250],"computation,":[251],"two":[252],"selection":[254],"algorithms":[255],"named":[256],"Mann-Whitney":[257],"significance":[258],"predictor":[259],"test":[260],"principal":[262],"component":[263],"analysis":[264],"applied":[266],"resampled":[269],"features.":[270],"Moreover,":[271],"eliminate":[273],"over-fitting":[274],"convergence":[276],"problem,":[277],"Min-Max":[278],"normalization":[279],"was":[280],"performed":[281],"selected":[284],"later":[288],"heterogeneous":[296],"model.":[299],"standalone":[301],"classifier-based":[302],"SQLIA,":[303],"learning-model":[306],"employed":[307],"nine":[311],"base":[312],"classifiers":[313],"designed":[314],"serve":[316],"maximum":[317],"voting":[318],"ensemble-based":[319],"ensemble-learning":[323],"classified":[325],"SQL-query":[327],"normal-query":[330],"SQLIA-query.":[333],"Simulation":[334],"results":[335],"affirmed":[336],"superiority":[337],"prediction":[342],"(98%),":[348],"F-Score":[349],"(0.989),":[350],"AUC":[351],"(0.999)":[352],"signifying":[353],"its":[354],"efficacy":[355],"toward":[356],"real-world":[357],"IoT-ecosystems.":[359]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":13},{"year":2024,"cited_by_count":17},{"year":2023,"cited_by_count":22},{"year":2022,"cited_by_count":6}],"updated_date":"2026-05-08T15:41:06.802602","created_date":"2025-10-10T00:00:00"}
