Abstract: The business intelligence workload is required to serve analytical process. The data warehouses have a very large collection of digital data. The large collection of digital data is required to analytical process within the perplexing workload. The main problem for perplexing workload is to estimate the total completion time. Estimate total completion time is required when workload is executed as a batch of queries. To estimate the queries according to their interaction aware scheme because queries are run in batches. The database administrators often require to perceive how much longer time for business intelligence workloads will take to complete. This question ascends, when database administrator entails to accomplish workloads within existing time frame. The database system executes mixes of multiple queries concurrently. We would rather measure query interactions of a mix than practiced approach to consider each query separately. A novel approach as a estimate framework is presented to estimate running time of a workload based on experiment driven modeling coupled with workload simulation. An estimation framework is developed which has two major parts offline phase and online phase. Offline phase collects the experiments sampling of mixes which has different query types. To find the good accuracy for estimating the running time of the workload by evaluation with TPC-H queries on PostgreSQL.

Muhammad Amjad, Waqas Ahmad, Zia Ur Rehman, Waqar Hussain, Syed Badar Ud Duja, Bilal Ahmed, Usman Ali, M. Abdul Qadoos, Ammad Khan and M. Umar Farooq Alvi, “Estimate the Total Completion Time of the Workload” International Journal of Advanced Computer Science and Applications(IJACSA), 11(6), 2020. http://dx.doi.org/10.14569/IJACSA.2020.0110606

@article{Amjad2020,
title = {Estimate the Total Completion Time of the Workload},
journal = {International Journal of Advanced Computer Science and Applications},
doi = {10.14569/IJACSA.2020.0110606},
url = {http://dx.doi.org/10.14569/IJACSA.2020.0110606},
year = {2020},
publisher = {The Science and Information Organization},
volume = {11},
number = {6},
author = {Muhammad Amjad and Waqas Ahmad and Zia Ur Rehman and Waqar Hussain and Syed Badar Ud Duja and Bilal Ahmed and Usman Ali and M. Abdul Qadoos and Ammad Khan and M. Umar Farooq Alvi}
}