Skoči na glavni sadržaj

Izvorni znanstveni članak

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

QOTUM: The Query Optimizer for Distributed Database in Cloud Environment

Archana Bachhav orcid id 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

* Autor za dopisivanje.


Puni tekst: engleski pdf 1.233 Kb

str. 172-177

preuzimanja: 48

citiraj


Sažetak

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.

Ključne riječi

cloud computing; distributed databases; materialized views; query optimizer; query optimization technique

Hrčak ID:

316896

URI

https://hrcak.srce.hr/316896

Datum izdavanja:

31.5.2024.

Posjeta: 92 *