{"id":"https://openalex.org/W2952032096","doi":"https://doi.org/10.18653/v1/p19-1448","title":"Representing Schema Structure with Graph Neural Networks for Text-to-SQL Parsing","display_name":"Representing Schema Structure with Graph Neural Networks for Text-to-SQL Parsing","publication_year":2019,"publication_date":"2019-01-01","ids":{"openalex":"https://openalex.org/W2952032096","doi":"https://doi.org/10.18653/v1/p19-1448","mag":"2952032096"},"language":"en","primary_location":{"id":"doi:10.18653/v1/p19-1448","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/p19-1448","pdf_url":"https://www.aclweb.org/anthology/P19-1448.pdf","source":null,"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 57th Annual Meeting of the Association for Computational Linguistics","raw_type":"proceedings-article"},"type":"preprint","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.aclweb.org/anthology/P19-1448.pdf","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5051169643","display_name":"Ben Bogin","orcid":null},"institutions":[{"id":"https://openalex.org/I16391192","display_name":"Tel Aviv University","ror":"https://ror.org/04mhzgx49","country_code":"IL","type":"education","lineage":["https://openalex.org/I16391192"]}],"countries":["IL"],"is_corresponding":true,"raw_author_name":"Ben Bogin","raw_affiliation_strings":["School of Computer Science, Tel-Aviv University"],"affiliations":[{"raw_affiliation_string":"School of Computer Science, Tel-Aviv University","institution_ids":["https://openalex.org/I16391192"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5045872048","display_name":"Jonathan Berant","orcid":null},"institutions":[{"id":"https://openalex.org/I16391192","display_name":"Tel Aviv University","ror":"https://ror.org/04mhzgx49","country_code":"IL","type":"education","lineage":["https://openalex.org/I16391192"]},{"id":"https://openalex.org/I4210156221","display_name":"Allen Institute for Artificial Intelligence","ror":"https://ror.org/05w520734","country_code":"US","type":"nonprofit","lineage":["https://openalex.org/I4210156221"]}],"countries":["IL","US"],"is_corresponding":false,"raw_author_name":"Jonathan Berant","raw_affiliation_strings":["Allen Institute for Artificial Intelligence","School of Computer Science, Tel-Aviv University"],"affiliations":[{"raw_affiliation_string":"Allen Institute for Artificial Intelligence","institution_ids":["https://openalex.org/I4210156221"]},{"raw_affiliation_string":"School of Computer Science, Tel-Aviv University","institution_ids":["https://openalex.org/I16391192"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5035088083","display_name":"Matt Gardner","orcid":"https://orcid.org/0000-0001-8458-1727"},"institutions":[{"id":"https://openalex.org/I4210156221","display_name":"Allen Institute for Artificial Intelligence","ror":"https://ror.org/05w520734","country_code":"US","type":"nonprofit","lineage":["https://openalex.org/I4210156221"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Matt Gardner","raw_affiliation_strings":["Allen Institute for Artificial Intelligence"],"affiliations":[{"raw_affiliation_string":"Allen Institute for Artificial Intelligence","institution_ids":["https://openalex.org/I4210156221"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5051169643"],"corresponding_institution_ids":["https://openalex.org/I16391192"],"apc_list":null,"apc_paid":null,"fwci":16.6389,"has_fulltext":true,"cited_by_count":197,"citation_normalized_percentile":{"value":0.99277987,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":99,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"4560","last_page":"4565"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","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/T10181","display_name":"Natural Language Processing Techniques","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/T10028","display_name":"Topic Modeling","score":0.9987000226974487,"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.9962999820709229,"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/computer-science","display_name":"Computer science","score":0.8714019060134888},{"id":"https://openalex.org/keywords/parsing","display_name":"Parsing","score":0.7010197639465332},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.6111106872558594},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5728312730789185},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.5302196145057678},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.5175096988677979},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.4833931028842926},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.4335158169269562},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.4251213073730469},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.32314038276672363},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.268077552318573},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.08695518970489502}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8714019060134888},{"id":"https://openalex.org/C186644900","wikidata":"https://www.wikidata.org/wiki/Q194152","display_name":"Parsing","level":2,"score":0.7010197639465332},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6111106872558594},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5728312730789185},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.5302196145057678},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.5175096988677979},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4833931028842926},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.4335158169269562},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.4251213073730469},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.32314038276672363},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.268077552318573},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.08695518970489502}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.18653/v1/p19-1448","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/p19-1448","pdf_url":"https://www.aclweb.org/anthology/P19-1448.pdf","source":null,"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 57th Annual Meeting of the Association for Computational Linguistics","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.18653/v1/p19-1448","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/p19-1448","pdf_url":"https://www.aclweb.org/anthology/P19-1448.pdf","source":null,"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 57th Annual Meeting of the Association for Computational Linguistics","raw_type":"proceedings-article"},"sustainable_development_goals":[{"display_name":"Quality Education","score":0.5199999809265137,"id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2952032096.pdf","grobid_xml":"https://content.openalex.org/works/W2952032096.grobid-xml"},"referenced_works_count":26,"referenced_works":["https://openalex.org/W1496189301","https://openalex.org/W2133564696","https://openalex.org/W2157331557","https://openalex.org/W2163274265","https://openalex.org/W2511108736","https://openalex.org/W2751448157","https://openalex.org/W2757361303","https://openalex.org/W2793978524","https://openalex.org/W2798663534","https://openalex.org/W2812869832","https://openalex.org/W2890431379","https://openalex.org/W2891691255","https://openalex.org/W2947354947","https://openalex.org/W2950898568","https://openalex.org/W2962728167","https://openalex.org/W2963617989","https://openalex.org/W2963662654","https://openalex.org/W2963691697","https://openalex.org/W2964078224","https://openalex.org/W2964271186","https://openalex.org/W2964308564","https://openalex.org/W4236265809","https://openalex.org/W4289406345","https://openalex.org/W4289494028","https://openalex.org/W4289699827","https://openalex.org/W6601926947"],"related_works":["https://openalex.org/W579810227","https://openalex.org/W2952780262","https://openalex.org/W2979495269","https://openalex.org/W2392917763","https://openalex.org/W2083429127","https://openalex.org/W2358855848","https://openalex.org/W2142145894","https://openalex.org/W2033808215","https://openalex.org/W2807110902","https://openalex.org/W2359307945"],"abstract_inverted_index":{"Research":[0],"on":[1],"parsing":[2],"language":[3],"to":[4,111],"SQL":[5,61],"has":[6],"largely":[7],"ignored":[8],"the":[9,12,18,51,54,59,73,76,102,115,119],"structure":[10,52,74,104],"of":[11,53,75,118],"database":[13],"(DB)":[14],"schema,":[15],"either":[16],"because":[17,24],"DB":[19,55,77],"was":[20,26],"very":[21],"simple,":[22],"or":[23],"it":[25],"observed":[27],"at":[28,46,92,123],"both":[29,93],"training":[30],"and":[31,41,49,86,95],"test":[32,47],"time.":[33,97],"In":[34,63],"SPIDER,":[35],"a":[36,82],"recentlyreleased":[37],"text-to-SQL":[38],"dataset,":[39],"new":[40],"complex":[42],"DBs":[43],"are":[44],"given":[45],"time,":[48],"so":[50],"schema":[56,78,103],"can":[57],"inform":[58],"predicted":[60],"query.":[62],"this":[64,87],"paper,":[65],"we":[66],"present":[67],"an":[68],"encoder-decoder":[69],"semantic":[70],"parser,":[71],"where":[72],"is":[79,89,122],"encoded":[80],"with":[81],"graph":[83],"neural":[84],"network,":[85],"representation":[88],"later":[90],"used":[91],"encoding":[94,101],"decoding":[96],"Evaluation":[98],"shows":[99],"that":[100],"improves":[105],"our":[106],"parser":[107],"accuracy":[108],"from":[109],"33.8%":[110],"39.4%,":[112],"dramatically":[113],"above":[114],"current":[116],"state":[117],"art,":[120],"which":[121],"19.7%.":[124]},"counts_by_year":[{"year":2026,"cited_by_count":7},{"year":2025,"cited_by_count":27},{"year":2024,"cited_by_count":20},{"year":2023,"cited_by_count":28},{"year":2022,"cited_by_count":17},{"year":2021,"cited_by_count":37},{"year":2020,"cited_by_count":48},{"year":2019,"cited_by_count":13}],"updated_date":"2026-03-27T14:29:43.386196","created_date":"2025-10-10T00:00:00"}