Oracle is correct when the bemoan NoSQL's lack of joins and relations ... so I'm using CouchDB as my operational store and exporting the data to PostgreSQL so that I can issue arbitrary queries. It took a little bit of work to make the exporter understand that there might be missing or extra fields in the CouchDB documents, but it was well worth it.
Comments
Oracle is correct when the bemoan NoSQL's lack of joins and relations ... so I'm using CouchDB as my operational store and exporting the data to PostgreSQL so that I can issue arbitrary queries. It took a little bit of work to make the exporter understand that there might be missing or extra fields in the CouchDB documents, but it was well worth it.