Preliminary communication

https://doi.org/10.31803/tg-20210205094356

An Efficient Query Optimizer with Materialized Intermediate Views in Distributed and Cloud Environment

Archana Bachhav orcid.org/0000-0002-6762-1210 ; KSKW Arts, Science and Commerce College, Jawahar Road Trimbykeshwar Ta: Tryambakeshwar, Nashik, Maharashtra 422212, India / Savitribai Phule Pune University, Ganeshkhind Road, Pune, Maharashtra 411007, India
Vilas Kharat ; School of Mathematical and Computing Sciences, Savitribai Phule Pune University, Pune, India
Madhukar Shelar ; Department of Computer Science, KRT Arts, BH Commerce and AM Science (KTHM) College, Nashik, India

Abstract

In cloud computing environment hardware resources required for the execution of query using distributed relational database system are scaled up or scaled down according to the query workload performance. Complex queries require large scale of resources in order to complete their execution efficiently. The large scale of resource requirements can be reduced by minimizing query execution time that maximizes resource utilization and decreases payment overhead of customers. Complex queries or batch queries contain some common subexpressions. If these common subexpressions evaluated once and their results are cached, they can be used for execution of further queries. In this research, we have come up with an algorithm for query optimization, which aims at storing intermediate results of the queries and use these by-products for execution of future queries. Extensive experiments have been carried out with the help of simulation model to test the algorithm efficiency.

Keywords

Conventional SQL; Database Management in Cloud Environment; Distributed Databases; Intermediate Views; Materialized Views; Query Execution Time; Query Optimization

Hrčak ID:

253029

URI

https://hrcak.srce.hr/253029

Publication date:

3.3.2021.

Visits: 1.640 *