Development of a stored procedure debugger for MYSQL V5.x

摘要

MYSQL is a relational database administrator. So, it is used to store data in a persistent way. It allows the creation of stored procedures on which they are a set of SQL instructions, plus a series of control structures that facilitate automated control actions that often take place in it. They are saved on the server, where they wait to be called to execute. In this context it has created a partial implementation of a tool for debugging behavior of such processes, considering that there is not a wide variety of these types of tools, especially free. Debugging is carried out, based on knowledge of the creation of translators, which consists of two phases: The Analysis phase and the phase of code translation; on which only the first applies, in its three stages: lexical, parsing and semantic analysis, where there is an interaction with a graphical interface and the database engine.