Python / Django : emulating a multidimensional 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/02
6:23 UTC
Read the original article
Hit count: 280
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 an OLAP database once in college, and I thought that it would fit my needs, but it appears that it is much too 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, to recap, I need a python library:
- to emulate a multidimensional database (OLAP style would be nice because I think it is quite convenient : star 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