CouchDB

DynamoBI is an ideal solution on top of CouchDB to enable real time queries, reporting, and data aggregation with other data sources.

How it Works

DynamoBI connects to a CouchDB server via it’s standard HTTP protocol.
CouchDB views, built in native Javascript and run on the server, prepare some level of normalized summary data to be prepared upon. All the richness of the CouchDB MapReduce and free form JSON access is retained.
Views are accessible via SQL, including the ability to do after the fact filtering (only users who match criteria xyz).
CouchDB data can be easily loaded on periodic basis; offload queries to summary data from CouchDB.
Data is now available for easy report building, and charting on both the cached and live data in CouchDB.