Semantic Parsing with Syntax- and Table-Aware SQL Generation

Name: Work Video:
Duration: 3 min 30 s
Description: Yibo Sun, Duyu Tang, Nan Duan, Jianshu Ji, Guihong Cao, Xiaocheng Feng, Bing Qin, Ting Liu, Ming Zhou. Proceedings of the 56th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers). 2018.
Yibo Sun; Duyu Tang; Nan Duan; Jianshu Ji; Guihong Cao; Xiaocheng Feng; Bing Qin; Ting Liu; Ming Zhou
{'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': {'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': {'id': 'https://openalex.org/S4363608652', 'display_name': 'Proceedings of the 60th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers)', 'issn_l': None, 'issn': None, 'is_oa': False, 'is_in_doaj': False, 'is_core': False, 'host_organization': None, 'host_organization_name': None, 'host_organization_lineage': [], 'host_organization_lineage_names': [], 'type': 'conference'}, 'license': 'cc-by', 'license_id': 'https://openalex.org/licenses/cc-by', 'version': 'publishedVersion', 'is_accepted': True, 'is_published': True}, 'type': 'article', 'type_crossref': 'proceedings-article', 'indexed_in': ['crossref'], 'open_access': {'is_oa': True, 'oa_status': 'hybrid', 'oa_url': 'https://www.aclweb.org/anthology/P18-1034.pdf', 'any_repository_has_fulltext': True}, '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'], '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': None}, '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'], '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'], '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': None}, 'institutions': [], 'countries': [], 'is_corresponding': False, 'raw_author_name': 'Jianshu Ji', 'raw_affiliation_strings': [], 'affiliations': []}, {'author_position': 'middle', 'author': {'id': 'https://openalex.org/A5110660237', 'display_name': 'Guihong Cao', 'orcid': None}, 'institutions': [], 'countries': [], 'is_corresponding': False, 'raw_author_name': 'Guihong Cao', 'raw_affiliation_strings': [], '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'], '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'], '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'], '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'], 'affiliations': [{'raw_affiliation_string': 'Microsoft Research Asia, Beijing, China Microsoft AI and Research, Redmond WA, USA', 'institution_ids': ['https://openalex.org/I4210113369']}]}], 'institution_assertions': [], 'countries_distinct_count': 1, 'institutions_distinct_count': 2, 'corresponding_author_ids': [], 'corresponding_institution_ids': [], 'apc_list': None, 'apc_paid': None, 'fwci': 3.379, 'has_fulltext': True, 'fulltext_origin': 'pdf', 'cited_by_count': 72, 'citation_normalized_percentile': {'value': 0.999898, 'is_in_top_1_percent': True, 'is_in_top_10_percent': True}, 'cited_by_percentile_year': {'min': 97, 'max': 98}, 'biblio': {'volume': None, 'issue': None, 'first_page': None, 'last_page': None}, 'is_retracted': False, 'is_paratext': False, 'primary_topic': {'id': 'https://openalex.org/T10181', 'display_name': 'Natural Language Processing Techniques', 'score': 0.9999, '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.9999, '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.9998, '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.9869, '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/table', 'display_name': 'Table (database)', 'score': 0.51390266}, {'id': 'https://openalex.org/keywords/computational-linguistics', 'display_name': 'Computational linguistics', 'score': 0.45335805}], 'concepts': [{'id': 'https://openalex.org/C41008148', 'wikidata': 'https://www.wikidata.org/wiki/Q21198', 'display_name': 'Computer science', 'level': 0, 'score': 0.7720982}, {'id': 'https://openalex.org/C186644900', 'wikidata': 'https://www.wikidata.org/wiki/Q194152', 'display_name': 'Parsing', 'level': 2, 'score': 0.76317465}, {'id': 'https://openalex.org/C60048249', 'wikidata': 'https://www.wikidata.org/wiki/Q37437', 'display_name': 'Syntax', 'level': 2, 'score': 0.6477453}, {'id': 'https://openalex.org/C204321447', 'wikidata': 'https://www.wikidata.org/wiki/Q30642', 'display_name': 'Natural language processing', 'level': 1, 'score': 0.58941656}, {'id': 'https://openalex.org/C199360897', 'wikidata': 'https://www.wikidata.org/wiki/Q9143', 'display_name': 'Programming language', 'level': 1, 'score': 0.5739207}, {'id': 'https://openalex.org/C45235069', 'wikidata': 'https://www.wikidata.org/wiki/Q278425', 'display_name': 'Table (database)', 'level': 2, 'score': 0.51390266}, {'id': 'https://openalex.org/C510870499', 'wikidata': 'https://www.wikidata.org/wiki/Q47607', 'display_name': 'SQL', 'level': 2, 'score': 0.510257}, {'id': 'https://openalex.org/C155092808', 'wikidata': 'https://www.wikidata.org/wiki/Q182557', 'display_name': 'Computational linguistics', 'level': 2, 'score': 0.45335805}, {'id': 'https://openalex.org/C154945302', 'wikidata': 'https://www.wikidata.org/wiki/Q11660', 'display_name': 'Artificial intelligence', 'level': 1, 'score': 0.44941056}, {'id': 'https://openalex.org/C77088390', 'wikidata': 'https://www.wikidata.org/wiki/Q8513', 'display_name': 'Database', 'level': 1, 'score': 0.24380383}], 'mesh': [], 'locations_count': 2, 'locations': [{'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': {'id': 'https://openalex.org/S4363608652', 'display_name': 'Proceedings of the 60th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers)', 'issn_l': None, 'issn': None, 'is_oa': False, 'is_in_doaj': False, 'is_core': False, 'host_organization': None, 'host_organization_name': None, 'host_organization_lineage': [], 'host_organization_lineage_names': [], 'type': 'conference'}, 'license': 'cc-by', 'license_id': 'https://openalex.org/licenses/cc-by', 'version': 'publishedVersion', 'is_accepted': True, 'is_published': True}, {'is_oa': True, 'landing_page_url': 'https://arxiv.org/abs/1804.08338', 'pdf_url': 'https://arxiv.org/pdf/1804.08338', 'source': {'id': 'https://openalex.org/S4306400194', 'display_name': 'arXiv (Cornell University)', 'issn_l': None, 'issn': None, 'is_oa': True, 'is_in_doaj': False, 'is_core': False, 'host_organization': 'https://openalex.org/I205783295', 'host_organization_name': 'Cornell University', 'host_organization_lineage': ['https://openalex.org/I205783295'], 'host_organization_lineage_names': ['Cornell University'], 'type': 'repository'}, 'license': None, 'license_id': None, 'version': 'submittedVersion', 'is_accepted': False, 'is_published': False}], 'best_oa_location': {'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': {'id': 'https://openalex.org/S4363608652', 'display_name': 'Proceedings of the 60th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers)', 'issn_l': None, 'issn': None, 'is_oa': False, 'is_in_doaj': False, 'is_core': False, 'host_organization': None, 'host_organization_name': None, 'host_organization_lineage': [], 'host_organization_lineage_names': [], 'type': 'conference'}, 'license': 'cc-by', 'license_id': 'https://openalex.org/licenses/cc-by', 'version': 'publishedVersion', 'is_accepted': True, 'is_published': True}, 'sustainable_development_goals': [{'score': 0.82, 'display_name': 'Quality education', 'id': 'https://metadata.un.org/sdg/4'}], 'grants': [], 'datasets': [], 'versions': [], '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/W4288047943', 'https://openalex.org/W4221163897', 'https://openalex.org/W2979495269', 'https://openalex.org/W2952780262', 'https://openalex.org/W2948670949', 'https://openalex.org/W2392917763', 'https://openalex.org/W2168778844', 'https://openalex.org/W2083429127', 'https://openalex.org/W2077104824'], '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]}, 'cited_by_api_url': 'https://api.openalex.org/works?filter=cites:W2963207291', 'counts_by_year': [{'year': 2024, 'cited_by_count': 4}, {'year': 2023, 'cited_by_count': 5}, {'year': 2022, 'cited_by_count': 7}, {'year': 2021, 'cited_by_count': 10}, {'year': 2020, 'cited_by_count': 20}, {'year': 2019, 'cited_by_count': 19}, {'year': 2018, 'cited_by_count': 6}], 'updated_date': '2024-12-17T03:23:49.400468', 'created_date': '2019-07-30'}
Publication Information

Basic Information

Access and Citation

AI Researcher Chatbot

Primary Location

Authors

Topics

Keywords

Related Works
