XML与关系数据集成中的数据同步修改技术  

Synchronized Update in Data Integration between XML and RDB

作　　者：孙宏伟[1] 张树生[1] 周竞涛[1] 王静[1] 赵寒[1] 

机构地区：[1]西北工业大学CAD/CAM国家专业实验室,陕西西安710072

出　　处：《西北工业大学学报》2004年第3期333-337,共5页Journal of Northwestern Polytechnical University

基　　金：国家 8 6 3高技术研究发展计划基金 (2 0 0 2 AA4 14 2 10 )资助

摘　　要：XML与 RDB的同步修改是基于 RDB的 XML管理技术中实现 XML视图与底层 RDB数据一致性的根本保障 ,有关 XML修改及其与 RDB集成后的同步修改技术的研究尚未系统开展。文中提出了一种 XML修改语言原型 FLWU( FOR、LET、WHERE、UPDATE) ;通过 FLWU到SQL的转换及两者之间同步执行机制的建立 ,实现 XML与 RDB的同步修改 ,从而保证基于 RDB的 XML数据管理中 XML视图与底层 RDB的数据一致性。Synchronized update between XML (extensible markup language) and RDB (relational database) is the basis for ensuring data consistency between XML view and bottom RDB in RDB-based XML management technology. Up to now, the update on XML as well as the synchronized update on integrated data between XML and RDB has not been studied systematically mainly because existing methods all focus on document update of XML and neglect the full update process. We propose extending XQuery, the standard XML query language recommended by W3C, through making its function include both query and update. XQuery includes the three rule sentences FOR, LET, WHERE; naturally, as our proposed extension adds UPDATE, we call our proposed protocol of XML update language FLWU. The UPDATE sentence consists of eleven update operations on not only XML contents but also XML structure. Then FLWU is decomposed into FLWI (FOR, LET, WHERE, INSERT) and FLWD (FOR, LET, WHERE, DELETE) according to the update function. By transforming FLWD and FLWI on XML view to corresponding SQL (structure query language) on bottom RDB respectively, we can convert the update on XML to update on RDB. At last a synchronized operating mechanism between XML and RDB is set up through the pre-implementation and data lock technology. Through the synchronized data update between XML and RDB, the consistency between XML view and the bottom RDB is assured.

关 键 词：XML视图 底层RDB 同步修改 SQL 

分 类 号：TP301.6[自动化与计算机技术—计算机系统结构]