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

Authors

  • Archana Sitaram Bachhav Savitribai Phule Pune University
  • Vilas Sheshrao Kharart Savitribai Phule Pune University
  • Madhukar Nathu Shelar K.T.H.M. College, Nashik, India

DOI:

https://doi.org/10.37591/joadms.v5i2.1561

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.

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.

Downloads

Published

2018-08-20

Issue

Vol. 5 No. 2 (2018)

Section

Research Articles

License

Declaration and Copyright Transfer Form

(to be completed by authors)

I/ We, the undersigned author(s) of the submitted manuscript, hereby declare, that the above manuscript which is submitted for publication in the STM Journals(s), is not published already in part or whole (except in the form of abstract) in any journal or magazine for private or public circulation, and, is not under consideration of publication elsewhere.

  • I/We will not withdraw the manuscript after 1 week of submission as I have read the Author Guidelines and will adhere to the guidelines.
  • I/We Author(s ) have niether given nor will give this manuscript elsewhere for publishing after submitting in STM Journal(s).
  • I/ We have read the original version of the manuscript and am/ are responsible for the thought contents embodied in it. The work dealt in the manuscript is my/ our own, and my/ our individual contribution to this work is significant enough to qualify for authorship.
  •  I/We also agree to the authorship of the article in the following order:

Author’s name                                    

 

1. ________________

2. ________________

3. ________________

4. ________________

 

We  Author(s) tick this box and would request you to consider it as our signature as we agree to the terms of this Copyright Notice, which will apply to this submission if and when it is published by this journal.