{"title":"On Relational Language Translation","authors":"A. Dudáš, Daniel Demian, J. Škrinárová","doi":"10.1109/Informatics57926.2022.10083497","DOIUrl":null,"url":null,"abstract":"Relational database model, as one of the most commonly used database models, is defined by the structure used for the storing of data, methods of data manipulation and so called data integrity. In this paper, we are focusing on the methods and processes of manipulating data stored in the database with the use of relational algebra, relational calculus and Structured Query Language. The paper presents the design, implementation and experimental evaluation of a software tool that can be used for automatic translation between the mentioned relational languages themselves and restricted natural language with the integrated automatic optimization of queries in relational algebra.","PeriodicalId":101488,"journal":{"name":"2022 IEEE 16th International Scientific Conference on Informatics (Informatics)","volume":"17 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2022-11-23","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"2022 IEEE 16th International Scientific Conference on Informatics (Informatics)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/Informatics57926.2022.10083497","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 1
Abstract
Relational database model, as one of the most commonly used database models, is defined by the structure used for the storing of data, methods of data manipulation and so called data integrity. In this paper, we are focusing on the methods and processes of manipulating data stored in the database with the use of relational algebra, relational calculus and Structured Query Language. The paper presents the design, implementation and experimental evaluation of a software tool that can be used for automatic translation between the mentioned relational languages themselves and restricted natural language with the integrated automatic optimization of queries in relational algebra.