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

Archana Sitaram Bachhav; Vilas Sheshrao Kharart; Madhukar Nathu Shelar

doi: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.