What's up with schema-less db systems?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Luke
The Ninja Space Mod
Posts: 6424
Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA

What's up with schema-less db systems?

Post by Luke »

I've noticed a lot of talk on the nets about schema-less db systems such as CouchDB and MongoDB. What exactly is the benefit of these? I can't imagine they're good for aggregate queries, sorting, searching by column, etc. So what is the benefit? Are they more for just storing "documents" and retrieving them one at a time? In what situation would I benefit from choosing a DB system like this?
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: What's up with schema-less db systems?

Post by Eran »

schema-less databases aim to solve two major problems - indexing a large amount of documents (which most relational database are not very good at), and handling rows/items with unknown number of attributes (=columns). Of course you lose most of the benefits of relational databases, but it's an effective solution for applications with specific problems (such as Google indexing the Internet for example).
Post Reply