Top

Published in:

2021 | OriginalPaper | Chapter

SQL Query from Portuguese Language Using Natural Language Processing

Authors : Carlos Fernando Mulessiua da Silva, Rajni Jindal

Published in: Advanced Computing

Publisher: Springer Singapore

Activate our intelligent search to find suitable subject content or patents.

search-config

AI-assisted search

Off

Abstract

Nowadays, there is a great challenge to make information technology transparent so the end-user can have a good user experience. We are proposing a Natural Language Interface Model in which the user introduces the phrase through a text box in the local natural language, preferably in the Portuguese language. The system will read these words and separate them into a list of tokens, which will be analyzed, and if unnecessary words are found, they will be removed. The system will make a combination of the user’s request. In the end, it will arrive until the generation of SQL Query and basics MongoDB Query as well ready to be executed directly in the Database. The model has an average accuracy of 70.27%. A morphological analysis will understand the meaning of the user’s sentence ending in a friendly interface.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

über 102.000 Bücher
über 537 Zeitschriften

aus folgenden Fachgebieten:

Automobil + Motoren
Bauwesen + Immobilien
Business IT + Informatik
Elektrotechnik + Elektronik
Energie + Nachhaltigkeit
Finance + Banking
Management + Führung
Marketing + Vertrieb
Maschinenbau + Werkstoffe
Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

inform now

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

über 67.000 Bücher
über 390 Zeitschriften

aus folgenden Fachgebieten:

Automobil + Motoren
Bauwesen + Immobilien
Business IT + Informatik
Elektrotechnik + Elektronik
Energie + Nachhaltigkeit
Maschinenbau + Werkstoffe

Jetzt Wissensvorsprung sichern!

inform now

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

über 67.000 Bücher
über 340 Zeitschriften

aus folgenden Fachgebieten:

Bauwesen + Immobilien
Business IT + Informatik
Finance + Banking
Management + Führung
Marketing + Vertrieb
Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

inform now

previous chapter Speech2Image: Generating Images from Speech Using Pix2Pix Model

next chapter Misogynous Text Classification Using SVM and LSTM

Kate, A., Kamble, S., Bodkhe, A., Joshi, M.: Conversion of natural language query to SQL query. In: Proceedings of the 2nd International Conference on Electronics, Communication and Aerospace Technology, ICECA 2018, pp. 488–491. Institute of Electrical and Electronics Engineers Inc. (2018). https://doi.org/10.1109/ICECA.2018.8474639

Mohite, A., Bhojane, V.: Natural language interface to database using modified co-occurrence matrix technique. In: 2015 International Conference on Pervasive Computing: Advance Communication Technology and Application for Society, ICPC 2015. Institute of Electrical and Electronics Engineers Inc. (2015). https://doi.org/10.1109/PERVASIVE.2015.7087045

Badhya, S., Prasad, A., Rohan, S., Yashwanth, S., Deepamala, N., Shobha, G.: Natural language to structured query language using elasticsearch for descriptive columns. In: CSITSS 2019 - 2019 4th International Conference on Computational Systems and Information Technology for Sustainable Solution, Proceedings (2019). https://doi.org/10.1109/CSITSS47250.2019.9031030

Reinaldha, F., Widagdo, E.: Natural language interfaces to database (NLIDB): question handling and unit conversion. In: Proceedings of 2014 International Conference on Data and Software Engineering, ICODSE 2014. Institute of Electrical and Electronics Engineers Inc. (2014). https://doi.org/10.1109/ICODSE.2014.7062663

Bais, H., Machkour, M.: Arabic language interface for xml databases. In: Proceedings of 2019 IEEE World Conference on Complex Systems, WCCS 2019. Institute of Electrical and Electronics Engineers Inc. (2019). https://doi.org/10.1109/ICoCS.2019.8930803

Choudhary, N., Gore, S.: Impact of intellisense on the accuracy of natural language interface to database. In: 2015 4th International Conference on Reliability, Infocom Technologies and Optimization: Trends and Future Directions, ICRITO 2015. Institute of Electrical and Electronics Engineers Inc. (2015). https://doi.org/https://doi.org/10.1109/ICRITO.2015.7359310

Gupta, P., Goswami, A., Koul, S., Sartape, K.: IQS-intelligent querying system using natural language processing. In: Proceedings of the International Conference on Electronics, Communication and Aerospace Technology, ICECA 2017, pp. 410–413. Institute of Electrical and Electronics Engineers Inc. (January 2017). https://doi.org/10.1109/ICECA.2017.8212846

Kumar, R., Dua, M.: Translating controlled natural language query into SQL query using pattern matching technique. In: 2014 International Conference for Convergence of Technology, I2CT 2014. Institute of Electrical and Electronics Engineers Inc. (2014). https://doi.org/10.1109/I2CT.2014.7092161

Pradeep, T., Rafeeque, P.C., Murali, R.: Natural language to NoSQL query conversion using deep learning, SSRN Electron. J. (2019). https://doi.org/10.2139/ssrn.3436631

10.

Pinheiro, V., Pequeno, T., Furtado, V., Franco, W.: InferenceNet.Br: expression of inferentialist semantic content of the Portuguese language. In: Pardo, T.A.S., Branco, A., Klautau, A., Vieira, R., de Lima, V.L.S. (eds.) PROPOR 2010. LNCS (LNAI), vol. 6001, pp. 90–99. Springer, Heidelberg (2010). https://doi.org/10.1007/978-3-642-12320-7_12CrossRef

11.

Posevkin, R., Bessmertny, I.: Multilanguage natural user interface to database. In: Application of Information and Communication Technologies AICT 2016 - Conference Proceedings, Institute of Electrical and Electronics Engineers Inc. (2017). https://doi.org/10.1109/ICAICT.2016.7991706

12.

Ribeiro Afonso, A.: Brazilian Portuguese text clustering based on evolutionary computing. IEEE Latin Am. Trans. 14, 3370–3377 (2016). https://doi.org/10.1109/TLA.2016.7587644CrossRef

13.

Mondal, S., Mukherjee, P., Chakraborty, B., Bashar, R.: Natural language query to NoSQL generation using query-response model. In: Proceedings - International Conference on Machine Learning and Data Engineering, iCMLDE 2019, pp. 85–90. Institute of Electrical and Electronics Engineers Inc. (2019). https://doi.org/10.1109/iCMLDE49015.2019.00026

14.

Parvat, A., Chavan, J., Kadam, S., Dev, S., Pathak, V.: A survey of deep-learning frameworks. In: Proceedings of the International Conference on Inventive Systems and Control, ICISC 2017, Institute of Electrical and Electronics Engineers Inc. (2017). https://doi.org/10.1109/ICISC.2017.8068684

Title: SQL Query from Portuguese Language Using Natural Language Processing
Authors: Carlos Fernando Mulessiua da Silva
Rajni Jindal
Publisher: Springer Singapore
Book: Advanced Computing
Print ISBN: 978-981-16-0400-3

Electronic ISBN: 978-981-16-0401-0

Copyright Year: 2021
DOI: https://doi.org/10.1007/978-981-16-0401-0_25

Springer Professional

Abstract

Please log in to get access to your license.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Springer Professional "Technik"

Springer Professional "Wirtschaft"

Premium Partner