A Data Warehouse Design for a Typical University Information System
Youssef Bassil

TL;DR
This paper proposes a data warehouse design model for a university information system, enabling effective data analysis and decision-making through data transformation and storage.
Contribution
It introduces a four-stage data migration process for transforming operational databases into data warehouses specifically for university systems.
Findings
Implemented system in MS Access 2010 demonstrates feasibility.
Supports data mining, analysis, prediction, and forecasting.
Facilitates decision-making for university management.
Abstract
Presently, large enterprises rely on database systems to manage their data and information. These databases are useful for conducting daily business transactions. However, the tight competition in the marketplace has led to the concept of data mining in which data are analyzed to derive effective business strategies and discover better ways in carrying out business. In order to perform data mining, regular databases must be converted into what so called informational databases also known as data warehouse. This paper presents a design model for building data warehouse for a typical university information system. It is based on transforming an operational database into an informational warehouse useful for decision makers to conduct data analysis, predication, and forecasting. The proposed model is based on four stages of data migration: Data extraction, data cleansing, data…
Peer Reviews
No public reviews on file for this paper yet. If you reviewed it on a platform where reviews are public (OpenReview, ICLR, NeurIPS, ICML), you can paste yours below so the community can read it here.
Videos
No videos yet. Explain this paper in a talk, walkthrough, or lecture? Add one.
Taxonomy
TopicsData Quality and Management · Data Mining Algorithms and Applications · Big Data and Business Intelligence
