We want to create Java objects which encapsulate certain aspects by creating a service interface. These services are backed by some database tables.
Now we have some decisions which need information of all kinds of services. With SQL you would do a big join over a lot of tables and get a small result. Using OO you would ask service A getting 5000 objects and merge it with the result of service B getting 6000 objects...
I don't have to mention that the OO version is unbearably slow. The SQL version is quite fast but breaks encapsulation. The writer of the query has to know the implementation details of all services.
Is there any solution? Somthing like the service provides a part of a query/criterias and the caller "joins" them with its own query?