NoSQL Document DB

Question

I am in a need for a document-oriented database for a project I am working on. I basically have two things I need: Full ACID support and the ability to have references. Scalability is not a major issue since the number of total users is at most 300.

I know MongoDB supports references between documents and CouchDB supports ACID but I have not found one that has both.

I am really trying to avoid implementing either (ACID, References) in the application layer. The obvious fallback is RDBMS with some tree structure implementation which I am also trying to avoid.

Any suggestions?

THANX

Answer 1

You require ACID and full references, and CouchDB is not good for that.

You do not require scalability either. My guess is a database that is well-known wouldn't hurt either.

For those reasons, a relational database sounds appropriate.