{"id":"https://openalex.org/W3103291908","doi":"https://doi.org/10.18653/v1/2020.emnlp-main.560","title":"IGSQL: Database Schema Interaction Graph Based Neural Model for Context-Dependent Text-to-SQL Generation","display_name":"IGSQL: Database Schema Interaction Graph Based Neural Model for Context-Dependent Text-to-SQL Generation","alternate_titles":[],"publication_year":2020,"publication_date":"2020-01-01","ids":{"openalex":"https://openalex.org/W3103291908","doi":"https://doi.org/10.18653/v1/2020.emnlp-main.560","mag":"3103291908"},"language":"en","primary_location":{"id":"doi:10.18653/v1/2020.emnlp-main.560","doi":"https://doi.org/10.18653/v1/2020.emnlp-main.560","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/2020.emnlp-main.560","pdf_url":"https://www.aclweb.org/anthology/2020.emnlp-main.560.pdf","source":{"id":"https://openalex.org/S4363608991","display_name":"Conference on Empirical Methods in Natural Language Processing (EMNLP)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310320244","host_organization_name":"Association for Computational Linguistics","host_organization_lineage":["https://openalex.org/P4310320244"],"host_organization_lineage_names":["Association for Computational Linguistics"],"type":"conference"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2020 Conference on Empirical Methods in Natural Language Processing (EMNLP)","raw_type":"proceedings-article"},"parent_works":[],"lineage":["https://openalex.org/W3103291908"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"indexed_in":["arxiv","crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://www.aclweb.org/anthology/2020.emnlp-main.560.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5102423692","display_name":"Yitao Cai","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I20231570","display_name":"Peking University","ror":"https://ror.org/02v51f717","country_code":"CN","type":"education","lineage":["https://openalex.org/I20231570"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yitao Cai","raw_affiliation_strings":["Center for Data Science , Peking University The MOE Key Laboratory of Computational Linguistics , Peking University","Wangxuan Institute of Computer Technology , Peking University","The MOE Key Laboratory of Computational Linguistics, Peking University","Wangxuan Institute of Computer Technology, Peking University Center for Data Science, Peking University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Center for Data Science , Peking University The MOE Key Laboratory of Computational Linguistics , Peking University","institution_ids":["https://openalex.org/I20231570"]},{"raw_affiliation_string":"Wangxuan Institute of Computer Technology , Peking University","institution_ids":["https://openalex.org/I20231570"]},{"raw_affiliation_string":"The MOE Key Laboratory of Computational Linguistics, Peking University","institution_ids":["https://openalex.org/I20231570"]},{"raw_affiliation_string":"Wangxuan Institute of Computer Technology, Peking University Center for Data Science, Peking University","institution_ids":["https://openalex.org/I20231570"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5029568096","display_name":"Xiaojun Wan","orcid":"https://orcid.org/0000-0001-6887-1994","observed_orcids":["https://orcid.org/0000-0001-6887-1994"]},"institutions":[{"id":"https://openalex.org/I20231570","display_name":"Peking University","ror":"https://ror.org/02v51f717","country_code":"CN","type":"education","lineage":["https://openalex.org/I20231570"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xiaojun Wan","raw_affiliation_strings":["Center for Data Science , Peking University The MOE Key Laboratory of Computational Linguistics , Peking University","Wangxuan Institute of Computer Technology , Peking University","The MOE Key Laboratory of Computational Linguistics, Peking University","Wangxuan Institute of Computer Technology, Peking University Center for Data Science, Peking University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Center for Data Science , Peking University The MOE Key Laboratory of Computational Linguistics , Peking University","institution_ids":["https://openalex.org/I20231570"]},{"raw_affiliation_string":"Wangxuan Institute of Computer Technology , Peking University","institution_ids":["https://openalex.org/I20231570"]},{"raw_affiliation_string":"The MOE Key Laboratory of Computational Linguistics, Peking University","institution_ids":["https://openalex.org/I20231570"]},{"raw_affiliation_string":"Wangxuan Institute of Computer Technology, Peking University Center for Data Science, Peking University","institution_ids":["https://openalex.org/I20231570"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I20231570"],"apc_list":null,"apc_paid":null,"fwci":2.2394,"has_fulltext":true,"cited_by_count":60,"citation_normalized_percentile":{"value":0.90842701,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"6903","last_page":"6912"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.4332999885082245,"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.4332999885082245,"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.1835000067949295,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.12600000202655792,"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/graph-encoder","display_name":"graph encoder","score":0.7269999980926514},{"id":"https://openalex.org/keywords/gate-mechanism","display_name":"gate mechanism","score":0.8550000190734863},{"id":"https://openalex.org/keywords/sparc","display_name":"SPARC","score":0.7319999933242798}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.882699728012085},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7132666110992432},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5667078495025635},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.5088701248168945},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.4205951690673828},{"id":"https://openalex.org/C118505674","wikidata":"https://www.wikidata.org/wiki/Q42586063","display_name":"Encoder","level":2,"score":0.4194212853908539},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3844211995601654},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.34547847509384155},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2401212751865387},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.18653/v1/2020.emnlp-main.560","doi":"https://doi.org/10.18653/v1/2020.emnlp-main.560","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/2020.emnlp-main.560","pdf_url":"https://www.aclweb.org/anthology/2020.emnlp-main.560.pdf","source":{"id":"https://openalex.org/S4363608991","display_name":"Conference on Empirical Methods in Natural Language Processing (EMNLP)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310320244","host_organization_name":"Association for Computational Linguistics","host_organization_lineage":["https://openalex.org/P4310320244"],"host_organization_lineage_names":["Association for Computational Linguistics"],"type":"conference"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2020 Conference on Empirical Methods in Natural Language Processing (EMNLP)","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:2011.05744","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/2011.05744","pdf_url":"https://arxiv.org/pdf/2011.05744","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"doi:10.48550/arxiv.2011.05744","doi":"https://doi.org/10.48550/arxiv.2011.05744","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2011.05744","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"}],"best_oa_location":{"id":"doi:10.18653/v1/2020.emnlp-main.560","doi":"https://doi.org/10.18653/v1/2020.emnlp-main.560","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/2020.emnlp-main.560","pdf_url":"https://www.aclweb.org/anthology/2020.emnlp-main.560.pdf","source":{"id":"https://openalex.org/S4363608991","display_name":"Conference on Empirical Methods in Natural Language Processing (EMNLP)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310320244","host_organization_name":"Association for Computational Linguistics","host_organization_lineage":["https://openalex.org/P4310320244"],"host_organization_lineage_names":["Association for Computational Linguistics"],"type":"conference"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2020 Conference on Empirical Methods in Natural Language Processing (EMNLP)","raw_type":"proceedings-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[{"id":"https://openalex.org/G3544945854","display_name":"\u591a\u8bed\u8a00\u73af\u5883\u4e0b\u6587\u672c\u60c5\u611f\u8bed\u4e49\u8ba1\u7b97\u5173\u952e\u6280\u672f\u7814\u7a76","funder_award_id":"61772036","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3103291908.pdf","grobid_xml":"https://content.openalex.org/works/W3103291908.grobid-xml"},"referenced_works_count":29,"referenced_works":["https://openalex.org/W1522301498","https://openalex.org/W2047237057","https://openalex.org/W2133564696","https://openalex.org/W2269738476","https://openalex.org/W2626778328","https://openalex.org/W2751448157","https://openalex.org/W2766453196","https://openalex.org/W2768409085","https://openalex.org/W2796979813","https://openalex.org/W2890431379","https://openalex.org/W2891691255","https://openalex.org/W2896457183","https://openalex.org/W2912624765","https://openalex.org/W2945102109","https://openalex.org/W2948465491","https://openalex.org/W2952032096","https://openalex.org/W2952380375","https://openalex.org/W2963341956","https://openalex.org/W2964121744","https://openalex.org/W2970172141","https://openalex.org/W2970442801","https://openalex.org/W2971323043","https://openalex.org/W2971377618","https://openalex.org/W2972571786","https://openalex.org/W2984689063","https://openalex.org/W2985377636","https://openalex.org/W3015937477","https://openalex.org/W3034196295","https://openalex.org/W7097023696"],"related_works":["https://openalex.org/W3184970047","https://openalex.org/W4388551794","https://openalex.org/W3118052716","https://openalex.org/W4226490385","https://openalex.org/W7161766948","https://openalex.org/W4385573339","https://openalex.org/W4406771118","https://openalex.org/W4412945208","https://openalex.org/W3134835171","https://openalex.org/W4402670240"],"abstract_inverted_index":{"Context-dependent":[0],"text-to-SQL":[1,13,91],"task":[2,14],"has":[3],"drawn":[4],"much":[5],"attention":[6],"in":[7,24],"recent":[8],"years.Previous":[9],"models":[10],"on":[11,17,77,107],"context-dependent":[12,89],"only":[15],"concentrate":[16],"utilizing":[18],"historical":[19,31],"user":[20,34],"inputs.In":[21],"this":[22],"work,":[23],"addition":[25],"to":[26,29,44,59],"using":[27],"encoders":[28],"capture":[30],"information":[32,47],"of":[33,48,63,71,118,124],"inputs,":[35],"we":[36,54],"propose":[37],"a":[38,56,99],"database":[39,49,126],"schema":[40,50,127],"interaction":[41,128],"graph":[42,129],"encoder":[43],"utilize":[45],"historicalal":[46],"items.In":[51],"decoding":[52],"phase,":[53],"introduce":[55],"gate":[57],"mechanism":[58],"weigh":[60],"the":[61,69,78,108,116,122,125],"importance":[62],"different":[64],"vocabularies":[65],"and":[66,81,102,112,121],"then":[67],"make":[68],"prediction":[70],"SQL":[72],"tokens.We":[73],"evaluate":[74],"our":[75,119],"model":[76,93,97,120],"benchmark":[79],"SParC":[80],"CoSQL":[82],"datasets,":[83],"which":[84],"are":[85],"two":[86,109],"large":[87,100],"complex":[88],"cross-domain":[90],"datasets.Our":[92],"outperforms":[94],"previous":[95],"state-of-the-art":[96,105],"by":[98],"margin":[101],"achieves":[103],"new":[104],"results":[106,114],"datasets.The":[110],"comparison":[111],"ablation":[113],"demonstrate":[115],"efficacy":[117],"usefulness":[123],"encoder.":[130]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W3103291908","counts_by_year":[{"year":2026,"cited_by_count":11},{"year":2025,"cited_by_count":7},{"year":2024,"cited_by_count":7},{"year":2023,"cited_by_count":16},{"year":2022,"cited_by_count":12},{"year":2021,"cited_by_count":7}],"updated_date":"2026-11-19T14:11:59.513116","created_date":"2020-11-23T00:00:00"}
