Creation and Comparison of Query Mix

In the database management system, it is significant to show the results of any query with the lowest response time. This research conduct on the Postgresql database queries on the TPC-H benchmark for calculating the response time of the multiple queries. For acquiring this phenomenon, it is essential to adapt such practice from which more than one queries at the same time may be executed to get benefits of parallel processing. By inspiring this idea, this paper presents the query mix, which is a combination of more than two queries for multiprogramming level 3 (MPL-3), which shows that there are three randomly selected queries in each query mix. This research contained two different experiments, in the former experiment, each query executed in isolation, and in the second experiment, the combination of three queries executed simultaneously for acquiring MPL3. The results show that there is a strong correlation between the individual query and the query mix.