CAJ | 학술논문

本文研究数据仓库技术在高校大类招生环境下,学生自主选择专业行为特征分析中的应用,为高校大类招生相关政策的制定提供理论支持及技术手段.首先介绍了数据仓库星形模型分析方法,结合专业选择分析相关需求描述数据仓库建立的一般步骤.随后以北京科技大学经济管理学院2005级学生基本信息及学科成绩为例,重点阐述学生专业选择数据仓库逻辑模型设计.通过确立学生基本影响因素分析和学生成绩分析两大主题,充分分析学生基本属性、学生成绩等对学生选择专业的影响,并给出OLAP分析结论.
본문연구수거창고기술재고교대류초생배경하,학생자주선택전업행위특정분석중적응용,위고교대류초생상관정책적제정제공이론지지급기술수단.수선개소료수거창고성형모형분석방법,결합전업선택분석상관수구묘술수거창고건립적일반보취.수후이북경과기대학경제관이학원2005급학생기본신식급학과성적위례,중점천술학생전업선택수거창고라집모형설계.통과학립학생기본영향인소분석화학생성적분석량대주제,충분분석학생기본속성、학생성적등대학생선택전업적영향,병급출OLAP분석결론.
This paper focuses on the behavioral characteristics analysis in major selection for college students admit- ted without major classification, using Data Warehouse (DW) technology, which provides theoretic and applied support for decision making for college recruitment without major classification. DW star schema analysis is firstly introduced, and general construction steps are shown combined with the major selection application. Then, we emphasis on the logic model design of DW for major selection analysis, based on the information of students in grade 2005, who come from school of e- conomics and management, University of Science and Technology. OLAP (On Line Analytical Processing) is carried out based on the theme of basic factor analysis and grade analysis, and the OLAP analysis conclusion is given.