Skip to main content
SpringerLink
Log in

Updating Recursive XML Views of Relations

  • Regular Paper
  • Published:
Journal of Computer Science and Technology Aims and scope Submit manuscript

Abstract

This paper investigates the view update problem for XML views published from relational data. We consider XML views defined in terms of mappings directed by possibly recursive DTDs compressed into DAGs and stored in relations. We provide new techniques to efficiently support XML view updates specified in terms of XPath expressions with recursion and complex filters. The interaction between XPath recursion and DAG compression of XML views makes the analysis of the XML view update problem rather intriguing. Furthermore, many issues are still open even for relational view updates, and need to be explored. In response to these, on the XML side, we revise the notion of side effects and update semantics based on the semantics of XML views, and present effecient algorithms to translate XML updates to relational view updates. On the relational side, we propose a mild condition on SPJ views, and show that under this condition the analysis of deletions on relational views becomes PTIME while the insertion analysis is NP-complete. We develop an efficient algorithm to process relational view deletions, and a heuristic algorithm to handle view insertions. Finally, we present an experimental study to verify the effectiveness of our techniques.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

References

  1. Stavros S Cosmadakis, Christos H Papadimitriou. Updates of relational views. Journal of ACM, 1984, 31(4): 742–760.

    Article  MATH  MathSciNet  Google Scholar 

  2. Umeshwar Dayal, Philip A Bernstein. On the correct translation of update operations on relational views. ACM Transactions on Database Systems (TODS), 1982, 7(3): 381–416.

    Article  MATH  MathSciNet  Google Scholar 

  3. Arthur Keller. Algorithms for translating view updates to database updates for views involving selections, projections, and joins. In Proc. the fourth ACM SIGACT-SIGMOD Symposium on Principles of Database Systems (PODS), Portland, Oregon, USA, 1985, pp.154–163.

  4. Jens Lechtenborger, Gottfried Vossen. On the computation of relational view complements. ACM Transactions on Database Systems (TODS), 2003, 28(2): 175–208.

    Article  Google Scholar 

  5. IBM DB2 universal database SQL reference. IBM. www306.ibm.com/software/data/db2/.

  6. SQL reference. Oracle. www.oracle.com/technology/documentation/.

  7. SQL server. MSDN Library. msdn.microsoft.com/enus/sqlserver/.

  8. Philip Bohannon, Byron Choi, Wenfei Fan. Incremental evaluation of schema-directed XML publishing. In Proc. the 2004 ACM SIGMOD International Conference on Management of Data (SIGMOD), Paris, France, 2004, pp.503–514.

  9. Michael J Carey, Jerry Kiernan, Jayavel Shanmugasundaram, Eugene J Shekita, Subbu N Subramanian. XPERANTO: Middleware for publishing object-relational data as XML documents. In Proc. the 26th International Conference on Very Large Data Bases (VLDB), Cairo, Egypt, 2000, pp.646–648.

  10. Mary F Fernandez, Atsuyuki Morishima, Dan Suciu. Efficient evaluation of XML middleware queries. In Proc. the 2001 ACM SIGMOD International Conference on Management of Data (SIGMOD), Santa Barbara, CA, USA, 2001, pp.103–114.

  11. Vanessa P Braganholo, Susan B Davidson, Carlos A Heuser. From XML view updates to relational view updates: Old solutions to a new problem. In Proc. the Thirtieth International Conference on Very Large Data Bases (VLDB), Toronto, Canada, 2004, pp.276–287.

  12. L Wang, E A Rundensteiner, Murali Mani. UFilter: A lightweight XML view update checker. In Proc. the 22nd International Conference on Data Engineering (ICDE), Atlanta, USA, 2006, p.126.

  13. L Wang, E A Rundensteiner, Murali Mani. Updating XML view published over relational databases: Towards the existence of a correct update mapping. Data and Knowledge Engineering (DKE), 2006, 58(3): 263–298.

    Article  Google Scholar 

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

  15. Sur G, Hammer J, Siméon J. An XQuery-based language for processing updates in XML. In Proc. Programming Language Technologies for XML (PLAN-X), Venice, Italy, 2004.

  16. Byron Choi. What are real DTDs like. In Proc. the Fifth International Workshop on the Web and Databases (Webdb), Madison, Wisconsin, USA, 2002, pp.43–48.

  17. Rajasekar Krishnamurthy, Raghav Kaushik, Jefferey Naughton. XML-SQL query translation literature: The state of the art and open problems. In Proc. Database and XML Technologies, First International XML Database Symposium (XSym), Berlin, Germany, 2003, pp.1–18.

  18. Buneman P, Khanna S, Tan W. On propagation of deletions and annotations through views. In Proc. the Twenty-First ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems (PODS), Wisconsin, USA, 2002, pp.150–158.

  19. Byron Choi, Gao Cong, Wenfei Fan, Stratis Viglas. Updating recursive XML views of relations. In Proc. the 23nd International Conference on Data Engineering (ICDE), Istanbul, Turkey, 2007, pp.766–775.

  20. Michael Benedikt, Chee Yong Chan, Weifei Fan, Rajeev Rastogi, Shihui Zheng, Aoying Zhou. DTD-directed publishing with attribute translation grammars. In Proc, the 28th International Conference on Very Large Data Bases (VLDB), Hong Kong, China, 2002, pp.838–849.

  21. Jayavel Shanmugasundaram, Kristin Tufte, Chun Zhang, Gang He, David J DeWitt, Jefferey F Naughton. Relational databases for querying XML documents: Limitations and opportunities. In Proc. 25th International Conference on Very Large Data Bases (VLDB), Edinburgh, Scotland, UK, 1999, pp.302–314.

  22. Cormen T H, Leiserson C E, Rivest R L, Stein C. Introduction to Algorithms. McGraw-Hill, 2001.

  23. Li Chen, Amarnath Gupta, M Erdem Kurul. Stack-based algorithms for pattern matching on DAGs. In Proc. the 31st International Conference on Very Large Data Bases (VLDB), Trondheim, Norway, 2005, pp.493–504.

  24. Ralf Schenkel, Anja Theobald, Gerhard Weikum. Efficient creation and incremental maintenance of the HOPI index for complex XML document collections. In Proc. the 21st International Conference on Data Engineering (ICDE), Tokyo, Japan, 2005, pp.360–371.

  25. Christoph Koch. Efficient processing of expressive nodeselecting queries on XML data in secondary storage: A tree automata-based approach. In Proc. the 29th International Conference on Very Large Data Bases (VLDB), Berlin, Germany, 2003, pp.249–260.

  26. Italiano G F. Finding paths and deleting edges in directed acyclic graphs. Inf. Process. Lett., 1988, 28.

  27. King V, Sagert G. A fully dynamic algorithm for maintaining the transitive closure. In Proc. ACM Symposium on Theory of Computing, 1999.

  28. Alberto Marchetti-Spaccamela, Umberto Nanni, Hans Rohnert. Maintaining a topological order under edge insertions. Information Processing Letters, 1996, 59(1): 53–58.

    Article  MATH  MathSciNet  Google Scholar 

  29. Michael Garey, David Johnson. Computers and Intractability: A Guide to the Theory of NP-Completeness. 1979.

  30. Bart Selman, Henry Kautz. Walksat Home Page. 2004. http://www.cs.washington.edu/homes/kautz/walksat/.

  31. Elias Koutsoupias, Christos H Papadimitriou. On the greedy algorithm for satisfiability. Information Processing Letters, 1992, 43(1): 53–55.

    Article  MATH  MathSciNet  Google Scholar 

  32. Wang L, Mulchandani M, Rundensteiner E. Updating XQuery views published over relational data: A round-trip case study. In Proc. XML Database Symposium, 2003, pp.223–237.

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

  34. Yingwei Cui, Jennifer Widom. Run-time translation of view tuple deletions using data lineage. Technical Report, Stanford University, 2001.

  35. Gao Cong, Wenfei Fan, Floris Geerts. Annotation propagation revisited for key preserving views. In Proc. the 15th ACM International Conference on Information and Knowledge Management, Arlington, Virginia, USA, 2006, pp.632–641.

  36. Cohen E, Kaplan H, Milo T. Labeling dynamic XML tree. In Proc. the Twenty-First ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems (PODS), Madison, Wisconsin, USA, 2002, pp.271–281.

