Featured Post
EAV versus Row modeling
- Get link
- Other Apps
By
Rishoo Mittal
-
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
Post a Comment
Let's discuss and learn more