作者投稿和查稿 主编审稿 专家审稿 编委审稿 远程编辑

计算机工程 ›› 2008, Vol. 34 ›› Issue (4): 84-86. doi: 10.3969/j.issn.1000-3428.2008.04.029

• 软件技术与数据库 • 上一篇    下一篇

基于XML的代理关键字处理方法

葛 欣1,丁恩杰2   

  1. (1. 中国矿业大学计算机学院,徐州 221008; 2. 中国矿业大学信息与电气工程学院,徐州 221008)
  • 收稿日期:1900-01-01 修回日期:1900-01-01 出版日期:2008-02-20 发布日期:2008-02-20

Surrogate Keys Processing Method Based on XML

GE Xin1, DING En-jie2   

  1. (1. School of Computer, China University of Mining and Technology, Xuzhou 221008;2. School of Information & Electronic Engineering, China University of Mining and Technology, Xuzhou 221008)
  • Received:1900-01-01 Revised:1900-01-01 Online:2008-02-20 Published:2008-02-20

摘要: 代理关键字被普遍应用于数据仓库的构建。在XML Schema映射为数据仓库结构的情况下,该文提出一种引入代理关键字的处理方法,利用Java工具包,将XML Schema转换成XOM树结构,在转换成关系模式时加入代理关键字,实现了XML文档与数据仓库间的直接转换。实验结果证明了该算法的有效性。

关键词: 代理关键字, 数据仓库, 数据转换

Abstract: With the universal application of surrogate keys in data warehouse creation, this paper presents a method to deal with surrogate keys when mapping XML Schema to data warehouse model. It maps XML Schema to XOM tree by using Java toolkit, and adds surrogate keys during transforming the tree to relation schema, which realizes the creation of data warehouse through XML. Experimental results show that the method is effective.

Key words: surrogate keys, data warehouse, data transformation

中图分类号: