Abstract
Physical structures, for example indexes and materialized views, can improve query execution performance by orders of magnitude. Hence, it is important to choose the right configuration of these physical structures for a given database. In this paper, we discuss the types of materialized views that are suitable for an XML database. We then focus on XMLTable materialized views and present a procedure to recommend them given an XML database and a workload of XQuery queries. We have implemented our XMLTable View Advisor in a prototype version based on IBM® DB2® V9.7, which supports both relational and XML data, and we experimentally demonstrate the effectiveness of our advisor’s recommendations.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
XMLTABLE overview (2006), http://publib.boulder.ibm.com/infocenter/db2luw/v9/
Agrawal, S., Chaudhuri, S., Kollár, L., Marathe, A.P., Narasayya, V.R., Syamala, M.: Database tuning advisor for Microsoft SQL Server 2005. In: VLDB (2004)
Arion, A., Benzaken, V., Manolescu, I., Papakonstantinou, Y.: Structured materialized views for XML queries. In: VLDB (2007)
Arion, A., Benzaken, V., Manolescu, I., Vijay, R.: ULoad: choosing the right storage for your XML application. In: VLDB (2005)
Balmin, A., Özcan, F., Beyer, K., Cochrane, R.J., Pirahesh, H.: A framework for using materialized XPath views in XML query processing. In: VLDB (2004)
Beyer, K., et al.: DB2 goes hybrid: Integrating native XML and XQuery with relational data and SQL. IBM Systems Journal 45(2) (2006)
Bohannon, P., Freire, J., Haritsa, J.R., Ramanath, M.: LegoDB: Customizing relational storage for XML documents. In: VLDB (2002)
Bohannon, P., Freire, J., Roy, P., Siméon, J.: From XML schema to relations: A cost-based approach to XML storage. In: ICDE (2002)
Deutsch, A., Tannen, V.: MARS: A system for publishing XML from mixed and redundant storage. In: VLDB (2003)
Elghandour, I., Aboulnaga, A., Zilio, D.C., Chiang, F., Balmin, A., Beyer, K., Zuzarte, C.: XML index recommendation with tight optimizer coupling. In: ICDE (2008)
Godfrey, P., Gryz, J., Hoppe, A., Ma, W., Zuzarte, C.: Query rewrites with views for XML in DB2. In: ICDE (2009)
Halevy, A.Y.: Answering queries using views: A survey. The VLDB Journal 10(4) (2001)
Halverson, A., Josifovski, V., Lohman, G.M., Pirahesh, H., Mörschel, M.: ROX: Relational over XML. In: VLDB (2004)
Comparing XML and relational storage: A best practices guide. IBM: Storage best practices (2005)
Josifovski, V., Massmann, S., Naumann, F.: Super-Fast XML wrapper generation in DB2: A demonstration. In: ICDE (2003)
Mandhani, B., Suciu, D.: Query caching and view selection for XML databases. In: VLDB (2005)
Manolescu, I., Florescu, D., Kossmann, D.: Answering XML queries on heterogeneous data sources. In: VLDB (2001)
Moro, M.M., Lim, L., Chang, Y.-C.: Schema advisor for hybrid relational-XML DBMS. In: SIGMOD (2007)
Nicola, M., Kogan, I., Schiefer, B.: An XML transaction processing benchmark. In: SIGMOD (2007), https://sourceforge.net/projects/tpox/
Onose, N., Deutsch, A., Papakonstantinou, Y., Curtmola, E.: Rewriting nested XML queries using nested views. In: SIGMOD (2006)
Oracle Corp.: Oracle Database 11g Release 1 XML DB Developer’s Guide (2007), http://www.oracle.com/pls/db111/
Rys, M.: XML and relational database management systems: Inside Microsoft SQL Server 2005. In: SIGMOD (2005)
Zilio, D.C., Rao, J., Lightstone, S., Lohman, G.M., Storm, A., Garcia-Arellano, C., Fadden, S.: DB2 design advisor: Integrated automatic physical database design. In: VLDB (2004)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Elghandour, I., Aboulnaga, A., Zilio, D.C., Zuzarte, C. (2009). Recommending XMLTable Views for XQuery Workloads. In: Bellahsène, Z., Hunt, E., Rys, M., Unland, R. (eds) Database and XML Technologies. XSym 2009. Lecture Notes in Computer Science, vol 5679. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-03555-5_11
Download citation
DOI: https://doi.org/10.1007/978-3-642-03555-5_11
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-03554-8
Online ISBN: 978-3-642-03555-5
eBook Packages: Computer ScienceComputer Science (R0)