首页> 外文会议>Knowledge-Based Systems for Safety Critical Applications >Super-fast XML wrapper generation in DB2: a demonstration
【24h】

Super-fast XML wrapper generation in DB2: a demonstration

机译:DB2中超快速的XML包装器生成:一个演示

获取原文
获取原文并翻译 | 示例

摘要

The XML wrapper is a new feature of the federated database capabilities of DB2/UDB v8. It enables users and applications to issue SQL queries against XML data from a variety of sources, including files and Web services. The XML wrapper assumes hierarchical XML documents modeled as families of virtual relational tables in a federated schema, which can then be queried to extract information from the XML and combine it with data from other sources. Due to the nature of the problem, using the XML wrapper is complex and several difficult steps must be undertaken: (i) The hierarchical schema of the source must be flattened to a relational form, (ii) Each relation of the flattened schema must be registered in DB2 as a NICKNAME - a complex virtual table definition containing several XPaths as specialized options. (iii) Each NICKNAME must be accompanied by a VIEW - again a complex structure involving join conditions. Chocolate is a tool that alleviates all three tasks: Chocolate provides several flattening strategies and an interface allowing users to modify the automatically generated target schema. Once the user is satisfied with the schema, Chocolate automatically generates the corresponding NICKNAME and VIEW definitions.
机译:XML包装器是DB2 / UDB v8的联合数据库功能的新功能。它使用户和应用程序可以对来自各种来源(包括文件和Web服务)的XML数据发出SQL查询。 XML包装器假定将层次化XML文档建模为联合模式中的虚拟关系表族,然后可以查询该分层结构以从XML中提取信息并将其与其他来源的数据组合。由于问题的性质,使用XML包装器很复杂,必须执行几个困难的步骤:(i)必须将源的分层架构展平为一种关系形式,(ii)必须对展平架构的每个关系进行平整。在DB2中注册为NICKNAME-一个复杂的虚拟表定义,其中包含多个XPath作为专用选项。 (iii)每个NICKNAME必须附带一个VIEW,这也是一个包含连接条件的复杂结构。 Chocolate是减轻所有三个任务的工具:Chocolate提供了几种展平策略和一个界面,允许用户修改自动生成的目标架构。用户对模式满意后,Chocolate会自动生成相应的NICKNAME和VIEW定义。

著录项

相似文献

  • 外文文献
  • 中文文献
  • 专利
获取原文

客服邮箱:kefu@zhangqiaokeyan.com

京公网安备:11010802029741号 ICP备案号:京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有
  • 客服微信

  • 服务号