| Lists: | 윈 토토 PostgreSQL : PostgreSQL 메일 링리스트 : 2014-03-11 이후 PDXPUG 16:17 |
|---|
| From: | gabrielle <gorthx(at)gmail(dot)com> |
|---|---|
| To: | Postgresql PDX_Users <pdxpug(at)postgresql(dot)org> |
| Subject: | PDXPUG - March meeting next week |
| Date: | 2014-03-11 16:17:53 |
| Message-ID: | CAHRs-_eAx=Y4dM1eRpoVL9f_3RWGE=9X3my0z2XvCQ+qCegWbQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 윈 토토 PostgreSQL : PostgreSQL 메일 링리스트 : 2014-03-11 이후 PDXPUG 16:17 |
When: 7-9pm Thu Mar 20, 2014
Where: Iovation
Who: Mark Wong
What: An Adventure in Data Modeling: The Entity-Attribute-Value Model
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.
Mark is a Data Architect at Emma, Inc. and works with their PostgreSQL
database systems.
-
Our meeting will be held at Iovation, on the 32nd floor of the US Bancorp
Tower at 111 SW 5th (5th & Oak). It's right on the Green & Yellow Max
lines. Underground bike parking is available in the parking garage;
outdoors all around the block in the usual spots. No bikes in the office,
sorry!
Building security will close access to the floor at 7:30.
See you there!