Weight-Based Query Optimization System Using Buffer
Year: 2008
Type: article
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.
Language: English
Subfield: Information Systems
Field: Computer Science
Domain: Physical Sciences
Keywords: query optimization, execution plans, query caching
Open Access status: green
OpenAlex ID: W2177373506
