COMPARATIVE CHARACTERISTIC OF MEANS OF AUTOMATED CHECK OF THE CORRECTNESS OF WRITING OF SQL REQUESTS
https://doi.org/10.26518/2071-7296-2017-3(55)-92-97
Abstract
The article presents an analysis of resources that can be used to test users who study the SQL language. Also, the article describes plan and result of the attack on web applications for learning the SQL language. There are some weaknesses of web applications in terms of their ability to verify the correctness of the compilation of SQL queries, which are also describes here. The conclusion deals with is made about the expediency of developing a specialized test system for verifying the correctness of writing SQL-queries.
Keywords
database,
shadow database,
table,
record,
DB scheme,
SQL-request,
attack,
testing system,
automated system,
DBMS
About the Authors
Z. V. Semenova
Siberian State Automobile and Highway University
Russian Federation
Semenova Zinaida Vasil’yevna – doctor of pedagogical sciences, professor, head of the department of Information Security
Russian Federation
Semenova Zinaida Vasil’yevna – doctor of pedagogical sciences, professor, head of the department of Information Security
S. A. Lyubich
Siberian State Automobile and Highway University
Russian Federation
Lyubich Stanislav Alexandrovich – senior lecturer of the department of Information Security
Russian Federation
Lyubich Stanislav Alexandrovich – senior lecturer of the department of Information Security
A. G Kuznetsov
Siberian State Automobile and Highway University
Russian Federation
Kuznetsov Artem Gennad’yevich – student, department department of Information Security
Russian Federation
Kuznetsov Artem Gennad’yevich – student, department department of Information Security
P. A. Mal’tsev
Siberian State Automobile and Highway University
Russian Federation
Mal’tsev Pavel Andreyevich – student, department department of Information Security
Russian Federation
Mal’tsev Pavel Andreyevich – student, department department of Information Security
References
1. Reyting sistem upravleniya bazami dannykh (SUBD) 2016. Available at: http://tagline.ru/database-management-systems-rating/
2. Vstupil v silu zakon o sokhranenii i obrabotke personal’nykh dannykh s ispol’zovaniyem serverov, nakhodyashchikhsya na territorii Rossii. GARANT.RU. Available at: http://www.garant.ru/news/648095/#ixzz4fqIthNDx
3. Perovskaya S. VeralTest Express 2.6: testy na vse sluchai zhizni. Available at: http://www.softkey.info/reviews/review16552.php
4. Moodle - sistema distantsionnogo obucheniya. Available at: https://opentechnology.ru/products/moodle
5. SQL trenazher. Available at: http://www.sqlex.ru.5. SQL trainer (electronic resource): http://www.sql-ex.ru
6. Websites to Learn SQL Online for FREE. (electronic resource): http://javarevisited.blogspot.ru/2015/06/5-websites-to-learn-sql-onlineforfree.html
7. Kursy po SQL. Available at: https://academy.vertabelo.com
Review
For citations:
Semenova Z.V., Lyubich S.A., Kuznetsov A.G., Mal’tsev P.A. COMPARATIVE CHARACTERISTIC OF MEANS OF AUTOMATED CHECK OF THE CORRECTNESS OF WRITING OF SQL REQUESTS. The Russian Automobile and Highway Industry Journal. 2017;(3(55)):152-160. (In Russ.) https://doi.org/10.26518/2071-7296-2017-3(55)-92-97
Views:
880
Email this article 