Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

by Martin Kleppmann

The simplest implementation of this join would go over the activity events one by one and query the user database (on a remote server) for every user ID it encounters.