The performance and reliability of converting natural language into structured query language can be problematic in handling nuances that are prevalent in natural language. Relational databases are not designed to understand language nuance, therefore the question why we must handle nuance has to be asked. This paper is looking at an alternative solution for the conversion of a Natural Language Query into a Structured Query Language (SQL) capable of being used to search a relational database. The process uses the natural language concept, Part of Speech to identify words that can be used to identify database tables and table columns. The use of Open NLP based grammar files, as well as additional configuration files, assist in the translation from natural language to query language. Having identified which tables and which columns contain the pertinent data the next step is to create the SQL statement.
References
[1]
Soumya, M.D. and Patil, B.A. (2017) An Interactive Interface for Natural Language Query Processing to Database Using Semantic Grammar. International Journal of Advance Research, Ideas and Innovations in Technology, 3, 193-198.
[2]
Kim, M. and Kim, H. (2018) Dialogue Act Classification Model Based on Deep Neural Networks for a Natural Language Interface to Databases in Korean. IEEE International Conference on Big Data and Smart Computing, Shanghai, 15-17 January 2018, 537-540. https://doi.org/10.1109/BigComp.2018.00090
[3]
Bais, H., Machkour, M. and Koutti, L. (2018) An Arabic Natural Language Interface for Querying Relational Databases Based on Natural Language Processing and Graph Theory Methods. International Journal of Reasoning-Based Intelligent Systems, 10, 155-165. https://doi.org/10.1504/IJRIS.2018.092221
[4]
Li, Y.Y. and Rafiei, D. (2017) Natural Language Data Management and Interfaces: Recent Development and Open Challenges. Proceedings of the 2017 ACM International Conference on Management of Data, Chicago, 14-19 May 2017, 1765-1770.
https://doi.org/10.1145/3035918.3054783
[5]
Jwalapuram, P. and Mamidi, R. (2017) Domain Independent Keyword Identification for Question Answering. International Conference on Asian Language Processing, Singapore, 5-7 December 2017, 95-98.
https://doi.org/10.1109/IALP.2017.8300554
[6]
Voorhees, E.M. (2001) The TREC Question Answering Track. Natural Language Engineering, 7, 361-378. https://doi.org/10.1017/S1351324901002789
[7]
Joshi, M.R. and Akerkar, R.A. (2008) Algorithms to Improve Performance of Natural Language Interface. International Journal of Computer Science and Applications, 5, 52-68.
[8]
Ratnaparkhi, A. (1996) A Maximum Entropy Model for Part-of-Speech Tagging. In: Conference on Empirical Methods in Natural Language Processing, Association for Computational Linguistics, Stroudsburg, 133-142.
http://aclweb.org/anthology/W/W96/W96-0213
[9]
Baldridge, J. (2005) The OpenNLP Project. http://opennlp.apache.org/
[10]
Taghipour, K. and HweeTou, N. (2015) One Million Sense-Tagged Instances for Word Sense Disambiguation and Induction. In: Proceedings of the Nineteenth Conference on Computational Natural Language Learning, Association for Computational Linguistics, Beijing, 338-344. https://doi.org/10.18653/v1/K15-1037
http://www.aclweb.org/anthology/K15-1037
[11]
Deuter, A. and Hans-Jürgen, K. (2015) Applying Manufacturing Performance Figures to Measure Software Development Excellence. In: Software Measurement, Lecture Notes in Business Information Processing, Springer, Cham, 62-77.
https://doi.org/10.1007/978-3-319-24285-9_5
[12]
Sim, S.E., Easterbrook, S. and Holt, R.C. (2003) Using Benchmarking to Advance Research: A Challenge to Software Engineering. 25th International Conference on Software Engineering, Portland, 3-10 May 2003, 74-83.
https://doi.org/10.1109/ICSE.2003.1201189
[13]
Siewiorek, D.P., Hudak, J.J., Suh, B.H. and Segal, Z. (1993) Development of a Benchmark to Measure System Robustness. The 23rd International Symposium on Fault-Tolerant Computing, Toulouse, 22-24 June 1993, 88-97.
https://doi.org/10.1109/FTCS.1993.627311
[14]
Gama, K., Pedraza, G., Lévêque, T. and Donsez, D. (2011) Application Management Plug-Ins through Dynamically Pluggable Probes. Proceedings of the 1st Workshop on Developing Tools as Plug-Ins, Waikiki, 28 May 2011, 32-35.
https://doi.org/10.1145/1984708.1984718
[15]
Whaley, J. (2000) A Portable Sampling-Based Profiler for Java Virtual Machines. Proceedings of the ACM Conference on Java Grande, San Francisco, 3-4 June 2000, 78-87. https://doi.org/10.1145/337449.337483
[16]
Brad, F., Iacob, R., Hosu, I. and Rebedea, T. (2017) Dataset for a Neural Natural Language Interface for Databases (NNLIDB). Proceedings of the 8th International Joint Conference on Natural Language Processing, Vol. 1, 13 p.
http://arxiv.org/abs/1707.03172
