Query Rewrites with Views for XML in DB2

There is much effort to develop comprehensive support for the storage and querying of XML data in database management systems. The major developers have extended their systems to handle XML data natively. These have the advantage over stand-alone XML database systems that relational and XML data can be queried mutually. Indeed, recent SQL standards specify means to query relational and XML data together (called SQL/XML). These systems also now support XQuery, in addition to SQL. It is thus possible to mix the processing of relational and XML data via either query language. While there has been significant progress in efficient native storage systems for XML, there remain numerous challenges to handle efficiently queries over XML. There are efforts to adapt the strong optimization techniques used for relational ("SQL") queries for XML (and mixed) queries as well. One such technique, the materialized view, has been well studied, and well adopted, over the last decade as an effe...

• Type: Journal
• Year: 2009
• Where: ICDE
• Authors: Parke Godfrey, Jarek Gryz, Andrzej Hoppe, Wenbin Ma, Calisto Zuzarte
• Keywords: Database, ICDE 2009, Stand-alone Xml Database, Systems, XML Data