数据挖掘在教学评估中的应用
|
摘要
数据挖掘是目前信息领域和数据库技术的前沿研究课题,关联规则技术是数据挖掘的最重要的组成部分之一,它用于发现大量数据中项集之间的有意义的关联和相关联系。本文旨在研究如何将数据挖掘技术与教学评估相结合,从大量数据中提取出隐藏在数据之中的有用的信息。
论文首先介绍了数据挖掘的定义及主要的数据挖掘技术,并给出数据挖掘的体系结构和运行过程。接着详细描述了关联规则挖掘的基本理论和经典关联规则挖掘算法Apriori算法,包括了规则生成的算法。其次,设计与阐述了评估系统的总体结构与功能,并对公共登录模块、数据采集模块、教师综合评估模块和统计查询模块进行了详细设计。最后,探讨了教学质量评估数据挖掘系统的实现方法,给出了基于SQLServer的两种数据挖掘的解决方案。本文给出了教学评估数据挖掘系统的软件框架,并使用相关数据进行了关联规则算法的实验,对结果进行了初步分析。所得出的结论对高校教学评估和教学工作都具有一定的指导意义。
Data Mining is a frontier area in information and database technology, Association rule technology is one of the most important components of Data Mining and it can be used in detecting the meaningful relevance and associations between the item sets of mass data.This paper aims at studying the way of combining data mining technology with teaching appraisal and the way of looking for useful information hiding behind the data from the large amounts of data.
In this paper firstly introduced the definition and several typical technologies of data mining, then gives its faculty structure and run course. Secondly mainly describe basic theory of association rule mining and classical mining algorithm Apriori including the algorithm of generate rules, then analyze the efficiency of algorithm Apriori. Secondly,the paper designs and elaborates the overall structure and the function of evaluation system,and designs the public registered module, the data acquisition module, the teacher overall assessment module and the statistical inquiry module in detail. Finally, this text inquires into the teaching quality evaluation data mining system and gives two kinds of solution based on the SQL Server. This text gives out the software frame of the system on teaching quality evaluation data mining, and uses correlated data to carry on the experiment of the association rule mining algorithm, and carries on its first step analysis on its results.The results obtained are valuable for collegeteaching evaluation.
论文首先介绍了数据挖掘的定义及主要的数据挖掘技术,并给出数据挖掘的体系结构和运行过程。接着详细描述了关联规则挖掘的基本理论和经典关联规则挖掘算法Apriori算法,包括了规则生成的算法。其次,设计与阐述了评估系统的总体结构与功能,并对公共登录模块、数据采集模块、教师综合评估模块和统计查询模块进行了详细设计。最后,探讨了教学质量评估数据挖掘系统的实现方法,给出了基于SQLServer的两种数据挖掘的解决方案。本文给出了教学评估数据挖掘系统的软件框架,并使用相关数据进行了关联规则算法的实验,对结果进行了初步分析。所得出的结论对高校教学评估和教学工作都具有一定的指导意义。
Data Mining is a frontier area in information and database technology, Association rule technology is one of the most important components of Data Mining and it can be used in detecting the meaningful relevance and associations between the item sets of mass data.This paper aims at studying the way of combining data mining technology with teaching appraisal and the way of looking for useful information hiding behind the data from the large amounts of data.
In this paper firstly introduced the definition and several typical technologies of data mining, then gives its faculty structure and run course. Secondly mainly describe basic theory of association rule mining and classical mining algorithm Apriori including the algorithm of generate rules, then analyze the efficiency of algorithm Apriori. Secondly,the paper designs and elaborates the overall structure and the function of evaluation system,and designs the public registered module, the data acquisition module, the teacher overall assessment module and the statistical inquiry module in detail. Finally, this text inquires into the teaching quality evaluation data mining system and gives two kinds of solution based on the SQL Server. This text gives out the software frame of the system on teaching quality evaluation data mining, and uses correlated data to carry on the experiment of the association rule mining algorithm, and carries on its first step analysis on its results.The results obtained are valuable for collegeteaching evaluation.
引文
1 刘同明等编著.数据挖掘技术及其应用.北京:国防工业出版社,2001:2-3
2 普通高等学校本科教学工作水平评估方案(试行).2004
3 张海笑.数据挖掘分类技术在高校教学中的应用研究:[学位论文].广东:广东工业大学,2005
4 陈文伟,黄金才著.数据仓库与数据挖掘.北京:人民邮电出版社,2003.
5 卢启程,邹平.数据挖掘的研究与应用进展.昆明理工大学学报,2002,27(5):62-66
6 汤小文,蔡庆生.数据挖掘在电信业中的应用.计算机工程,2004,30(6):36-38
7(美)Olivia Parr Rud著.朱扬勇等译.数据挖掘实践.北京:机械工业出版社,2003,50
8 丁元明.数据挖掘技术在高校教学质量评估中的应用研究:[学位论文].上海:华东师范大学,2005
9 R.Agrawa,T.Imielinski,A.Swarimi.Database Mining:A Performance Perspective.IEEE,TRANS.ON KNOWL.AND DATA ENG,1993,Vol.5 No.6 p12-16
10 Han J,et al.Data Mining:Concepts and Techniques.Morgan Kaufmann Publishers.(高等教育出版社,影印版),2001
11 候迪,宋擒豹.数据挖掘-构筑企业竞争优势.西安:西安交通大学出版,2001,1-3
12 MannilaH,Toivonen H,Inkeri verkamo A.Efficient Algorithms for Discovering Association Rules.In:Raghavan.Proceedings of AAA I Workshop on Knowledge Discovery in Database.America:AAA/MIT Press.1994:181-192
13 李雄飞,李军.数据挖掘与知识发现.高等教育出版社,2003:118-142
14 朱明.数据挖掘.合肥:中国科学技术大学出版社,2002:5-7
15 Agrawal R,Srikant Ro Fast algorithms for mining association rules.In Proceeding of the 20th International Conference on Very Large Databases.1994:487-499
16 朱玉全等编著.数据挖掘技术.南京:东南大学出版社,2006
17汪 澜.数据挖掘技术在教学评估中的应用研究:[学位论文].阜新:辽宁工程技术大学.2003
18 http://www.dmresearch.net/数据挖掘研究院
19 马希荣,孙华志.数据挖掘技术在教学评价中的应用.计算机工程与应用.2003(19)
20 http://www.dmgroup.org.cn/数据挖掘讨论组
21 R.Agrawal,T.Imielinski,and A.S.wami.Mining Association Rules between Sets of Items in Large Databases.In Proc.of the ACMSIGMOD Conference on Management of Data.Washington,D.C.,May 1993:207-216P
22 邵峰晶,于忠清编著.数据挖掘原理与算法.北京:中国水利水电出版社,2003
23 Park J,Chen M,Yu P.An effective hash based algorithm for mining association rules.In:Anon ed.Proceedings of the ACM SIGMOD International Conference on Management of Data.New York,NY:ACM Press.1995:175-186P
24 张云涛,龚玲.数据挖掘原理与技术.电子工业出版社,2004(4):191-199
25 冯宝萍,袁志华,苏宗伟等.高等学校教学效果综合评价体系研究,新乡教育学院学报,2003(12)
26 杨志民.高等院校课堂教学评估系统.河北建筑科技学院学报,1999(4):68-72
27 李静,王建军.数据挖掘在高校教学信息化管理中的应用探讨.科技信息,2006(8):300-301
28 Fayyad,Usama,Paul.Data mining and KDD.Promise and challenges.Future Generation Computer Systems,November,1997:99-115
29 Jiawei Han,Micheline Kambe:著,范明,孟小峰等译.数据挖掘概念与技术.北京:机械工业出版社,2004
30 商琳,骆斌.一种基于数据仓库的数据挖掘系统的结构框架.计算机应用研究,2000(9):63-65
31 颜雪松,李宏等.用SQL Server 2000构建数据挖掘解决方案.计算机与现代化.2001(5):29-34
32 曲春锦.改进的关联规则挖掘算法及其在教育信息挖掘中的应用.交通与计算机,2005(4):68-71
33 华江林.基于粗集理论的教学质量评估系统的研究:[学位论文].南京:河海大学,2006
34 董传银.Visual Basic 6.0数据库编程技术.北京:北京希望电子出版社,2002.152
35 罗朝盛等.Visual Basic 6.0程序设计教程。北京:人民邮电出版社,2002.2
36 Using Data Definition Language with SQL Server 2000 Analysis Services Client Applications.Dennis Kennedy Microsoft Corporation,May 2001.
37 陈辉等.关联规则挖掘在教师教学评价系统中的应用.南华大学学报自然科学版,2005,19(1):3
38 陈文庆,许棠.关联规则挖掘Apriori算法的改进与实现.微机发展,2005,15(8):8
39 Jiawei Han.Micheline Kambert Data mining Concepts and Techniques morgan Kaufmann publishers,inc,2001(8):155-156
40 H.Toivonen.Sampling Large Databases for Association Rules.In Proceedings of the 22th VLDB Conference,Mumbai(Bombay),India,1996:134-145P
41 Hart Jiawei,CaiYangdong.Knowledge Discovery in Databases:An Attribute Oriented Approach.In:Proc.1995 Int.Conf.VLDB,1995.408
42(美)Mehmed Kantardzic著,闪四清等译.数据挖掘—概念、模型、方法和算法.北京:清华大学出版社,2003
43 Michalaski RS,et al.Machine Learning and Aata Mining:Methods and Applications.John Wiley&Sons,1998
44 Keyun Hu,Yuchang Lu,and Chunyi Shi.Incremental Discovering Association Rules:A Concept Lattice Approach.In Proc.Third Pacific-Asia Conference.PAKDD-99,Beijing,April 1999:109-113P
45 T.M.Mitchell.Machine Learning and Data Mining,Communications of the ACM.November 1999,42(11):30-36P
46 蒋秀英.关联规则在课程教学评价中的应用.山东师范大学学报.2003(18):3
2 普通高等学校本科教学工作水平评估方案(试行).2004
3 张海笑.数据挖掘分类技术在高校教学中的应用研究:[学位论文].广东:广东工业大学,2005
4 陈文伟,黄金才著.数据仓库与数据挖掘.北京:人民邮电出版社,2003.
5 卢启程,邹平.数据挖掘的研究与应用进展.昆明理工大学学报,2002,27(5):62-66
6 汤小文,蔡庆生.数据挖掘在电信业中的应用.计算机工程,2004,30(6):36-38
7(美)Olivia Parr Rud著.朱扬勇等译.数据挖掘实践.北京:机械工业出版社,2003,50
8 丁元明.数据挖掘技术在高校教学质量评估中的应用研究:[学位论文].上海:华东师范大学,2005
9 R.Agrawa,T.Imielinski,A.Swarimi.Database Mining:A Performance Perspective.IEEE,TRANS.ON KNOWL.AND DATA ENG,1993,Vol.5 No.6 p12-16
10 Han J,et al.Data Mining:Concepts and Techniques.Morgan Kaufmann Publishers.(高等教育出版社,影印版),2001
11 候迪,宋擒豹.数据挖掘-构筑企业竞争优势.西安:西安交通大学出版,2001,1-3
12 MannilaH,Toivonen H,Inkeri verkamo A.Efficient Algorithms for Discovering Association Rules.In:Raghavan.Proceedings of AAA I Workshop on Knowledge Discovery in Database.America:AAA/MIT Press.1994:181-192
13 李雄飞,李军.数据挖掘与知识发现.高等教育出版社,2003:118-142
14 朱明.数据挖掘.合肥:中国科学技术大学出版社,2002:5-7
15 Agrawal R,Srikant Ro Fast algorithms for mining association rules.In Proceeding of the 20th International Conference on Very Large Databases.1994:487-499
16 朱玉全等编著.数据挖掘技术.南京:东南大学出版社,2006
17汪 澜.数据挖掘技术在教学评估中的应用研究:[学位论文].阜新:辽宁工程技术大学.2003
18 http://www.dmresearch.net/数据挖掘研究院
19 马希荣,孙华志.数据挖掘技术在教学评价中的应用.计算机工程与应用.2003(19)
20 http://www.dmgroup.org.cn/数据挖掘讨论组
21 R.Agrawal,T.Imielinski,and A.S.wami.Mining Association Rules between Sets of Items in Large Databases.In Proc.of the ACMSIGMOD Conference on Management of Data.Washington,D.C.,May 1993:207-216P
22 邵峰晶,于忠清编著.数据挖掘原理与算法.北京:中国水利水电出版社,2003
23 Park J,Chen M,Yu P.An effective hash based algorithm for mining association rules.In:Anon ed.Proceedings of the ACM SIGMOD International Conference on Management of Data.New York,NY:ACM Press.1995:175-186P
24 张云涛,龚玲.数据挖掘原理与技术.电子工业出版社,2004(4):191-199
25 冯宝萍,袁志华,苏宗伟等.高等学校教学效果综合评价体系研究,新乡教育学院学报,2003(12)
26 杨志民.高等院校课堂教学评估系统.河北建筑科技学院学报,1999(4):68-72
27 李静,王建军.数据挖掘在高校教学信息化管理中的应用探讨.科技信息,2006(8):300-301
28 Fayyad,Usama,Paul.Data mining and KDD.Promise and challenges.Future Generation Computer Systems,November,1997:99-115
29 Jiawei Han,Micheline Kambe:著,范明,孟小峰等译.数据挖掘概念与技术.北京:机械工业出版社,2004
30 商琳,骆斌.一种基于数据仓库的数据挖掘系统的结构框架.计算机应用研究,2000(9):63-65
31 颜雪松,李宏等.用SQL Server 2000构建数据挖掘解决方案.计算机与现代化.2001(5):29-34
32 曲春锦.改进的关联规则挖掘算法及其在教育信息挖掘中的应用.交通与计算机,2005(4):68-71
33 华江林.基于粗集理论的教学质量评估系统的研究:[学位论文].南京:河海大学,2006
34 董传银.Visual Basic 6.0数据库编程技术.北京:北京希望电子出版社,2002.152
35 罗朝盛等.Visual Basic 6.0程序设计教程。北京:人民邮电出版社,2002.2
36 Using Data Definition Language with SQL Server 2000 Analysis Services Client Applications.Dennis Kennedy Microsoft Corporation,May 2001.
37 陈辉等.关联规则挖掘在教师教学评价系统中的应用.南华大学学报自然科学版,2005,19(1):3
38 陈文庆,许棠.关联规则挖掘Apriori算法的改进与实现.微机发展,2005,15(8):8
39 Jiawei Han.Micheline Kambert Data mining Concepts and Techniques morgan Kaufmann publishers,inc,2001(8):155-156
40 H.Toivonen.Sampling Large Databases for Association Rules.In Proceedings of the 22th VLDB Conference,Mumbai(Bombay),India,1996:134-145P
41 Hart Jiawei,CaiYangdong.Knowledge Discovery in Databases:An Attribute Oriented Approach.In:Proc.1995 Int.Conf.VLDB,1995.408
42(美)Mehmed Kantardzic著,闪四清等译.数据挖掘—概念、模型、方法和算法.北京:清华大学出版社,2003
43 Michalaski RS,et al.Machine Learning and Aata Mining:Methods and Applications.John Wiley&Sons,1998
44 Keyun Hu,Yuchang Lu,and Chunyi Shi.Incremental Discovering Association Rules:A Concept Lattice Approach.In Proc.Third Pacific-Asia Conference.PAKDD-99,Beijing,April 1999:109-113P
45 T.M.Mitchell.Machine Learning and Data Mining,Communications of the ACM.November 1999,42(11):30-36P
46 蒋秀英.关联规则在课程教学评价中的应用.山东师范大学学报.2003(18):3