what is EAV in Magento?

EAV( Entity Attribute Value)data model is used to get flexibility for your data, but it brings more complexity than relation table model.
 
As far as I know, EAV also known as object attribute value model and open schema. Entity (E): Entity actually refers to data item. For example we can consider it as customer, category or product. Attribute (A): Attribute refers to the different attributes of the Entity.
 
Magento EAV stands for Entity Attribute Value which is data model, used to get flexibility for your data, but it brings more complexity than relation table model.
If you need data model that will have flexible attributes which can be dynamically added, for example from Magento admin panel, then EAV is the best solution for you.
 
In magento we use two configurations of ORM: flat (flat table structure) and EAV (Entity Attribute Value). EAV is also known as object–attribute–value model, vertical database model and open schema. Actually, EAV is used to get flexibility for our data but it brings more complexity than relation table model.
 
Back
Top