Journals Proceedings

International Journal of Advances in Computer Science and Its Applications

A User-Friendly Approach to Design a Multidimensional Model from Relational Databases



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).

No fo Author(s) : 2
Page(s) : 323 - 330
Electronic ISSN : 2250 - 3765
Volume 1 : Issue 1
Views : 560   |   Download(s) : 115