News for hackers. Stuff that matters.
Re:Ask HN: OLAP and Reporting that feels like 2012 by me_bx on Thursday April 19, 2012 @07:22AM (#3862397)
I know no solution doing all we need, only some interesting components. Here are some more links:

storing data

* couchdb http://couchdb.apache.org/. Good if you already know the analysis you want to do. drawback is that indexes you create (= materialized views) are monodimensional. a multidimensional indexing on top of it would simply be great. Not great if you need real real time reporting and your data change a lot.

* mongodb: more flexible than couchdb for ad-hoc querying

* graph databases: neo4j, orientdb, ... might be a good alternative to OLAP

* ElasticSearch http://www.elasticsearch.org/ lets you have faceted indexes (= index and retrieve facts according to dimensions values). Pluggable to a many storage solutions

reporting / visualizations

* d3.js http://mbostock.github.com/d3/ far above other charting libraries

* Simile Exhibit http://simile-widgets.org/exhibit3/ Great for faceted browsing (facet = dimension)

* Cube http://square.github.com/cube/ Time series visualizations

* mind gapper https://github.com/RandomEtc/mind-gapper-js visualizations la Hans Rosling's Gapminder

* dejavis http://beta.dejavis.org/ looks offline for the moment

Big data

* Hadoop + data-warehousing / Querying solutions Apache Pig and/or hive

ETL (nothing exceptional here)

* Yahoo Pipes

* Python flow

* Google Refine

Saas

* Bime http://bimeanalytics.com/

* Druid http://metamarkets.com/2011/druid-part-i-real-time-analytics...

There are no comments on this comment yet.