Natural Language Processing in Translation of Relational Languages

Methods of data manipulation in combination with sturcture of the data and integrity constraints define data model used in the relational databases. This article focuses on the methods and processes of operation sets which are used for selection of data from relational database and translation between various formats of this manipulation. The article presents the design, implementation and experimental evaluation of tool for translating between relational algebra, tuple relational calculus, Structured Query Language and unrestricted natural language in all directions. Presented software tool translates from natural language with the use of artificial intelligence methods for natural language processing, syntactic analysis and parsing. Generative pretrained transformer of third generation (GPT3) based Codex – Davinci translation model was used as an artificial intelligence method used in the workflow of translation from English language to relational languages

natural language processing, relational languages, relational databases, language translation, artificial intelligence

1. Kvet, M., Matiasko, K. Analysis of current trends in relational database indexing. (2020) Proceedings of 2020 International Conference on Smart Systems and Technologies, SST 2020, art. no. 9264034, pp. 109-114. DOI: 10.1109/SST49455.2020.9264034

2. Kvet, M., Matiasko, K. Data block and tuple identification using master index. (2020) Sensors (Switzerland), 20 (7), art. no. 1848. DOI: 10.3390/s20071848

3. Kvet, M., Matiasko, K. Efficiency of the relational database tuple access. (2019) INFORMATICS 2019 - IEEE 15th International Scientific Conference on Informatics, Proceedings, art. no. 9119325, pp. 231-236. DOI: 10.1109/Informatics47936.2019.9119325

4. Steingartner, W. Compiler Module of Abstract Machine Code for Formal Semantics Course. (2021) SAMI 2021 - IEEE 19th World Symposium on Applied Machine Intelligence and Informatics, Proceedings, art. no. 9378696, pp. 193-199. DOI: 10.1109/SAMI50585.2021.9378696

5. Brockman, G., Cheung, V., Pettersson, L., Schneider, J., Schulman, J., Tang, J., & Zaremba, W. (2016). OpenAI gym. ArXiv:1606.01540.

6. Jing, L., Aixin, S., Ray, H., Chenliang, L. A Survey on Deep Learning for Named Entity Recognition. IEEE Transactions on Knowledge and Data Engineering. 2020. DOI:10.1109/TKDE.2020.2981314

7. Huang, H., Wang, X., Wang, H. NER-RAKE: An improved rapid automatic keyword extraction method for scientific literatures based on named entity recognition. Proceedings of the Association for Information Science and Technology, 2020, 57(1) DOI:10.1002/pra2.374

8. Nhi N.Y. Vo, Quang T. Vu, Nam H. Vu, Tu A. Vu, Bang D. Mach, Guandong Xu. Domain-specific NLP system to support learning path and curriculum design at tech universities. Computers and Education: Artificial Intelligence, Volume 3, 2022, 100042, ISSN 2666-920X

9. Gridach, M. A framework based on (probabilistic) soft logic and neural network for NLP. Applied Soft Computing, Volume 93, 2020, 106232,ISSN 1568-4946

10. Yu-Cheng Zhou, Zhe Zheng, Jia-Rui Lin, Xin-Zheng Lu. Integrating NLP and context-free grammar for complex rule interpretation towards automated compliance checking. Computers in Industry, Volume 142, 2022, 103746, ISSN 0166-3615

...