CAJ | 학술논문

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