{"id":"https://openalex.org/W4389495228","doi":"https://doi.org/10.1109/tr.2023.3336330","title":"LI-EMRSQL: Linking Information Enhanced Text2SQL Parsing on Complex Electronic Medical Records","display_name":"LI-EMRSQL: Linking Information Enhanced Text2SQL Parsing on Complex Electronic Medical Records","publication_year":2023,"publication_date":"2023-12-08","ids":{"openalex":"https://openalex.org/W4389495228","doi":"https://doi.org/10.1109/tr.2023.3336330"},"language":"en","primary_location":{"id":"doi:10.1109/tr.2023.3336330","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tr.2023.3336330","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":"https://openalex.org/A5100701586","display_name":"Qing Li","orcid":"https://orcid.org/0000-0001-6350-0502"},"institutions":[{"id":"https://openalex.org/I17145004","display_name":"Northwestern Polytechnical University","ror":"https://ror.org/01y0j0j86","country_code":"CN","type":"education","lineage":["https://openalex.org/I17145004"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Qing Li","raw_affiliation_strings":["School of Computer Science, Northwestern Polytechnical University, Xi'an, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science, Northwestern Polytechnical University, Xi'an, China","institution_ids":["https://openalex.org/I17145004"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5006326110","display_name":"Tao You","orcid":"https://orcid.org/0000-0003-0023-7617"},"institutions":[{"id":"https://openalex.org/I17145004","display_name":"Northwestern Polytechnical University","ror":"https://ror.org/01y0j0j86","country_code":"CN","type":"education","lineage":["https://openalex.org/I17145004"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Tao You","raw_affiliation_strings":["School of Computer Science, Northwestern Polytechnical University, Xi'an, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science, Northwestern Polytechnical University, Xi'an, China","institution_ids":["https://openalex.org/I17145004"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5086071901","display_name":"Jinchao Chen","orcid":"https://orcid.org/0000-0001-6234-1001"},"institutions":[{"id":"https://openalex.org/I17145004","display_name":"Northwestern Polytechnical University","ror":"https://ror.org/01y0j0j86","country_code":"CN","type":"education","lineage":["https://openalex.org/I17145004"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jinchao Chen","raw_affiliation_strings":["School of Computer Science, Northwestern Polytechnical University, Xi'an, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science, Northwestern Polytechnical University, Xi'an, China","institution_ids":["https://openalex.org/I17145004"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100386171","display_name":"Ying Zhang","orcid":"https://orcid.org/0000-0002-7557-2965"},"institutions":[{"id":"https://openalex.org/I17145004","display_name":"Northwestern Polytechnical University","ror":"https://ror.org/01y0j0j86","country_code":"CN","type":"education","lineage":["https://openalex.org/I17145004"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Ying Zhang","raw_affiliation_strings":["School of Computer Science, Northwestern Polytechnical University, Xi'an, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science, Northwestern Polytechnical University, Xi'an, China","institution_ids":["https://openalex.org/I17145004"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5102162840","display_name":"Chenglie Du","orcid":null},"institutions":[{"id":"https://openalex.org/I17145004","display_name":"Northwestern Polytechnical University","ror":"https://ror.org/01y0j0j86","country_code":"CN","type":"education","lineage":["https://openalex.org/I17145004"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chenglie Du","raw_affiliation_strings":["School of Computer Science, Northwestern Polytechnical University, Xi'an, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science, Northwestern Polytechnical University, Xi'an, China","institution_ids":["https://openalex.org/I17145004"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5100701586"],"corresponding_institution_ids":["https://openalex.org/I17145004"],"apc_list":null,"apc_paid":null,"fwci":13.8588,"has_fulltext":false,"cited_by_count":107,"citation_normalized_percentile":{"value":0.99244211,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":100},"biblio":{"volume":"73","issue":"2","first_page":"1280","last_page":"1290"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.9994999766349792,"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.9994999766349792,"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/T11710","display_name":"Biomedical Text Mining and Ontologies","score":0.9987000226974487,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9984999895095825,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8560338020324707},{"id":"https://openalex.org/keywords/parsing","display_name":"Parsing","score":0.6798551082611084},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.67010098695755},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4629138112068176},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.44320735335350037},{"id":"https://openalex.org/keywords/unified-medical-language-system","display_name":"Unified Medical Language System","score":0.43323269486427307},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.41175612807273865},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2989840805530548}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8560338020324707},{"id":"https://openalex.org/C186644900","wikidata":"https://www.wikidata.org/wiki/Q194152","display_name":"Parsing","level":2,"score":0.6798551082611084},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.67010098695755},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4629138112068176},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.44320735335350037},{"id":"https://openalex.org/C69505689","wikidata":"https://www.wikidata.org/wiki/Q455338","display_name":"Unified Medical Language System","level":2,"score":0.43323269486427307},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.41175612807273865},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2989840805530548}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tr.2023.3336330","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tr.2023.3336330","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":[{"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4","score":0.6399999856948853}],"awards":[{"id":"https://openalex.org/G3302618404","display_name":null,"funder_award_id":"62171382","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G3378799727","display_name":null,"funder_award_id":"20200051053002","funder_id":"https://openalex.org/F4320327472","funder_display_name":"Chinese Aeronautical Establishment"},{"id":"https://openalex.org/G5575984920","display_name":null,"funder_award_id":"62102316","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G565200708","display_name":null,"funder_award_id":"G2021KY05114","funder_id":"https://openalex.org/F4320329878","funder_display_name":"Central University Basic Research Fund of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320327472","display_name":"Chinese Aeronautical Establishment","ror":null},{"id":"https://openalex.org/F4320329878","display_name":"Central University Basic Research Fund of China","ror":null}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":63,"referenced_works":["https://openalex.org/W1522301498","https://openalex.org/W2095705004","https://openalex.org/W2154268919","https://openalex.org/W2269738476","https://openalex.org/W2396881363","https://openalex.org/W2743104969","https://openalex.org/W2751448157","https://openalex.org/W2762513422","https://openalex.org/W2768409085","https://openalex.org/W2794752572","https://openalex.org/W2890561662","https://openalex.org/W2891400669","https://openalex.org/W2963919031","https://openalex.org/W3004507689","https://openalex.org/W3022196370","https://openalex.org/W3034835156","https://openalex.org/W3035140194","https://openalex.org/W3035231859","https://openalex.org/W3035719901","https://openalex.org/W3103513278","https://openalex.org/W3116083993","https://openalex.org/W3126918322","https://openalex.org/W3170549803","https://openalex.org/W3173964589","https://openalex.org/W3175818566","https://openalex.org/W3176047499","https://openalex.org/W3208581766","https://openalex.org/W3216055172","https://openalex.org/W4284683546","https://openalex.org/W4287824654","https://openalex.org/W4317553049","https://openalex.org/W4382202531","https://openalex.org/W4383199468","https://openalex.org/W6631190155","https://openalex.org/W6631943919","https://openalex.org/W6674330103","https://openalex.org/W6684031499","https://openalex.org/W6691431627","https://openalex.org/W6736356258","https://openalex.org/W6737850504","https://openalex.org/W6743367031","https://openalex.org/W6745921949","https://openalex.org/W6750597312","https://openalex.org/W6753816834","https://openalex.org/W6754783781","https://openalex.org/W6754996754","https://openalex.org/W6755207826","https://openalex.org/W6755714500","https://openalex.org/W6757817989","https://openalex.org/W6766978945","https://openalex.org/W6767653448","https://openalex.org/W6771917389","https://openalex.org/W6783935634","https://openalex.org/W6784050033","https://openalex.org/W6784491437","https://openalex.org/W6785429573","https://openalex.org/W6785449282","https://openalex.org/W6786236183","https://openalex.org/W6796243636","https://openalex.org/W6796838256","https://openalex.org/W6801048869","https://openalex.org/W6803081274","https://openalex.org/W6848948743"],"related_works":["https://openalex.org/W2003127701","https://openalex.org/W2563868050","https://openalex.org/W4381248170","https://openalex.org/W1822792362","https://openalex.org/W3189621521","https://openalex.org/W1507779355","https://openalex.org/W2173794830","https://openalex.org/W1502858101","https://openalex.org/W2575181596","https://openalex.org/W2138789621"],"abstract_inverted_index":{"Converting":[0],"natural":[1],"language":[2],"text":[3],"into":[4],"executable":[5],"SQL":[6,82],"queries":[7],"significantly":[8],"impacts":[9],"the":[10,40,108,119,131,135,157,166],"healthcare":[11],"domain,":[12],"specifically":[13],"when":[14],"applied":[15],"to":[16,59,75,86,117],"electronic":[17,22],"medical":[18,23,44],"records.":[19],"Given":[20],"that":[21],"records":[24],"store":[25],"extensive":[26],"patient":[27],"information":[28],"in":[29,165],"a":[30,35,54,92],"relational":[31],"multitable":[32],"database,":[33],"developing":[34],"Text-to-SQL":[36],"parser":[37,57],"would":[38],"enable":[39],"correlation":[41],"of":[42,121,133,171],"intricate":[43],"terminology":[45],"through":[46],"semantic":[47],"parsing.":[48],"A":[49,62],"major":[50],"challenge":[51],"is":[52,138],"designing":[53],"versatile":[55],"Text2SQL":[56,97,150,155],"applicable":[58],"new":[60],"databases.":[61],"critical":[63],"step":[64],"towards":[65],"this":[66],"goal":[67],"involves":[68],"schema":[69,127],"linking":[70],"-":[71],"accurately":[72],"identifying":[73],"references":[74],"previously":[76],"unseen":[77],"columns":[78],"or":[79],"tables":[80],"during":[81],"creation.":[83],"In":[84],"response":[85],"these":[87],"key":[88],"challenges,":[89],"we":[90],"propose":[91],"novel":[93],"framework\u2014Linking":[94],"Information":[95],"Enhanced":[96],"Parsing":[98],"on":[99],"Complex":[100],"Electronic":[101],"Medical":[102],"Records":[103],"(LI-EMRSQL).":[104],"This":[105],"model":[106],"leverages":[107],"Poincar\u00e9":[109],"distance":[110],"metric":[111],"detection":[112,136],"procedure,":[113],"utilizing":[114],"induced":[115],"relations":[116],"enhance":[118,130],"performance":[120],"pre-existing":[122],"graph-based":[123],"parsers":[124],"and":[125,141,152,169],"improve":[126],"linkage.":[128],"To":[129],"generalizability":[132],"LI-EMRSQL,":[134],"process":[137],"completely":[139],"unsupervised":[140],"does":[142],"not":[143],"necessitate":[144],"additional":[145],"parameters.":[146],"On":[147],"two":[148,153],"conventional":[149],"datasets":[151],"EMRs":[154],"datasets,":[156],"system":[158],"delivers":[159],"SOTA":[160],"performance.":[161],"Furthermore,":[162],"notable":[163],"enhancements":[164],"model's":[167],"comprehension":[168],"alignment":[170],"schemas":[172],"are":[173],"observed.":[174]},"counts_by_year":[{"year":2026,"cited_by_count":4},{"year":2025,"cited_by_count":33},{"year":2024,"cited_by_count":41},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":2},{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-03-09T08:58:05.943551","created_date":"2025-10-10T00:00:00"}