{"id":"https://openalex.org/W4406260533","doi":"https://doi.org/10.1109/bibm62325.2024.10822294","title":"Automatic SQL Query Generation from Code Switched Natural Language Questions on Electronic Medical Records","display_name":"Automatic SQL Query Generation from Code Switched Natural Language Questions on Electronic Medical Records","publication_year":2024,"publication_date":"2024-12-03","ids":{"openalex":"https://openalex.org/W4406260533","doi":"https://doi.org/10.1109/bibm62325.2024.10822294"},"language":"en","primary_location":{"id":"doi:10.1109/bibm62325.2024.10822294","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bibm62325.2024.10822294","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 IEEE International Conference on Bioinformatics and Biomedicine (BIBM)","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/A5059498267","display_name":"Haodi Zhang","orcid":"https://orcid.org/0000-0001-8470-7246"},"institutions":[{"id":"https://openalex.org/I180726961","display_name":"Shenzhen University","ror":"https://ror.org/01vy4gh70","country_code":"CN","type":"education","lineage":["https://openalex.org/I180726961"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Haodi Zhang","raw_affiliation_strings":["Shenzhen University,College of Computer and Software Engineering,Shenzhen,China"],"affiliations":[{"raw_affiliation_string":"Shenzhen University,College of Computer and Software Engineering,Shenzhen,China","institution_ids":["https://openalex.org/I180726961"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5081807840","display_name":"Jinyin Nie","orcid":null},"institutions":[{"id":"https://openalex.org/I180726961","display_name":"Shenzhen University","ror":"https://ror.org/01vy4gh70","country_code":"CN","type":"education","lineage":["https://openalex.org/I180726961"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jinyin Nie","raw_affiliation_strings":["Shenzhen University,College of Computer and Software Engineering,Shenzhen,China"],"affiliations":[{"raw_affiliation_string":"Shenzhen University,College of Computer and Software Engineering,Shenzhen,China","institution_ids":["https://openalex.org/I180726961"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103008895","display_name":"Zeming Liu","orcid":"https://orcid.org/0000-0002-3691-8097"},"institutions":[{"id":"https://openalex.org/I180726961","display_name":"Shenzhen University","ror":"https://ror.org/01vy4gh70","country_code":"CN","type":"education","lineage":["https://openalex.org/I180726961"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zeming Liu","raw_affiliation_strings":["Shenzhen University,College of Computer and Software Engineering,Shenzhen,China"],"affiliations":[{"raw_affiliation_string":"Shenzhen University,College of Computer and Software Engineering,Shenzhen,China","institution_ids":["https://openalex.org/I180726961"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5015869047","display_name":"Lei Dong","orcid":"https://orcid.org/0000-0001-7379-3388"},"institutions":[{"id":"https://openalex.org/I4210113369","display_name":"Microsoft Research Asia (China)","ror":"https://ror.org/0300m5276","country_code":"CN","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210113369"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Dong Lei","raw_affiliation_strings":["Microsoft,Beijing,China"],"affiliations":[{"raw_affiliation_string":"Microsoft,Beijing,China","institution_ids":["https://openalex.org/I4210113369"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5077688051","display_name":"Yuanfeng Song","orcid":"https://orcid.org/0000-0003-2221-9807"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yuanfeng Song","raw_affiliation_strings":["WeBank Co., Ltd,AI Group,Shenzhen,China"],"affiliations":[{"raw_affiliation_string":"WeBank Co., Ltd,AI Group,Shenzhen,China","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5059498267"],"corresponding_institution_ids":["https://openalex.org/I180726961"],"apc_list":null,"apc_paid":null,"fwci":0.3637,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.70657549,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"2844","last_page":"2851"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.991100013256073,"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.991100013256073,"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/T10028","display_name":"Topic Modeling","score":0.9854000210762024,"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.9761000275611877,"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.7980872392654419},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6989524960517883},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.5929467678070068},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.567466139793396},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.5010995864868164},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.46781134605407715},{"id":"https://openalex.org/keywords/rdf-query-language","display_name":"RDF query language","score":0.45376530289649963},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4524770975112915},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3759843409061432},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.37028276920318604},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3394501209259033},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.1712358593940735},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.12452259659767151},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.09943628311157227}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7980872392654419},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6989524960517883},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5929467678070068},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.567466139793396},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.5010995864868164},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.46781134605407715},{"id":"https://openalex.org/C96956885","wikidata":"https://www.wikidata.org/wiki/Q6138701","display_name":"RDF query language","level":5,"score":0.45376530289649963},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4524770975112915},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3759843409061432},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.37028276920318604},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3394501209259033},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.1712358593940735},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.12452259659767151},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.09943628311157227},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/bibm62325.2024.10822294","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bibm62325.2024.10822294","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 IEEE International Conference on Bioinformatics and Biomedicine (BIBM)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.7599999904632568,"display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":34,"referenced_works":["https://openalex.org/W2064675550","https://openalex.org/W2089565762","https://openalex.org/W2095192855","https://openalex.org/W2127141656","https://openalex.org/W2196528099","https://openalex.org/W2396881363","https://openalex.org/W2762513422","https://openalex.org/W2884096449","https://openalex.org/W2891113091","https://openalex.org/W2896457183","https://openalex.org/W2939069254","https://openalex.org/W2945102109","https://openalex.org/W2952638691","https://openalex.org/W2962713807","https://openalex.org/W2963617989","https://openalex.org/W2963655793","https://openalex.org/W2963850025","https://openalex.org/W2963945964","https://openalex.org/W2964002616","https://openalex.org/W2964268978","https://openalex.org/W2964271186","https://openalex.org/W2972702443","https://openalex.org/W3022196370","https://openalex.org/W3034835156","https://openalex.org/W3105912780","https://openalex.org/W3170549803","https://openalex.org/W3171986718","https://openalex.org/W4285158365","https://openalex.org/W4385245566","https://openalex.org/W6684031499","https://openalex.org/W6743367031","https://openalex.org/W6745921949","https://openalex.org/W6758814090","https://openalex.org/W6848948743"],"related_works":["https://openalex.org/W1548279772","https://openalex.org/W3081572596","https://openalex.org/W1489445454","https://openalex.org/W319014924","https://openalex.org/W2130043461","https://openalex.org/W2094438898","https://openalex.org/W2313789150","https://openalex.org/W2400419823","https://openalex.org/W2031915568","https://openalex.org/W1983721531"],"abstract_inverted_index":{"Electronic":[0],"Medical":[1],"Records":[2],"(EMRs)":[3],"meticulously":[4],"document":[5],"patient":[6],"information":[7],"in":[8,33,41,59,78,92,102,122,157,185],"relational":[9],"databases,":[10],"presenting":[11],"a":[12,30],"challenging":[13],"task":[14,32,166],"for":[15,68,163],"medical":[16,47,66,82,186],"professionals":[17],"to":[18,26,115],"effectively":[19],"retrieve":[20],"this":[21,43,147,175],"data.":[22],"Natural":[23],"Language":[24],"Question":[25],"SQL":[27,54,201],"query":[28],"(NL2SQL),":[29],"critical":[31],"natural":[34],"language":[35],"processing":[36],"(NLP),":[37],"shows":[38],"promising":[39],"performance":[40,173],"addressing":[42],"challenge.":[44],"However,":[45,135],"existing":[46],"NL2SQL":[48,67,141,165],"studies":[49],"often":[50],"focus":[51],"on":[52,139,155,167,174],"generating":[53],"queries":[55],"from":[56],"monolingual":[57],"questions":[58,75,162],"English.":[60,93],"None":[61],"of":[62,160],"them":[63],"have":[64,142],"studied":[65],"the":[69,74,103,136,151,158,164,171,179,209,218],"Chinese":[70,72,161],"domain.In":[71],"EMRs,":[73],"are":[76,89,109],"primarily":[77],"Chinese,":[79],"while":[80],"many":[81,123],"terms,":[83],"such":[84,125],"as":[85,99,120,126],"drugs":[86],"and":[87,131],"diseases,":[88],"commonly":[90],"described":[91],"This":[94],"phenomenon":[95],"is":[96],"generally":[97],"known":[98],"code-switching":[100],"(CS)":[101],"field.":[104],"Given":[105],"that":[106,208],"underlying":[107],"systems":[108],"typically":[110],"monolingual,":[111],"CS":[112,156],"has":[113],"proven":[114],"pose":[116],"significant":[117],"accuracy":[118],"challenges,":[119],"observed":[121],"tasks":[124],"Automatic":[127],"Speech":[128],"Recognition":[129],"(ASR)":[130],"Machine":[132],"Translation":[133],"(MT).":[134],"potential":[137],"effects":[138],"EMRs":[140],"not":[143],"been":[144],"explored.":[145],"In":[146],"study,":[148],"we":[149,177],"investigate":[150],"CS-NL2SQL":[152,181,192],"problem,":[153],"focusing":[154],"context":[159],"EMRs.":[168],"To":[169],"assess":[170],"model\u2019s":[172],"task,":[176],"construct":[178],"first":[180],"dataset":[182],"named":[183],"CS-MIMICSQL":[184],"domains.":[187],"We":[188],"then":[189],"explore":[190],"different":[191],"architectures":[193],"along":[194],"two":[195],"dimensions:":[196],"cascaded":[197,219],"(translation":[198],"followed":[199],"by":[200],"generation)":[202],"vs.":[203],"end-to-end.":[204],"Our":[205],"results":[206],"demonstrate":[207],"proposed":[210],"end-to-end":[211],"structure":[212],"can":[213],"outperform":[214],"much":[215],"better":[216],"than":[217],"baselines.":[220]},"counts_by_year":[{"year":2025,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}