title: Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¿ÑÐ¾ÑÐ¾ÑÐ¸Ð¿Ð° Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð¸ÑÐ¾Ð²Ð°Ð½Ð½Ð¾Ð¹ ÑÐ¸ÑÑÐµÐ¼Ñ Ð¿ÑÐ¾Ð²ÐµÑÐºÐ¸ Ð¿ÑÐ°Ð²Ð¸Ð»ÑÐ½Ð¾ÑÑÐ¸ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð½Ð° ÑÐ·ÑÐºÐµ Oracle SQL Ñ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸ÐµÐ¼ Oracle Application Express
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: The development of a prototype of an automated query validation system in Oracle SQL language using Oracle Application Express
Creators: name: Ð¦ÑÐ´ÑÐ¿Ð¾Ð²Ð°, ÐÐ»Ð¸Ð·Ð°Ð²ÐµÑÐ°
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2022
Subjects: Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð¸ÑÐ¾Ð²Ð°Ð½Ð½ÑÐµ ÑÐ¸ÑÑÐµÐ¼Ñ
sql-Ð·Ð°Ð¿ÑÐ¾ÑÑ
oracle application express
Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ
automated systems
sql queries
databases

description: Ð¢ÐµÐ¼Ð° Ð²ÑÐ¿ÑÑÐºÐ½Ð¾Ð¹ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÑ: Â«Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¿ÑÐ¾ÑÐ¾ÑÐ¸Ð¿Ð° Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð¸ÑÐ¾Ð²Ð°Ð½Ð½Ð¾Ð¹ ÑÐ¸ÑÑÐµÐ¼Ñ Ð¿ÑÐ¾Ð²ÐµÑÐºÐ¸ Ð¿ÑÐ°Ð²Ð¸Ð»ÑÐ½Ð¾ÑÑÐ¸ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð½Ð° ÑÐ·ÑÐºÐµ Oracle SQL Ñ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸ÐµÐ¼ Oracle Application ExpressÂ». ÐÐ°Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¿Ð¾ÑÐ²ÑÑÐµÐ½Ð° Ð·Ð°Ð´Ð°ÑÐµ Ð¿ÑÐ¾Ð²ÐµÑÐºÐ¸ Ð¿ÑÐ°Ð²Ð¸Ð»ÑÐ½Ð¾ÑÑÐ¸ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð½Ð° ÑÐ·ÑÐºÐµ Oracle SQL. Ð¦ÐµÐ»ÑÑ ÑÐ°Ð±Ð¾ÑÑ ÑÐ²Ð»ÑÐµÑÑÑ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¿ÑÐ¾ÑÐ¾ÑÐ¸Ð¿Ð° Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð¸ÑÐ¾Ð²Ð°Ð½Ð½Ð¾Ð¹ ÑÐ¸ÑÑÐµÐ¼Ñ, ÐºÐ¾ÑÐ¾ÑÐ°Ñ Ð±Ñ ÑÐ°Ð¼Ð¾ÑÑÐ¾ÑÑÐµÐ»ÑÐ½Ð¾ Ð¿ÑÐ¾Ð²ÐµÑÑÐ»Ð° Ð¿ÑÐ°Ð²Ð¸Ð»ÑÐ½Ð¾ÑÑÑ SQL-Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð², Ð½Ð°Ð¿Ð¸ÑÐ°Ð½Ð½ÑÑ ÑÑÑÐ´ÐµÐ½ÑÐ°Ð¼Ð¸. Ð ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐµ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð´Ð°Ð½Ð½Ð¾Ð¹ ÑÐµÐ¼Ñ Ð±ÑÐ»Ð¸ Ð¸Ð·ÑÑÐµÐ½Ñ Ð¼ÐµÑÐ¾Ð´Ñ Ð¿ÑÐ¾Ð²ÐµÑÐºÐ¸ Ð¿ÑÐ°Ð²Ð¸Ð»ÑÐ½Ð¾ÑÑÐ¸ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð¸ ÑÐ¾Ð·Ð´Ð°Ð½ ÑÐ¾Ð±ÑÑÐ²ÐµÐ½Ð½ÑÐ¹ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼, Ð¿Ð¾Ð·Ð²Ð¾Ð»ÑÑÑÐ¸Ð¹ Ð¾ÑÑÑÐµÑÑÐ²Ð¸ÑÑ Ð¿ÑÐ¾Ð²ÐµÑÐºÑ SQL-Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² ÑÑÑÐ´ÐµÐ½ÑÐ¾Ð² Ð½Ð° Ð¿ÑÐ°Ð²Ð¸Ð»ÑÐ½Ð¾ÑÑÑ. ÐÐ¾Ð»ÐµÐµ ÑÐ¾Ð³Ð¾, Ð±ÑÐ»Ð¸ ÑÐ°ÑÑÐ¼Ð¾ÑÑÐµÐ½Ñ ÑÐ°Ð·Ð»Ð¸ÑÐ½ÑÐµ Ð¸Ð½ÑÑÑÑÐ¼ÐµÐ½ÑÑ Ð´Ð»Ñ ÑÐ°Ð·Ð²ÐµÑÑÑÐ²Ð°Ð½Ð¸Ñ ÑÐ¸ÑÑÐµÐ¼Ñ, Ð° Ð²ÑÐ±ÑÐ°Ð½Ð½Ð¾Ðµ ÑÑÐµÐ´ÑÑÐ²Ð¾ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ¸ Ð±ÑÐ»Ð¾ Ð¾Ð±Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ð¾. Ð ÐºÐ¾Ð½ÐµÑÐ½Ð¾Ð¼ Ð¸ÑÐ¾Ð³Ðµ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð½Ð°Ñ ÑÐ¸ÑÑÐµÐ¼Ð° Ð±ÑÐ»Ð° Ð¿ÑÐ¾ÑÐµÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð° Ð½Ð° ÑÐµÐ°Ð»ÑÐ½ÑÑ Ð·Ð°Ð´Ð°Ð½Ð¸ÑÑ Ð¿Ð¾ SQL, ÑÐµÑÐ°ÐµÐ¼ÑÑ ÑÑÑÐ´ÐµÐ½ÑÐ°Ð¼Ð¸ Ð¼Ð¾ÐµÐ³Ð¾ Ð½Ð°Ð¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð½Ð° Ð²ÑÐ¾ÑÐ¾Ð¼ Ð¸ ÑÑÐµÑÑÐµÐ¼ ÐºÑÑÑÐ°Ñ. Ð Ð¿ÐµÑÑÐ¿ÐµÐºÑÐ¸Ð²Ðµ Ð´Ð°Ð½Ð½ÑÑ Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð¸ÑÐ¾Ð²Ð°Ð½Ð½ÑÑ ÑÐ¸ÑÑÐµÐ¼Ñ Ð¼Ð¾Ð¶Ð½Ð¾ Ð²Ð½ÐµÐ´ÑÐ¸ÑÑ Ð² ÐÐ£ÐÑ, Ð³Ð´Ðµ ÐµÑÑÑ Ð½Ð°Ð¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ, ÑÐ²ÑÐ·Ð°Ð½Ð½ÑÐµ Ñ Ð±Ð°Ð·Ð°Ð¼Ð¸ Ð´Ð°Ð½Ð½ÑÑ.
description: The subject of the graduate qualification work is Â«The development of a prototype of an automated query validation system in Oracle SQL language using Oracle Application ExpressÂ». This work is devoted to the task of verifying the correctness of queries in Oracle SQL language. The purpose of the work is to develop a prototype of an automated system that would independently verify the correctness of SQL queries written by students. As a result of the research on this topic, methods for verifying the correctness of queries were studied and a proprietary algorithm was created that allows to implement the verification of studentsâ SQL queries for correctness. Moreover, various tools for deploying the system were considered, and the chosen one was justified. Eventually, the developed system was tested on real SQL tasks written by sophomores and third-year students of my area of specialization. In the future, this automated system can be implemented in universities where there are areas related to databases.