Search or add a thesis

Advanced Search (Beta)
Home > Compression-Aware Query Optimization Using Cost-Based Model

Compression-Aware Query Optimization Using Cost-Based Model

Thesis Info

Access Option

External Link

Author

Aurangzeb Khan

Institute

Virtual University of Pakistan

Institute Type

Public

City

Lahore

Province

Punjab

Country

Pakistan

Thesis Completing Year

2018

Thesis Completion Status

Completed

Subject

Software Engineering

Language

English

Link

http://vspace.vu.edu.pk/detail.aspx?id=181

Added

2021-02-17 19:49:13

Modified

2024-03-24 20:25:49

ARI ID

1676720986929

Similar


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.
Loading...

Similar Thesis

Showing 1 to 20 of 100 entries
TitleAuthorSupervisorDegreeInstitute
Virtual University of Pakistan, Lahore, Pakistan
MS
Riphah International University, Islamabad, Pakistan
MS
University of Management and Technology, Lahore, Pakistan
Mphil
Quaid-i-Azam University, Islamabad, Pakistan
RCS
COMSATS University Islamabad, Islamabad, Pakistan
BCS
International Islamic University, Islamabad, Pakistan
BCS
International Islamic University, Islamabad, Pakistan
Mphil
Quaid-i-Azam University, Islamabad, Pakistan
Mphil
Quaid-i-Azam University, Islamabad, Pakistan
BS
COMSATS University Islamabad, Islamabad, Pakistan
Mphil
Quaid-i-Azam University, Islamabad, Pakistan
Mphil
Quaid-i-Azam University, Islamabad, Pakistan
Virtual University of Pakistan, Lahore, Pakistan
Mphil
Quaid-i-Azam University, Islamabad, Pakistan
Mphil
Quaid-i-Azam University, Islamabad, Pakistan
RSE
COMSATS University Islamabad, Islamabad, Pakistan
MS
International Islamic University, Islamabad, Pakistan
RCS
COMSATS University Islamabad, Islamabad, Pakistan
BS
COMSATS University Islamabad, Islamabad, Pakistan
MS
Riphah International University, Islamabad, Pakistan
TitleAuthorSupervisorDegreeInstitute
Showing 1 to 20 of 100 entries

Similar Books

Loading...

Similar Chapters

Loading...

Similar News

Loading...

Similar Articles

Loading...

Similar Article Headings

Loading...

17. Al-Isra’/The Night Journey

17. Al-Isra’/The Night Journey

I/We begin by the Blessed Name of Allah

The Immensely Merciful to all, The Infinitely Compassionate to everyone.

17:01
All Glory is to The One WHO took HIS Servant Muhammad for a journey by night,
from the Grand Sacred Masjid in Holy Makkah to the Distant Masjid in Blessed Jerusalem;
the environs of which WE have especially blessed,
so that WE make him see some of OUR Wonders of Almightiness.
Truly HE - HE is All-Listening, and HE is All-Watching.

17:02
And WE granted the Scripture - the Torah - to Moses, and
made it a source of guidance for Descendants of Jacob.
Saying:
‘Do not take anyone - metaphorically or hypothetically - for a guardian other than ME!

17:03
You are all descendants of those whom WE carried in the Ark with Noah.
He was truly a grateful servant!’

17:04
And WE warned Descendants of Jacob about OUR Decision in their Scripture:
‘You will definitely create and promote corruption in the land twice, and
you will indeed exalt yourselves’ with haughtiness and become grossly overbearing.
And thus you will be punished twice.

17:05
So when the first of these two warnings came true - as the Descendants of Jacob were tuned to sinful disobedience;
WE raised against you OUR servants, people of great power - the Babylonians.
And they ravaged your homes and caused havoc throughout the land.
And it was thus a warning fulfilled!

17:06
Then WE returned to you another chance of victory against them after you had repented,
and strengthened you with wealth/prosperity and sons/manpower,
and made you even more numerous in soldiery than ever.