Download references

Author information

Authors and Affiliations

  1. Division of Information System, School of Computer Engineering, Nanyang Technological University, 639798, Singapore, Singapore

    Byron Choi

  2. Microsoft Research Asia, Beijing, 100080, China

    Gao Cong

  3. Bell Laboratories, Murray Hill, NJ07974-0636, U.S.A.

    Wenfei Fan

  4. University of Edinburgh, Edinburgh, EH8 9LE, Scotland, U.K.

    Byron Choi, Gao Cong, Wenfei Fan & Stratis D. Viglas

Authors
  1. Byron Choi
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Gao Cong
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Wenfei Fan
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Stratis D. Viglas
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Byron Choi.

Additional information

Wenfei Fan is supported in part by EPSRC under Grants No. GR/S63205/01, No. GR/T27433/01, and No. EP/E029213/1.

Electronic supplementary material

Below is the link to the electronic supplementary material.

(PDF 132 kb)

Rights and permissions

Reprints and permissions

About this article

Cite this article

Choi, B., Cong, G., Fan, W. et al. Updating Recursive XML Views of Relations. J. Comput. Sci. Technol. 23, 516–537 (2008). https://doi.org/10.1007/s11390-008-9150-y

Download citation

  • Received:

  • Revised:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s11390-008-9150-y

Keywords

Search

Navigation