Wednesday, February 13, 2008

table with infinite dynamically expandable columns veritcal rows propertes attributes eav otlt

If you need to have a table with attributes(columns) that need to be added dynamically, consider going vertically. There are various methods to add attributes to an entity by adding the attributes as rows.

you may be looking for these (Google them):

Entity-Attribute-Value model
“OTLT” (One True Lookup Table)
vertical model
vertical database
row modeling
attribute value system
sql_variant

Think deeply before you use any of these. Be careful you don't end up with a mess.
Resources:
Dave’s guide to the EAV

OTLT and EAV: the two big design mistakes all beginners make

Entity-Attribute-Value (EAV) model with SQL Server 2005 xml datatype

An Introduction to Entity-Attribute-Value Design for Generic Clinical Study Data Management Systems

Entity-Attribute-Value model

Explanation of many database models including EAV

-Dwight

1 Comments:

At 1:58 AM, Anonymous WOW Gold said...

Appropriate humor might ease the tense atmosphere and create a good interpersonal relationship to find balance.

 

Post a Comment

<< Home