From the course: Data Curation Foundations

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Entity-attribute-value (EAV) structure

Entity-attribute-value (EAV) structure

From the course: Data Curation Foundations

Start my 1-month free trial

Entity-attribute-value (EAV) structure

“

- [Narrator] Now to continue with our topic of back end curation, we are going to focus on the entity-attribute-value data structure. These three words, entity, attribute, and value, have particular meanings when thinking of a data table, like the table of imaginary data I made and put on the slide. The term entity refers to what each row of the table represents. In my example on the slide, each row of the table represents a hospital. Next, we have attribute. That refers to the columns, which are attributes or characteristics of the entity. In the example, hospid is some sort of hospital ID, and that is an attribute of each hospital listed in the table. Also, each hospital has a code, called serv. That is a code that refers to the type of hospital it is. That is another attribute. Finally, we have value. That's the actual value of any particular attribute, so on the slide you'll see in the first row the value of the…

Contents