University student information system development using data warehouse

العناوين الأخرى

بناء نظام معلومات طلبة الجامعة باستخدام مستودعات البيانات

مقدم أطروحة جامعية

al-Hayyari, Nur Husayn

مشرف أطروحة جامعية

al-Ani, Muzhir Shaban

أعضاء اللجنة

Nassar, Muhammad
Uthman, Akram

الجامعة

جامعة عمان العربية

الكلية

كلية العلوم الحاسوبية و المعلوماتية

القسم الأكاديمي

قسم علم الحاسوب

دولة الجامعة

الأردن

الدرجة العلمية

ماجستير

تاريخ الدرجة العلمية

2012

الملخص الإنجليزي

The university environment is a Data-Driven institution and part of it is the student information system that had been collecting data regarding student absence, performance, and overall success.

Data are also often collected concerning courses sections and courses categories, this data were collected using transactional databases, the huge amount of historically collected data were used for transactional purposes but it never been a concern to analyze students data.

This thesis developed a university student information system using a data warehouse for the purpose of analysis and forecasting.

The developed system extracted the students data from two Jordanian private universities databases.

In the extraction process the implemented system imported the data from its sources and transformed the data into unified representations, checked integrity constraints, sorted the data, and loaded the transformed data into a staging database which contains tables related to student academic achievement.

After loading the staging database the dimensional model is applied which uses the star schema design , the star schema of the university data warehouse consists of a single fact table and five dimensions that are Students dimension ,courses dimension, majors dimension, semesters dimension, and university dimension.

Then the data warehouse dimensions and the fact table are loaded with students data, and then the results of the data warehouse were used for data cubing process in which the data can be viewed from multidimensional perspectives; finally the aggregated results from the cube are used for forecasting the students’ academic achievement for the next semester.

التخصصات الرئيسية

الرياضيات

الموضوعات

• مستودعات البيانات

عدد الصفحات

66

قائمة المحتويات

• APA
• MLA
• AMA

لغة النص

الإنجليزية

نوع البيانات

رسائل جامعية

رقم السجل

BIM-529217