基于完全学分制的选课系统的性能优化  

The Performance Optimization of Class Selection System Based on Complete Credit System

作　　者：黄瑞雪[1] 李翠华[1] 蔡炳跃[1] 

机构地区：[1]厦门大学信息科学与技术学院,福建厦门361005

出　　处：《厦门大学学报（自然科学版）》2011年第3期535-539,共5页Journal of Xiamen University：Natural Science

基　　金：国家重点基础研究发展计划(973)项目(2007CB311005);国防基础科研计划项目(B1420110155);福建省自然科学基金项目(A0710020);厦门大学985二期信息创新平台项目

摘　　要：完全学分制是我国高等院校近年来教学改革的一种潮流.完全学分制的核心是全面选课制.对于综合性大学而言,随着招生规模的不断扩大,专业、班级、学生的数量急剧增加,有关学生选课的各种信息量也成倍增长,实行全面选课制难度很大.针对全面选课制的特点,深入分析了选课系统的复杂性,针对选课系统的性能问题提出了多层次的优化方案.从选课的需求着手,对选课策略进行了调整,对系统设计进行了优化,降低了选课时数据处理的集中度.从技术层面,采用存储过程、数据缓存、数据库连接池技术.应用实践表明,优化后的系统性能有了大幅度的提升,能较好地满足综合性大学的选课要求.Complete credit system is one of education innovation trends,its core is complete course-selection regulation.For comprehensive university,with the rapid expanding of students,classes,specialties,the course-selection information doubled.It is much more difficult to implement complete course-selection.We make a deep research into complete course-selection regulation and analyze the complexity of course-selection system.For solving performance problem,we bring the multi-level performance optimization scheme.On the analysis of system requirements,we regulate the strategy of course-selection and optimize the system design,so as to reduce the data process concentration.The front-level query is optimaized and the database is designed on technical side.Database connection pool is bring to improve connection management.The multi-level data caching is used to make a practical separated procession of course-selection activity.Test results show that there is a big improvement in system performance,and can be able to fulfil comprehensive university′s requirements.

关 键 词：学分制 全面选课制 性能优化 

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