Analysis of query processing and optimization.

Nimra  Memon; Muhammad Saleem  Vighio; Shah Zaman  Nizamani; Niaz Ahmed  Memon; Adeel Riaz  Memon; Umair Ramzan  Shaikh

No Detail Found!

Analysis of query processing and optimization.

Author(s)

Nimra Memon Information Technology Department, Quaid-e-Awam University of Engineering, Science & Technology, Nawabshah, Pakistan

Muhammad Saleem Vighio Information Technology Department, Quaid-e-Awam University of Engineering, Science & Technology, Nawabshah, Pakistan

Shah Zaman Nizamani Information Technology Department, Quaid-e-Awam University of Engineering, Science & Technology, Nawabshah, Pakistan

Niaz Ahmed Memon 600MW Combined Cycle Power Station (CCPS) Thermal Power Station (TPS), Genco-II Guddu, Kashmore, Sindh, Pakistan

Adeel Riaz Memon Information Technology Department, Quaid-e-Awam University of Engineering, Science & Technology, Nawabshah, Pakistan

Umair Ramzan Shaikh Information Technology Department, Quaid-e-Awam University of Engineering, Science & Technology, Nawabshah, Pakistan

Abstract

Modern database management systems are complex programs which get user queries, translate them in internal representation necessary for data access and provide results in best possible way; that is, results which take less execution-time and consume fewer resources. However, as the data is increasing at rapid pace, there is always a need of systems which meet organizational requirements. Better systems can only be developed if internal working of (existing) systems is understood very well. This paper presents a tool that helps in understanding how (high-level) user queries are translated in internal representation necessary for data access. Furthermore, the tool also implements few optimization techniques to produce alternative execution plans and their corresponding execution time. Paper also presents a discussion on which plans are better based on the computational analysis.

Publication Details

Page(s) 14-20

DOI DOI not available

Published Journal: Bahria University Journal of Information & Communication Technologies, Volume: 8, Issue: 1, Year: 2015

Request the full text from PASTIC

Citations

Downloads

Views