Ask HN: Which is a good Column Store database?

https://news.ycombinator.com/item?id=1014523

by hyuen • 17 years ago

7 9 17 years ago

news.ycombinator.com

I am looking for an Open Source Column Store DB, but seems like there is no dominant one around. Can you suggest me some to look at?

Thanks

jarsj• 17 years ago

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

wheels• 17 years ago

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.

hyuen• 17 years 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.

kleinsch• 17 years 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.

gleb• 17 years ago

http://www.luciddb.org/

shotgun• 17 years 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/

mattrepl• 17 years ago

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.

alienasia• 17 years ago

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

frooyo• 17 years ago

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

Ask HN: Which is a good Column Store database?

Related Stories