Optimizing Query Processing in Practical Software Database by Adapting

Different methods have been presented because of the needs to query processing optimization in databases. The reason of these needs is to increase the amount of data and the queries sent to the Database Management System. Even though there are various methods presented to optimize queries, the probl...

Full description

Saved in:
Bibliographic Details
Main Authors: Derakhshi, M.R.F., Asil, H., Asil, A., Zafarani, E.
Format: Conference Proceeding
Language:English
Subjects:
Adaption
Agen
Computer industry
Data engineering
Data mining
Database systems
Engineering management
Optimization methods
Queries Processing
Query processing
Relational Database
Relational databases
Software testing
Spatial databases
Online Access:Request full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:Different methods have been presented because of the needs to query processing optimization in databases. The reason of these needs is to increase the amount of data and the queries sent to the Database Management System. Even though there are various methods presented to optimize queries, the problem is that in most of these methods, the execution plan is deleted after the query is conducted. This study tries to provide a method that uses optimized execution plan obtained from executing a query for the next executions or executing a similar query in order to reduce time needed for executing queries. The method presented in this study has been tested on real practical software databases and the results shows 11% improvement.
DOI:10.1109/WKDD.2010.121