Browse

The Virtual University, Pakistan’s first University based completely on modern Information and Communication Technologies, was established by the Government as a public sector, not-for-profit institution with a clear mission: to provide extremely affordable world class education to aspiring students all over the country.

Using free-to-air satellite television broadcasts and the Internet, the Virtual University allows students to follow its rigorous programs regardless of their physical locations. It thus aims at alleviating the lack of capacity in the existing universities while simultaneously tackling the acute shortage of qualified professors in the country. By identifying the top Professors of the country, regardless of their institutional affiliations, and requesting them to develop and deliver hand-crafted courses, the Virtual University aims at providing the very best courses to not only its own students but also to students of all other universities in the country.

COMPRESSION-AWARE QUERY OPTIMIZATION USING COST-BASED MODEL

Download

Author: AURANGZEB KHAN


Citable URI : https://vspace.vu.edu.pk/detail.aspx?id=181

Publisher : Virtual University

Date Issued: 2/20/2019 12:00:00 AM


Abstract

In these days to enhance the performance of databases researchers propose compression as well as query optimization. Compression reduces volume of data and query optimization reduces execution time of query. There are some issues while compressing database and performing query optimization the first one is the selection of suitable compression scheme. Second is how to reduce the query execution time. which algorithm we use. How to overcome on the demerits of these two issues. We use dictionary-based approach for compression with many small dictionaries that quickly load in the memory on demand. One big diction requires more time for loading and scanning. We also perform query optimization on database without decompressing it by considering fewer execution plans instead of all. The use of many small - dictionaries save space, load quickly. Due to compression, smaller size of intermediate results, less I/O operation required and less buffer misses occurs. While in query optimization selection of randomized algorithm with enhancement consider fewer execution plans instead of all plans. This reduce query execution time. We conclude that the use of compression and query optimization improve the performance of database.


URI : https://vspace.vu.edu.pk/details.aspx?id=181

Citation: Khan, A(2018). COMPRESSION-AWARE QUERY OPTIMIZATION USING COST-BASED MODEL. Virtual University of Pakistan.(Lahore, Pakistan).

Version : Final Version

Terms of Use :

Detailed Terms :

Journal :

Files in this item

Name Size Format
Spring 2018_CS720_MS150200312.pdf 1153kb pdf


Copyright 2016 © Virtual University of Pakistan