Talk

Master the Art of Schema Dissection: Operation Data Engineer

Saturday, May 30

11:45 - 12:15
RoomSpaghetti
LanguageEnglish
Audience levelBeginner
Elevator pitch

That enormous wide table? It’s hiding entities, metrics, and time semantics. Learn the dissection framework that reveals schema structure and turns risky rewrites into surgical precision.

Abstract

Denormalized tables promise simplicity, but often hide complexity in plain sight. A single table may contain business entities, metrics, time semantics, and technical artifacts: all mixed together behind a deceptively flat schema.

This talk introduces a practical framework for dissecting denormalized tables in 1NF by classifying columns into functional roles: keys, dimensions, facts, temporal granularities, technical columns, aggregates, and indices. This perspective turns tables into understandable systems instead of mysterious collections of fields.

With this mental model, data engineers can spot leaky abstractions early and approach normalization as a deliberate, surgical process rather than a risky rewrite. If you work with Python-based data stacks and messy real-world schemas, this talk will change how you look at tables forever.

TagsDatabases, Data Engineering, Performance and scalability techniques
Participant

Cangialosi

Hi there, I’m Nino! An Italian-Finnish theoretical physicist turned into a Software Engineer for a living.

My relentless curiosity drives me to continuously explore new languages and frameworks. Over the past five years, I’ve thrived in roles ranging from DevOps and Full-Stack to Platform and Big Data Engineering.

When I’m not diving into data, you can find me challenging gravity with bouldering, centering my mind through yoga, or strategizing my next chess move.