Graph based query trimming algorithm for relational data semantic cache

Semantic cache enhances the capability of conventional (page/tuple) cache by adopting the dynamic strategy to group the contents and semantics of already processed queries. Query processing and cache management are two major activities for semantic caching. Semantic caching demands efficient, correct and complete algorithms to process incoming queries. Efficiency of query processing activity in semantic cache mainly depends on query trimming. Query trimming process consists of two sub processes; query matching and query splitting. Efficient query matching and query splitting process will ensures the optimal query trimming process. In this paper, we have proposed query trimming algorithm by defining query matching algorithm and using query splitting algorithm from the literature. To optimize the query matching process we have proposed graph based semantic indexing scheme. On the basis of proposed indexing scheme we have designed query matching algorithm (qTrim). We have proved that complexity of graph based query matching algorithm is reduced to linear from exponential. Comparison of graph based (proposed) scheme is done with segment based scheme. On the basis of comparison and runtime complexity we have argued that the proposed algorithm is an optimum to trim the queries into sub-queries (probe and remainder).

[1]  Wei Sun,et al.  Solving satisfiability and implication problems in database systems , 1996, TODS.

[2]  Divesh Srivastava,et al.  Performance and overhead of semantic cache management , 2006, TOIT.

[3]  Nick Roussopoulos,et al.  The Implementation and Performance Evaluation of the ADMS Query Optimizer: Integrating Query Result Caching and Matching , 1994, EDBT.

[4]  Jeffrey F. Naughton,et al.  Active Query Caching for Database Web Servers , 2000, WebDB.

[5]  V. Vaidehi,et al.  Xml Query Processing - Semantic Cache System , 2007 .

[6]  Divesh Srivastava,et al.  Semantic Data Caching and Replacement , 1996, VLDB.

[7]  Yan Jia,et al.  A Method of Aggregate Query Matching in Semantic Cache for Massive Database Applications , 2005, APPT.

[8]  V. Vaidehi,et al.  Dynamic Rule Set Mapping Strategy for the Design of Effective Semantic Cache , 2007, The 9th International Conference on Advanced Communication Technology.

[9]  V. Vaidehi,et al.  Hash Mapping Strategy for Improving Retrieval Effectiveness in Semantic Cache System , 2007, 2007 International Conference on Signal Processing, Communications and Networking.

[10]  Mobin Uddin Ahmed,et al.  Intelligent cache management for data grid , 2005 .

[11]  Lionel M. Ni,et al.  Processing Implication on Queries , 1989, IEEE Transactions on Software Engineering.

[12]  Vijay Kumar,et al.  Semantic Caching and Query Processing , 2003, IEEE Trans. Knowl. Data Eng..

[13]  M.A. Qadir,et al.  Query processing over relational databases with semantic cache: A survey , 2008, 2008 IEEE International Multitopic Conference.

[14]  Nick Roussopoulos,et al.  An incremental access method for ViewCache: concept, algorithms, and cost analysis , 1991, TODS.

[15]  Jeffrey F. Naughton,et al.  Caching multidimensional queries using chunks , 1998, SIGMOD '98.

[16]  Muhammad Abdul Qadir,et al.  An efficient query matching algorithm for relational data semantic cache , 2009, 2009 2nd International Conference on Computer, Control and Communication.

[17]  Muhammad Abdul Qadir,et al.  SCAM: Semantic Caching Architecture for Efficient Content Matching over Data Grid , 2007, AWIC.

[18]  Jongwan Kim,et al.  Cache Strategies for Semantic Prefetching Data , 2006, 2006 Seventh International Conference on Web-Age Information Management Workshops.

[19]  Sharad Mehrotra,et al.  Efficient Query Refinement in Multimedia Databases , 2000, Proceedings of 16th International Conference on Data Engineering (Cat. No.00CB37073).

[20]  Dongwon Lee,et al.  Semantic caching via query matching for web sources , 1999, CIKM '99.

[21]  Hamid Pirahesh,et al.  Cache Tables: Paving the Way for an Adaptive Database Cache , 2003, VLDB.

[22]  Stefan Andrei,et al.  Utilizing semantic caching in ubiquitous environment , 2009, IWCMC.

[23]  Jarek Gryz,et al.  Semantic Query Caching for Hetereogeneous Databases , 1997, KRDB.

[24]  Divesh Srivastava,et al.  Using LDAP directory caches , 1999, PODS '99.

[25]  Elke A. Rundensteiner,et al.  XCache: a semantic caching system for XML queries , 2002, SIGMOD '02.

[26]  M.A. Qadir,et al.  HiSIS: 4-Level Hierarchical Semantic Indexing for Efficient Content Matchingover Semantic Cache , 2006, 2006 IEEE International Multitopic Conference.

[27]  Muhammad Abdul Qadir,et al.  DL based Subsumption Analysis for Relational Semantic Cache Query Processing and Management , 2010 .

[28]  Muhammad Abdul Qadir,et al.  Translation of relational queries into Description Logic for semantic cache query processing , 2010, 2010 International Conference on Information and Emerging Technologies.

[29]  M. Ahmad,et al.  SCAD-XML: Semantic Cache Architecture for XML data files using XPath with cases and rules , 2008, 2008 IEEE International Multitopic Conference.