Updating XML views published over relational databases: Towards the existence of a correct update mapping

Data and Knowledge Engineering

Volumn 58, Issue 3, 2006, Pages 263-298

  Wang, Ling ^a   Rundensteiner, Elke A ^a   Mani, Murali ^a  

^a Worcester Polytechnic Institute   (United States)

Author keywords

Update translatability; XML view; XQuery

Indexed keywords

ALGORITHMS; GRAPH THEORY; KNOWLEDGE ENGINEERING; MATHEMATICAL MODELS; QUERY LANGUAGES; RELATIONAL DATABASE SYSTEMS;

UPDATE TRANSLATABILITY; XML VIEW; XQUERY;

XML;

EID: 33745612031     PISSN: 0169023X     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.datak.2005.07.003     Document Type: Article

References (29)

1. Keller A.M. The role of semantics in translating view updates. IEEE Transactions on Computers 19 1 (1986) 63-73
2. Bancilhon F., and Spyratos N. Update semantics of relational views. ACM Transactions on Database Systems (1981) 557-575
3. S. Banerjee, V. Krishnamurthy, M. Krishnaprasad, R. Murthy, Oracle8i-The XML Enabled Data Management System, in: ICDE, 2000, pp. 561-568.
4. T. Barsalou, N. Siambela, A.M. Keller, G. Wiederhold, Updating relational databases through object-based views, in: SIGMOD, 1991, pp. 248-257.
5. M. Benedikt, C.Y. Chan, W. Fan, R. Rastogi, DTD-directed publishing with attribute translation grammars, in: VLDB, 2002, pp. 838-849.
6. P. Bohannon, P. Buneman, B. Choi, W. Fan, Incremental evaluation of schema-directed XML publishing, in: SIGMOD, 2004, pp. 503-514.
7. V.P. Braganholo, S.B. Davidson, C.A. Heuser, On the updatability of XML views over relational databases, in: WEBDB, 2003, pp. 31-36.
8. V.P. Braganholo, S.B. Davidson, C.A. Heuser, From XML view updates to relational view updates: old solutions to a new problem, in: LDB, 2004, pp. 276-287.
9. P. Buneman, S. Khanna, W. C. Tan, On propagation of deletions and annotations through views, in: PODS, 2002, pp. 150-158.
10. Carey M.J., Kiernan J., Shanmugasundaram J., Shekita E.J., and Subramanian S.N. XPERANTO: middleware for publishing object-relational data as XML documents. The VLDB Journal (2000) 646-648
11. Y.B. Chen, T.W. Ling, M.-L. Lee, Designing valid XML views, in: ER, 2002, pp. 463-478.
12. J.M. Cheng, J. Xu, XML and DB2, in: ICDE, 2000, pp. 569-573.
13. Cosmadakis S.S., and Papadimitriou C.H. Updates of relational views. Journal of the Association for Computing Machinery (1984) 742-760
14. Dayal U., and Bernstein P.A. On the correct translation of update operations on relational views. ACM Transactions on Database Systems 7 3 (1982) 381-416
15. Fernandez M.F., Morishima A., Suciu D., and Tan W.C. Publishing relational data in XML: the silkroute approach. IEEE Data Engineering Bulletin 24 2 (2001) 12-19
16. J. Shanmugasundaram et al., Relational databases for querying XML documents: limitations and opportunities, in: VLDB, September 1999, pp. 302-314.
17. A.M. Keller, Algorithms for translating view updates to database updates for view involving selections, projections and joins, in: Fourth ACM SIGACT-SIGMOD Symposium on Principles of Database Systems, 1985, pp. 154-163.
18. A.M. Keller, Choosing a view update translator by dialog at view definition time, in: VLDB, 1996, pp. 467-474.
19. R. Krishnamurthy, R. Kaushik, J.F. Naughton. Unraveling the duplicate-elimination problem in XML-to-SQL query translation, in: WebDB, 2004.
20. T.W. Ling, M.-L. Lee, A theory for entity-relationship view updates, in: ER, 1992, pp. 262-279.
21. Fernandez M., et al. Silkroute: a framework for publishing relational data in XML. ACM Transactions on Database Systems 27 4 (2002) 438-493
22. Ramakrishnan R. Database Management Systems (1997), McGraw-Hill
23. M. Rys, Bringing the Internet to your database: using SQL Server 2000 and XML to build loosely-coupled systems, in: VLDB, 2001, pp. 465-472.
24. I. Tatarinov, Z.G. Ives, A. Y. Halevy, D.S. Weld, Updating XML, in: SIGMOD, May 2001, pp. 413-424.
25. W3C, XQuery: a query language for XML, , (accessed February 2001).
26. W3C, XQuery 1.0 Formal Semantics, http://www.w3.org/TR/query-semantics/, June 2003.
27. L. Wang, M. Mulchandani, E.A. Rundensteiner, Updating XQuery views published over relational data: a round-trip case study, in: XML Database Symposium, 2003, pp. 223-237.
28. L. Wang, E.A. Rundensteiner, On the updatability of XQuery views published over relational data, in: ER, 2004.
29. X. Zhang, K. Dimitrova, L. Wang, M. EL-Sayed, B. Murphy, L. Ding, E.A. Rundensteiner, RainbowII: multi-XQuery optimization using materialized XML views, in: Demo Session Proceedings of SIGMOD, 2003, p. 671.