Decision-Making Information System for Academic Careers in Congolese Universities: From Analysis to Design of a Data Warehouse  

作　　者：Boribo Kikunda Philippe Thierry Nsabimana Longin Ndayisaba Jules Raymond Kala Jérémie Ndikumagenge Elie Zihindula Mushengezi Boribo Kikunda Philippe;Thierry Nsabimana;Longin Ndayisaba;Jules Raymond Kala;Jérémie Ndikumagenge;Elie Zihindula Mushengezi(Centre de Recherche en Infrastructure Environnement et Technologie (CRIET), Faculty of Engineering Sciences, Université du Burundi, Bujumbura, Burundi;Faculty of Sciences, Université Catholique de Bukavu (UCB), Bukavu, DR Congo;Management Computer Département, Institut Supérieur Pédagogique de Bukavu (ISP/Bukavu), Bukavu, DR Congo)

机构地区：[1]Centre de Recherche en Infrastructure Environnement et Technologie (CRIET), Faculty of Engineering Sciences, Université du Burundi, Bujumbura, Burundi [2]Faculty of Sciences, Université Catholique de Bukavu (UCB), Bukavu, DR Congo [3]Management Computer Département, Institut Supérieur Pédagogique de Bukavu (ISP/Bukavu), Bukavu, DR Congo

出　　处：《Open Journal of Applied Sciences》2023年第12期2395-2407,共13页应用科学(英文)

摘　　要：Universities collect and generate a considerable amount of data on students throughout their academic career. Currently in South Kivu, most universities have an information system in the form of a database made up of several disparate files. This makes it difficult to use this data efficiently and profitably. The aim of this study is to develop this transactional database-based information system into a data warehouse-oriented system. This tool will be able to collect, organize and archive data on the student’s career path, year after year, and transform it for analysis purposes. In the age of Big Data, a number of artificial intelligence techniques have been developed, making it possible to extract useful information from large databases. This extracted information is of paramount importance in decision-making. By way of example, the information extracted by these techniques can be used to predict which stream a student should choose when applying to university. In order to develop our contribution, we analyzed the IT information systems used in the various universities and applied the bottom-up method to design our data warehouse model. We used the relational model to design the data warehouse.Universities collect and generate a considerable amount of data on students throughout their academic career. Currently in South Kivu, most universities have an information system in the form of a database made up of several disparate files. This makes it difficult to use this data efficiently and profitably. The aim of this study is to develop this transactional database-based information system into a data warehouse-oriented system. This tool will be able to collect, organize and archive data on the student’s career path, year after year, and transform it for analysis purposes. In the age of Big Data, a number of artificial intelligence techniques have been developed, making it possible to extract useful information from large databases. This extracted information is of paramount importance in decision-making. By way of example, the information extracted by these techniques can be used to predict which stream a student should choose when applying to university. In order to develop our contribution, we analyzed the IT information systems used in the various universities and applied the bottom-up method to design our data warehouse model. We used the relational model to design the data warehouse.

关 键 词：Data Warehouse University Courses Universities of South Kivu 

分 类 号：TP3[自动化与计算机技术—计算机科学与技术]