XQuery and Databases

XQuery is a native XML query language that is useful for querying XML views of relational data to create XML results. It also provides the mechanism to efficiently and easily extract information from Native XML Databases (NXD) and relational data. The following database systems supported in Oxygen XML Editor offer XQuery support:

• Native XML Databases:
  • Berkeley DB XML
  • eXist
  • MarkLogic (validation support available starting with version 5)
  • Documentum xDb (X-Hive/DB) 10
• Relational Databases:
  • IBM DB2
  • Microsoft SQL Server (validation support not available)
  • Oracle (validation support not available)

1. Build Queries with Drag and Drop from the Data Source Explorer View
   
2. XQuery Transformation
   
3. XQuery Database Debugging