| What is stored procedure? It is a subroutine; | | | | Second, when database privileges have stored |
| codes that help make a program perform certain | | | | procedures using static SQL, the security of the |
| tasks, but are independent of the other codes of | | | | program can be improved by the database |
| the program. It is used in relational database | | | | administrator. This means that only the database |
| systems which are systems that relates, | | | | administrator can set who can make edits or |
| matches, and groups information to already | | | | access to certain parts of the program, which are |
| existing organized data in the system that are | | | | database privileges. Usually, the users of the client |
| easy for laypeople to understand. So, what is | | | | applications will not need that database privilege; |
| stored procedure able to bring to the table? | | | | otherwise things may get chaotic should |
| First, as it is an independent set of codes that do | | | | inconsistency occur. |
| not affect the other codes in the network, its | | | | Lastly, because many tasks are constantly |
| network usage is not much. To further elaborate, | | | | repeated when using database applications, the |
| a set of codes that are interdependent with each | | | | act of doing things repeatedly would use codes |
| other in a network, for example, code A and | | | | over and over again. With static procedures used |
| code B, would require both codes in the network | | | | with static SQL, the codes do not need to be |
| to be active for use. However, it works in a way | | | | regenerated again and again, but instead, just |
| where only one code is needed to perform a | | | | taken the codes out of memory. This way, less |
| task, hence, less activation of codes within the | | | | server space is used, while improving reliability of |
| network. This also enhances the hardware or | | | | the codes to be used exactly the way it is |
| software where the stored procedures are used | | | | stored. |
| since less disk space is used on the server. | | | | |