Managing a fragmented XML data cube with oracle and timesten

In this paper, we cross two techniques for performance tuning of an XML cube. We analyze six configurations for managing the cube. The configurations result from storing two variants of the cube (unfragmented and fragmented) in different ways. First, we consider a disk-resident database. Then, we consider caching the frequent properties of the unfragmented cube and the frequent fragments of the fragmented cube. Finally, we load and manage the entire cube into the main memory. We show the benefits of vertical fragmentation and in-memory management of the XML cube through a set of experiments.

[1]  Koen Holtman,et al.  A cache filtering optimisation for queries to massive datasets on tertiary storage , 1999, DOLAP '99.

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

[3]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[4]  Stefan Böttcher,et al.  XML fragment caching for large-scale mobile commerce applications , 2008, ICEC.

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

[6]  Peter Scheuermann,et al.  WATCHMAN : A Data Warehouse Intelligent Cache Manager , 1996, VLDB.

[7]  Joel H. Saltz,et al.  Active semantic caching to optimize multidimensional data analysis in parallel and distributed environments , 2007, Parallel Comput..

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

[9]  Martin L. Kersten,et al.  Optimizing database architecture for the new bottleneck: memory access , 2000, The VLDB Journal.

[10]  W. H. Inmon,et al.  Building the data warehouse (2nd ed.) , 1996 .

[11]  Yu Hong,et al.  Data Warehouse Performance , 2009, Encyclopedia of Data Warehousing and Mining.

[12]  Mong-Li Lee,et al.  Efficient Mining of XML Query Patterns for Caching , 2003, VLDB.

[13]  Elke A. Rundensteiner,et al.  A fine-grained replacement strategy for XML query cache , 2002, WIDM '02.

[14]  Kenneth A. Ross,et al.  Serving datacube tuples from main memory , 2000, Proceedings. 12th International Conference on Scientific and Statistica Database Management.

[15]  Hyoil Han,et al.  XML-OLAP: A Multidimensional Analysis Framework for XML Warehouses , 2005, DaWaK.

[16]  Yin-Fu Huang,et al.  Mining web logs to improve hit ratios of prefetching and caching , 2008, Knowl. Based Syst..

[17]  Omar Boussaïd,et al.  Vertical Fragmentation of XML Data Warehouses Using Frequent Path Sets , 2011, DaWaK.

[18]  Dan Suciu,et al.  Query Caching and View Selection for XML Databases , 2005, VLDB.

[19]  Wolfgang Lehner,et al.  Divide and aggregate: caching multidimensional objects , 2000, DMDW.

[20]  Olivier Teste,et al.  Finding an application-appropriate model for XML data warehouses , 2010, Inf. Syst..

[21]  P ? ? ? ? ? ? ? % ? ? ? ? , 1991 .

[22]  Masaru Kitsuregawa,et al.  Improving main memory utilization for array-based datacube computation , 1998, DOLAP '98.