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.
Does an in-memory database also have a filesystem component?
Splitting a Server Hosted Access Database
postgres: constraint check and null values
An illustrative story: http://www.simple-talk.com/opinion/opinion-pieces/bad-carma/.
Database of surveillance camera locations
User's text in my database as a separate table or within other data
To improve a relation figure for a database
How to improve a ERD
How to model Open/Closed statuses in a database?
The up side of EAV is so seductive that a lot of newbies will dig a very big hole for themselves before they realize it.
. Hopefully the google search will reveal at least some of the down side..
But that might be an acceptable trade-off.
I managed a project that had to develop a general clinical trial data management system.
There could not be many common data elements because each trial needs to collect different data.
Capturing data was urgent; we had to develop data entry pages under pressure.
Reports are harder with EAV, but they're also less urgent, and with some clever thought they can be simplified a bit.
EAV has served us well.
Guidelines for the Effective Use of Entity-Attribute-Value Modeling for Biomedical Databases.
Int J Med Inform.
2007 ; 76: 769–779.