Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What is EAV data model?

What is EAV data model technique.

Please explain.

1 Reply
markp201
Creator III
Creator III

EAV stands for Entity-Attribute-Value model.  It is a data antipattern which generalizes all your facts and dimensions

Tables in your physical model will have only 3 columns

  • The entity: the item being described.
  • The attribute or parameter: typically implemented as a foreign key into a table of attribute definitions. The attribute definitions table might contain the following columns: an attribute ID, attribute name, description,data type, and columns assisting input validation, e.g., maximum string length and regular expression, set of permissible values, etc.
  • The value of the attribute.

Here is a wiki entry  Entity–attribute–value model - Wikipedia

Hope this helps.