{"id":"https://openalex.org/W2963207291","doi":"https://doi.org/10.18653/v1/p18-1034","title":"Semantic Parsing with Syntax- and Table-Aware SQL Generation","display_name":"Semantic Parsing with Syntax- and Table-Aware SQL Generation","publication_year":2018,"publication_date":"2018-01-01","ids":{"openalex":"https://openalex.org/W2963207291","doi":"https://doi.org/10.18653/v1/p18-1034","mag":"2963207291"},"language":"en","primary_location":{"id":"doi:10.18653/v1/p18-1034","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/p18-1034","pdf_url":"https://www.aclweb.org/anthology/P18-1034.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 56th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers)","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.aclweb.org/anthology/P18-1034.pdf","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5034137422","display_name":"Yibo Sun","orcid":"https://orcid.org/0000-0002-9519-2185"},"institutions":[{"id":"https://openalex.org/I204983213","display_name":"Harbin Institute of Technology","ror":"https://ror.org/01yqg2h08","country_code":"CN","type":"education","lineage":["https://openalex.org/I204983213"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yibo Sun","raw_affiliation_strings":["Harbin Institute of Technology, Harbin, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Harbin Institute of Technology, Harbin, China","institution_ids":["https://openalex.org/I204983213"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5110628758","display_name":"Duyu Tang","orcid":null},"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":"Duyu Tang","raw_affiliation_strings":["Microsoft Research Asia, Beijing, China Microsoft AI and Research, Redmond WA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Research Asia, Beijing, China Microsoft AI and Research, Redmond WA, USA","institution_ids":["https://openalex.org/I4210113369"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5042018181","display_name":"Nan Duan","orcid":"https://orcid.org/0000-0002-3387-4674"},"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":"Nan Duan","raw_affiliation_strings":["Microsoft Research Asia, Beijing, China Microsoft AI and Research, Redmond WA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Research Asia, Beijing, China Microsoft AI and Research, Redmond WA, USA","institution_ids":["https://openalex.org/I4210113369"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5026968640","display_name":"Jianshu Ji","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jianshu Ji","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5110660237","display_name":"Guihong Cao","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Guihong Cao","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073213620","display_name":"Xiaocheng Feng","orcid":"https://orcid.org/0000-0001-6011-0496"},"institutions":[{"id":"https://openalex.org/I204983213","display_name":"Harbin Institute of Technology","ror":"https://ror.org/01yqg2h08","country_code":"CN","type":"education","lineage":["https://openalex.org/I204983213"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xiaocheng Feng","raw_affiliation_strings":["Harbin Institute of Technology, Harbin, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Harbin Institute of Technology, Harbin, China","institution_ids":["https://openalex.org/I204983213"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5017671620","display_name":"Bing Qin","orcid":"https://orcid.org/0000-0002-2543-5604"},"institutions":[{"id":"https://openalex.org/I204983213","display_name":"Harbin Institute of Technology","ror":"https://ror.org/01yqg2h08","country_code":"CN","type":"education","lineage":["https://openalex.org/I204983213"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Bing Qin","raw_affiliation_strings":["Harbin Institute of Technology, Harbin, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Harbin Institute of Technology, Harbin, China","institution_ids":["https://openalex.org/I204983213"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100418156","display_name":"Ting Liu","orcid":"https://orcid.org/0000-0002-9091-7757"},"institutions":[{"id":"https://openalex.org/I204983213","display_name":"Harbin Institute of Technology","ror":"https://ror.org/01yqg2h08","country_code":"CN","type":"education","lineage":["https://openalex.org/I204983213"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Ting Liu","raw_affiliation_strings":["Harbin Institute of Technology, Harbin, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Harbin Institute of Technology, Harbin, China","institution_ids":["https://openalex.org/I204983213"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100701572","display_name":"Ming Zhou","orcid":"https://orcid.org/0000-0002-2551-2964"},"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":"Ming Zhou","raw_affiliation_strings":["Microsoft Research Asia, Beijing, China Microsoft AI and Research, Redmond WA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Research Asia, Beijing, China Microsoft AI and Research, Redmond WA, USA","institution_ids":["https://openalex.org/I4210113369"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":75,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"361","last_page":"372"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.9998999834060669,"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.9998999834060669,"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.9998000264167786,"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.9868999719619751,"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.772098183631897},{"id":"https://openalex.org/keywords/parsing","display_name":"Parsing","score":0.7631746530532837},{"id":"https://openalex.org/keywords/syntax","display_name":"Syntax","score":0.6477453112602234},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.5894165635108948},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.573920726776123},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.5139026641845703},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5102570056915283},{"id":"https://openalex.org/keywords/computational-linguistics","display_name":"Computational linguistics","score":0.4533580541610718},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.4494105577468872},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.24380382895469666}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.772098183631897},{"id":"https://openalex.org/C186644900","wikidata":"https://www.wikidata.org/wiki/Q194152","display_name":"Parsing","level":2,"score":0.7631746530532837},{"id":"https://openalex.org/C60048249","wikidata":"https://www.wikidata.org/wiki/Q37437","display_name":"Syntax","level":2,"score":0.6477453112602234},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.5894165635108948},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.573920726776123},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.5139026641845703},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5102570056915283},{"id":"https://openalex.org/C155092808","wikidata":"https://www.wikidata.org/wiki/Q182557","display_name":"Computational linguistics","level":2,"score":0.4533580541610718},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.4494105577468872},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.24380382895469666}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.18653/v1/p18-1034","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/p18-1034","pdf_url":"https://www.aclweb.org/anthology/P18-1034.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 56th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers)","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.18653/v1/p18-1034","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/p18-1034","pdf_url":"https://www.aclweb.org/anthology/P18-1034.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 56th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers)","raw_type":"proceedings-article"},"sustainable_development_goals":[{"score":0.8199999928474426,"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4"}],"awards":[{"id":"https://openalex.org/G304842684","display_name":"\u7ed3\u5408\u7528\u6237\u95f4\u76f8\u4e92\u5173\u6ce8\u7684\u4e2a\u6027\u5316APP\u56fe\u63a8\u8350\u6a21\u578b\u7814\u7a76","funder_award_id":"61772156","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G4165806713","display_name":null,"funder_award_id":"61632011","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G4645379681","display_name":null,"funder_award_id":"61472107","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/W2963207291.pdf","grobid_xml":"https://content.openalex.org/works/W2963207291.grobid-xml"},"referenced_works_count":69,"referenced_works":["https://openalex.org/W1496189301","https://openalex.org/W2047237057","https://openalex.org/W2097647324","https://openalex.org/W2101964891","https://openalex.org/W2111742432","https://openalex.org/W2119717200","https://openalex.org/W2121465811","https://openalex.org/W2125308790","https://openalex.org/W2130942839","https://openalex.org/W2133564696","https://openalex.org/W2154268919","https://openalex.org/W2157331557","https://openalex.org/W2161002933","https://openalex.org/W2163274265","https://openalex.org/W2186283982","https://openalex.org/W2189089430","https://openalex.org/W2227250678","https://openalex.org/W2236405165","https://openalex.org/W2250539671","https://openalex.org/W2250701144","https://openalex.org/W2252136820","https://openalex.org/W2269738476","https://openalex.org/W2307268612","https://openalex.org/W2342096063","https://openalex.org/W2507756961","https://openalex.org/W2511108736","https://openalex.org/W2546950329","https://openalex.org/W2556468274","https://openalex.org/W2594782638","https://openalex.org/W2612228435","https://openalex.org/W2736168681","https://openalex.org/W2739894144","https://openalex.org/W2740087922","https://openalex.org/W2741631785","https://openalex.org/W2751448157","https://openalex.org/W2757361303","https://openalex.org/W2768409085","https://openalex.org/W2782031709","https://openalex.org/W2808481912","https://openalex.org/W2949800357","https://openalex.org/W2962713807","https://openalex.org/W2962716332","https://openalex.org/W2962728167","https://openalex.org/W2962885446","https://openalex.org/W2962942784","https://openalex.org/W2962944953","https://openalex.org/W2963073938","https://openalex.org/W2963224792","https://openalex.org/W2963319870","https://openalex.org/W2963364848","https://openalex.org/W2963372003","https://openalex.org/W2963595025","https://openalex.org/W2963617989","https://openalex.org/W2963655793","https://openalex.org/W2963794306","https://openalex.org/W2963822436","https://openalex.org/W2963899988","https://openalex.org/W2963963168","https://openalex.org/W2964165364","https://openalex.org/W2964186869","https://openalex.org/W2964224049","https://openalex.org/W2964252535","https://openalex.org/W2964271186","https://openalex.org/W2964308564","https://openalex.org/W4236265809","https://openalex.org/W4246375690","https://openalex.org/W4295017198","https://openalex.org/W4299674251","https://openalex.org/W4301674784"],"related_works":["https://openalex.org/W579810227","https://openalex.org/W2952780262","https://openalex.org/W2979495269","https://openalex.org/W2392917763","https://openalex.org/W2948670949","https://openalex.org/W4288047943","https://openalex.org/W2083429127","https://openalex.org/W4221163897","https://openalex.org/W2077104824","https://openalex.org/W2168778844"],"abstract_inverted_index":{"Yibo":[0],"Sun,":[1],"Duyu":[2],"Tang,":[3],"Nan":[4],"Duan,":[5],"Jianshu":[6],"Ji,":[7],"Guihong":[8],"Cao,":[9],"Xiaocheng":[10],"Feng,":[11],"Bing":[12],"Qin,":[13],"Ting":[14],"Liu,":[15],"Ming":[16],"Zhou.":[17],"Proceedings":[18],"of":[19,24],"the":[20,25],"56th":[21],"Annual":[22],"Meeting":[23],"Association":[26],"for":[27],"Computational":[28],"Linguistics":[29],"(Volume":[30],"1:":[31],"Long":[32],"Papers).":[33],"2018.":[34]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":7},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":7},{"year":2021,"cited_by_count":10},{"year":2020,"cited_by_count":19},{"year":2019,"cited_by_count":18},{"year":2018,"cited_by_count":7}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}