Max Brokman is the Lead Developer for business intelligence at Vice, a global media company. Max works in Python and PHP and Vice makes extensive use of Laravel for internal systems. Max has been working in Information Systems for Vice for 3 years, mainly focussing on display advertising systems. He is a DDD enthusiast and enjoys photography.
As developers we are often encouraged to store data in a normalized fashion. This improves the integrity of data and reduces data redundancy but sometimes makes read queries complex. We will explore how a denormalized data store can be used to improve the performance and developer experience of reports, listing pages and search systems. Specifically thinking about Eloquent we will see that it is possible to maintain a normalized store to ensure integrity while also automatically producing denormalized tables more suitable for running reports. The session will go through data normalization and why it is useful; the problems normalization introduces for reporting; how denormalization solves some of those problems; how we've used denormalization at Vice; strategies for automatically denormalizing your data with Eloquent; and how this could be further applied to populating search indexes.
This year we raffle a handful of free conference tickets to all of our mailing list subscribers.
Without them it would be impossible to create such an amazing experience.