Design and Implementation of Educational Data Warehouse Using OLAP

Abdullah, Zina A. S. and Obaid, Taleb A. S. Design and Implementation of Educational Data Warehouse Using OLAP. International Journal of Computer Science and Network - IJCSN, 2016, vol. 5, n. 5. [Journal article (Unpaginated)]

Text Design-and-Implementation-of-Educational-Data-Warehouse-Using-OLAP.pdf Download (292kB)

English abstract

Educational Data Mining (EDM) is a method to support learning and teaching processes. Educational Intelligence (EI) is not wide spreading like a business Intelligence (BI). Data Warehouse (DW) technology aims to collect historical data from different kinds of Database (DB) and unifies them under single schema by using the most powerful tool as OLAP which helps the decision maker to make a right decision. Educational Intelligence system combines Educational records of students from two different sources in a single DW. The inputs of educational data warehouse can be in any format (such as reports...). Since the quantities are huge, they are almost meaningless, on the other hand the outputs mainly consist of reports and flowcharts and KPIs with meaning and effective factor for decision maker. The proposed DW is implemented based on two simulated databases of Computer Science Department in the College of Science, University of Basra for the last ten years and AL_IRAQ University for the last 4 years implemented by SQL Server 2014 and SQL Server Data Tool (SSDT) 2012.

Item type:	Journal article (Unpaginated)
Keywords:	Data Warehouse, Educational, OLAP System
Subjects:	I. Information treatment for information services > IE. Data and metadata structures.
Depositing user:	IJCSN Journal
Date deposited:	26 Jan 2017 12:12
Last modified:	26 Jan 2017 12:12
URI:	http://hdl.handle.net/10760/30201

References

[1] Subotic, Danijela, Patrizia Pošcic, and Vanja Slavuj. "OlAP Tools in Education." Media, Culture and Public Relations 4, no. 1 (2013): 34-44. [2] Pinar, B. "A Comparison of Data Warehouse Design Models." PhD diss., Master Thesis, Atilim University, 2005. [3] Reddy, G. Satyanarayana, Rallabandi Srinivasu, M. Poorna Chander Rao, and Srikanth Reddy Rikkula. "Data Warehousing, Data Mining, OLAP and OLTP Technologies are essential elements to support decision-making process in industries." International Journal on Computer Science and Engineering 2, no. 9 (2010): 2865-2873. [4] Kimball, Ralph, and Margy Ross. "The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling". John Wiley & Sons, 2011. [5] Mirabedini, Shirin. "Design of Flexible Mining Language on Educational Analytical DataBase." (2014). [6] Zorrilla M.2009. Marta E. Zorrilla, “Data Warehouse Technology for E-Learning”, Springer- Verlag Berlin Heidelberg 2009.

Downloads

Actions (login required)

View Item