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

Download Now
Provided by: Seek Digital Library
Topic: Data Management
Format: PDF
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, the authors 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.
Download Now

Find By Topic