Another Dimensional Model Implementation

date:2007-05-26 01:14:41
category:Databases and Python

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.

Previous topic

The Django World-View: Model+Admin First; Built-in Transparency and Trustworthiness

Next topic

Just for a moment, I though I’d found something SQLAlchemy doesn’t do perfectly.

This Page