NoSQL Document DB

I am in a need f开发者_JS百科or 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

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.

Checkout RavenDB - it has both ACID and transaction support AND it supports the notion of relations between documents via Includes and Live Projections. Denormalization can probably come in handy, too.

Don't use an RDBMS if your business logic says it doesn't like it.

You mentioned the constraints - you mentioned correctly what CouchDB/MongoDB give you. So based on those facts: use your fallback.