Publication: Depuración de SQL
Loading...
Official URL
Full text at PDC
Publication Date
2020
Authors
Advisors (or tutors)
Editors
Journal Title
Journal ISSN
Volume Title
Publisher
Citations
Exportar
Abstract
SQL es un lenguaje de programación declarativo que esconde muchos de sus mecanismos de resolución y por tanto no tiene un flujo de depuración claro como puedan tener otros lenguajes como C cuando se encuentra un error. Actualmenteexisten muy pocos métodos para hacer una depuración de una base de datos y la depuración declarativa es una de las soluciones más efectivas para esto.
DES es un programa que permite la depuración de bases de datos a través de una interfaz textual pero resulta tedioso de usar en comparación a una interfaz gráfica. En este trabajo crearemos una interfaz gráfica para la depuración de bases de datos en ACIDE, que es un IDE especializado en bases de datos que usa DES como soporte para realizar sus operaciones. En esta versión se ha añadido una ampliación de la depuración que hay en la última versión disponible de DES que permite asignar el estado de tablas y vistas que no están seleccionadas, mejorando la usabilidad del sistema. Además, en este trabajo se han realizado tareas de mantenimiento y corrección de errores en ACIDE.
SQL is a declarative programming language that hides many of its resolution mechanisms and therefore does not have a clear debugging flow as other languages such as C may have when an error is encountered. Currently there are very few methods of debugging a database and declarative debugging is one of the most effective solutions for this. DES is a program that allows debugging databases through a textual interface but it is tedious to use compared to a graphical interface. In this work we will create a graphical interface for debugging databases in ACIDE, which is an IDE specialized in databases that uses DES as support to carry out its operations. In this version, an extension of the debugging that is in the latest available version of DES has been added that allows assigning the status of tables and views that are not selected, improving the usability of the system. In addition, this work has carried out maintenance and error correction tasks in ACIDE.
SQL is a declarative programming language that hides many of its resolution mechanisms and therefore does not have a clear debugging flow as other languages such as C may have when an error is encountered. Currently there are very few methods of debugging a database and declarative debugging is one of the most effective solutions for this. DES is a program that allows debugging databases through a textual interface but it is tedious to use compared to a graphical interface. In this work we will create a graphical interface for debugging databases in ACIDE, which is an IDE specialized in databases that uses DES as support to carry out its operations. In this version, an extension of the debugging that is in the latest available version of DES has been added that allows assigning the status of tables and views that are not selected, improving the usability of the system. In addition, this work has carried out maintenance and error correction tasks in ACIDE.
Description
Trabajo de Fin de grado en Ingeniería del Software, Facultad de Informática UCM, Departamento de Ingeniería del Software e Inteligencia Artificial, Curso 2019/2020.