International Journal of Computer Applications |
Foundation of Computer Science (FCS), NY, USA |
Volume 43 - Number 23 |
Year of Publication: 2012 |
Authors: P.mohan Kumar, J.vaideeswaran |
10.5120/6419-8911 |
P.mohan Kumar, J.vaideeswaran . Semantic based Efficient Cache Mechanism for Database Query Optimization. International Journal of Computer Applications. 43, 23 ( April 2012), 14-18. DOI=10.5120/6419-8911
The primary goal of the database system is to provide the user a convenient and efficient access to the query related data. With this concern this paper provides semantic based cache mechanism techniques for optimizing the user queries. Here the frame work for optimization is analyzed which supports data and computation reuse, query scheduling and cache efficient utilization algorithm is presented in order to improve the evaluation process and minimize the overall response time. Further the case study is analyzed to test the performance and extended the same for multi-queries to achieve parallelism