Title :
From ER models to multidimensional models: The application of Moody and Kortink technique to a university information system
Author :
At-taibe, Adil ; El Mohajir, Badreddine
Author_Institution :
Inf. & Telecommun. Syst. Lab., Abdelmalek Essaadi Univ., Tetouan, Morocco
Abstract :
The objective of this paper is applying a technique that transform an operational system (OLTP) to a data warehouse conceptual model (OLAP). To do so, we survey several conversion techniques that were suggested, We choose the moody and Kortink technique according to well-defined criteria and we apply it to design a DSS (decision support system) which targets the administrative task of planning the university´s educational capacity. The application of the technique on our example points out the need of validating in practice. That will be our perspective in the future work.
Keywords :
data mining; data warehouses; decision support systems; educational administrative data processing; educational institutions; further education; information systems; DSS; ER models; Moody-and-Kortink technique; OLAP; OLTP; conversion techniques; data warehouse conceptual model; decision support system; multidimensional models; online analytical processing; online transaction processing; university educational capacity; university information system; Abstracts; Capacity planning; Data models; Data warehouses; Decision support systems; Planning; Transforms; DSS; Data Warehouse; ER Models; Multidimensional Design; Multidimensional Model; OLAP; OLTP; University information system database Comparison; operational systems;
Conference_Titel :
Information Science and Technology (CIST), 2014 Third IEEE International Colloquium in
Conference_Location :
Tetouan
Print_ISBN :
978-1-4799-5978-5
DOI :
10.1109/CIST.2014.7016611
