Temporal Joins

A replacement for foreign key joins that uses time and customer to pair activities

Diagram showing a single table (the activity stream) with plots depending on it

Connect filtered activities in one table

A diagram describing how temporal joins work by showing 1. filtering by customer, then 2. by time, then 3. picking a row and appending

Temporal joins...

Don't add or remove rows
Temporal joins add columns from additional activities. They cannot duplicate or drop rows.

Don't require modeling the join in advance
Traditional joins require a foreign key between tables. Temporal joins only use customer and time, which is present in all activities.

Can bring in any data
Because they follow the same structure, any activity can be joined to any other activities.

Improved Accuracy

All temporal joins