views:

382

answers:

1

I was recently exposed to the concept of an Entity Attribute Value database model via. the Magento e-commerce system. Varien (the company behind Magento) has used a relational database (mysql) to create an EAV style model using PHP Objects.

I'm curious if there are "native" EAV database solutions out there. The "featured recently on stack overflow CouchDB" seems like it might fit this model. Is that a correct assumption, or is CouchDB something else? Where else could I find EAV in the wild?

Relational is to MySQL as EAV is to ___?

+2  A: 

Relational is to MySQL as EAV is to ...

Various non-relational database technologies are becoming more popular, to support dynamic attributes. Here are a few you should check out:

Any of these are preferable to trying to force the EAV data model into a relational database!

See also http://stackoverflow.com/questions/282783/the-next-gen-databases/282813#282813

Bill Karwin