Based On Teaching Affairs System Database Stored Procedure Research

With the arrival of the information age, the growing popularity of information technology is wandering into almost all field of our life. Manage information system began to play an important role in university teaching service systems, it brings fundamental changes for the education information management.The system is based on B/S structure of the database management system (DBMS) solutions. The basic framework platform of Management Information System of Tianjin University of Science and Technology Continuing Education college was established, focuses on solving some of the features in enrollment management module.At first, the system function is meeting the actual needs of Continuing Education Information Management, using the tool of SQL Server Management Studio Express (SSMSE) to develop the database, and the system is based on MVC (model-view-controller) model, database systems, and implements ASP.NET access to the database through ADO.NET. Secondly, create database tables by the entities in the system, get the system E-R diagram by the constraints between the table. And then develops the software application. Using queuing theory(stochastic service system theory) to discuss the practice of software stored procedure scheduling issues, proposes stored procedure service model and scheduling algorithm based on practice teaching service system. The system provides a comprehensive right management controls into the system administrator, the subjects administrator of main department, correspondence Station (College) administrators, class manager and the ordinary students. Each role have different administrative privileges, they can use the different functions, in order to ensure the security of data information. Finally, in order to optimize database performance, and solve the problems in teaching service system that may be encountered due to the concurrent access. Propose service system evaluation for specific application environments. Provide an effective solution to optimize the efficiency of querying in teaching service system.