Browse > Article

Storage Schemes for XML Query Cache  

Kim, Young-Hyun (삼성전자)
Kang, Hyun-Chul (중앙대학교 컴퓨터공학부)
Abstract
XML query caching for XML database-backed Web applications began to be investigated recently. Despite its practical significance, efficiency of the storage schemes for cached query results has not been addressed. In this paper, we deal with the storage schemes for XML query cache. A fundamental problem that needs to be considered in designing an efficient storage structure for XML query cache is that there exist performance tradeoffs between the two major types of operations on a cached query result. The two are (1) retrieving the whole of it to return the query result and (2) updating just a small portion of it for its incremental refresh against the updates done to its source. We propose eight different storage schemes for XML query cache, which are categorized into three groups: (1) the schemes based on the plain text file, (2) the schemes based on the persistent DOM (PDOM) file, and (3) a scheme employing an RDBMS. We implemented all of them, and compared their performance with each other. We also compared our proposal with a storage scheme based on a current state-of-the-art XML storage scheme, showing that ours is more efficient.
Keywords
XML Query Cache; Incremental Refresh of Cache; XML Update; DOM; PDOM;
Citations & Related Records
연도 인용수 순위
  • Reference
1 P. Marron and G. Lausen, 'Efficient Cache Answerability for XPath Queries,' Proc. the 2nd Int'l Workshop on Data Interation over the Web (DIWeb), 2002, pp. 35-45
2 L. Yang, M. Lee, and W. Hsu, 'Efficient Mining of XML Query Patterns for Caching,' Proc. Int'l Conf. on VLDB, 2003
3 A. Balmin, F. Ozcan, K. Beyer, R. Cochrane, and H. Pirahesh, 'A Framework for Using Materialized XPath Views in XML Query Processing,' Proc. Int'l Conf, on VLDB, 2004
4 L. Chen and E. Rundensteiner, 'ACE- XQ: A CachE-aware XQuery Answering System,' Proc. Workshop on the Web and Databases, 2002
5 V. Hristidis and M. Petropoulos, 'Semantic Caching of XML Databases,' Proc. Workshop on the Web and Databases, 2002
6 L. Chen and E. Rundensteiner, 'Aggregate Path Index for Incremental Web View Maintenance,' Proc. 2nd Int'l Workshop on Advanced Issues of E-Commerce and Web-based Information Systems, 2000   DOI
7 A. Sawires, J. Tatemura, O. Po, D. Agrawal, and K. Candan, 'Incremental Maintenance of Path-Expression Views,' Proc. ACM SIGMOD Int'l Conf. on Management of Data, 2005   DOI
8 L. Quan et al., 'Argos: Efficient Refresh in an XQL-Based Web Caching System,' Proc. Workshop on the Web and Databases, 2000, pp. 23-28
9 K. Dimitrova, M. El-Sayed, E. Rundensteiner, 'Order-sensitive View Maintenance of Materialized XQuery Views,' Tech. Rep. WPI-CS-TR03-17, Computer Science Department, Worcester Polytechnic Institute, May 2003
10 A. Levy et al., 'Answering Queries Using Views,' Proc. of ACM Int'l Symp. on PODS, 1995
11 A. Gupta and I. Mumick, 'Materialized Views: Techniques, Implementations, and Applications,' 1999, MIT Press
12 M. Yoshikawa, T. Amagasa, T. Shimura, S. Uemura, 'XRel: A Path-Based Approach to Storage and Retrieval of XML Documents Using Relational Databases,' ACM Trans. on Internet Technology, Vol. 1, No. 1, Aug. 2001, pp. 110-141   DOI
13 D. Florescu and D. Kossmann, 'Storing and Querying XML Data Using an RDBMS,' IEEE Data Engg. Bulletin, Sep. 1999, pp. 27-34
14 J. Shanmugasundaram et al., 'Efficiently Publishing Relational Data as XML Documents,' Proc. Int'l Conf. on VLDB, 2000, pp. 65-76
15 Xerces Java Parser: http://xml.apache.org/xerces-j/
16 TPC-W: Transaction Processing Performance Council. http://www.tpc.org/tpcw/
17 ToXgene: http://www.cs.toronto.edu/tox/toxgene/
18 G. Huck, and I. Macherius, 'GMD-IPSI XQL Engine,' http://xml.darmstadt.gmd.de/xql/
19 J. Kohl et aI., 'HighLight; Using a Log-structured File System for Tertiary Storage Management,' Proc. Winter USENIX, 1993, pp. 435-447
20 XBench: http://db.uwaterloo.ca/~ddbms/projects/xbench/
21 B. Mandhani and D. Suciu, 'Query Caching and View Selection for XML Databases,' Proc. Int'l Cont. on VLDB, 2005
22 W. Xu and Z. Ozsoyoglu, 'Rewriting XPath Queries Using Materialized Views,' Proc. Int'l Conf. on VLDB, 2005
23 G. Huck, I. Macherius, and P. Fankhauser, 'PDOM: Lightweight Persistency Support for the Document Object Scheme,' Proc. OOPSLA Workshop Java and Databases: Persistence Options, 1999
24 Schmidt, A. et al., 'XMark: A Benchmark for XML Data Management,' Proc, Int'l Conf, on VLDB, 2002