In-memory caching for multi-query optimization of data-intensive scalable computing workloads