Friday - May 25, 2007

Another Dimensional Model Implementation 

The Cubulus project and Alexandru Toth's page describe an "OLAP Aggregation Engine".  It is very nice to see advanced work done on the dimensional model.

The cited research dates from 1999 (V. Markl, F. Ramsak, R. Bayer, "Improving OLAP Performance by Multidimensional Hierarchical Clustering", Proceedings of the Intl. Database Engineering and Applications Symposium, pp. 165-177, 1999.)  I'm suspicious that it predates the "bit-mapped index".  

It may be that this technique helps a lot with an RDBMS that doesn't support the star schema via bit-mapped indexes.  It may be that this technique only helps a little with a more modern RDBMS.

However, the idea of a nice, tidy Python application that helps manipulate the dimensional model is a great thing.  

Author: Steven Lott
Technorati Tags: Python DimensionalModeling StarSchema
Technorati Cosmos:
Technorati Watchlist:
Add this entry to: