From the MSFT dotnet Architecture Center, "SOA Challenges: Entity Aggregation".
Speak of the devil. Another view on the SOA "data problem".
See for example the sections on "Cross Entity Queries" and "Entity Aggregation Service". Then the paper proceeds into some useful solution approaches.