SE7EN deadly sins of database design
2022TL; DR
Whether you know it or not, pride, greed, wrath, envy, lust, gluttony, and sloth plague your database design. They convolute your queries and are detrimental to database integrity, performance and scalability. After this session, you'll never look at database design the same way.
Session Details
Christian teachings speak of the seven deadly sins: pride, greed, wrath, envy, lust, gluttony, and sloth. Like any aspect of life, the same human vices come into play in database design as well. In this case, the one who deserves to die is the database itself, not the designer.
In this full day of learning you will see the 7 most common errors of database design and implementation. We’ll explore their origins, understand why they are wrong, and how they got rooted so deep, that some even consider them ‘best practices’. We’ll see practical examples of how they impact data consistency, code convolution, query performance, challenges in modularity, and eventually – why they must die. I mean how to uproot them and the alternatives that exist right in front of your eyes.
By the way, I promise you that each and everyone of you has at least 4 of these in the database you’re currently working on. I invite you to join this meeting and prove me wrong.
3 things you'll get out of this session
Speakers
Ami Levin's previous sessions
Data loading at warp speeds
Do you struggle to reduce those frustrating long hours it takes to load data? Are your time windows for loading becoming too short for comfort? If so – you simply can’t afford to miss this session…
A heap of clusters
An in-depth dive into physical table structures
Physical Join Operators
See how the optimiser chooses the operators it does through real world examples.