Abstract
Updates over virtual XML views that wrap the relational data have not been well supported by current XML data management systems. This paper studies the problem of the existence of a correct relational update translation for a given view update. First, we propose a clean extended-source theory to decide whether a translation mapping is correct. Then to answer the question of the existence of a correct mapping, we classify a view update as either un-translatable, conditionally or unconditionally translatable under a given update translation policy. We design a graph-based algorithm to classify a given update into one of the three update categories based on schema knowledge extracted from the XML view and the relational base. This now represents a practical approach that could be applied by any existing view update system in industry and in academic for analyzing the translatability of a given update statement before translation of it is attempted.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Keller, M.: The Role of Semantics in Translating View Updates. IEEE Transactions on Computers 19(1), 63–73 (1986)
Banerjee, S., Krishnamurthy, V., Krishnaprasad, M., Murthy, R.: Oracle8i - The XML Enabled Data Management System. In: ICDE, pp. 561–568 (2000)
Barsalou, T., Siambela, N., Keller, A.M., Wiederhold, G.: Updating Relational Databases through Object-Based Views. In: SIGMOD, pp. 248–257 (1991)
Braganholo, V.P., Davidson, S.B., Heuser, C.A.: On the Updatability of XML Views over Relational Databases. In: WEBDB, pp. 31–36 (2003)
Carey, M.J., Kiernan, J., Shanmugasundaram, J., Shekita, E.J., Subramanian, S.N.: XPERANTO: Middleware for Publishing Object-Relational Data as XML Documents. The VLDB Journal, 646–648 (2000)
Cheng, J.M., Xu, J.: XML and DB2. In: ICDE, pp. 569–573 (2000)
Dayal, U., Bernstein, P.A.: On the Correct Translation of Update Operations on Relational Views. ACM Transactions on Database Systems 7(3), 381–416 (1982)
Shanmugasundaram, J., et al.: Relational Databases for Querying XML Documents: Limitations and Opportunities. In: VLDB, September 1999, pp. 302–314 (1999)
Fernandez, M., et al.: SilkRoute: A Framework for Publishing Relational Data in XML. ACM Transactions on Database Systems 27(4), 438–493 (2002)
Rys, M.: Bringing the Internet to Your Database: Using SQL Server 2000 and XML to Build Loosely-Coupled Systems. In: VLDB, pp. 465–472 (2001)
Tatarinov, I., Ives, Z.G., Halevy, A.Y., Weld, D.S.: Updating XML. In: SIGMOD, May 2001, pp. 413–424 (2001)
Wang, L., Mulchandani, M., Rundensteiner, E.A.: Updating XQuery Views Published over Relational Data: A Round-trip Case Study. In: XML Database Symposium (VLDB Workshop), pp. 223–237 (2003)
Wang, L., Rundensteiner, E.A.: Updating XML Views Published Over Relational Databases: Towards the Existence of a Correct Update Mapping. Technical Report WPI-CS-TR-04-19, Computer Science Department, WPI (2004)
Zhang, X., Dimitrova, K., Wang, L., EL-Sayed, M., Murphy, B., Ding, L., Rundensteiner, E.A.: RainbowII: Multi-XQuery Optimization Using Materialized XML Views. In: Demo Session Proceedings of SIGMOD, p. 671 (2003)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Wang, L., Rundensteiner, E.A. (2004). On the Updatability of XML Views Published over Relational Data. In: Atzeni, P., Chu, W., Lu, H., Zhou, S., Ling, TW. (eds) Conceptual Modeling – ER 2004. ER 2004. Lecture Notes in Computer Science, vol 3288. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-30464-7_59
Download citation
DOI: https://doi.org/10.1007/978-3-540-30464-7_59
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-23723-5
Online ISBN: 978-3-540-30464-7
eBook Packages: Springer Book Archive