  Data analytics over normalized databases typically requires computing and
materializing expensive joins (wide-tables). Factorized query execution models
execution as message passing between relations in the join graph and pushes
aggregations through joins to reduce intermediate result sizes. Although this
accelerates query execution, it only optimizes a single wide-table query. In
contrast, wide-table analytics is usually interactive and users want to apply
delta to the initial query structure. For instance, users want to slice, dice
and drill-down dimensions, update part of the tables and join with new tables
for enrichment. Such Wide-table Delta Analytics offers novel work-sharing
opportunities. This work shows that carefully materializing messages during
query execution can accelerate Wide-table Delta Analytics by >10^5x as compared
to factorized execution, and only incurs a constant factor overhead. The key
challenge is that messages are sensitive to the message passing ordering. To
address this challenge, we borrow the concept of calibration in probabilistic
graphical models to materialize sufficient messages to support any ordering. We
manifest these ideas in the novel Calibrated Junction Hypertree (CJT) data
structure, which is fast to build, aggressively re-uses messages to accelerate
future queries, and is incrementally maintainable under updates. We further
show how CJTs benefit applications such as OLAP, query explanation, streaming
data, and data augmentation for ML. Our experiments evaluate three versions of
the CJT that run in a single-threaded custom engine, on cloud DBs, and in
Pandas, and show 30x - 10^5x improvements over state-of-the-art factorized
execution algorithms on the above applications.
