News for hackers. Stuff that matters.
Re:The four categories of NoSQL databases by michh on Saturday May 28, 2011 @10:11AM (#2594453)
Imho this article is too much of an oversimplification. It's forcing artifical labels on some things that don't really fit very well.

It's fairly useless if you've already heard about most of these and it's a false start if you haven't.

If you do want such a list, a much more accurate and complete one is at http://nosql.mypopescu.com/kb/nosql

Re:The four categories of NoSQL databases by antirez on Saturday May 28, 2011 @11:24AM (#2594556)
You could be surprised about the efforts many folks do to try to put the different DB solutions into some kind of schema. The reason for this is mostly opaque for me...
Re:The four categories of NoSQL databases by _delirium on Saturday May 28, 2011 @11:39AM (#2594588)
It can be useful to have a sort of map of the landscape if you're looking around. Sort of how in PLs, it's nice to be able to have a categorization better than "there are thousands of programming languages". Coming up with a good map is hard, though, and any categorization does tend to emphasize some factors and gloss over others...
Re:The four categories of NoSQL databases by strlen on Saturday May 28, 2011 @04:14PM (#2595121)
Categorizing the stores by their data model is misleading. Tokyo Tyrant and Voldemort are very different: later is a multi-master, partitioned, distributed system; former is a network attached database. In fact, one could easily use Tokyo Cabinet as the persistence engine in Voldemort in place of BerkeleyDB.

A far better classification should be done along the lines of the distribution models and handling of failures. Do they use consistent hashing or range based partitioned? Under failure, is consistency or availability given up? Are there barriers to nodes rejoining after recovering from a failure? Is there an ordered, distributed commit log, etc...

It's much harder to change the distribution model than it is change the query model. Riak, HBase and Voldemort also have support for running custom code against which queries may be made. On the other hand, adding a totally ordered commit log (via serializing through a floating master or using consensus) to Voldemort or Riak, or adding multi-master (in the sense of multiple region servers taking reads and writes for the same partition) support to HBase is going to be far more difficult.

Creating a "grand classification scheme" that ignores the most important aspect suggests a dilettante approach (not saying the author is a dilettante, but it's a much more complex topic which requires more than dabbling).

Re:The four categories of NoSQL databases by btilly on Saturday May 28, 2011 @10:00AM (#2594435)
I'm puzzled by their describing Riak as a column oriented database. It is a key/value store. Perhaps they are thinking of the highly beta Riak Search? http://wiki.basho.com/Riak-Search.html
Re:The four categories of NoSQL databases by Fluxx on Saturday May 28, 2011 @11:18AM (#2594547)
Key/value store or maybe a document database. But it certainly has nothing to do with being column oriented.
Re:The four categories of NoSQL databases by sjs on Saturday May 28, 2011 @04:03PM (#2595092)
Basho themselves have complained about being called a document DB. Probably because you can store absolutely anything in Riak. Regardless of the reason I think we can safely call it a KV store and be done with it.

edit: And by Basho themselves I don't mean some official statement, I just mean people who work for Basho.

Re:The four categories of NoSQL databases by siculars on Saturday May 28, 2011 @12:10PM (#2594654)
I would put RIak in either the Key/Value store category but most likely in the Document Database category and certainly not in the Column Family Store category. Riak is in no way a column store.
Re:The four categories of NoSQL databases by simonw on Saturday May 28, 2011 @09:38AM (#2594411)
Describing Redis as just another key value store kind of misses the point.
Re:The four categories of NoSQL databases by kennu on Saturday May 28, 2011 @10:58AM (#2594509)
I agree. Anybody interested in Redis should get to know its hash tables, lists, sets, sorted sets, etc. It's sometimes amazing how many problems Redis can solve out-of-the-box, just because it provides these common data structures as a persistent service.
Re:The four categories of NoSQL databases by est on Saturday May 28, 2011 @11:59AM (#2594629)
redis is key-structured-value db
Re:The four categories of NoSQL databases by mscarborough on Saturday May 28, 2011 @11:01AM (#2594513)
And no mention of memcache in the key/value list. Not cool enough anymore?
Re:The four categories of NoSQL databases by antirez on Saturday May 28, 2011 @11:12AM (#2594535)
Indeed. Memcached is very effective for what it does and IMHO one of the fathers of the whole NoSQL thing.
Re:The four categories of NoSQL databases by pavel_lishin on Saturday May 28, 2011 @11:16AM (#2594543)
I thought they left it off because it wasn't persistent.
Re:The four categories of NoSQL databases by antirez on Saturday May 28, 2011 @11:23AM (#2594555)
This is just a particular tradeoff IMHO. It is persistent as long as the process is running. Other databases are persistent as long as the HD is working :) Others are persistent as long as N nodes are still working. Just tradeoffs.
Re:The four categories of NoSQL databases by lurker19 on Saturday May 28, 2011 @11:47AM (#2594599)
While technically possible to accept in some cases, nowhere-durable is a rather extreme tradeoff option.

It would be interesting to reconsider memcached as durable storage in the modern SSD era, however.

Re:The four categories of NoSQL databases by true_religion on Saturday May 28, 2011 @02:15PM (#2594893)
Memcachedb is persistent though.
Re:The four categories of NoSQL databases by spenrose on Saturday May 28, 2011 @09:55AM (#2594432)
I believe his description of document-based databases is mistaken WRT versioning: it's a central concept for couchdb, but not for mongodb.
Re:The four categories of NoSQL databases by arkitaip on Saturday May 28, 2011 @09:13AM (#2594392)
It would be great if there was a very basic web site that could guide you to the most suitable storage solution based on the problem you are working on. Sorta like a guide or wizard.

I think it's a shame that the movement is called NoSQL because it sorta creates this false dichotomy that the field of web data storage is divided in two camps. In reality, you need to, as always, pick the right solution for the problem you are facing. NoSQL databases will never entirely replace SQL databases and I think it's important to not shoehorn NoSQL in places where it doesn't really belong.

Re:The four categories of NoSQL databases by andrewl on Saturday May 28, 2011 @10:10AM (#2594451)
Philip Greenspun has a short article on the subject at:

http://philip.greenspun.com/teaching/three-day-rdbms/beyond-...

And there's a discussion about the article on his blog:

http://blogs.law.harvard.edu/philg/2011/01/13/rdbms-versus-n...

Re:The four categories of NoSQL databases by MediaBehavior on Saturday May 28, 2011 @09:19AM (#2594402)
To your request for such a guide I would like to request:

Documentation of the technological overhead: the soft/hardware/sys_admin_experience overhead required by each (and the hosts offering such support overhead for them - compared for example to support for MySQL :/ ).

Re:The four categories of NoSQL databases by btilly on Saturday May 28, 2011 @10:01AM (#2594439)
The best such comparison that I've seen is http://kkovacs.eu/cassandra-vs-mongodb-vs-couchdb-vs-redis.
Re:The four categories of NoSQL databases by russell on Saturday May 28, 2011 @03:19PM (#2595010)
Re:The four categories of NoSQL databases by baddox on Saturday May 28, 2011 @01:11PM (#2594777)
What about non-relational object databases?
Re:The four categories of NoSQL databases by est on Saturday May 28, 2011 @12:02PM (#2594640)
how about EAV, OOdbms, functional and deductive db?