SQL query synthesis software based on the met-amodel of the BlockSet toolkit

Nikolay Kozyrev, Pavel Keyno

Abstract


The paper examines one of the main tasks in developing an interpreter for the BlockSet toolkit - designing the synthesis of SQL queries based on the metamodel, as well as software for its use. The authors examined both the toolkit as a whole and the role of the algorithm itself in its context. Peripheral tools for managing the algorithm in the BML language are discussed in detail. The stages of its formation and technical details of implementation are demonstrated. In addition to the direct algorithm, a reverse algorithm for generating a query to search for factors of private events, which is necessary when implementing a resource based on an event-oriented approach, is also considered. For clarity, an example of processing the “message” event has been analyzed, as a result of which it is necessary to determine the id of “users” - the sender and the recipient, who need to be notified about the appearance of the specified “message”. Conclusions are drawn demonstrating the results of the work done.


Full Text:

PDF (Russian)

References


DOI: 10.25559/INJOIT.2307-8162.12.202404.54-59

J.J. Cadavid et al., “A Domain Specific Language to Generate Web Applications,” In CIbSE, 2009, pр. 139-144.

E. Visser, WebDSL. A Case Study in Domain-Specific Language. Berlin, Heidelberg. Springer 2008.

P.P. Keyno, “Predposylki formirovaniya novoj metodologii razrabotki veb-uzlov BlockSet i deklarativnogo yazyka BML,” [Prerequisites for the formation of a new methodology for developing BlockSet web sites and the declarative language BML]. Sovremennye informacionnye tekhnologii i IT-obrazovanie. [Modern information technologies and IT education.], vol. 11, no. 2, pp. 78-84, 2015. [in Rus]

P Keyno, “Software Architecture of synchronizer as part of declarative web-application modeling language interpreter,” Prikladnaya Informatika [Journal of Applied Informatics], vol. 11, no. 2 (62), pp. 65–77, 2016. [In Rus].

M. Hanus, S. Koschinicke, “An ER-based framework for declarative web programming,” In Practical Aspects of Declarative Languages, 2010, pp. 201-216

I.G. Borovskoy, E.A Shelmina, “Comparative analysis of desk-top and client-server databases,” Doklady Tomskogo gosudarstvennogo universiteta sistem upravlenija i radiojelektroniki, vol. 20, no 4, pp. 92-94, 2017.

The PostgreSQL Global Development Group. PostgreSQL documentation: Composites. URL: http://www.postgreSQL.org/docs/

/rowtypes.html

The PostgreSQL Global Development Group. PostgreSQL documentation: Arrays. URL: http://www.postgreSQL.org/

docs/10/arrays.html

P. Keyno, N. Kozyrev, V. Kvashnin, A. Novikov, “Permission system and its management organization in BlockSet project,” Prikladnaya informatika [Journal of Applied Informatics], vol. 14, no. 3 (81), pp. 66-73, 2019. [In Rus]

Nicolas Seriot. Parsing JSON is a Minefield. URL: htpp://http://seriot.ch/parsing_JSON.php

C.O. Truica et al, “Performance evaluation for CRUD operations in asynchronously replicated document oriented database,” In 2015 20th International Conference on Control Systems and Computer Science (CSCS),.IEEE, 2015, pр. 191-196.

A.N., Johanson, W. Hasselbring, “Effectiveness and efficiency of a domain-specific language for high-performance marine ecosystem simulation: a controlled experiment,” Empirical Software Engineering, vol. 22, pp. 2206-2236, 2017.

S. Karus, M. Dumas, “Predicting the maintainability of XSL transformations,” Science of Computer Programming, vol. 76, no. 12, pp. 1161–1176, 2011.

S.C. Kleene, Representation of events in nerve nets and finite automata: tech. rep. DTIC Document. — 1951.

P. Klint, T. Van Der Storm, J. Vinju, “On the impact of DSL tools on the maintainability of language implementations,” In Proceedings of the Tenth Workshop on Language Descriptions, Tools and Applications, ACM. 2010, p. 10.

T. Kosar, N. Oliveira, M. Mernik, V.J.M. Pereira, M. Crepinsˇek, C.D. Da, R.P. Henriques, “Comparing general-purpose and domain-specific languages: An empirical study,” Computer Science and Information Systems, vol. 7, no. 2, pp. 247–264, 2010.

C.T. Li, A. El Gamal, “An efficient feedback coding scheme with low error probability for discrete memoryless channels,” IEEE Transactions on Information Theory, vol. 61, no. 6, pp. 2953–2963, 2015.

K. Magel, R.M. Kluczny, W.A. Harrison, A.R. Dekock, Applying software complexity metrics to program maintenance. 1982.


Refbacks

  • There are currently no refbacks.


Abava  Кибербезопасность IT Congress 2024

ISSN: 2307-8162