[wdmmg-dev] Online Analytical Processing (OLAP) for WDMMG
stefan at knowerce.com
Thu Dec 23 19:06:33 UTC 2010
I have put together couple of notes about online analytical processing (see  and ) for WDMMG:
Main point is to introduce metadata: create a logical model that reflects data *how they are being measured*, that is: from user's perspective.
Documents with notes are here:
Online Analytical Processing and Aggregations (document for specifying aggregation design and API):
Spreadsheet with WDMMG metadata (list of fields in source DB, proposed multidimensional model):
Preliminary proposal (diagram):
I started porting an OLAP framework from ruby to python . The logical model in python version is close to the Oracle 11 OLAP  way of modelling. Currently the port handles logical model  and creation of denormalized view (in relational database) based on the model. I hope to have aggregation browser ready soon. Also I will provide more detailed documentation with examples.
I would like to know, what do you think about it?
If you have any questions or want more explanations or examples, just let me know.
More information about the openspending-dev