{"id":"https://openalex.org/W4414432667","doi":"https://doi.org/10.1109/case58245.2025.11163844","title":"Automated SQL Query Generation for an Intelligent Sewer Management System Using Large Language Models","display_name":"Automated SQL Query Generation for an Intelligent Sewer Management System Using Large Language Models","publication_year":2025,"publication_date":"2025-08-17","ids":{"openalex":"https://openalex.org/W4414432667","doi":"https://doi.org/10.1109/case58245.2025.11163844"},"language":"en","primary_location":{"id":"doi:10.1109/case58245.2025.11163844","is_oa":false,"landing_page_url":"https://doi.org/10.1109/case58245.2025.11163844","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2025 IEEE 21st International Conference on Automation Science and Engineering (CASE)","raw_type":"proceedings-article"},"type":"conference-paper","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/A5119704157","display_name":"Dharmendra Reddy Chitte","orcid":null},"institutions":[{"id":"https://openalex.org/I115475287","display_name":"Oklahoma State University","ror":"https://ror.org/01g9vbr38","country_code":"US","type":"education","lineage":["https://openalex.org/I115475287"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Dharmendra Reddy Chitte","raw_affiliation_strings":["Oklahoma State University,Dharmendra Reddy Chitte is With the Computer Science Department,Stillwater,OK,USA,74078"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oklahoma State University,Dharmendra Reddy Chitte is With the Computer Science Department,Stillwater,OK,USA,74078","institution_ids":["https://openalex.org/I115475287"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5045461895","display_name":"Fei Liang","orcid":"https://orcid.org/0000-0002-3617-8244"},"institutions":[{"id":"https://openalex.org/I115475287","display_name":"Oklahoma State University","ror":"https://ror.org/01g9vbr38","country_code":"US","type":"education","lineage":["https://openalex.org/I115475287"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Fei Liang","raw_affiliation_strings":["School of Electrical and Computer Engineering, Oklahoma State University,Stillwater,OK,USA,74078"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Electrical and Computer Engineering, Oklahoma State University,Stillwater,OK,USA,74078","institution_ids":["https://openalex.org/I115475287"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5090289368","display_name":"Weihua Sheng","orcid":"https://orcid.org/0000-0003-2214-0373"},"institutions":[{"id":"https://openalex.org/I115475287","display_name":"Oklahoma State University","ror":"https://ror.org/01g9vbr38","country_code":"US","type":"education","lineage":["https://openalex.org/I115475287"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Weihua Sheng","raw_affiliation_strings":["School of Electrical and Computer Engineering, Oklahoma State University,Stillwater,OK,USA,74078"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Electrical and Computer Engineering, Oklahoma State University,Stillwater,OK,USA,74078","institution_ids":["https://openalex.org/I115475287"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5007385399","display_name":"Yongwei Shan","orcid":"https://orcid.org/0000-0001-5918-042X"},"institutions":[{"id":"https://openalex.org/I115475287","display_name":"Oklahoma State University","ror":"https://ror.org/01g9vbr38","country_code":"US","type":"education","lineage":["https://openalex.org/I115475287"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yongwei Shan","raw_affiliation_strings":["School of Civil and Environmental Engineering, Oklahoma State University,Stillwater,OK,USA,74078"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Civil and Environmental Engineering, Oklahoma State University,Stillwater,OK,USA,74078","institution_ids":["https://openalex.org/I115475287"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5051408948","display_name":"Hossein Khaleghian","orcid":null},"institutions":[{"id":"https://openalex.org/I115475287","display_name":"Oklahoma State University","ror":"https://ror.org/01g9vbr38","country_code":"US","type":"education","lineage":["https://openalex.org/I115475287"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Hossein Khaleghian","raw_affiliation_strings":["InfraTie Solutions, LLC.,Stillwater,OK,USA,74074"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"InfraTie Solutions, LLC.,Stillwater,OK,USA,74074","institution_ids":["https://openalex.org/I115475287"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I115475287"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"3339","last_page":"3344"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T14427","display_name":"Environmental Monitoring and Data Management","score":0.6485000252723694,"subfield":{"id":"https://openalex.org/subfields/1907","display_name":"Geology"},"field":{"id":"https://openalex.org/fields/19","display_name":"Earth and Planetary Sciences"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T14427","display_name":"Environmental Monitoring and Data Management","score":0.6485000252723694,"subfield":{"id":"https://openalex.org/subfields/1907","display_name":"Geology"},"field":{"id":"https://openalex.org/fields/19","display_name":"Earth and Planetary Sciences"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12601","display_name":"Web Applications and Data Management","score":0.6183000206947327,"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/T11344","display_name":"Traffic Prediction and Management Techniques","score":0.6025999784469604,"subfield":{"id":"https://openalex.org/subfields/2215","display_name":"Building and Construction"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7797999978065491},{"id":"https://openalex.org/keywords/asset-management","display_name":"Asset management","score":0.4823000133037567},{"id":"https://openalex.org/keywords/baseline","display_name":"Baseline (sea)","score":0.47679999470710754},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.4307999908924103},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4068000018596649},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.3695000112056732},{"id":"https://openalex.org/keywords/asset","display_name":"Asset (computer security)","score":0.36629998683929443},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.36320000886917114}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8281000256538391},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7797999978065491},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5317000150680542},{"id":"https://openalex.org/C2776517139","wikidata":"https://www.wikidata.org/wiki/Q873442","display_name":"Asset management","level":2,"score":0.4823000133037567},{"id":"https://openalex.org/C12725497","wikidata":"https://www.wikidata.org/wiki/Q810247","display_name":"Baseline (sea)","level":2,"score":0.47679999470710754},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.4307999908924103},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4068000018596649},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.38339999318122864},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.3695000112056732},{"id":"https://openalex.org/C76178495","wikidata":"https://www.wikidata.org/wiki/Q4808784","display_name":"Asset (computer security)","level":2,"score":0.36629998683929443},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.36320000886917114},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.34880000352859497},{"id":"https://openalex.org/C1668388","wikidata":"https://www.wikidata.org/wiki/Q1149776","display_name":"Data management","level":2,"score":0.3336000144481659},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.3176000118255615},{"id":"https://openalex.org/C180198813","wikidata":"https://www.wikidata.org/wiki/Q121182","display_name":"Information system","level":2,"score":0.29350000619888306},{"id":"https://openalex.org/C198783460","wikidata":"https://www.wikidata.org/wiki/Q629173","display_name":"Management system","level":2,"score":0.2842999994754791},{"id":"https://openalex.org/C128487930","wikidata":"https://www.wikidata.org/wiki/Q579488","display_name":"Information management","level":2,"score":0.2824999988079071},{"id":"https://openalex.org/C138827492","wikidata":"https://www.wikidata.org/wiki/Q6661985","display_name":"Data processing","level":2,"score":0.2718000113964081},{"id":"https://openalex.org/C2989070954","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database query","level":2,"score":0.26589998602867126},{"id":"https://openalex.org/C47487241","wikidata":"https://www.wikidata.org/wiki/Q5227230","display_name":"Data access","level":2,"score":0.26579999923706055},{"id":"https://openalex.org/C174252522","wikidata":"https://www.wikidata.org/wiki/Q3816772","display_name":"Natural language user interface","level":3,"score":0.26339998841285706},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.260699987411499},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.2581000030040741},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.2551000118255615}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/case58245.2025.11163844","is_oa":false,"landing_page_url":"https://doi.org/10.1109/case58245.2025.11163844","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2025 IEEE 21st International Conference on Automation Science and Engineering (CASE)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320310627","display_name":"Oklahoma Center for the Advancement of Science and Technology","ror":"https://ror.org/02q578v20"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"The":[0,81],"aging":[1],"U.S.":[2],"wastewater":[3],"infrastructure":[4],"poses":[5],"significant":[6],"environmental":[7],"and":[8,48,100,114],"public":[9],"health":[10],"risks.":[11],"While":[12],"municipalities":[13],"collect":[14],"data":[15,30,96],"for":[16],"asset":[17],"management,":[18],"handling":[19],"large":[20],"datasets":[21],"can":[22],"overwhelm":[23],"decision-makers.":[24],"Natural":[25],"language":[26],"processing":[27],"(NLP)":[28],"simplifies":[29],"access":[31],"by":[32],"enabling":[33],"users":[34],"to":[35,78,87,106],"retrieve":[36],"information":[37],"through":[38],"voice":[39],"or":[40],"text":[41],"commands,":[42],"reducing":[43],"reliance":[44],"on":[45],"IT":[46],"support":[47],"improving":[49],"management":[50,70],"efficiency.":[51],"This":[52],"paper":[53],"investigates":[54],"automated":[55],"SQL":[56,92],"query":[57,93],"generation":[58],"from":[59],"natural":[60],"language,":[61],"a":[62,118],"critical":[63],"step":[64],"in":[65],"developing":[66],"an":[67],"intelligent":[68],"sewer":[69],"system.":[71],"Large":[72],"Language":[73],"Models":[74],"(LLMs)":[75],"are":[76,104],"employed":[77],"achieve":[79],"it.":[80],"proposed":[82,109],"method":[83,110],"adopts":[84],"several":[85],"techniques":[86],"improve":[88],"the":[89,108],"performance":[90],"of":[91],"generation,":[94],"including":[95],"augmentation,":[97],"prompt":[98],"engineering":[99],"fine-tuning.":[101],"Experimental":[102],"results":[103],"presented":[105],"evaluate":[107],"with":[111,117],"different":[112],"settings":[113],"compare":[115],"it":[116],"baseline":[119],"method.":[120]},"counts_by_year":[],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}