{"title":"类clusterix数据库中sql查询到正则计划的自动转换","authors":"R. K. Klassen, I. A. Kazantsev","doi":"10.1109/RusAutoCon52004.2021.9537394","DOIUrl":null,"url":null,"abstract":"Previously completed developments on pretranslation of SQL queries have not brought significant success. Nevertheless, such a pre-translator is necessary for the use of Clusterix-like database management systems (DBMS) by a wide range of specialists. The article proposes an original approach to the operations of pretranslation of SQL queries without writing to the regular schedule for Clusterix-like DBMS. The possibility of implementing such a pretranslator is being discussed. The concepts of \"complex\" and \"simple\" SQL-query are given. The pretranslator is based on the antlr4 grammar parsing library, which is used to build a SQL query tree. The software-based pretranslator uses it to build queries that fit a regular plan.","PeriodicalId":106150,"journal":{"name":"2021 International Russian Automation Conference (RusAutoCon)","volume":"31 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2021-09-05","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Automatic Translator of Sql-Query to Regular Plan for Clusterix-Like Dbms\",\"authors\":\"R. K. Klassen, I. A. Kazantsev\",\"doi\":\"10.1109/RusAutoCon52004.2021.9537394\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Previously completed developments on pretranslation of SQL queries have not brought significant success. Nevertheless, such a pre-translator is necessary for the use of Clusterix-like database management systems (DBMS) by a wide range of specialists. The article proposes an original approach to the operations of pretranslation of SQL queries without writing to the regular schedule for Clusterix-like DBMS. The possibility of implementing such a pretranslator is being discussed. The concepts of \\\"complex\\\" and \\\"simple\\\" SQL-query are given. The pretranslator is based on the antlr4 grammar parsing library, which is used to build a SQL query tree. The software-based pretranslator uses it to build queries that fit a regular plan.\",\"PeriodicalId\":106150,\"journal\":{\"name\":\"2021 International Russian Automation Conference (RusAutoCon)\",\"volume\":\"31 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2021-09-05\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2021 International Russian Automation Conference (RusAutoCon)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/RusAutoCon52004.2021.9537394\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2021 International Russian Automation Conference (RusAutoCon)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/RusAutoCon52004.2021.9537394","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Automatic Translator of Sql-Query to Regular Plan for Clusterix-Like Dbms
Previously completed developments on pretranslation of SQL queries have not brought significant success. Nevertheless, such a pre-translator is necessary for the use of Clusterix-like database management systems (DBMS) by a wide range of specialists. The article proposes an original approach to the operations of pretranslation of SQL queries without writing to the regular schedule for Clusterix-like DBMS. The possibility of implementing such a pretranslator is being discussed. The concepts of "complex" and "simple" SQL-query are given. The pretranslator is based on the antlr4 grammar parsing library, which is used to build a SQL query tree. The software-based pretranslator uses it to build queries that fit a regular plan.