CFP last date
20 January 2025
Call for Paper
February Edition
IJCA solicits high quality original research papers for the upcoming February edition of the journal. The last date of research paper submission is 20 January 2025

Submit your paper
Know more
The week's pick
Responsive image
SFLA-Based Line Balancing and Task Optimization in Master-Slave Controlled Hanger Transportation Systems for Garment Production

Duc Hoang Nguyen
Random Articles
Reseach Article

A Hybrid Cache Investment Strategy for Distributed Database Queries

by Sanju Gupta, Swati V. Chande
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 145 - Number 5
Year of Publication: 2016
Authors: Sanju Gupta, Swati V. Chande
10.5120/ijca2016910629

Sanju Gupta, Swati V. Chande . A Hybrid Cache Investment Strategy for Distributed Database Queries. International Journal of Computer Applications. 145, 5 ( Jul 2016), 29-33. DOI=10.5120/ijca2016910629

@article{ 10.5120/ijca2016910629,
author = { Sanju Gupta, Swati V. Chande },
title = { A Hybrid Cache Investment Strategy for Distributed Database Queries },
journal = { International Journal of Computer Applications },
issue_date = { Jul 2016 },
volume = { 145 },
number = { 5 },
month = { Jul },
year = { 2016 },
issn = { 0975-8887 },
pages = { 29-33 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume145/number5/25276-2016910629/ },
doi = { 10.5120/ijca2016910629 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T23:49:01.353889+05:30
%A Sanju Gupta
%A Swati V. Chande
%T A Hybrid Cache Investment Strategy for Distributed Database Queries
%J International Journal of Computer Applications
%@ 0975-8887
%V 145
%N 5
%P 29-33
%D 2016
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Caching is one of the most popular techniques for last decades for improve the performance of distributed database queries. There are different techniques to implement the caching. This paper will present one of the caching methods, i.e. Cache Investment Technique. This technique is use to select best caching candidates item .These candidates item is not only useful for current query but also useful for subsequent queries. This paper will review initially existing cache investment policies and their comparative analysis in distributed environment. Then a new feasible policy proposed which is hybrid of existing policies. This proposed policy is based on existing a history based policies .This new policy gives us better candidate item, this improves the hit ratio. Improvement in hit ratio ensures the reusability of stored data efficiently. Due to this efficient reuse of stored data, lesser amount of data is required to be retrieved from remote location. Thus it improves the performance of queries in distributed database system. This paper will present the architecture of this proposed policy and give the detail explanation of each module of proposed policy.

References
  1. Donald Kossmann , Michael J. Franklin and Bjorn Thor Jonsson, "Performance Tradeoffs for Client-Server Query Processing” , ACM – SIGMOD Conference on Management of Data , New York,1996.
  2. Donald Kossmann, “ The State of the Art in Distributed Query Processing”, ACM Computational Surveys, vol. 32, Dec. 2000.
  3. Abhijit Gadkari, “ Caching in Distribute Environment”, The Architecture Journal,2009.
  4. Shaina,Anshu Kamboj, “ High Performance E-Business using Application Level Caching”, International Journal of Advanced Research in Communication Engineering, vol3,issue sep.2014.
  5. Mantu Kumar,Neera Batra and Hemant Aggarwalo, “Cache Based Query Optimization Approach in Distributed Database”,IJCSI,Vol.9, Nov.2012.
  6. Konard G.Beiske,Jan Bjorndalen,Jon Olav Hauglid, ”Semantic Cache Investment” , NIK-2009 conference.
  7. Norvald H. Ryeng, Jon Olav Hauglid, and Kjetil Norvag , “Site-Autonomous Distribted Semantic Cachig”, SAC,2011 .
  8. Donald Kossmann , Michael J. Franklin, “Cache Investment Strategies", Univ.of MD Technical CS-TR-3803 and UMIACS-TR -97-50,May 1997.
  9. Ideh Azari ,” Efficient Execution of Query in Distributed Database Systems”, 2010 3rd International Conference on Advanced Computer Theory and Engineering(ICACTE).
  10. Donald Kossmann , Michael J. Franklin,Gehard Drasch, "Cache Investment : Integrating Query Optimization and Distributed Data Placement," ACM Transaction on Database System (TODS), Dec. 2000.
  11. Michael J. Carey,Franklin J. Carey, Miron Livny ,”Local Disk Caching for Client-Server Database Systems *”, Computer Science Department University of Wisconsin-Madison,1994.
  12. Doshi P. and Raisinghani V., “Review of Dynamic Optimization Strategies in Distributed Database”, Electronics Computer Technology (ICECT), 3rd International Conference, April 2011.
  13. Yan T,IacobesnM,Garcia-Mo Lina H,”Introduction of Query optimization of distributed database”, WAM Press, I 999.
  14. Alaa Aljanaby, Emad Abuelrub, and Mohammed Odeh,“A Survey of Distributed Query Optimization”, The International Arab Journal of Information Technology, Vol. 2, January 2005.
  15. Elmasri R. and Navathe S. B., ” Fundamentals of Database Systems, Reading”, MA, Addison-Wesley, 2000.
  16. Donald Kossmann , Michael J.Franklin,Gehard Drach,”Cache Investment for Indexes”,VLDB Conference,Feb,1998.
  17. Hua-Ming Liao, Guo-Shun Pei, “Cache-Based Aggregate Query Shipping: An Efficient Scheme of Distributed OLAP Query Processing”, JOURNAL OF COMPUTER SCIENCE AND TECHNOLOGY 23(6): 905{915 Nov. 2008
  18. Ruby Bhati ,Nitika Bansal, S K Jha,“ Distributed Database System:The Current Features And Problems?”, International Journal of Computer Science and Management Research, Vol 2 , March 2013
Index Terms

Computer Science
Information Sciences

Keywords

Distributed database Caching Cache investment .Investment Cost Return on Investment (ROI)

Powered by PhDFocusTM