Dynamic Store Procedures in Database

Abstract

In production of applied software, different methods have been proposed for communication with the database (Feizi et al. 2010). These methods are generally classified in two main groups. In the first method, questions are usually written in the program section and inside the code. In the second method, questions are stored in the database as stored procedures and the stored procedures are recalled in the database (Deshpande 2007). Typically, both of the above methods have advantages and disadvantages. In the first method, the velocity of coding rate is higher than the first condition and there is the possibility of generating complex query in the code. In the first method, the response time to the query was high and in each step of sending the query to the database, the seven steps of query processing in the database (query, analyzer, analysis tree, optimizer, execution plan, execution, and the results of query) are implemented for the query (Feizi et al. 2010). So, the response time to queries is longer than in the second method.