Every couple of months, I hear about data modelers working with the value-pairs pattern , also called the EAV pattern, the generic pattern, or informally called the diamond pattern. In SQL Server 2000 Bible, I called it the relational-dynamic pattern.
Read More...