Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I asked the same thing about a specific NoSql engine (Big Table) on SO. It seems that Big Table doesn't support NOT IN queries?

Is that possible in any other NoSQL databases? Will it ever be possible on NoSQL databases?

share|improve this question
Are you asking if NoSQL supports anti-semi-join? Isn't the whole idea of NoSQL to say bye-bye to those pesky relational operators? – Remus Rusanu Jun 24 '12 at 20:53
@RemusRusanu What's the solution when you need that? Is there a whole another way of thinking when it comes to nosql? What should I read to get that? – Jader Dias Jun 25 '12 at 7:11
Think key-value. Enumerate keys given a range. Given a key, lookup the value. If you need more, simplify the app until you don't need the 'more'. – Remus Rusanu Jun 25 '12 at 7:21
@RemusRusanu Maybe it's easy for you, but I can't devise a way to simplify that. – Jader Dias Jun 25 '12 at 17:32
@JaderDias, exactly why NoSQL will not replace the RDBMS. – Chris Travers Mar 5 '13 at 7:48
up vote 5 down vote accepted

The answer to your question is "no." And no, I don't think it will ever be possible at least in any helpful way.

Relational databases are designed to operate over sets of tuples. Non-relational databases are not. This means that one of the key tradeoffs is being able to have very fast access (with "good enough" consistency controls) to single pieces of data in NoSQL vs high-end consistency controls and set-based math on the relational side.

So the answer is "no, no, and no."

If you want relational math, pick a relational database.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.