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

Related Posts

Ex-HP CEO Hurd Pays $14 Million Bounty as Oracle Pledge Fee

The bug in the name of the C++ language.

Biography of The Rock 'n' Roll Drummer...John bonham....

Scrum Roles (Scrum Master, Product owner, Development Team) and collaboration between each other

Wi-Fi WPA2 Zero Day Vulnerability Found