Featured Post

EAV versus Row modeling


Following are main features/downsides EAV has over classic row modeling technique.
  • A row-modeled table is homogeneous. It will always carry same type of data in contrast to EAV modeled table where this cannot be an issue.
  • The data type of the value column/s in a row-modeled table is pre-determined by the nature of the facts it records. In contrast, in an EAV table, the conceptual data type of a value in a particular row depends on the attribute in that row.
  • A Row modeling technique data increase only in one direction i.e. from Upside-down whereas in EAV data model data increase in both directions i.e. from upside down as well as from left-right.







Other Related Links:

Comments