Articles feed: Twitter: 
Home Date Added: 2003-11-27 Last Updated: 2010-08-31 Revision: 3 News Feed: Articles feed: Twitter:
This paper has described some of the main characteristics of the multi-dimensional database structure, and provided an analysis of its effectiveness when compared to that of more traditional entity relationship database systems.
The paper concludes that multi-dimensional database systems are a complementary technology to entity relational systems, and in some circumstances it makes more sense to use relational tables rather than multi-dimensional arrays.
Where multi-dimensional systems excel over their relational system counterparts is in the area of data presentation and analysis, where the data in question lends itself to being suitable for multi-dimensional systems, such as where complex inter-relationships exist.
The top-level views of data over many combinations of dimensions make multi-dimensional systems particularly useful for trend analysis over time by management staff of organisations, due to the ease of viewing the data in a more naturally intuitive way.
Tags: characteristics database effectiveness entity concludes complementary relational tables arrays excel counterparts lends dimensions
Permalink: http://www.design-ireland.net/article/Multi-Dimensional_Databases:_Conclusion
Title: Multi-Dimensional Databases: Conclusion
Author: John Collins
Copyright © 2011, the above named author. All rights reserved.