Open Access Open Access  Restricted Access Subscription or Fee Access

Novel Architecture of an Intelligent Query Optimizer for Distributed Database in Cloud Environment

Archana Sitaram Bachhav, Vilas Sheshrao Kharart, Madhukar Nathu Shelar

Abstract


Cloud computing delivers services like storage, databases, servers, networking, software and many more over the internet. Users get services from cloud providers and pay for it as per their usage. Database as a service DaaS is becoming a more popular service of cloud computing. Enterprises are transferring the storage data to cloud computing centre. Due to faster response and more reliability, distributed databases are used in cloud for storing and managing data. In order to improve the performance in the cloud requires the optimization of data processing time and leads to resource rent time optimization in cloud environment. There are numerous query optimization strategies like randomized, static and dynamic, however, these strategies require a prior knowledge of the entire system. In this paper, we have analysed numerous query optimization techniques and came up with the architecture of an Intelligent Query Optimizer for Distributed Database in Cloud Environment. The proposed optimizer is incorporated with the materialized views that are used for the evaluation of further queries.


Full Text:

PDF

References


Gardarin, G., Sha, F., & Tang, Z. H. (1996, September). Calibrating the Query Optimizer Cost Model of IRO-DB, an Object-Oriented Federated Database System. In VLDB (Vol. 96, pp. 3-6).

Bachhav, A., Kharat, V., & Shelar, M. (2017). Query Optimization for Databases in Cloud Environment: A Survey.

Doshi, P., & Raisinghani, V. (2011, April). Review of dynamic query optimization strategies in distributed database. In Electronics Computer Technology (ICECT), 2011 3rd International Conference on (Vol. 6, pp. 145-149). IEEE.

Özsu, M. T., & Valduriez, P. (2011). Principles of distributed database systems. Springer Science & Business Media.

Dokeroglu, T., Sert, S. A., & Cinar, M. S. (2014). Evolutionary multiobjective query workload optimization of Cloud data warehouses. The Scientific World Journal, 2014.

Lee, R., Zhou, M., & Liao, H. (2007, September). Request Window: an approach to improve throughput of RDBMS-based data integration system by utilizing data sharing across concurrent distributed queries. In Proceedings of the 33rd international conference on Very large data bases (pp. 1219-1230). VLDB Endowment.

Chen, G., Wu, Y., Liu, J., Yang, G., & Zheng, W. (2011). Optimization of sub-query processing in distributed data integration systems. Journal of Network and Computer Applications, 34(4), 1035-1042.

Bruno, N., Jain, S., & Zhou, J. (2013). Continuous cloud-scale query optimization and processing. Proceedings of the VLDB Endowment, 6(11), 961-972.

Safaeei, A. A., Kamali, M., Haghjoo, M. S., & Izadi, K. (2007, May). Caching intermediate results for multiple-query optimization. In Computer Systems and Applications, 2007. AICCSA'07. IEEE/ACS International Conference on (pp. 412-415). IEEE.

Theeten, B.; Janssens, N., "CHive: Bandwidth Optimized Continuous Querying in Distributed Clouds," Cloud Computing, IEEE Transactions on , vol.3, no.2, pp.219,232, April-June 1 2015 doi: 10.1109/ TCC. 2015.2424868.

Lang, W., Nehme, R. V., & Rae, I. (2015). Database optimization for the cloud: Where costs, partial results, and consumer choice meet. ACM, CIDR.


Refbacks

  • There are currently no refbacks.


This site has been shifted to https://stmcomputers.stmjournals.com/