Synchronized Update in Data Integration between XML and RDB
孙宏伟,张树生,周竞涛,王静,赵寒
DOI: https://doi.org/10.3969/j.issn.1000-2758.2004.03.017
2004-01-01
Xibei Gongye Daxue Xuebao/Journal of Northwestern Polytechnical University
Abstract: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.