International Journal of Advances in Computer Science and Its Applications
Author(s) : GEETIKA CHAUDHARY, PAYAL PAHWA
Data in a data warehouse is organized in a multidimensional model. This multidimensional model helps in faster query processing and efficient OLAP operations for data analysis and decision making. In this paper, we introduce a framework which proposes design methodologies to map the relational database into a multidimensional model. The process starts with first cleaning the relational database and then categorizing the attributes of this cleansed relational database into metrics and dimensional attributes by applying the proposed set of mapping rules. This approach has been analyzed using the case study of bank management system and has been implemented successfully using WAMP 2.0 (PHP 5.3.0 and MySQL 5.1.36).