CFP last date
20 December 2024
Reseach Article

Semantic based Efficient Cache Mechanism for Database Query Optimization

by P.mohan Kumar, J.vaideeswaran
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

@article{ 10.5120/6419-8911,
author = { P.mohan Kumar, J.vaideeswaran },
title = { Semantic based Efficient Cache Mechanism for Database Query Optimization },
journal = { International Journal of Computer Applications },
issue_date = { April 2012 },
volume = { 43 },
number = { 23 },
month = { April },
year = { 2012 },
issn = { 0975-8887 },
pages = { 14-18 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume43/number23/6419-8911/ },
doi = { 10.5120/6419-8911 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T20:34:05.693635+05:30
%A P.mohan Kumar
%A J.vaideeswaran
%T Semantic based Efficient Cache Mechanism for Database Query Optimization
%J International Journal of Computer Applications
%@ 0975-8887
%V 43
%N 23
%P 14-18
%D 2012
%I Foundation of Computer Science (FCS), NY, USA
Abstract

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

References
  1. S. Prabha, A. Kannan Anna University 2006 "An optimizing query processor with an efficient caching mechanism for distributed databases". International Arab journal of Information Technology Vol 3 July.
  2. . Munir Ahmad, Abdul quadar MD Ali Jinna university Pakistan 2005 " A efficient query matching algorithm for relational data cache "Intelligence cache management for grid Australia.
  3. Sumalatha A. Vaidhei 2007 "XML query processing-semantic cache mechanism "IJCSNS International Journal of Computer Science and Network Security, VOL. 7 No. 4, April.
  4. Min Wang, Haixun Wang University of Hawaii China 2009 Semantic queries in database problems and challenges. CIKM'09, November 2–6, Hong Kong, China.
  5. . Brian D. Davison Department of Computer Science Rutgers, the State University of New Jersey (USA) A Web Caching Primer c IEEE. Reprinted from IEEE Internet mputing, Volume 5, Number 4, July/August 2001, pages 38-45.
  6. . Research challenges and perspectives of the Semantic Web Report of the EU-NSF strategic workshop held at Sophia-Antipolis, France, October 3rd.
  7. . Q. Yang, H. H. Zhang, and T. Li. Mining web logs for prediction models in WWW caching and perfecting.
  8. . Qiongluo, Naughton, Sekar "Active Query Caching for Database Web Servers"
  9. . Abdullah Balamash and Marwan Krunz Performance Analysis of a Client-Side Caching/ Prefetching System for Web Traffic National Science Foundation through grant ANI-0095626.
  10. . M. Rabinovich and O. Spats check. Web Caching and Replication. Addison Wesley, 1st edition, December 2001.
  11. . John Hebeler,Ryan Blace Semantic Web Programming Wiley India Edition ISBN 978-81-265-2110-4 pp-519-555.
Index Terms

Computer Science
Information Sciences

Keywords

Semantic Cache Efficiency Optimization