Explore outer join operations in relational algebra and their role in retrieving comprehensive data sets.