Alex Rivera | Logout

Pros/cons of document-based databases vs. relational databases

Asked 2008-12-03T14:44:29.580
81

I've been trying to see if I can accomplish some requirements with a document based database, in this case CouchDB. Two generic requirements:

  • CRUD of entities with some fields which have unique index on it
  • ecommerce web app like eBay (better description here).

And I'm begining to think that a Document-based database isn't the best choice to address these requirements. Furthermore, I can't imagine a use for a Document based database (maybe my imagination is too limited).

Can you explain to me if I am asking pears from an elm when I try to use a Document oriented database for these requirements?

Edit
Report

1 Answer

4

Document based DBs are best suiting for storing, well, documents. Lotus Notes is a common implementation and Notes email is an example. For what you are describing, eCommerce, CRUD, etc., realtional DBs are better designed for storage and retrieval of data items/elements that are indexed (as opposed to documents).

answered 2008-12-03T14:57:27.837

Your Answer