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

Tehnički Glasnik

Madhukar Shelar¹  Archana Bachhav²  Vilas Kharat³ 

[1] Department of Computer Science, KRT Arts, BH Commerce and AM Science (KTHM) College, Nashik, India;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;School of Mathematical and Computing Sciences, Savitribai Phule Pune University, Pune, India;

关键词: Conventional SQL;    Database Management in Cloud Environment;    Distributed Databases;    Intermediate Views;    Materialized Views;    Query Execution Time;   

DOI  :  

来源: DOAJ

【 摘 要 】

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.

【 授权许可】

Unknown