Browsed by
Tag: EAV

EAV : Long and skinny data model: part II

EAV : Long and skinny data model: part II

Let us continue next part of EAV data model article. EAV/CR has traditionally meant entity-attribute-value with classes and relationships.EAV/CR is a data modeling technique that, with good amount of metadata, executes a logical database schema and is having different physical database schema. Logical tables are usually prepared from one or many physical tables that often has single column of real payload data of a specific data type like string, integer. All logical tables (that is “classes”) are related to each…

Read More Read More

EAV : Long and skinny data model: part I

EAV : Long and skinny data model: part I

Many times, database developers face certain circumstances while defining data requirements is that number of attributes are not fixed and hence dynamic. Those several attributes describe the object, but only few of them actually apply to each one. In this case, several number of attributes can be used to narrate an object, but only limited attributes really apply to everyone. To tackle this situation of unknown attributes the EAV data model comes to the rescue. As technocrats, we are aware…

Read More Read More

Enjoy this blog? Please spread the word :)