Multi-Query Optimization using Tuple Size and Histogram (MOTH) system has been proposed to consider the granularity of the reused-based opportunities. The proposed MOTH system exploits the coarse-grained of the fully and partially reused-based opportunities among queries with considering non-equal tuples size and non-uniform data distribution to avoid repeated computations. The publications are available at
1-Exploiting Coarse-grained Reused-based Opportunities in Big Data Multi-Query Optimization https://www.sciencedirect.com/science/article/pii/S1877750317306142
2-iHOME: Index based JOIN Query Optimization for Limited Big Data Storage https://link.springer.com/article/10.1007/s10723-018-9431-9
Join Aggregation Sort-MOTH system (JAS-MOTH) is an extension of MOTH system to exploit sharing work among multi-query. Part of the JAS-MOTH system is available at:
1-SOOM: Sortbased Optimizer for Big Data Multi-Query