基于MVC的网上学习系统数据库的开发  

Development of E-learning Database System Based on MVC

作　　者：黎冬媛[1] 周文辉[2] 莫剑斌 

机构地区：[1]电子科技大学中山学院计算机学院,广东中山528402 [2]电子科技大学中山学院机电工程学院,广东中山528402 [3]广东全通教育股份有限公司软件事业部,广东中山528403

出　　处：《计算机与现代化》2012年第6期156-160,共5页Computer and Modernization

基　　金：全国教育信息技术研究"十二五"规划重点课题(116120205);广东省教育部产学研结合项目(2009B090300254)

摘　　要：针对网上学习系统具有互动性、实时性、并发性等特点,采用MVC分层设计模式,使其能适应未来不断变化的需求和扩展。独立设置Web服务器处理页面HTTP请求,FMS服务器处理视频文件的媒体流转换,既可减轻单台服务器的数据处理压力,也使大数据量的视频传输不影响用户的网页浏览。重点分析数据库开发中数据库设计原则、数据库开发流程,以及数据库建表、数据表关联、数据库连接等实现方法。最后对系统进行功能和压力测试,结果表明,系统能支持大用户量和高并发在线学习和即时交流。系统功能完备、实用性强,推广应用将对包括干部培训在内的网络教育的教学和管理起到积极的示范作用。For E-learning system with features such as interactive, real-time, concurrency, MVC hierarchical design model is used so that it can adapt to change needs and extend in the future. Independent Web server HTrP request for pages is processed, video file streaming into FMS server and relieving pressure on the data processing of a single server, and video transmission of large amount of data will not affect the user＇ s website. Focused analysis on the process of database development in the principles of database design, database development, and database tables, database connection method is included. Finally test on function and stress of the system is carried out, results show that this system can support large user populations and high concurrency and instant online learning exchange. The system is fully functional, usable. Future application will include online education teach- ing, training, and management.

关 键 词：网上学习 MVC 数据库 

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