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

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

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

CLC Number: 

• TP311