Systems design
Standardize data update model ● ACME
ACME uses templates to generate and manage events such as movie screenings, play performances, and concerts, not unlike how Outlook manages meetings. However, an ACME template has features to allow event managers to configure corresponding ticket prices, personnel assignments, facility reservations, and the like.
As new features were added to templates, it became clear that there was no agreement about how edits to instances or templates should propagate through an existing schedule. Are certain data points such as ticket prices considered “top priority” and override existing settings? Can an event manager edit a template but apply changes only to events on a specific day of the week or after a certain date? Can edits to instances be pushed back up to the original template?
I designed a consistent data update model which met customer needs and, through the identification of update patterns, simplified the development effort.