Technical Journal, Vol. 18 No. 2, 2024.
Original scientific paper
https://doi.org/10.31803/tg-20230501083155
QOTUM: The Query Optimizer for Distributed Database in Cloud Environment
Archana Bachhav
orcid.org/0000-0002-6762-1210
; MVP Samaj’s KSKW Arts, Science and Commerce College, Ambad-Uttam Nagar Road, CIDCO, Nashik, Maharashtra 422008, India
*
Vilas Kharat
; School of Mathematical and Computational Sciences, S. P. Pune University, Pune, India
Madhukar Shelar
; MVP Samaj’s Commerce, Management & Computer Science (CMCS) College, Nashik, India
* Corresponding author.
Abstract
In distributed and cloud database system, large amount of resources are used by complex queries that increase in payment overheads of cloud users. These resource needs can be minimised by evaluating common join operations and caching their results so that they could be applied to the execution of additional queries. In this research, the Query Optimization Technique Using Materialization (QOTUM) system is designed and developed that uses the mechanism of materialized views during query execution at distributed database in cloud environment. Extensive experiments are conducted with the help of standard benchmarks datasets and query workloads in cloud environment. The performance of QOTUM system is studied and evaluated against conventional SQL system based on various performance parameters.
Keywords
cloud computing; distributed databases; materialized views; query optimizer; query optimization technique
Hrčak ID:
316896
URI
Publication date:
31.5.2024.
Visits: 650 *