AUTOMATICAL PRETRANSLATION OF SQL-QUERIES TO A REGULAR PLAN IN CLUSTERIX-LIKE DBMS-Reference-Cited by-同舟云学术

AUTOMATICAL PRETRANSLATION OF SQL-QUERIES TO A REGULAR PLAN IN CLUSTERIX-LIKE DBMS

Published:2020-10 Issue:196 Volume: Page:11-20
ISSN:1810-7206
Container-title:Vestnik komp'iuternykh i informatsionnykh tekhnologii
language:ru
Short-container-title:vkit

Author:

Klassen R. K.,Kazantsev I. A.

Abstract

Previously completed designs for pretranslating SQL queries did not bring significant success. Nevertheless, such a pretranslator is necessary for the possibility of using Clusterix-like database management systems (DBMSs) by a wide circle of specialists. The article proposes an original approach to pretranslating SQL queries without writing operations to the regular plan for Clusterix-like DBMSs. The possibility of implementing such a pretranslator is discussed. The concepts of a hard and a simple SQL query are given. The basis of the pretranslator is a library for parsing arbitrary grammars antlr4, which is used to build a SQL query tree. A software-implemented pretranslator uses it to build queries that meet the regular plan.

Publisher

Izdatel'skii dom Spektr, LLC

Reference16 articles.

1. PostgreSQL: Documentation: 12: 2. A Brief History of PostgreSQL. (2019). PostgreSQL Documentation. Available at: https://www.postgresql.org/docs/current/ history.html (Accessed: 19.12.2019).

2. SQL. (2019). Wikipedia. Available at: https://ru.wikipedia.org/?oldid=103455867 (Accessed: 21.11.2019). [in Russian language]

3. PostgreSQL: The World̓’s Most Advanced Open Source Database. (2019). PostgreSQL. Available at: https:// www.postgresql.org/ (Accessed: 19.12.2019).

4. TIOBE Index. TIOBE – The Software Quality Company. Available at: https://www.tiobe.com/tiobe-index/ (Accessed: 19.12.2019).

5. Database Trends – SQL vs. NoSQL, Top Data-bases, Single vs. Multiple Database Use. (2019). Highscalability. Available at: http://highscalability.com/blog/2019/3/6/2019-database-trends-sql-vs-nosql-top-databases-single-vs-mu.html (Accessed: 19.12.2019).

Cited by 1 articles. 订阅此论文施引文献订阅此论文施引文献，注册后可以免费订阅5篇论文的施引文献，订阅后可以查看论文全部施引文献

1. IMPROVING THE AUTOMATIC PRETANSLATOR OF SQL-QUERIES TO A REGULAR PLAN;Vestnik komp'iuternykh i informatsionnykh tekhnologii;2021-12