保持数据约束的关系数据库至XML文档的转换  

CONVERTING RELATIONAL DATABASE INTO XML DOCUMENTS WITH DATA CONSTRAINTS PRESERVATION

作　　者：徐文浩[1] 焦智[1] 刘秀兰[1] 薛宝仪[2] 

机构地区：[1]北京工业大学电子信息与控制工程学院,北京100022 [2]国防大学训练模拟中心,北京100091

出　　处：《计算机应用与软件》2007年第1期61-64,共4页Computer Applications and Software

摘　　要：XML已成为Internet上的技术趋势,在保留原有关系数据库的同时发展XML文档是目前的最佳选择,它需要在保持数据依赖约束基础上实现关系数据库与XML文档的转换。这一过程中,模式转换必须先于数据转换,因为现有的关系数据库通常是规范化的,重建XML文档树结构才能实现这一转换。为了达成此目的,首先依据已有的数据依赖约束将规范化的关系联合进一组表格,实现反向规范化,然后将这些联合表格映射为一组DOM,归并成XML文档树,根据用户选择的根结点,以及与它相连的结点形成一个期望的局部文档树,被选的XML文档树又映射为DTD格式的XML模式。这样就可以将联合表映射成一组DOM,并将其归并成单一DOM,最终转换成XML文档。XML is recognized as the trend of technology on the Intemet, and it＇s the best choice that developing new XML documents while running ,existing relational databases. But it needs converting relational databases into XML documents with constraints preservation. In the process, schema translation must be done before dataconversion. Since the existing relational databases are usually normalized, they have to be reconstructed into XML document tree structures. This can be accomplished through denormalization by joining the normalized relations into ta- bles according to their data dependency constrains. The joined tables are mapped into DOMs, which are then integrated into XML document trees. The user specifies an XML document root with its relevant nodes to form a partitioned XML document tree to meet their requirements. The selected XML document tree is mapped into an XML schema in the form of DTD. We then load joined tables into DOMs, integrate them into a DOM, and transform it into an XML document.

关 键 词：数据约束 关系数据库 XML文档 转换 

分 类 号：TP311.132[自动化与计算机技术—计算机软件与理论]