An Adventure in Data Modeling: The Entity-Attribute-Value Model*
A case study on the trials of Emma's performance when implementing the Entity-Attribute-Value data model on their PostgreSQL database systems.
Emma, Inc. is an email marketing company that provides a Web based application for managing email lists and marketing campaigns. This is a tale about Emma’s experience with a database schema design refactor that is now using the Entity-Attribute-Value (EAV) data model on the members in email lists. We will briefly describe the previous data model and why we had to move to a new one. This is followed by all the places where Emma stumbled and recovered in implementing the EAV data model and rebuilding the application around it. Finally we will touch on where Emma might go next with respect to the data.
Postgres, PostgreSQL, data models, eav, entity-attribute-value, data modeling, schema design
Ottawa Linux Symposium, Linux World Expo, PGCon, PostgreSQL Conferences, Portland State University guest lecture series. https://vimeo.com/3163620 Talk is scheduled to be given at PDXPUG, PGConf NYC, PGCon, and a PSU class.
Mark is a Data Architect at Emma, Inc. and works with their PostgreSQL database systems. Outside of Emma, he also helps organize various PDXPUG (Portland PostgreSQL Users Group) related events.
- Title: An Adventure in Data Modeling: The Entity-Attribute-Value Model
- Track: Chemistry
- Room: B301
- Time: 1:30 – 2:15pm
A case study on the trials of Emma’s performance when implementing the Entity-Attribute-Value data model on their PostgreSQL database systems.
- Speakers: Mark Wong