Research Article
Pragmatic Approach to Query Optimization
|
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
|
| Volume 66 - Issue 7 |
| Published: March 2013 |
| Authors: Subhi H. Hamdoon, Virendra Gawande, Ahmed Al-Barashdi |
10.5120/11099-6063
|
Subhi H. Hamdoon, Virendra Gawande, Ahmed Al-Barashdi . Pragmatic Approach to Query Optimization. International Journal of Computer Applications. 66, 7 (March 2013), 32-37. DOI=10.5120/11099-6063
@article{ 10.5120/11099-6063,
author = { Subhi H. Hamdoon,Virendra Gawande,Ahmed Al-Barashdi },
title = { Pragmatic Approach to Query Optimization },
journal = { International Journal of Computer Applications },
year = { 2013 },
volume = { 66 },
number = { 7 },
pages = { 32-37 },
doi = { 10.5120/11099-6063 },
publisher = { Foundation of Computer Science (FCS), NY, USA }
}
%0 Journal Article
%D 2013
%A Subhi H. Hamdoon
%A Virendra Gawande
%A Ahmed Al-Barashdi
%T Pragmatic Approach to Query Optimization%T
%J International Journal of Computer Applications
%V 66
%N 7
%P 32-37
%R 10.5120/11099-6063
%I Foundation of Computer Science (FCS), NY, USA
Abstract
One of the most critical functional requirements of a DBMS is its ability to process queries in a timely manner. This is particularly true for very large, applications such as weather forecasting, banking systems and aeronautical applications, which can contain millions and even trillions of records. The need for faster and faster, and immediate results never ceases. Thus, a great deal of research and resources is required on creating smarter, highly efficient query optimization techniques. Some of the basic techniques of query processing and optimization have been presented in this paper. This paper highlights the basic concepts of query processing and query optimization in the relational database domain. The results of the experiment presented have been verified using Query Analyzer.
References
- Andrew Eisenberg and Jim Melton, June 2004. An Early Look at XQuery API for Java™ (XQJ). ACM SIGMOD Record, Vol. 33.
- Avi Silbershatz, Hank Korth and S. Sudarshan, 2002. Database System Concepts, 4th Edition. McGraw-Hill.
- Chiang Lee, Chi-Sheng Shih and Yaw-Huei Chen, 2001. A Graph-theoritic model for optimizing queries involving methods. The VLDB Journal — The International Journal on Very Large Data Bases, Vol. 9, Issue 4, Pages 327-343.
- Clay Lua, 15 ways to Optimize your Queries, [hungred. com/useful-information/ways-optimize-sql-queries].
- Hsiao-Fei Liu, Ya-Hui Chang and Kun-Mao Chao, June 2004. An Optimal Algorithm for Querying Tree Structures and its Applications in Bioinformatics. ACM SIGMOD Record Vol. 33.
- Jingren Zhou and Kenneth A. Ross, June 2004. Buffering Database Operations for Enhanced Instruction Cache Performance. Proceedings of the 2004 ACM SIGMOD international conference on Management of data, Pages 191-202.
- Michael L. Rupley, 2008. Jr. Introduction to Query Processing and Optimization. Indiana University at South Bend.
- Olivier Perron, 2001. How to Optimize Queries [Theory and Practice], [serverwatch. com/tutorials/article. php/ 2175621].
- Ramez Elmasri and Shamkant B. Navathe. 1994. Fundamentals of Database Systems, second edition. Addison-Wesley Publishing Company.
- Reza Sadri, Carlo Zaniolo, Amir Zarkesh and Jafar Adibi. June 2004. Expressing and Optimizing Sequence Queries in Database Systems. ACM Transactions on Database Systems, Vol. 29, Issue 2, Pages 282-318.
- Reza Sadri, Carlo Zaniolo, Amir Zarkesh and Jafar Adibi. May 2001. Optimization of Sequence Queries in Database Systems. In Proceedings of the twentieth ACM SIGMOD-SIGACTSIGART symposium on Principles of database systems, Pages 71-81.
- Thomas Schwentick. March 2004. XPath Query Containment. ACM SIGMOD Record, Vol. 33.
Index Terms
Keywords