Skip to main content
Article thumbnail
Location of Repository

Weight-Based Query Optimization System Using Buffer

By Kashif Irfan, Fahad Shahbaz Khan, Tehseen Zia and M. A. Anwar

Abstract

Abstract—Fast retrieval of data has been a need of user in any database application. This paper introduces a buffer based query optimization technique in which queries are assigned weights according to their number of execution in a query bank. These queries and their optimized executed plans are loaded into the buffer at the start of the database application. For every query the system searches for a match in the buffer and executes the plan without creating new plans. Keywords—Query Bank, Query Matcher, Weight Manager. I

Year: 2011
OAI identifier: oai:CiteSeerX.psu:10.1.1.192.9502
Provided by: CiteSeerX
Download PDF:
Sorry, we are unable to provide the full text but you may find it at the following location(s):
  • http://citeseerx.ist.psu.edu/v... (external link)
  • http://www.waset.org/journals/... (external link)
  • Suggested articles


    To submit an update or takedown request for this paper, please submit an Update/Correction/Removal Request.