基于MVC架构的Blackboard平台运行数据分析系统研究

A Study of the Blackboard Academic Suite Database Analysis System Based on the MVC Architecture

基于Blackboard平台数据库,研究设计了一种运行数据分析系统.在Blackboard网络教学平台中,用户的课程访问记录、测试使用情况、论坛使用情况可通过ACTIVITY_ACCUMULA-TOR、ATTEMPT、FORUM_MAIN等表的记录、计算后得到.所有数据从Blackboard平台数据库(ora-cle)导出到SQL Server数据库,再经过数据处理、汇总后,进行按课程汇总分析、按用户汇总分析、平台整体汇总分析.开发的数据分析系统利用SQL Server 2005对数据进行管理,易维护、扩展,数据传输和计算均在服务器端完成,增强了系统安全性和易维护性;采用Microsoft.NET MVC架构开发B/S网站,系统界面友好、简捷易操作.实际运行表明,Blackboard平台运行数据分析系统运行速度快、操作透明度高,对历史数据和准实时数据均能进行查询,结果准确.此系统已在实践中应用,并取得了良好效果.

Based on Blackboard platform database,the authors of this paper designed a Database Analysis Sys-tem. In the Blackboard Academic Suite, the details of users’access to courses, test usage and forum usage can be recorded and calculated by ACTIVITY ACCUMULATOR table, ATTEMPT table, FORUM MAIN table,etc. Firstly, all the data will be derived from the Blackboard platform database（oracle）to a SQL Server database,and then they will be processed and tabulated later. Lastly, they will be analyzed in terms of summarized courses,us-ers and overall platform. The developed data analysis system will be administrated by SQL Server 2005, which can be maintained and extended conveniently. The data transmission and computing can just be done over the terminal, which strengthens the safety and stability of the system. It also adopts Microsoft. NET MVC framework to develop B/S website, which makes the system user-friendly and easily operated. The actual operation shows blackboard platform data analysis system is fast and transparent;it also implements the function of querying all the historical data and quasi-real-time data, which can be testified accurately. The system has already been ap-plied into the practice and achieves very good results. This paper describes the design process to develop a data model of the system in detail.