This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - Nordic PGDay 2022

Data modeling for modern SQL applications: 3NF? ARRAY? JSONB?

Date: 2022-03-22
Time: 11:15–12:05
Room: Ballroom

This is not a course on normal forms! After a short introduction, we will focus on a practical use case and demo. When SQL databases became popular, the mantra was normalization for agility and data integrity. Then came big data and de-normalization for performance. And web-scale and NoSQL. And purpose-built databases for key-values, documents. And SQL extensions for nested structures like ARRAYS, XML, JSON. Now that everything is possible, what is the best solution? Let's take an example and see where it makes sense to normalize into multiple tables, or think about single-table design. For the best combination of agility and scalability. This is about data modeling and understanding access paths in scalable databases.


The following slides have been made available for this session:


Franck Pachot