{"id":"https://openalex.org/W4387337835","doi":"https://doi.org/10.1145/3622896.3622906","title":"Instruction Tuning Text-to-SQL with Large Language Models in the Power Grid Domain","display_name":"Instruction Tuning Text-to-SQL with Large Language Models in the Power Grid Domain","publication_year":2023,"publication_date":"2023-08-25","ids":{"openalex":"https://openalex.org/W4387337835","doi":"https://doi.org/10.1145/3622896.3622906"},"language":"en","primary_location":{"id":"doi:10.1145/3622896.3622906","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3622896.3622906","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2023 4th International Conference on Control, Robotics and Intelligent System","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/A5101980581","display_name":"Sun Gang","orcid":"https://orcid.org/0009-0003-0219-6975"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Gang Sun","raw_affiliation_strings":["Marketing Service Center State Grid Zhejiang Electric Power Co., Ltd, China"],"raw_orcid":"https://orcid.org/0009-0003-0219-6975","affiliations":[{"raw_affiliation_string":"Marketing Service Center State Grid Zhejiang Electric Power Co., Ltd, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038544378","display_name":"Ran Shen","orcid":"https://orcid.org/0009-0008-6851-6931"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ran Shen","raw_affiliation_strings":["Marketing Service Center State Grid Zhejiang Electric Power Co., Ltd, China"],"raw_orcid":"https://orcid.org/0009-0008-6851-6931","affiliations":[{"raw_affiliation_string":"Marketing Service Center State Grid Zhejiang Electric Power Co., Ltd, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5002357017","display_name":"Liangfeng Jin","orcid":"https://orcid.org/0009-0008-1403-4320"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Liangfeng Jin","raw_affiliation_strings":["Marketing Service Center State Grid Zhejiang Electric Power Co., Ltd, China"],"raw_orcid":"https://orcid.org/0009-0008-1403-4320","affiliations":[{"raw_affiliation_string":"Marketing Service Center State Grid Zhejiang Electric Power Co., Ltd, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5005602221","display_name":"Y.H. Wang","orcid":"https://orcid.org/0009-0006-2531-2213"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yifan Wang","raw_affiliation_strings":["Marketing Service Center State Grid Zhejiang Electric Power Co., Ltd, China"],"raw_orcid":"https://orcid.org/0009-0006-2531-2213","affiliations":[{"raw_affiliation_string":"Marketing Service Center State Grid Zhejiang Electric Power Co., Ltd, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101682032","display_name":"Shiyu Xu","orcid":"https://orcid.org/0009-0000-4734-1089"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Shiyu Xu","raw_affiliation_strings":["Marketing Service Center State Grid Zhejiang Electric Power Co., Ltd, China"],"raw_orcid":"https://orcid.org/0009-0000-4734-1089","affiliations":[{"raw_affiliation_string":"Marketing Service Center State Grid Zhejiang Electric Power Co., Ltd, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027505910","display_name":"J. M. Chen","orcid":"https://orcid.org/0009-0006-7114-6391"},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jinpeng Chen","raw_affiliation_strings":["Zhejiang University, China, China"],"raw_orcid":"https://orcid.org/0009-0006-7114-6391","affiliations":[{"raw_affiliation_string":"Zhejiang University, China, China","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5083246300","display_name":"Weihao Jiang","orcid":"https://orcid.org/0009-0006-8093-4437"},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Weihao Jiang","raw_affiliation_strings":["Zhejiang University, China, China"],"raw_orcid":"https://orcid.org/0009-0006-8093-4437","affiliations":[{"raw_affiliation_string":"Zhejiang University, China, China","institution_ids":["https://openalex.org/I76130692"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5101980581"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.3633,"has_fulltext":false,"cited_by_count":8,"citation_normalized_percentile":{"value":0.8496267,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"59","last_page":"63"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.9958999752998352,"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/T10028","display_name":"Topic Modeling","score":0.9958999752998352,"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/T10181","display_name":"Natural Language Processing Techniques","score":0.9735000133514404,"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/computer-science","display_name":"Computer science","score":0.8895232677459717},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7711892127990723},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.48336976766586304},{"id":"https://openalex.org/keywords/language-model","display_name":"Language model","score":0.4587649703025818},{"id":"https://openalex.org/keywords/leverage","display_name":"Leverage (statistics)","score":0.44078683853149414},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.43267545104026794},{"id":"https://openalex.org/keywords/parsing","display_name":"Parsing","score":0.41732552647590637},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.4149159789085388},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.40356960892677307},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3388161361217499},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.24206408858299255},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2304704189300537}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8895232677459717},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7711892127990723},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.48336976766586304},{"id":"https://openalex.org/C137293760","wikidata":"https://www.wikidata.org/wiki/Q3621696","display_name":"Language model","level":2,"score":0.4587649703025818},{"id":"https://openalex.org/C153083717","wikidata":"https://www.wikidata.org/wiki/Q6535263","display_name":"Leverage (statistics)","level":2,"score":0.44078683853149414},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.43267545104026794},{"id":"https://openalex.org/C186644900","wikidata":"https://www.wikidata.org/wiki/Q194152","display_name":"Parsing","level":2,"score":0.41732552647590637},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.4149159789085388},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.40356960892677307},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3388161361217499},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.24206408858299255},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2304704189300537},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3622896.3622906","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3622896.3622906","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2023 4th International Conference on Control, Robotics and Intelligent System","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Quality Education","score":0.6200000047683716,"id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":3,"referenced_works":["https://openalex.org/W2890867094","https://openalex.org/W3102020135","https://openalex.org/W3214600982"],"related_works":["https://openalex.org/W2340883001","https://openalex.org/W1980548249","https://openalex.org/W2884764431","https://openalex.org/W650213220","https://openalex.org/W4386768611","https://openalex.org/W1592149428","https://openalex.org/W2183714398","https://openalex.org/W2134779891","https://openalex.org/W1554917839","https://openalex.org/W91546718"],"abstract_inverted_index":{"This":[0,84],"paper":[1,35,72,121],"explores":[2],"the":[3,9,16,21,34,58,71,96,102,107,114,120,150],"large":[4,66,75,128],"language":[5,67,76,129],"models":[6,68,130],"to":[7,39,56,69,95],"address":[8],"Text-to-SQL":[10],"task":[11],"in":[12,15,48],"real-world":[13,32],"scenarios":[14],"electricity":[17],"domain.":[18],"To":[19],"tackle":[20],"lack":[22],"of":[23,65],"training":[24],"data":[25,43,53],"and":[26,62,113,134],"corresponding":[27],"databases":[28],"for":[29,42,78,81,131,152],"vertical":[30],"domain":[31],"scenarios,":[33],"devised":[36],"specific":[37,97],"prompts":[38],"leverage":[40],"ChatGPT":[41],"generation,":[44],"achieving":[45],"significant":[46],"improvements":[47],"annotation":[49],"efficiency":[50],"through":[51],"automated":[52],"generation.":[54,83],"Furthermore,":[55],"apply":[57],"powerful":[59],"semantic":[60],"parsing":[61],"generation":[63,99],"capabilities":[64],"Text-to-SQL,":[70],"utilized":[73],"a":[74],"model":[77,85],"instruction":[79],"tuning":[80],"SQL":[82,98],"has":[86],"undergone":[87],"secondary":[88],"pre-training":[89],"with":[90],"electrical":[91],"knowledge,":[92],"tailoring":[93],"it":[94],"task.":[100],"On":[101],"power":[103],"grid":[104],"test":[105],"set,":[106],"paper\u2019s":[108],"matching":[109],"accuracy":[110,116],"reached":[111,117],"65.7%,":[112],"execution":[115],"80.9%.":[118],"Additionally,":[119],"conducted":[122],"further":[123],"tests":[124],"on":[125],"various":[126],"general":[127],"zero-shot":[132],"learning":[133],"single-sample":[135],"prompt-based":[136],"Text-to-SQL.":[137],"The":[138],"results":[139],"indicate":[140],"that":[141],"while":[142],"simple":[143],"single-table":[144],"queries":[145,154],"can":[146],"be":[147],"achieved,":[148],"meeting":[149],"requirements":[151],"complex":[153],"remains":[155],"challenging.":[156]},"counts_by_year":[{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}