Abstract
Workload management for concurrent queries is one of the challenging aspects of executing queries over the cloud computing environment. The core problem is to manage any unpredictable load imbalance with respect to varying resource capabilities and performances. Key challenges raised by this problem are how to increase control over the running resources to improve the overall performance and response time of the query execution. This paper proposes an efficient workload management system for controlling the queries execution over cloud environment. The paper presents an architecture to improve the query response time by detecting any load imbalance over the resources. Also, responding to the queries dynamically by rebalancing the query executions across the resources. The results show that applying this Workload Management System improves the query response time by 68%.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Yang, D., Li, J., Han, X., Wang, J.: Ad Hoc Aggregation Query Processing Algorithms based on Bit-store in a Data Intensive Cloud. J. Future Generat. Comput. Syst. 29, 725–1735 (2013)
Paton, N.W., de Aragão, M.A.T., Fernandes, A.A.A.: Utility-driven Adap-tive Query Workload Execution. Future Generation Computer Systems 28, 1070–1079 (2012)
Maghawry, E.A., Ismail, R.M., Badr, N.L., Tolba, M.F.: An Enhanced Resource Allocation Approach for Optimizing a Sub-query on Cloud. In: Hassanien, A.E., Salem, A.-B.M., Ramadan, R., Kim, T.-h. (eds.) AMLTA 2012. CCIS, vol. 322, pp. 413–422. Springer, Heidelberg (2012)
Duggan, J., Cetintemel, U., Papaemmanouil, O., Upfal, E.: Performance Pre-diction for Concurrent Database Workloads. In: SIGMOD, Athens, pp. 337–348 (2011)
Liu, S., Karimi, A.H.: Grid Query Optimizer to Improve Query Processing in Grids. Future Generation Computer Systems 24, 342–353 (2008)
Albuitiu, M.C., Kemper, A.: Synergy based Workload Management. In: Proceedings of the VLDB PhD Workshop, Lyon (2009)
Gounaris, A., Smith, J., Paton, N.W., Sakellariou, R., Fernandes, A.A.A., Watson, P.: Adapting to Changing Resource Performance in Grid Query Processing. In: Pierson, J.-M. (ed.) VLDB DMG 2005. LNCS, vol. 3836, pp. 30–44. Springer, Heidelberg (2006)
Wei, Z., Pierre, G., Chi, C.: Scalable Join Queries in Cloud Data Stores. In: IEEE/ACM International Symposium on Cluster, Cloud and Grid Computing, Ottawa, pp. 547–555 (2012)
Krompass, S., Kuno, H., Dayal, U., Kemper, A.: Dynamic Workload Man-agement for Very Large Data Warehouses: Juggling Feathers and Bowling Balls. In: 33rd International Conference on VLDB, Vienna, Austria, pp. 1105–1115 (2007)
Paton, N.W., Buenabad, J.C., Chen, M., Raman, V., Swart, G., Narang, I., Yellin, D.M., Fernandes, A.A.A.: Autonomic Query Parallelization using Non-dedicated Computers: An Evaluation of Adaptivity Options. In: VLDB, vol. 18, pp. 119–140 (2009)
Chen, G., Wu, Y., Liu, J., Yang, G., Zheng, W.: Optimization of Sub-query Proc-essing in Distributed Data Integration Systems. Journal of Network and Computer Applications 34, 1035–1042 (2011)
Performance Monitoring, https://software.intel.com/en-us/articles/use-windows-performance-monitor-for-infrastructure-health
Fritchey, G., Dam, S.: SQL Server 2008 Query Performance Tuning Distilled, 2nd edn., USA (2009)
Transaction Processing and Database Benchmark, http://www.tpc.org/tpch/
VMware, http://www.vmware.com/
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this paper
Cite this paper
Maghawry, E.A., Ismail, R.M., Badr, N.L., Tolba, M.F. (2014). Queries Based Workload Management System for the Cloud Environment. In: Hassanien, A.E., Tolba, M.F., Taher Azar, A. (eds) Advanced Machine Learning Technologies and Applications. AMLTA 2014. Communications in Computer and Information Science, vol 488. Springer, Cham. https://doi.org/10.1007/978-3-319-13461-1_9
Download citation
DOI: https://doi.org/10.1007/978-3-319-13461-1_9
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-13460-4
Online ISBN: 978-3-319-13461-1
eBook Packages: Computer ScienceComputer Science (R0)