page1
staging tables
normalize
current process:
new process:
denormalize
full_occurrence
add derived columns
(to staging tables)
add derived columns
(to full_occurrence)
(materialized table)
(view)
13 h
2 h
~1 h for first import,
0 h thereafter