Skip to main content
SpringerLink
Log in
Book cover

International Workshop on Databases in Networked Information Systems

DNIS 2007: Databases in Networked Information Systems pp 81–95Cite as

Query and Update Through XML Views

  • Conference paper

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 4777))

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.

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 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)

    Article  MATH  Google Scholar 

  2. Amer-Yahia, S., Curtmola, E., Deutsch, A.: Flexible and efficient xml search with complex full-text predicates. In: SIGMOD Conference, pp. 575–586 (2006)

    Google Scholar 

  3. 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)

    Google Scholar 

  4. 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)

    Google Scholar 

  5. Buneman, P., Khanna, S., Tan, W.: On propagation of deletions and annotations through views. In: PODS (2002)

    Google Scholar 

  6. Buneman, P., Cong, G., Fan, W., Kementsietsidis, A.: Using partial evaluation in distributed query evaluation. In: VLDB (2006)

    Google Scholar 

  7. 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)

    Google Scholar 

  8. 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)

    Google Scholar 

  9. Chamberlin, D., Florescu, D., Robie, J.: XQuery Update. W3C working draft, http://www.w3.org/TR/xqupdate/

  10. Chaudhuri, S., Kaushik, R., Naughton, J.F.: On relational support for XML publishing: Beyond sorting and tagging. In: SIGMOD (2003)

    Google Scholar 

  11. Choi, B., Cong, G., Fan, W., Viglas, S.: Updating recursive xml views of relations. In: ICDE, pp. 766–775 (2007)

    Google Scholar 

  12. Cong, G., Fan, W., Kementsietsidis, A.: Distributed query evaluation with performance guarantees. In: SIGMOD Conference, pp. 509–520 (2007)

    Google Scholar 

  13. Cosmadakis, S.S., Papadimitriou, C.H.: Updates of relational views. In: PODS (1983)

    Google Scholar 

  14. Dayal, U., Bernstein, P.A.: On the correct translation of update operations on relational views. TODS 7(3) (1982)

    Google Scholar 

  15. 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)

    Google Scholar 

  16. Deutsch, A., Fernandez, M., Suciu, D.: Storing semistructured data with stored. In: SIGMOD Conference, pp. 431–442. ACM Press, New York (1999)

    Chapter  Google Scholar 

  17. Fan, W., Chan, C.Y., Garofalakis, M.: Secure XML querying with security views. In: SIGMOD (2004)

    Google Scholar 

  18. Fan, W., Cong, G., Bohannon, P.: Querying xml with update syntax. In: SIGMOD Conference, pp. 293–304 (2007)

    Google Scholar 

  19. 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)

    Article  Google Scholar 

  20. Fernandez, M.F., Morishima, A., Dan Suciu: Efficient evaluation of XML middleware queries. In: SIGMOD (2001)

    Google Scholar 

  21. 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)

    Google Scholar 

  22. IBM: IBM DB2 Extender Reference, ftp://ftp.software.ibm.com/ps/products/db2/info/vr82/pdf/enUS/db2sxe81.pdf

  23. IBM: IBM DB2 Universal Database SQL Reference

    Google Scholar 

  24. Jain, S., Mahajan, R., Suciu, D.: Translating xslt programs to efficient sql queries. In: WWW 2002 (2002)

    Google Scholar 

  25. 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)

    Chapter  Google Scholar 

  26. Keller, A.: Algorithms for translating view updates to database updates for views involving selections, projections, and joins. In: PODS (1985)

    Google Scholar 

  27. 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)

    Google Scholar 

  28. Laux, A., Martin, L.: XUpdate - XML Update Language (2000), http://www.xmldb.org/xupdate/xupdate-wd.html

  29. Lechtenborger, J., Vossen, G.: On the computation of relational view complements. TODS 28(2), 175–208 (2003)

    Article  Google Scholar 

  30. Lehti, P.: Design and implementation of a data manipulation processor for an XML query processor. Technical report, Technical University of Darmstadt, Diplomarbeit (2001)

    Google Scholar 

  31. 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)

    Chapter  Google Scholar 

  32. 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)

    Google Scholar 

  33. Li, Q., Moon, B.: Indexing and Querying XML Data for Regular Path Expressions. In: 27th International Conference on Very Large Data Bases (2001)

    Google Scholar 

  34. McHugh, J., Widom, J.: Query Optimization for XML. In: 25th International Conference on Very Large Data Bases (1999)

    Google Scholar 

  35. Oracle. SQL Reference

    Google Scholar 

  36. Oracle XML DB: Oracle Database 10g R1 XML DB Technical Whitepaper. http://download-uk.oracle.com/technology/tech/xml/xmldb/current/twp.pdf

  37. Polyzotis, N., Garofalakis, M.N.: Structure and Value Synopses for XML Data Graphs. In: 28th International Conference on Very Large Data Bases (2002)

    Google Scholar 

  38. Rys, M.: Proposal for an XML data modification language. Microsoft (2002)

    Google Scholar 

  39. SQL server: MSDN Library

    Google Scholar 

  40. Tatarinov, I., Ives, Z.G., Halevy, A.Y., Weld, D.S.: Updating XML. In: SIGMOD (2001)

    Google Scholar 

  41. Theobald, M., Schenkel, R., Weikum, G.: An efficient and versatile query engine for topx search. In: VLDB, pp. 625–636 (2005)

    Google Scholar 

  42. Wang, L., Mulchandani, M., Rundensteiner, E.: Updating XQuery Views Published over Relational Data: A Round-trip Case Study. In: Xsym (2003)

    Google Scholar 

  43. 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)

    Google Scholar 

  44. Wang, L., Rundensteiner, E.A., Mani, M.: Ufilter: A lightweight XML view update checker. In: ICDE (2006)

    Google Scholar 

  45. 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)

    Google Scholar 

  46. Wu, Y., Patel, J.M., Jagadish, H.V.: Estimating Answer Sizes for XML Queries. In: 8th International Conference on Extending Database Technology (2002)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Microsoft Research Asia,  

    Gao Cong

Authors
  1. Gao Cong
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Subhash Bhalla

Rights and permissions

Reprints 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)

Publish with us

Policies and ethics

Search

Navigation