Faster String Aggregations with Dimension Tables

Analytical workloads are full of repeated strings: product names, country names, station names, user agents, category labels. Take DuckDB’s public train services dataset, which has one row for every stop a Dutch railway train makes. The data comes from the open datasets published by the Rijden de Treinen (Are the trains running?) application .