topic Re: What is EAV data model? in QlikView https://community.qlik.com/t5/QlikView/What-is-EAV-data-model/m-p/781757#M1031339 <HTML><HEAD></HEAD><BODY><P>EAV stands for Entity-Attribute-Value model.&nbsp; It is a data antipattern which generalizes all your facts and dimensions</P><P></P><P>Tables in your physical model will have only 3 columns</P><UL><LI>The <EM>entity</EM>: the item being described.</LI><LI>The <EM>attribute</EM> or <EM>parameter</EM>: typically implemented as a <A href="https://en.wikipedia.org/wiki/Foreign_key" style="color: #0b0080; background: none;" title="Foreign key">foreign key</A> into a table of attribute definitions. The attribute definitions table might contain the following columns: an attribute ID, attribute name, description,<A href="https://en.wikipedia.org/wiki/Data_type" style="color: #0b0080; background: none;" title="Data type">data type</A>, and columns assisting input validation, e.g., maximum string length and regular expression, set of permissible values, etc.</LI><LI>The <EM>value</EM> of the attribute.</LI></UL><P></P><P>Here is a wiki entry&nbsp; <A href="https://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model#Structure_of_an_EAV_table" title="https://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model#Structure_of_an_EAV_table">Entity–attribute–value model - Wikipedia</A></P><P>Hope this helps.</P></BODY></HTML> Wed, 19 Oct 2016 12:38:27 GMT markp201 2016-10-19T12:38:27Z What is EAV data model? https://community.qlik.com/t5/QlikView/What-is-EAV-data-model/m-p/781756#M1031338 <HTML><HEAD></HEAD><BODY><P>What is EAV data model technique.</P><P></P><P>Please explain.</P></BODY></HTML> Wed, 11 Feb 2015 03:15:47 GMT https://community.qlik.com/t5/QlikView/What-is-EAV-data-model/m-p/781756#M1031338 2015-02-11T03:15:47Z Re: What is EAV data model? https://community.qlik.com/t5/QlikView/What-is-EAV-data-model/m-p/781757#M1031339 <HTML><HEAD></HEAD><BODY><P>EAV stands for Entity-Attribute-Value model.&nbsp; It is a data antipattern which generalizes all your facts and dimensions</P><P></P><P>Tables in your physical model will have only 3 columns</P><UL><LI>The <EM>entity</EM>: the item being described.</LI><LI>The <EM>attribute</EM> or <EM>parameter</EM>: typically implemented as a <A href="https://en.wikipedia.org/wiki/Foreign_key" style="color: #0b0080; background: none;" title="Foreign key">foreign key</A> into a table of attribute definitions. The attribute definitions table might contain the following columns: an attribute ID, attribute name, description,<A href="https://en.wikipedia.org/wiki/Data_type" style="color: #0b0080; background: none;" title="Data type">data type</A>, and columns assisting input validation, e.g., maximum string length and regular expression, set of permissible values, etc.</LI><LI>The <EM>value</EM> of the attribute.</LI></UL><P></P><P>Here is a wiki entry&nbsp; <A href="https://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model#Structure_of_an_EAV_table" title="https://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model#Structure_of_an_EAV_table">Entity–attribute–value model - Wikipedia</A></P><P>Hope this helps.</P></BODY></HTML> Wed, 19 Oct 2016 12:38:27 GMT https://community.qlik.com/t5/QlikView/What-is-EAV-data-model/m-p/781757#M1031339 markp201 2016-10-19T12:38:27Z