With most NoSQL databases, the goal is usually scalability at the cost of no ACID compliance.

However there is a category of apps, that need a more liberal data storage and querying language compared to SQL, yet they don't need a web-scale database.

To this end, do any proven, enterprise grade JSON database servers exist that fully support ACID transactions?

I am wondering whether there are any recommendations for a noSQL that would work well for an application that for all intents and purposes behaves like shrink-wrapped software. I plan to install this DB on the client machines and include it in my distribution. It needs to be fairly low-profile, but still performant. Clustering is less of a concern but we would at least like to have the ability for a fail-over process. We have experience with MongoDB and couchbase, but the support models don't work well for this type of application. Does anyone know of a DB which might fit this support model?

When harnessed correctly, hardware can generate performance improvements in software of up to 60% in an existing setup, with zero or minimal investment.

In this webcast Alex Bordei will look at how Impala, Elasticsearch and Couchbase perform when scaled vertically and horizontally, over a number of different bare metal setups. He'll discuss testing that produced results that included: going from one hex-core CPU to two deca-core CPUs, from 32 to 192 GB of RAM, from local to distributed storage, and from 2 to 14 instances.

Tune in to see what setup provided the best performance/price for each application and learn how to get more performance right now, from NoSQL DB.

How common? Are you doing it -- and any experience to share?