Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.