{"id":"https://openalex.org/W4391487421","doi":"https://doi.org/10.3233/ida-230390","title":"HFD: Hierarchical feature decoupling for SQL generation from text","display_name":"HFD: Hierarchical feature decoupling for SQL generation from text","publication_year":2024,"publication_date":"2024-02-02","ids":{"openalex":"https://openalex.org/W4391487421","doi":"https://doi.org/10.3233/ida-230390"},"language":"en","primary_location":{"id":"doi:10.3233/ida-230390","is_oa":false,"landing_page_url":"https://doi.org/10.3233/ida-230390","pdf_url":null,"source":{"id":"https://openalex.org/S2498839158","display_name":"Intelligent Data Analysis","issn_l":"1088-467X","issn":["1088-467X","1571-4128"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Intelligent Data Analysis","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/A5100437272","display_name":"Xu Zhang","orcid":"https://orcid.org/0000-0002-9294-2841"},"institutions":[{"id":"https://openalex.org/I76569877","display_name":"Southeast University","ror":"https://ror.org/04ct4d772","country_code":"CN","type":"education","lineage":["https://openalex.org/I76569877"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xu Zhang","raw_affiliation_strings":["School of Computer Science and Engineering, Key Laboratory of Computer Network and Information Integration, Ministry of Education, Southeast University, Nanjing, Jiangsu, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science and Engineering, Key Laboratory of Computer Network and Information Integration, Ministry of Education, Southeast University, Nanjing, Jiangsu, China","institution_ids":["https://openalex.org/I76569877"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055947764","display_name":"Xiaoyu Hu","orcid":"https://orcid.org/0000-0002-6980-6673"},"institutions":[{"id":"https://openalex.org/I76569877","display_name":"Southeast University","ror":"https://ror.org/04ct4d772","country_code":"CN","type":"education","lineage":["https://openalex.org/I76569877"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xiaoyu Hu","raw_affiliation_strings":["School of Computer Science and Engineering, Key Laboratory of Computer Network and Information Integration, Ministry of Education, Southeast University, Nanjing, Jiangsu, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science and Engineering, Key Laboratory of Computer Network and Information Integration, Ministry of Education, Southeast University, Nanjing, Jiangsu, China","institution_ids":["https://openalex.org/I76569877"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5077741053","display_name":"Zejie Liu","orcid":null},"institutions":[{"id":"https://openalex.org/I76569877","display_name":"Southeast University","ror":"https://ror.org/04ct4d772","country_code":"CN","type":"education","lineage":["https://openalex.org/I76569877"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zejie Liu","raw_affiliation_strings":["School of Computer Science and Engineering, Key Laboratory of Computer Network and Information Integration, Ministry of Education, Southeast University, Nanjing, Jiangsu, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science and Engineering, Key Laboratory of Computer Network and Information Integration, Ministry of Education, Southeast University, Nanjing, Jiangsu, China","institution_ids":["https://openalex.org/I76569877"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5032134059","display_name":"Yanzheng Xiang","orcid":"https://orcid.org/0000-0002-3395-9766"},"institutions":[{"id":"https://openalex.org/I76569877","display_name":"Southeast University","ror":"https://ror.org/04ct4d772","country_code":"CN","type":"education","lineage":["https://openalex.org/I76569877"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yanzheng Xiang","raw_affiliation_strings":["School of Computer Science and Engineering, Key Laboratory of Computer Network and Information Integration, Ministry of Education, Southeast University, Nanjing, Jiangsu, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science and Engineering, Key Laboratory of Computer Network and Information Integration, Ministry of Education, Southeast University, Nanjing, Jiangsu, China","institution_ids":["https://openalex.org/I76569877"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5007145568","display_name":"Deyu Zhou","orcid":"https://orcid.org/0000-0001-7702-9387"},"institutions":[{"id":"https://openalex.org/I76569877","display_name":"Southeast University","ror":"https://ror.org/04ct4d772","country_code":"CN","type":"education","lineage":["https://openalex.org/I76569877"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Deyu Zhou","raw_affiliation_strings":["School of Computer Science and Engineering, Key Laboratory of Computer Network and Information Integration, Ministry of Education, Southeast University, Nanjing, Jiangsu, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science and Engineering, Key Laboratory of Computer Network and Information Integration, Ministry of Education, Southeast University, Nanjing, Jiangsu, China","institution_ids":["https://openalex.org/I76569877"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5007145568"],"corresponding_institution_ids":["https://openalex.org/I76569877"],"apc_list":null,"apc_paid":null,"fwci":0.7274,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.72618323,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":95},"biblio":{"volume":"28","issue":"4","first_page":"991","last_page":"1005"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.9983999729156494,"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.9983999729156494,"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/T11307","display_name":"Domain Adaptation and Few-Shot Learning","score":0.9891999959945679,"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/T12016","display_name":"Web Data Mining and Analysis","score":0.9771999716758728,"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/decoupling","display_name":"Decoupling (probability)","score":0.7185367345809937},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6134161353111267},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6050786972045898},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.5373092889785767},{"id":"https://openalex.org/keywords/feature","display_name":"Feature (linguistics)","score":0.49992918968200684},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.4055689871311188},{"id":"https://openalex.org/keywords/pattern-recognition","display_name":"Pattern recognition (psychology)","score":0.3290722370147705},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.20603594183921814},{"id":"https://openalex.org/keywords/linguistics","display_name":"Linguistics","score":0.18434783816337585},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.11683711409568787},{"id":"https://openalex.org/keywords/philosophy","display_name":"Philosophy","score":0.062293946743011475}],"concepts":[{"id":"https://openalex.org/C205606062","wikidata":"https://www.wikidata.org/wiki/Q5249645","display_name":"Decoupling (probability)","level":2,"score":0.7185367345809937},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6134161353111267},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6050786972045898},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.5373092889785767},{"id":"https://openalex.org/C2776401178","wikidata":"https://www.wikidata.org/wiki/Q12050496","display_name":"Feature (linguistics)","level":2,"score":0.49992918968200684},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.4055689871311188},{"id":"https://openalex.org/C153180895","wikidata":"https://www.wikidata.org/wiki/Q7148389","display_name":"Pattern recognition (psychology)","level":2,"score":0.3290722370147705},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.20603594183921814},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.18434783816337585},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.11683711409568787},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.062293946743011475},{"id":"https://openalex.org/C133731056","wikidata":"https://www.wikidata.org/wiki/Q4917288","display_name":"Control engineering","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.3233/ida-230390","is_oa":false,"landing_page_url":"https://doi.org/10.3233/ida-230390","pdf_url":null,"source":{"id":"https://openalex.org/S2498839158","display_name":"Intelligent Data Analysis","issn_l":"1088-467X","issn":["1088-467X","1571-4128"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Intelligent Data Analysis","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/10","score":0.699999988079071,"display_name":"Reduced inequalities"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":33,"referenced_works":["https://openalex.org/W109256031","https://openalex.org/W2150172314","https://openalex.org/W2159231020","https://openalex.org/W2337398535","https://openalex.org/W2535540629","https://openalex.org/W2740385731","https://openalex.org/W2751045246","https://openalex.org/W2885948040","https://openalex.org/W2891691255","https://openalex.org/W2897196530","https://openalex.org/W2913340405","https://openalex.org/W2945102109","https://openalex.org/W2962713807","https://openalex.org/W2963357517","https://openalex.org/W2963854351","https://openalex.org/W2963877604","https://openalex.org/W2970597249","https://openalex.org/W2997970380","https://openalex.org/W3034835156","https://openalex.org/W3035040493","https://openalex.org/W3087931390","https://openalex.org/W3104003456","https://openalex.org/W3115123200","https://openalex.org/W3156449551","https://openalex.org/W3173225835","https://openalex.org/W4214724203","https://openalex.org/W4224919008","https://openalex.org/W4312986557","https://openalex.org/W6600459194","https://openalex.org/W6604452681","https://openalex.org/W6703302435","https://openalex.org/W6743561847","https://openalex.org/W6763701032"],"related_works":["https://openalex.org/W2152950565","https://openalex.org/W1617565119","https://openalex.org/W160381218","https://openalex.org/W2512958550","https://openalex.org/W2329266651","https://openalex.org/W3103825105","https://openalex.org/W2004102934","https://openalex.org/W4366455350","https://openalex.org/W4321844193","https://openalex.org/W4386159726"],"abstract_inverted_index":{"Text-to-SQL,":[0],"a":[1],"computational":[2],"linguistics":[3],"task,":[4],"seeks":[5],"to":[6,31,84,94,116,149,165],"facilitate":[7],"the":[8,21,34,50,80,90,104,120,127,143,162,177,182,185,194],"conversion":[9],"of":[10,23,52,106,146,184,196],"natural":[11,38,81,137],"language":[12,39,82],"queries":[13],"into":[14],"SQL":[15,29,133],"queries.":[16],"Recent":[17],"methodologies":[18],"have":[19],"leveraged":[20],"concept":[22],"slot-filling":[24],"in":[25,79,193],"conjunction":[26],"with":[27,67],"predetermined":[28],"templates":[30],"effectively":[32],"bridge":[33],"semantic":[35],"gap":[36],"between":[37],"questions":[40],"and":[41,86,100,154],"structured":[42],"database":[43],"queries,":[44],"achieving":[45],"commendable":[46],"performance":[47],"by":[48],"harnessing":[49],"power":[51],"multi-task":[53],"learning.":[54],"However,":[55],"employing":[56],"identical":[57],"features":[58,92,108,147,160],"across":[59],"diverse":[60],"tasks":[61],"is":[62],"an":[63,114,124],"ill-suited":[64],"practice,":[65],"fraught":[66],"inherent":[68],"drawbacks.":[69],"Firstly,":[70],"based":[71],"on":[72,176],"our":[73],"observation,":[74],"there":[75],"are":[76,97],"clear":[77],"boundaries":[78],"corresponding":[83],"SELECT":[85,153],"WHERE":[87,155],"clauses.":[88],"Secondly,":[89],"exclusive":[91],"integral":[93],"each":[95,110],"subtask":[96,163],"inadequately":[98],"emphasized":[99],"underutilized,":[101],"thereby":[102],"hampering":[103],"acquisition":[105],"discriminative":[107],"for":[109,132],"specific":[111],"subtask.":[112],"In":[113],"endeavor":[115],"rectify":[117],"these":[118,159],"issues,":[119],"present":[121],"work":[122],"introduces":[123],"innovative":[125],"approach:":[126],"hierarchical":[128],"feature":[129],"decoupling":[130],"model":[131,168],"query":[134,198],"generation":[135],"from":[136,173],"language.":[138],"This":[139],"novel":[140],"approach":[141,187],"involves":[142],"deliberate":[144],"separation":[145],"pertaining":[148],"subtasks":[150],"within":[151],"both":[152],"clauses,":[156],"further":[157],"dissociating":[158],"at":[161],"level":[164],"foster":[166],"better":[167],"performance.":[169],"Empirical":[170],"results":[171],"derived":[172],"experiments":[174],"conducted":[175],"WikiSQL":[178],"benchmark":[179],"dataset":[180],"reveal":[181],"superiority":[183],"proposed":[186],"over":[188],"several":[189],"state-of-the-art":[190],"baseline":[191],"methods":[192],"context":[195],"text-to-SQL":[197],"generation.":[199]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1}],"updated_date":"2026-01-24T23:23:39.755997","created_date":"2025-10-10T00:00:00"}