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

针对网上学习系统具有互动性、实时性、并发性等特点,采用MVC分层设计模式,使其能适应未来不断变化的需求和扩展。独立设置Web服务器处理页面HTTP请求,FMS服务器处理视频文件的媒体流转换,既可减轻单台服务器的数据处理压力,也使大数据量的视频传输不影响用户的网页浏览。重点分析数据库开发中数据库设计原则、数据库开发流程,以及数据库建表、数据表关联、数据库连接等实现方法。最后对系统进行功能和压力测试,结果表明,系统能支持大用户量和高并发在线学习和即时交流。系统功能完备、实用性强,推广应用将对包括干部培训在内的网络教育的教学和管理起到积极的示范作用。

Development of E-learning Database System Based on MVC

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.