Wondering if there was a scenario where one would use a document-based DB and a relational DB together in a best-of-both-worlds scenario?
+1
A:
One idea is to use a relational database as the main data store and a document-based db as a data distribution mechanism from the back end to the front end(s).
Hank
2009-03-15 10:05:32
+1
A:
In my view, until I see an actual (open source or otherwise transparent) application successfully doing this, I will remain skeptical that it's worthwhile for projects with fewer than a dozen developers.
I suspect that by choosing one database over another and sticking with it--in good times and in bad--developers will reduce both the complexity of the data model and the maintenance cost of the code. Also, by choosing two databases, one runs the risk of a worst-of-both-worlds scenario, with data which is both difficult to manipulate and report on (CouchDB) and also not scalable (RDBMS).
jhs
2009-03-15 16:06:54
answer chosen based on skepticism and doubt. i always prefer to see both perspectives in an answer.
mt3
2010-10-20 20:58:54
+1
A:
We use a mix of RDBMS and CouchDB. The RDBMS (IBM DB/2) is used for "exact" data where transactions make things easier. Examples are bookkeeping of money and inventory. CouchDB is used for archival of "finished" records from the RDBMS, digital asserts (JPEGs, scanned documents) and badly structured information, e.g. information acquired via shipping companie's track and trace systems.
mdorseif
2009-03-15 23:06:03