TITLE:
Decision-Making Information System for Academic Careers in Congolese Universities: From Analysis to Design of a Data Warehouse
AUTHORS:
Boribo Kikunda Philippe, Thierry Nsabimana, Longin Ndayisaba, Jules Raymond Kala, Jérémie Ndikumagenge, Elie Zihindula Mushengezi
KEYWORDS:
Data Warehouse, University Courses, Universities of South Kivu
JOURNAL NAME:
Open Journal of Applied Sciences,
Vol.13 No.12,
December
26,
2023
ABSTRACT: 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.