Ask HN: Which is a good Column Store database?

wheels16y ago· 4 in thread

It might be better to say what use case you're looking for and then go from there.

Column-oriented storage is basically an implementation detail for exploiting certain types of data-locality patterns; there may be things which fit your needs which exploit that in different ways.

hyuenOP16y ago

I am looking for something for analytics, I am interested in column storage specifically on something that supports compression. At this point I guess data can fit in one machine, so clustering would be desirable, but not mandatory.

shotgun16y ago

Redis was designed specifically for web analytics. Not exactly what you asked for, but you might find it highly useful nonetheless. >> http://code.google.com/p/redis/

kleinsch16y ago

Check out InfoBright. It has a free version that has most features you're going to need. There are some bugs, but they're working through them pretty quickly.

gleb16y ago

http://www.luciddb.org/

mattrepl16y ago· 1 in thread

BigTable clones like Cassandra (http://incubator.apache.org/cassandra/) and Hypertable (http://www.hypertable.org/) can be used in a column-oriented fashion. Both use column families to group related columns.

alienasia16y ago

Also HBase (http://hadoop.apache.org/hbase/), which has some nice features like replication, compression, recovery from node failure, and integration with Hadoop.

frooyo16y ago

http://Vertica.com - it's founded by Michael Stonebraker who started Ingres, Postgres and now Vertica.

jarsj16y ago

If looking to scale and store massive amount of data over multiple machines checkout Apache Cassandra. Otherwise, BerkeleyDB should be sufficient.

Ask HN: Which is a good Column Store database?

Ask HN: Which is a good Column Store database?

9 comments

9 comments