Benefits of MDD
• Cognitive Advantages for the User
• Ease of Data Presentation and Navigation
– Obtaining the same views in a relational world requires the end user to either write complex SQL queries or use an SQL generator against the relational database to convert the table outputs into a more intuitive format.
• Ease of Maintenance
– Because data is stored in the same way as it is viewed (i.e. according to its fundamental attributes), no additional overhead is required to translate user queries into requests for data
• Performance
– Multidimensional databases achieve performance levels that are difficult to match in a relational environment.