Using metadata to validate SQL DDL queries in training systems
How to cite
Abstract
This paper examines the problem of automated verification of SQL DDL queries when learning to work with databases in online courses or interactive simulators. The use of metadata available in the PostgreSQL database through the system catalog and information schema is proposed. A comparative analysis of these methods is carried out, their advantages and disadvantages for different types of database objects are considered. It describes the implementation of the verification functions and the use of the PostgreSQL extension to combine them.
Keywords
References
Mikhailova E., Boitsev A., Egorova O., Grafeeva N.G., Romanov A., Volchek D. Curriculum for Digital Culture at ITMO University // Advances in Intelligent Systems and Computing - 2020, Vol. 1161 AISC, pp. 235-244
Национальный исследовательский университет ИТМО. 2025. https://itmo.ru/
Новиков Б.А., Горшкова Е.А., Графеева Н.Г. Основы технологий баз данных: уч. пос. 2-е изд. М.: ДМК Пресс, 2020. 200 с.
Рогов Е., Лузанов П., Баштанов И. Организация данных. Системный каталог // Postgres professional. 2015-2022.
Рогов Е. PostgreSQL 17 изнутри // М.: ДМК Пресс, 2024. С. 24-28.
ISO/IEC 9075-11:2023 Information technology – Database languages SQL Part 11: Information and definition schemas (SQL/Schemata). 2023.
PostGIS. 2024. https://postgis.net/
PostgreSQL extension for ddl-queries validation. 2025. https://github.com/pluzhnikova/check_ddl_ext
PostgreSQL Documentation: 17 https://www.postgresql.org/docs/17/index.html.
Downloads
Published
Issue
Section
Metrics
License
Copyright (c) 2025 Education Management Review
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.