An Efficient Query Optimizer with Materialized Intermediate Views in Distributed and Cloud Environment
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 efficient...
| Permalink: | http://skupni.nsk.hr/Record/nsk.NSK01001163120/Details |
|---|---|
| Matična publikacija: |
Tehnički glasnik (Online) 15 (2021), 1 ; str. 105-111 |
| Glavni autori: | Bachhav, Archana (Author), Kharat, Vilas, Shelar, Madhukar |
| Vrsta građe: | e-članak |
| Jezik: | eng |
| Online pristup: |
https://doi.org/10.31803/tg-20210205094356 Elektronička verzija članka |
| LEADER | 02130naa a22003374i 4500 | ||
|---|---|---|---|
| 001 | NSK01001163120 | ||
| 003 | HR-ZaNSK | ||
| 005 | 20230213111025.0 | ||
| 006 | m d | ||
| 007 | cr|||||||||||| | ||
| 008 | 230213s2021 ci |o |0|| ||eng | ||
| 024 | 7 | |2 doi |a 10.31803/tg-20210205094356 | |
| 035 | |a (HR-ZaNSK)001163120 | ||
| 040 | |a HR-ZaNSK |b hrv |c HR-ZaNSK |e ppiak | ||
| 041 | 0 | |a eng | |
| 042 | |a croatica | ||
| 044 | |a ci |c hr | ||
| 080 | 1 | |2 2011 | |
| 100 | 1 | |a Bachhav, Archana |4 aut |9 HR-ZaNSK | |
| 245 | 1 | 0 | |a An Efficient Query Optimizer with Materialized Intermediate Views in Distributed and Cloud Environment |h [Elektronička građa] |c Archana Bachhav, Vilas Kharat, Madhukar Shelar. |
| 300 | |b Ilustr. | ||
| 504 | |a Bibliografija: | ||
| 504 | |a Summary. | ||
| 520 | |a 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 | ||
| 700 | 1 | |a Kharat, Vilas |4 aut |9 HR-ZaNSK | |
| 700 | 1 | |a Shelar, Madhukar |4 aut |9 HR-ZaNSK | |
| 773 | 0 | |t Tehnički glasnik (Online) |x 1848-5588 |g 15 (2021), 1 ; str. 105-111 |w nsk.(HR-ZaNSK)000810940 | |
| 981 | |b Be2021 | ||
| 856 | 4 | 0 | |u https://doi.org/10.31803/tg-20210205094356 |
| 856 | 4 | 0 | |u https://hrcak.srce.hr/253029 |y Elektronička verzija članka |
| 856 | 4 | 1 | |y Digitalna.nsk.hr |