Skip to content

Instantly share code, notes, and snippets.

@tomgrek
Last active February 25, 2018 22:03
Show Gist options
  • Save tomgrek/e5d89ac47642e273cafbab1793af902e to your computer and use it in GitHub Desktop.
Save tomgrek/e5d89ac47642e273cafbab1793af902e to your computer and use it in GitHub Desktop.
Denormalized Example

Originally, we join a table like this

zip_code data_val
94105 123.45
94106 100.10

with one like this

zip_code city
94105 San Francisco
94106 San Francisco

to yield the result

zip_code city data_val
94105 San Francisco 123.45
94106 San Francisco 100.10

...but it's faster (if less easy to maintain) to store that directly

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment