Python / Django : emulating a multidimensionnal layer on a mySql database

Posted by Sébastien Piquemal on Stack Overflow See other posts from Stack Overflow or by Sébastien Piquemal
Published on 2010-06-01T12:09:35Z Indexed on 2010/06/01 12:13 UTC
Read the original article Hit count: 236

Hi,

I'm working on a Django project where I need to provide a lot of different visualizations on the same data (for example average of a value for each month, for each year / for a location, etc ...).

I have been using OLAP database once in college, and I thought that it would fit my needs, but it appears that it is much to heavy for what I need. Actually the volume of data is not very big, so I don't need any optimization, just a way to present different visualizations of the same data without having to write 1000 times the same code.

So let's recap : I need a python library :

  • to emulate a multidimensional database (OLAP style would be nice because I think it is quite convenient : stat structure, and everything)
  • non-intrusive, because I can't modify anything on the existing mysql database
  • easy-to-use, because otherwise there's no point in replacing some overhead by another.

© Stack Overflow or respective owner

Related posts about python

Related posts about database