ModelLStat: A Tool for Static Analysis in Model Layer on Web MVC Application

Model-View-Controller (MVC) is a design pattern that is commonly used for web applications. MVC divides applications into three main layers, the Model, the View Layer, and the Controller Layer. The model layer is related to the database. All data access to and from the database occurs at this layer. Usually, to monitor database activity, we use tools from database tools in the server. That tools allow us to see real-time database load performance. The disadvantage of real-time monitoring is that we can perform analysis when the application is running. Lack in the implementation process will be seen as a whole when the application is running. If errors are known when the program is running, the costs will be higher. Therefore, in this study, we create a tool to analyze the model layer. The analysis we use is static analysis. We try to analyze information from the code in the model layer. From the code in the model layer, we will analyze information on classes, functions, queries, and the frequency of tables are accessed in the database. With this static analysis, we can anticipate the access data within the application before the application goes live.