存储过程在教务管理系统中的应用研究  

Research on the Application of Storage in Educational Administration System

作　　者：沈黎 张本文 雷申洪 SHEN Li;ZHANG Benwen;LEI Shenhong(Institute of Technology,Sichuan Minzu College,Kangding Sichuan 626001)

机构地区：[1]四川民族学院理工学院,四川康定626001

出　　处：《软件》2022年第7期13-15,共3页Software

基　　金：四川民族学院横向基金项目(HX202102):在线考试系统。

摘　　要：以四川民族学院教务管理系统为例,针对此系统存在运行效率不高的问题,提出了利用存储过程提高在查询、修改、插入、用户登录等操作中系统运行效率的解决的方案,实践表明存储过程在此教务管理系统的应用中能有效的提高系统的运行效率。Taking the educational administration management system of Sichuan University for Nationalities as an example,aiming at the problem of low operation efficiency of this system,this paper puts forward a solution to improve the operation efficiency of the system in query,modification,insertion,user login and other operations by using stored procedures.The practice shows that the storage process can effectively improve the operation efficiency of the system in the application of this educational administration management system.

关 键 词：存储过程 SQL Server数据库 教务管理 系统效率 

分 类 号：TP311.52[自动化与计算机技术—计算机软件与理论]