{"id":"https://openalex.org/W7130325631","doi":"https://doi.org/10.1109/access.2026.3665980","title":"A Secure and Efficient LLM-Based System for Natural Language Query-to-SQL Translation in IoT Data Management","display_name":"A Secure and Efficient LLM-Based System for Natural Language Query-to-SQL Translation in IoT Data Management","publication_year":2026,"publication_date":"2026-01-01","ids":{"openalex":"https://openalex.org/W7130325631","doi":"https://doi.org/10.1109/access.2026.3665980"},"language":null,"primary_location":{"id":"doi:10.1109/access.2026.3665980","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2026.3665980","pdf_url":null,"source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"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 Access","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1109/access.2026.3665980","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5032561737","display_name":"Mario San Emeterio de la Parte","orcid":"https://orcid.org/0000-0003-4182-8376"},"institutions":[{"id":"https://openalex.org/I88060688","display_name":"Universidad Polit\u00e9cnica de Madrid","ror":"https://ror.org/03n6nwv02","country_code":"ES","type":"education","lineage":["https://openalex.org/I88060688"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Mario San Emeterio De La Parte","raw_affiliation_strings":["Group of Next Generation Networks and Services (GRyS), Departamento de Ingeniería Telemática y Electrónica (DTE), Escuela Técnica Superior de Ingeniería y Sistemas de Telecomunicación, Universidad Politécnica de Madrid (UPM), Madrid, Spain"],"raw_orcid":"https://orcid.org/0000-0003-4182-8376","affiliations":[{"raw_affiliation_string":"Group of Next Generation Networks and Services (GRyS), Departamento de Ingeniería Telemática y Electrónica (DTE), Escuela Técnica Superior de Ingeniería y Sistemas de Telecomunicación, Universidad Politécnica de Madrid (UPM), Madrid, Spain","institution_ids":["https://openalex.org/I88060688"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Yiting Wang","orcid":"https://orcid.org/0009-0002-0203-7440"},"institutions":[{"id":"https://openalex.org/I88060688","display_name":"Universidad Polit\u00e9cnica de Madrid","ror":"https://ror.org/03n6nwv02","country_code":"ES","type":"education","lineage":["https://openalex.org/I88060688"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Yiting Wang","raw_affiliation_strings":["Group of Next Generation Networks and Services (GRyS), Departamento de Ingeniería Telemática y Electrónica (DTE), Escuela Técnica Superior de Ingeniería y Sistemas de Telecomunicación, Universidad Politécnica de Madrid (UPM), Madrid, Spain"],"raw_orcid":"https://orcid.org/0009-0002-0203-7440","affiliations":[{"raw_affiliation_string":"Group of Next Generation Networks and Services (GRyS), Departamento de Ingeniería Telemática y Electrónica (DTE), Escuela Técnica Superior de Ingeniería y Sistemas de Telecomunicación, Universidad Politécnica de Madrid (UPM), Madrid, Spain","institution_ids":["https://openalex.org/I88060688"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5126293878","display_name":"Jos\u00e9-Fern\u00e1n Mart\u00ednez-Ortega","orcid":null},"institutions":[{"id":"https://openalex.org/I88060688","display_name":"Universidad Polit\u00e9cnica de Madrid","ror":"https://ror.org/03n6nwv02","country_code":"ES","type":"education","lineage":["https://openalex.org/I88060688"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Jos\u00e9-Fern\u00e1n Mart\u00ednez-Ortega","raw_affiliation_strings":["Group of Next Generation Networks and Services (GRyS), Departamento de Ingeniería Telemática y Electrónica (DTE), Escuela Técnica Superior de Ingeniería y Sistemas de Telecomunicación, Universidad Politécnica de Madrid (UPM), Madrid, Spain"],"raw_orcid":"https://orcid.org/0000-0002-7635-4564","affiliations":[{"raw_affiliation_string":"Group of Next Generation Networks and Services (GRyS), Departamento de Ingeniería Telemática y Electrónica (DTE), Escuela Técnica Superior de Ingeniería y Sistemas de Telecomunicación, Universidad Politécnica de Madrid (UPM), Madrid, Spain","institution_ids":["https://openalex.org/I88060688"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5006177057","display_name":"N\u00e9stor Lucas Mart\u00ednez","orcid":"https://orcid.org/0000-0003-3333-4077"},"institutions":[{"id":"https://openalex.org/I88060688","display_name":"Universidad Polit\u00e9cnica de Madrid","ror":"https://ror.org/03n6nwv02","country_code":"ES","type":"education","lineage":["https://openalex.org/I88060688"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"N\u00e9stor Lucas Mart\u00ednez","raw_affiliation_strings":["Group of Next Generation Networks and Services (GRyS), Departamento de Ingeniería Telemática y Electrónica (DTE), Escuela Técnica Superior de Ingeniería y Sistemas de Telecomunicación, Universidad Politécnica de Madrid (UPM), Madrid, Spain"],"raw_orcid":"https://orcid.org/0000-0003-3333-4077","affiliations":[{"raw_affiliation_string":"Group of Next Generation Networks and Services (GRyS), Departamento de Ingeniería Telemática y Electrónica (DTE), Escuela Técnica Superior de Ingeniería y Sistemas de Telecomunicación, Universidad Politécnica de Madrid (UPM), Madrid, Spain","institution_ids":["https://openalex.org/I88060688"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I88060688"],"apc_list":{"value":1850,"currency":"USD","value_usd":1850},"apc_paid":{"value":1850,"currency":"USD","value_usd":1850},"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.16527484,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"14","issue":null,"first_page":"28435","last_page":"28456"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.17409999668598175,"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"}},"topics":[{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.17409999668598175,"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"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.11640000343322754,"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"}},{"id":"https://openalex.org/T14347","display_name":"Big Data and Digital Economy","score":0.1151999980211258,"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/sql","display_name":"SQL","score":0.6335999965667725},{"id":"https://openalex.org/keywords/executable","display_name":"Executable","score":0.5946000218391418},{"id":"https://openalex.org/keywords/leverage","display_name":"Leverage (statistics)","score":0.5544999837875366},{"id":"https://openalex.org/keywords/middleware","display_name":"Middleware (distributed applications)","score":0.5358999967575073},{"id":"https://openalex.org/keywords/data-access","display_name":"Data access","score":0.4343000054359436},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.4230000078678131},{"id":"https://openalex.org/keywords/authentication","display_name":"Authentication (law)","score":0.36169999837875366},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.3580000102519989},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.3544999957084656}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8924999833106995},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6335999965667725},{"id":"https://openalex.org/C160145156","wikidata":"https://www.wikidata.org/wiki/Q778586","display_name":"Executable","level":2,"score":0.5946000218391418},{"id":"https://openalex.org/C153083717","wikidata":"https://www.wikidata.org/wiki/Q6535263","display_name":"Leverage (statistics)","level":2,"score":0.5544999837875366},{"id":"https://openalex.org/C169468491","wikidata":"https://www.wikidata.org/wiki/Q146923","display_name":"Middleware (distributed applications)","level":2,"score":0.5358999967575073},{"id":"https://openalex.org/C47487241","wikidata":"https://www.wikidata.org/wiki/Q5227230","display_name":"Data access","level":2,"score":0.4343000054359436},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.4230000078678131},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3968000113964081},{"id":"https://openalex.org/C148417208","wikidata":"https://www.wikidata.org/wiki/Q4825882","display_name":"Authentication (law)","level":2,"score":0.36169999837875366},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.3580000102519989},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.3544999957084656},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.3393999934196472},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.3334999978542328},{"id":"https://openalex.org/C1668388","wikidata":"https://www.wikidata.org/wiki/Q1149776","display_name":"Data management","level":2,"score":0.32109999656677246},{"id":"https://openalex.org/C100776233","wikidata":"https://www.wikidata.org/wiki/Q2532492","display_name":"Bridge (graph theory)","level":2,"score":0.3167000114917755},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.2987000048160553},{"id":"https://openalex.org/C61871575","wikidata":"https://www.wikidata.org/wiki/Q384093","display_name":"Master data","level":2,"score":0.28540000319480896},{"id":"https://openalex.org/C56288433","wikidata":"https://www.wikidata.org/wiki/Q58673","display_name":"Data manipulation language","level":2,"score":0.2849999964237213},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.28349998593330383},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.2736999988555908},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.2736999988555908},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.2727000117301941},{"id":"https://openalex.org/C90312973","wikidata":"https://www.wikidata.org/wiki/Q7449052","display_name":"Semantic data model","level":2,"score":0.27070000767707825},{"id":"https://openalex.org/C53619493","wikidata":"https://www.wikidata.org/wiki/Q4787093","display_name":"Architecture framework","level":3,"score":0.2669000029563904},{"id":"https://openalex.org/C41009113","wikidata":"https://www.wikidata.org/wiki/Q54871","display_name":"SPARQL","level":4,"score":0.26440000534057617},{"id":"https://openalex.org/C100463513","wikidata":"https://www.wikidata.org/wiki/Q5227322","display_name":"Data model (GIS)","level":2,"score":0.2583000063896179},{"id":"https://openalex.org/C174252522","wikidata":"https://www.wikidata.org/wiki/Q3816772","display_name":"Natural language user interface","level":3,"score":0.2515000104904175},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.25060001015663147},{"id":"https://openalex.org/C10511746","wikidata":"https://www.wikidata.org/wiki/Q899388","display_name":"Data security","level":3,"score":0.25029999017715454}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/access.2026.3665980","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2026.3665980","pdf_url":null,"source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"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 Access","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1109/access.2026.3665980","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2026.3665980","pdf_url":null,"source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"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 Access","raw_type":"journal-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","score":0.7060027718544006,"display_name":"Peace, Justice and strong institutions"}],"awards":[{"id":"https://openalex.org/G4399102661","display_name":null,"funder_award_id":"857202","funder_id":"https://openalex.org/F4320338339","funder_display_name":"H2020 Leadership in Enabling and Industrial Technologies"}],"funders":[{"id":"https://openalex.org/F4320338339","display_name":"H2020 Leadership in Enabling and Industrial Technologies","ror":null}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Structured":[0],"data":[1,182],"embodies":[2],"vast":[3],"reservoirs":[4],"of":[5,141,176],"actionable":[6],"knowledge,":[7],"yet":[8],"non-technical":[9],"users":[10],"often":[11],"lack":[12],"the":[13,64,93,135,148,165,174],"tools":[14],"to":[15,36,119,179],"effectively":[16],"access":[17,78,183],"or":[18],"leverage":[19],"these":[20],"resources.":[21],"This":[22],"paper":[23],"presents":[24],"a":[25,58,68],"novel":[26],"middleware":[27,178],"system":[28,66],"architecture":[29],"that":[30,131],"harnesses":[31],"Large":[32],"Language":[33],"Models":[34],"(LLMs)":[35],"translate":[37],"natural":[38],"language":[39],"queries":[40],"(NLQs)":[41],"into":[42],"executable":[43],"SQL":[44],"statements,":[45],"enabling":[46],"seamless":[47],"interaction":[48],"with":[49],"relational":[50],"databases":[51],"without":[52],"requiring":[53],"technical":[54],"expertise.":[55],"To":[56],"bridge":[57],"critical":[59],"gap":[60],"in":[61,139],"existing":[62],"research,":[63],"proposed":[65],"integrates":[67],"robust":[69],"security":[70],"framework":[71],"featuring":[72],"multi-factor":[73],"authentication":[74],"and":[75,101,113,125,170,184],"fine-grained,":[76],"role-based":[77],"control.":[79],"A":[80],"comprehensive":[81],"evaluation":[82,109],"was":[83],"conducted":[84],"using":[85],"over":[86],"813,000":[87],"real":[88],"spatio-temporal":[89],"IoT":[90],"samples":[91],"from":[92],"H2020-AFarCloud":[94],"international":[95],"project,":[96],"comparing":[97],"both":[98],"general-purpose":[99],"LLMs":[100],"models":[102],"fine-tuned":[103],"for":[104],"NLQ-to-SQL":[105],"translation.":[106],"Two":[107],"complementary":[108],"metrics\u2014Execution":[110],"Accuracy":[111],"(EX)":[112],"Valid":[114],"Efficiency":[115],"Score":[116],"(VES)\u2014were":[117],"employed":[118],"assess":[120],"syntactic":[121],"correctness,":[122],"semantic":[123],"fidelity,":[124],"runtime":[126],"efficiency.":[127],"Experimental":[128],"results":[129],"show":[130],"GPT-o3":[132],"mini-high":[133],"achieves":[134],"highest":[136],"overall":[137],"performance":[138,160],"terms":[140],"average":[142],"VES,":[143],"while":[144],"DeepSeek":[145],"R1":[146],"exhibits":[147],"most":[149],"consistent":[150],"behavior":[151],"across":[152],"heterogeneous":[153],"query":[154],"scenarios,":[155],"as":[156],"reflected":[157],"by":[158],"lower":[159],"variability.":[161],"These":[162],"findings":[163],"underscore":[164],"interplay":[166],"between":[167],"model":[168],"capability":[169],"computational":[171],"efficiency,":[172],"demonstrating":[173],"potential":[175],"LLM-driven":[177],"democratize":[180],"structured":[181],"enhance":[185],"data-driven":[186],"decision-making.":[187]},"counts_by_year":[],"updated_date":"2026-02-27T06:17:20.405678","created_date":"2026-02-19T00:00:00"}