Abstract
XML has become a standard medium for data exchange, and XML views are frequently used as an interface to relational database and XML data. There have been a considerable number of studies on building and querying XML views, while updating related topics for XML views have not receive much attention. In this paper, we outline our work on building XML views defined in terms of update syntax and updating XML views of relations, and discuss some related work.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Aguilera, V., Cluet, S., Milo, T., Veltri, P., Dan Vodislav: Views in a large-scale xml repository. The VLDB Journal 11(3), 238–255 (2002)
Amer-Yahia, S., Curtmola, E., Deutsch, A.: Flexible and efficient xml search with complex full-text predicates. In: SIGMOD Conference, pp. 575–586 (2006)
Benedikt, M., Chan, C.Y., Fan, W., Rastogi, R., Zheng, S., Zhou, A.: Dtd-directed publishing with attribute translation grammars. In: Bressan, S., Chaudhri, A.B., Lee, M.L., Yu, J.X., Lacroix, Z. (eds.) CAiSE 2002 and VLDB 2002. LNCS, vol. 2590, p. 838. Springer, Heidelberg (2003)
Braganholo, V.P., Davidson, S.B., Heuser, C.A: From XML view updates to relational view updates: old solutions to a new problem. In: VLDB (2004)
Buneman, P., Khanna, S., Tan, W.: On propagation of deletions and annotations through views. In: PODS (2002)
Buneman, P., Cong, G., Fan, W., Kementsietsidis, A.: Using partial evaluation in distributed query evaluation. In: VLDB (2006)
Carey, M.J., Florescu, D., Ives, Z.G., Lu, Y., Shanmugasundaram, J., Shekita, E.J., Subramanian, S.N.: XPERANTO: Publishing object-relational data as XML. In: Suciu, D., Vossen, G. (eds.) WebDB 2000. LNCS, vol. 1997, Springer, Heidelberg (2001)
Carey, M.J., Kiernan, J., Shanmugasundaram, J., Shekita, E.J., Subramanian, S.N.: XPERANTO: Middleware for publishing object- relational data as XML documents. In: VLDB (2000)
Chamberlin, D., Florescu, D., Robie, J.: XQuery Update. W3C working draft, http://www.w3.org/TR/xqupdate/
Chaudhuri, S., Kaushik, R., Naughton, J.F.: On relational support for XML publishing: Beyond sorting and tagging. In: SIGMOD (2003)
Choi, B., Cong, G., Fan, W., Viglas, S.: Updating recursive xml views of relations. In: ICDE, pp. 766–775 (2007)
Cong, G., Fan, W., Kementsietsidis, A.: Distributed query evaluation with performance guarantees. In: SIGMOD Conference, pp. 509–520 (2007)
Cosmadakis, S.S., Papadimitriou, C.H.: Updates of relational views. In: PODS (1983)
Dayal, U., Bernstein, P.A.: On the correct translation of update operations on relational views. TODS 7(3) (1982)
DeHaan, D., Toman, D., Consens, M.P., Özsu, M.T.: A comprehensive xquery to sql translation using dynamic interval encoding. In: SIGMOD Conference, pp. 623–634. ACM Press, New York (2003)
Deutsch, A., Fernandez, M., Suciu, D.: Storing semistructured data with stored. In: SIGMOD Conference, pp. 431–442. ACM Press, New York (1999)
Fan, W., Chan, C.Y., Garofalakis, M.: Secure XML querying with security views. In: SIGMOD (2004)
Fan, W., Cong, G., Bohannon, P.: Querying xml with update syntax. In: SIGMOD Conference, pp. 293–304 (2007)
Fernandez, M.F., Kadiyska, Y., Suciu, D., Morishima, A., Tan, W.C.: SilkRoute: A framework for publishing relational data in XML. TODS 27(4), 438–493 (2002)
Fernandez, M.F., Morishima, A., Dan Suciu: Efficient evaluation of XML middleware queries. In: SIGMOD (2001)
Ghelli, G., Christopher, R., Simon, J.: XQuery!: an XML query language with side effects. In: Ioannidis, Y., Scholl, M.H., Schmidt, J.W., Matthes, F., Hatzopoulos, M., Boehm, K., Kemper, A., Grust, T., Boehm, C. (eds.) EDBT 2006. LNCS, vol. 3896, Springer, Heidelberg (2006)
IBM: IBM DB2 Extender Reference, ftp://ftp.software.ibm.com/ps/products/db2/info/vr82/pdf/enUS/db2sxe81.pdf
IBM: IBM DB2 Universal Database SQL Reference
Jain, S., Mahajan, R., Suciu, D.: Translating xslt programs to efficient sql queries. In: WWW 2002 (2002)
Kamps, J., Marx, M., de Rijke, M., Sigurbjörnsson, B.: Structured queries in xml retrieval. In: CIKM, pp. 4–11. ACM Press, New York (2005)
Keller, A.: Algorithms for translating view updates to database updates for views involving selections, projections, and joins. In: PODS (1985)
Krishnamurthy, R., Kaushik, R., Naughton, J.: XML-SQL query translation literature: The state of the art and open problems. In: Bellahsène, Z., Chaudhri, A.B., Rahm, E., Rys, M., Unland, R. (eds.) Database and XML Technologies. LNCS, vol. 2824, Springer, Heidelberg (2003)
Laux, A., Martin, L.: XUpdate - XML Update Language (2000), http://www.xmldb.org/xupdate/xupdate-wd.html
Lechtenborger, J., Vossen, G.: On the computation of relational view complements. TODS 28(2), 175–208 (2003)
Lehti, P.: Design and implementation of a data manipulation processor for an XML query processor. Technical report, Technical University of Darmstadt, Diplomarbeit (2001)
Li, C., Bohannon, P., Narayan, P.P.S.: Composing xsl transformations with xml publishing views. In: SIGMOD 2003: Proceedings of the 2003 ACM SIGMOD international conference on Management of data, pp. 515–526. ACM Press, New York (2003)
Li, H., Lee, M.L., Hsu, W., Cong, G.: An estimation system for xpath expressions. In: ICDE conference, p. 54. IEEE Computer Society, Washington, DC (2006)
Li, Q., Moon, B.: Indexing and Querying XML Data for Regular Path Expressions. In: 27th International Conference on Very Large Data Bases (2001)
McHugh, J., Widom, J.: Query Optimization for XML. In: 25th International Conference on Very Large Data Bases (1999)
Oracle. SQL Reference
Oracle XML DB: Oracle Database 10g R1 XML DB Technical Whitepaper. http://download-uk.oracle.com/technology/tech/xml/xmldb/current/twp.pdf
Polyzotis, N., Garofalakis, M.N.: Structure and Value Synopses for XML Data Graphs. In: 28th International Conference on Very Large Data Bases (2002)
Rys, M.: Proposal for an XML data modification language. Microsoft (2002)
SQL server: MSDN Library
Tatarinov, I., Ives, Z.G., Halevy, A.Y., Weld, D.S.: Updating XML. In: SIGMOD (2001)
Theobald, M., Schenkel, R., Weikum, G.: An efficient and versatile query engine for topx search. In: VLDB, pp. 625–636 (2005)
Wang, L., Mulchandani, M., Rundensteiner, E.: Updating XQuery Views Published over Relational Data: A Round-trip Case Study. In: Xsym (2003)
Wang, L., Rundensteiner, E.A.: Updating XML views published over relational databases: Towards the existence of a correct update mapping. Technical Report, Worcester Polytechnic Institute (2004)
Wang, L., Rundensteiner, E.A., Mani, M.: Ufilter: A lightweight XML view update checker. In: ICDE (2006)
Wang, L., Rundensteiner, E.A., Mani, M.: Updating XML views published over relational databases: Towards the existence of a correct update mapping. DKE (to appear)
Wu, Y., Patel, J.M., Jagadish, H.V.: Estimating Answer Sizes for XML Queries. In: 8th International Conference on Extending Database Technology (2002)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2007 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Cong, G. (2007). Query and Update Through XML Views. In: Bhalla, S. (eds) Databases in Networked Information Systems. DNIS 2007. Lecture Notes in Computer Science, vol 4777. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-75512-8_7
Download citation
DOI: https://doi.org/10.1007/978-3-540-75512-8_7
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-75511-1
Online ISBN: 978-3-540-75512-8
eBook Packages: Computer ScienceComputer Science (R0)