Data Joins
Joining 2 data set is a very common operation in Relational Data Model and has been very mature in RDBMS implementation. The common join mechanism in a centralized DB architecture is as follows

Great list of techniques and things to be aware of when coding jobs for MapReduce systems.