Best beginner resources for understanding the EAV database model?

database database-design magento entity-attribute-value
user4903 picture user4903 · Jan 30, 2009 · Viewed 20.1k times · Source

I'm doing some custom work with Magento, which has a database design based upon the EAV model, and I need some good resources/tutorials that explain the EAV database model. Please don't provide Wikipedia as a resource... I'm looking for something that teaches EAV in a friendly way for beginners.

Answer

David Aldridge picture David Aldridge · Jan 31, 2009

Here you go. An illustrative story: http://www.simple-talk.com/opinion/opinion-pieces/bad-carma/

Related questions

Can I have multiple primary keys in a single table?

Can I have multiple primary keys in a single table?

Read More
Database, Table and Column Naming Conventions?

Whenever I design a database, I always wonder if there is a best way of naming an item in my database. Quite often I ask myself the following questions: Should table names be plural? Should column names be singular? Should …

Read More
What's the difference between identifying and non-identifying relationships?

I haven't been able to fully grasp the differences. Can you describe both concepts and use real world examples?

Read More