Semantic Mapping between Natural Language Questions and SQL Queries via Syntactic Pairing

被引:0
|
作者
Giordani, Alessandra [1 ]
Moschitti, Alessandro [1 ]
机构
[1] Univ Trento, Dept Comp Sci & Engn, I-38100 Povo, TN, Italy
关键词
Natural Language Processing; Kernel Methods; Support Vector Machines;
D O I
暂无
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
Automatically mapping natural language semantics into programming languages has always been a major and interesting challenge in Computer Science. In this paper, we approach such problem by carrying out mapping at syntactic level and then applying machine learning algorithms to derive an automatic translator of natural language questions into their associated SQL queries. To build the required training and test sets, we designed an algorithm, which, given an initial corpus of questions and their answers, semi-automatically generates the set of possible incorrect and correct pairs. We encode such relational pairs in Support Vector Machines by means of kernel functions applied to the syntactic trees of questions and queries. The accurate results on automatic classification of the above pairs above, suggest that our approach captures the shared semantics between the two languages.
引用
收藏
页码:207 / 221
页数:15
相关论文
共 50 条
  • [1] SEMANTIC MAPPING FROM NATURAL LANGUAGE QUESTIONS TO OWL QUERIES
    Gao, Mingxia
    Liu, Jiming
    Zhong, Ning
    Chen, Furong
    Liu, Chunnian
    [J]. COMPUTATIONAL INTELLIGENCE, 2011, 27 (02) : 280 - 314
  • [2] Translating natural language questions to SQL queries (nested queries)
    Swamidorai, Sindhuja
    Murthy, T. Satyanarayana
    Sriharsha, K., V
    [J]. MULTIMEDIA TOOLS AND APPLICATIONS, 2023, 83 (15) : 45391 - 45405
  • [3] Translating natural language questions to SQL queries (nested queries)
    Sindhuja Swamidorai
    T Satyanarayana Murthy
    K V Sriharsha
    [J]. Multimedia Tools and Applications, 2024, 83 : 45391 - 45405
  • [4] Corpora for Automatically Learning to Map Natural Language Questions into SQL Queries
    Giordani, Alessandra
    Moschitti, Alessandro
    [J]. LREC 2010 - SEVENTH INTERNATIONAL CONFERENCE ON LANGUAGE RESOURCES AND EVALUATION, 2010, : 2336 - 2339
  • [5] L2S: Transforming natural language questions into SQL queries
    Duc Tam Hoang
    Minh Le Nguyen
    Son Bao Pham
    [J]. 2015 SEVENTH INTERNATIONAL CONFERENCE ON KNOWLEDGE AND SYSTEMS ENGINEERING (KSE), 2015, : 85 - 90
  • [6] Mapping Natural Language Questions to SPARQL Queries for Job Search
    Karim, Naila
    Latif, Khalid
    Ahmed, Nabeel
    Fatima, Mishall
    Mumtaz, Atif
    [J]. 2013 IEEE SEVENTH INTERNATIONAL CONFERENCE ON SEMANTIC COMPUTING (ICSC 2013), 2013, : 150 - 153
  • [7] A system to transform natural language queries into SQL queries
    Solanki A.
    Kumar A.
    [J]. International Journal of Information Technology, 2022, 14 (1) : 437 - 446
  • [8] ACL-SQL: Generating SQL Queries from Natural Language
    Kaoshik, Ronak
    Patil, Rohit
    Prakash, R.
    Agarawal, Shaurya
    Jain, Naman
    Singh, Mayank
    [J]. CODS-COMAD 2021: PROCEEDINGS OF THE 3RD ACM INDIA JOINT INTERNATIONAL CONFERENCE ON DATA SCIENCE & MANAGEMENT OF DATA (8TH ACM IKDD CODS & 26TH COMAD), 2021, : 423 - 423
  • [9] Mapping algorithms to translate natural language questions into search queries for Web databases
    Jacso, P
    [J]. NATIONAL ONLINE MEETING, PROCEEDINGS - 1997, 1997, : 189 - 199
  • [10] QUESTION PATTERNS FOR NATURAL LANGUAGE TRANSLATION IN SQL QUERIES
    Zhekova, Mariya
    Totkov, George
    [J]. INTERNATIONAL JOURNAL ON INFORMATION TECHNOLOGIES AND SECURITY, 2021, 13 (02): : 43 - 54