CFP last date
20 January 2025
Call for Paper
February Edition
IJCA solicits high quality original research papers for the upcoming February edition of the journal. The last date of research paper submission is 20 January 2025

Submit your paper
Know more
The week's pick
Responsive image
SFLA-Based Line Balancing and Task Optimization in Master-Slave Controlled Hanger Transportation Systems for Garment Production

Duc Hoang Nguyen
Random Articles
Reseach Article

Pragmatic Approach to Query Optimization

by Subhi H. Hamdoon, Virendra Gawande, Ahmed Al-barashdi
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 66 - Number 7
Year of Publication: 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 },
issue_date = { March 2013 },
volume = { 66 },
number = { 7 },
month = { March },
year = { 2013 },
issn = { 0975-8887 },
pages = { 32-37 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume66/number7/11099-6063/ },
doi = { 10.5120/11099-6063 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T21:21:45.491031+05:30
%A Subhi H. Hamdoon
%A Virendra Gawande
%A Ahmed Al-barashdi
%T Pragmatic Approach to Query Optimization
%J International Journal of Computer Applications
%@ 0975-8887
%V 66
%N 7
%P 32-37
%D 2013
%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
  1. Andrew Eisenberg and Jim Melton, June 2004. An Early Look at XQuery API for Java™ (XQJ). ACM SIGMOD Record, Vol. 33.
  2. Avi Silbershatz, Hank Korth and S. Sudarshan, 2002. Database System Concepts, 4th Edition. McGraw-Hill.
  3. 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.
  4. Clay Lua, 15 ways to Optimize your Queries, [hungred. com/useful-information/ways-optimize-sql-queries].
  5. 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.
  6. 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.
  7. Michael L. Rupley, 2008. Jr. Introduction to Query Processing and Optimization. Indiana University at South Bend.
  8. Olivier Perron, 2001. How to Optimize Queries [Theory and Practice], [serverwatch. com/tutorials/article. php/ 2175621].
  9. Ramez Elmasri and Shamkant B. Navathe. 1994. Fundamentals of Database Systems, second edition. Addison-Wesley Publishing Company.
  10. 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.
  11. 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.
  12. Thomas Schwentick. March 2004. XPath Query Containment. ACM SIGMOD Record, Vol. 33.
Index Terms

Computer Science
Information Sciences

Keywords

Optimization Query Processing Query Analyzer Query Metrics Tuples Cardinality

Powered by PhDFocusTM