...

PENINGKATAN KUALITAS PEMBELAJARAN MENYIMAK CERPEN DENGAN MENGGUNAKAN MEDIA REKAMAN PEMBACAAN CERPEN PADA SISWA KELAS XI IPA2 SMA NEGERI 1 BONTOTIRO KABUPATEN BULUKUMBA

Improving the Quality of Learning to Listen to Short Stories by Using Recorded Media for Reading Short Stories for Class XI IPA2 Students of SMA Negeri 1 Bontotiro, Bulukumba Regency.” This study aims to describe the improvement in the quality of learning to listen to short stories using short story reading recording media for students of class XI IPA2 SMA Negeri 1 Bontotiro, Bulukumba Regency.             The results of the study prove that improving the quality of learning to listen to short stories using short story reading recording media in class XI IPA2 SMA Negeri 1 Bontotiro Bulukumba Regency at the planning stage found an increase in the ability of teachers in the field of study to plan better learning implementation in cycle II. In the implementation stage, there was an increase in student activity during the learning process, such as the sincerity, discipline, and self-confidence of students following the learning process. The evaluation stage found an increase in the results of the short story listening test, showing that in the first cycle 56.09% of students experienced mastery learning, and in the second cycle it reached 97.56% who experienced learning mastery. Based on the results of the study, it was concluded that the recording media for reading short stories could improve the quality of learning to listen to short stories in class XI IPA2 SMA Negeri 1 Bontotiro, Bulukumba Regency

Stability and Quality of Fish Lipids

Globally fish consumption is increasing due to increase in awareness of its health benefits. Fish is a rich source of protein, carbohydrates, minerals, vitamins and fats. Among other fatty acids (including Long chain polyunsaturated fatty acids) omega-3 fatty acids, especially eicosapentaenoic acid (EPA) and docosahexaenoic acid (DHA) are beneficial for the human health. This thesis investigated the differences in the chemical composition of five economically important and most consumed fish species in Pakistan, namely Mahseer (Tor putitora), Rainbow trout (Oncorhynchus mykiss), Silver carp (Hypophthalmichthys molitrix), Thela fish (Catla catla) and Common carp (Cyprinus carpio). These species were evaluated for heavy metals accumulation, chemical composition, fatty acids composition, storage stability of their oils under room temperature and high shier conditions after gamma irradiation. Further, fatty acids composition of commercially available fish oil supplements and their oxidative stability was also evaluated to compare with their fatty acids profile to the aforementioned fish oils. There was a significant difference for most chemical components and fatty acids (P < 0.05) in the analyzed fish species. The highest polyunsaturated fatty acids (PUFAs) content was obtained from the Rainbow trout (24.63%), followed by Thela fish (22.52%), Common carp (19.52%), Mahseer (16.25%), whereas the lowest value was found in the Silver carp (15.20%). Similarly, a significant difference in metals content of all fish species was observed. Interestingly, heavy .metals concentration was much higher in fish liver and skin than that estimated in gills and muscles tissues. Furthermore, effects of irradiation on the storage stability of various crude fish oils extracted from selected fish species were tested for physicochemical constants, i.e., peroxide value (POV), free fatty acid value (FFA), anisidine value (AV), iodine value (IV), color and β-Carotene. Among the fish oils examined Common carp followed by Rainbow trout oils showed the greatest stability against oxidation. Additionally, fish oil capsules were evaluated for fatty acids profile to understand what is consumed to fulfill nutritional requirement regarding fish oil viii supplementation study about quality evaluation demonstrates that the tested samples of fish oil capsules show large variation of long-chain omega-3 polyunsaturated fatty acids and contain fewer amounts as claimed on the labels of the products contains considerably oxidized and has cost as well as health implications for the consumers. The results presented in this thesis will be beneficial for the nutritionists, physicians, consumers and researchers who are motivated to improve the nutritive value, processing and marketing of selected fish species and fish oil supplements.