• 主题
高级搜索  >
历史搜索 清空历史
首页> 外文期刊>Journal of Intelligent Information Systems >VIREX and VRXQuery: interactive approach for visual querying of relational databases to produce XML
【24h】

VIREX and VRXQuery: interactive approach for visual querying of relational databases to produce XML

机译：VIREX和VRXQuery：用于可视化查询关系数据库以生成XML的交互式方法

获取原文
获取原文并翻译 | 示例
           
页面导航
  • 摘要
  • 著录项
  • 相似文献
  • 相关主题

摘要

VIREX provides an interactive approach for querying and integrating relational databases to produce XML documents and the corresponding schemas. VIREX connects to each database specified by the user; analyzes the catalogue to derive an interactive diagram equivalent to the extended entity-relationship diagram; allows the user to display sample records from the tables in the database; allows the user to rename columns and relations by modifying directly the interactive diagram; facilitates the conversion of the relational database into XML; and derives the XML schema. VIREX works even when the catalogue of the relational database is missing; it extracts the required catalogue information by analyzing the database content. Further, VIREX supports VRXQuery, which is a visual naive-users-oriented query language that allows users to specify queries and define views directly on the interactive diagram as a sequence of mouse clicks with minimum keyboard input. The user is expected to interactively decide on certain factors to be considered in producing the XML result. Such factors include: 1) selecting the relations/attributes to be converted into XML; 2) specifying a predicate to be satisfied by the information to be converted into XML; 3) deciding on the order of nesting between the relations to be converted into XML; 4) ordering for the result. VRXQuery supports selection, projection, nesting/join, union, difference, and order-by. As the result of a query, VIREX displays on the screen the XML schema that satisfies the specified characteristics and generates colored (easy to read) XML document(s). Further, VIREX allows the user to display and review the SQL and XQuery equivalent to each query expressed in VRXQuery.
机译：VIREX提供了一种用于查询和集成关系数据库以生成XML文档和相应架构的交互式方法。 VIREX连接到用户指定的每个数据库；分析目录以得出与扩展实体关系图等效的交互式图；允许用户显示数据库表中的样本记录；允许用户通过直接修改交互式图表来重命名列和关系；促进关系数据库到XML的转换；并导出XML模式。即使关系数据库的目录丢失，VIREX仍可正常工作。它通过分析数据库内容来提取所需的目录信息。此外，VIREX支持VRXQuery，VRXQuery是一种面向天真用户的可视化查询语言，它允许用户指定查询并直接在交互式图表上定义视图，以最少的键盘输入来单击一系列鼠标。期望用户交互式地决定在生成XML结果时要考虑的某些因素。这些因素包括：1）选择要转换为XML的关系/属性； 2）指定要转换为XML的信息要满足的谓词； 3）确定要转换为XML的关系之间的嵌套顺序； 4）订购结果。 VRXQuery支持选择，投影，嵌套/联接，并集，差异和排序。查询的结果是，VIREX在屏幕上显示满足指定特征的XML模式，并生成彩色（易于阅读）的XML文档。此外，VIREX允许用户显示和查看与VRXQuery中表达的每个查询等效的SQL和XQuery。

著录项

相似文献

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

客服邮箱：kefu@zhangqiaokeyan.com

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

  • 客服微信

  • 服务号