I guess http://www.icCube.com http://www.icCube.com (an in-memory OLAP server) is quite easy to setup (in JAVA following Web standards). Then, a quite simple JS

I guess http://www.icCube.com http://www.icCube.com (an in-memory OLAP server) is quite easy to setup (in JAVA following Web standards). Then, a quite simple JSON/HTTP interface is provided in addition to the standard XMLA. There's currently a JS client API and an early JAVA API as well. The JS client API is used by their visualization library / dashboards. I'm not sure that OLAP cubes are good for 200G / week. I would go for something in between. Use a map/reduce algo. to mine your data and generate the relevant data from which you will build cubes for later and different analysis. As somebody said, I guess OLAP cubes concepts are still good nowadays and MDX is a very powerful language that goes far beyond SQL. My 2 cents (disclaimer I work for icCube)