How are others using relational modeling tools to map a logical model or one in third normal form to a database that uses EAV?
+3
A:
EAV is a non-relational design. You can't achieve any normal forms with EAV, because it fails to be a relation.
EAV is an example of the Inner-Platform Effect antipattern.
If you need many attributes, you could consider serializing to a blob of XML and storing that XML in a CLOB
column.
Bill Karwin
2010-01-04 06:13:09