informatics

seems, it is quite interesting issue.Today, the idea of Cube has been explained. wow what a hell of thoughts and programming to reach this idea.How it can be possible to save data from different data resources in multidimensional cube that prevent u from the huge cost of joining operation between multiple tables. The only disadvantage in it is the data redundancy but it is must to hugely improve the performance. For example , u can make a query that require a join operation between say 5 tables each of 10000 record of 1 gigabyte each ,it will take more than one hour at least meanwhile it wold take less than a second using the multidimensional cube.