EAV

The Magento EAV model: entity-attribute-value storage, attribute tables, flat tables, indexing and EAV performance considerations.