首页    期刊浏览 2024年09月14日 星期六
登录注册

文章基本信息

  • 标题:Educational Tool for Generation and Analysis of Multidimensional Modeling on Data Warehouse
  • 其他标题:Educational Tool for Generation and Analysis of Multidimensional Modeling on Data Warehouse
  • 本地全文:下载
  • 作者:Elena Fabiola Ruiz Ledesma ; Elizabeth Moreno Galván ; Enrique Alfonso Carmona García
  • 期刊名称:International Journal of Advanced Computer Science and Applications(IJACSA)
  • 印刷版ISSN:2158-107X
  • 电子版ISSN:2156-5570
  • 出版年度:2020
  • 卷号:11
  • 期号:9
  • DOI:10.14569/IJACSA.2020.0110930
  • 出版社:Science and Information Society (SAI)
  • 摘要:The curricular inclusion of topics, study plans, and teaching programs related to the study of Data Science has been trending mostly in higher-level education for the last years. However, the previous knowledge requirements for students to adequately assimilate these lessons are more specialised than the ones they obtain during secondary education. On the one hand, the interaction with complexes techniques and materials is needed, and on the other, tools to practice on-demand are required in the current learning. So, this is an excellent opportunity for the creation of data analysis tools for educational purpose that could be considered as a starting point of a broad area of application. This paper presents a pedagogical support tool aimed to facilitate the student approach to the basic knowledge of data mining through the practice of the analysis of online analytical processing (OLAP). It is a prototype that allows the visualisation of the multidimensional cubes generated with all possible combinations of the dimensions of the data set, as well as their storage in databases, the recovery operations for views, and the implementation of an algorithm for the selection of the optimal view set for materialising the set of records resulting from a search of the database, and computing the materialisation costs and total records recovered. The prototype also carries out and present recurrent patterns and association rules while considering factors such as support variables and reliability. All of this is steps are done explicitly to aid the students to comprehend the generation process of data cubes in the data mining discipline.
  • 关键词:Educational data mining; data cube; view materialization; educational software
国家哲学社会科学文献中心版权所有