PATAXÓ: A framework to allow updates through XML views

ACM Transactions on Database Systems

Volumn 31, Issue 3, 2006, Pages 839-886

  Braganholo, Vanessa P ^a   Davidson, Susan B ^b,d   Heuser, Carlos A ^c  

^a FEDERAL UNIVERSITY OF RIO DE JANEIRO   (Brazil)

^b UNIVERSITY OF PENNSYLVANIA   (United States)

^c FEDERAL UNIVERSITY OF RIO GRANDE DO SUL   (Brazil)

^d UNIVERSITY OF PENNSYLVANIA   (United States)

Author keywords

Relational databases; Updates; XML views

Indexed keywords

RELATIONAL DATABASES; XML VIEWS;

DATA TRANSFER; DATABASE SYSTEMS; PROBLEM SOLVING; QUERY LANGUAGES; SET THEORY;

XML;

EID: 33750196409     PISSN: 03625915     EISSN: 03625915     Source Type: Journal    
DOI: 10.1145/1166074.1166078     Document Type: Conference Paper

References (52)

1. ABITEBOUL, S., QUASS, D., MCHUGH, J., WIDOM, J., AND WIENER, J. 1997. The Lorel query language for semistructured data. Internat. J. Dig. Lib. 1, 1, 68-88.
2. APACHE SOFTWARE FOUNDATION. 2002. Apache Xindice. Available online at: 〈http://xml.apache.org/xindice〉.
3. BANCILHON, F. AND SPYRATOS, N. 1981. Update semantics of relational views. ACM Trans. Database Syst. 6, 4 (Dec.), 557-575.
4. BARU, C., GUPTA, A., LUDAESHER, B., MARCIANO, R., PAPAKONSTANTINOU, Y., PAVEL, V., AND CHU, V. 1999. XML-based information mediation with mix. In Proceedings of SIGMOD (Philadelphia, PA). 597-599.
5. BOAG, S., CHAMBERLIN, D., FERNANDEZ, M. F., FLORESCU, D., ROBIE, J., AND SIMÉON, J. 2005. XQuery 1.0: An XML query language. W3C Working Draft. Available online at: www.w3.org.
6. BOHANNON, P., GANGULY, S., KORTH, H., NARAYAN, P., AND SHENOY, P. 2002. Optimizing view queries in ROLEX to support navigable result trees. In Proceedings of VLDB (Hong Kong, China).
7. BONIFATI, A., BRAGA, D., CAMPI, A., AND CERI, S. 2002. Active XQuery. In Proceedings of ICDE (San Jose, CA).
8. BORKAR, V. AND CAREY, M. 2004. Extending XQuery for grouping, duplicate elimination, and outer joins. In Proceedings of the XML 2004 Conference and Exibition (Washington, D.C.). 1-11.
9. BRAGANHOLO, V. 2004. From XML to relational view updates: Applying old solutions to solve a new problem. Ph.D. dissertation. UFRGS, Porto Alegre, RS, Brazil.
10. BRAGANHOLO, V., DAVIDSON, S. B., AND HEUSER, C. A. 2003a. On the updatability of XML views over relational databases. In Proceedings of WebDB (San Diego, CA).
11. BRAGANHOLO, V., DAVIDSON, S. B., AND HEUSER, C. A. 2003b. UXQuery: Building updatable XML views over relational databases. In Simp*sio Brasileiro de Banco de Dados, SBBD. Belo Horizonte: Departamento de Ciëncia da Computaó/UFMG, Manaus, AM, Brasil. 26-40.
12. BRAGANHOLO, V., DAVIDSON, S. B., AND HEUSER, C. A. 2004. From XML view updates to relational view updates: Old solutions to a new problem. In Proceedings of VLDB (Toronto, Canada). 276-287.
13. BRAY, T., HOLLANDER, D., AND LAYMAN, A. 1999. Namespaces in XML. W3C Recomendation. Available online at www.w3.org.
14. BRAY, T., PAOLI, J., SPEHBERG-MCQUEEN, C. M., MALER, E., AND YERGEAU, F. 2004. Extensible markup language (XML) 1.0 (third edition). W3C Recommendation. W3C Recommendation. Available online at www.w3.org.
15. BUNEMAN, P., KHANNA, S., AND TAN, W. C. 2001. Why and where: A characterization of data provenance. In ICDT, J. V. den Bussche and V. Vianu, Eds. Lecture Notes in Computer Science, vol. 1973. Springer, London, U.K. 316-330.
16. CAREY, M. J., HAAS, L. M., SCHWARZ, P. M., ARYA, M., CODY, W. F., FAGIN, R., FLICKNER, M., LUNIEWSKI, A. W., NIBLACK, W., PETKOVIC, D., THOMAS, J., WILLIAMS, J., AND WIMMERS, E. L. 1995. Towards heterogeneous multimedia information systems: The garlic approach. In Proceedings of RIDE: Distributed Object Management (Taipei, Taiwan). 124-131.
17. CHAMBERLIN, D., FANKHAUSER, P., FLORESCU, D., MARCHIORI, M., AND ROBIE, J. 2005. XML query use cases. W3C Working Draft. Available online at www.w3.org.
18. CHAUDHURI, S., KAUSHIK, R., AND NAUGHTON, J. 2003. On relational support for XML publishing: Beyond sorting and tagging. In Proceedings of SIGMOD (San Diego, CA).
19. CHENG, J. AND XU, J. 2000. XML and DB2. In Proceedings of ICDE (San Diego, CA).
20. CLARK, J. AND DEROSE, S. 1999. XML path language (XPath) version 1.0. W3C Recomendation. Available online at www.w3.org.
21. CONRAD, A. 2001a. Interactive microsoft SQL Server & XML online tutorial. Available online at 〈www.topxml.com/tutorials/main.asp?id= sqlxml〉.
22. CONRAD, A. 2001b. A survey of Microsoft SQL Server 2000 XML features. MSDN Library. Available online at http://msdn.microsoft.com/library/en-us/ dnexxml/html/xm107162001.asp.
23. CUI, Y. AND WIDOM, J. 2000. Practical lineage tracing in data warehouses. In Proceedings of ICDE (San Diego, CA). 367-378.
24. DAYAL, U. AND BERNSTEIN, P. A. 1982. On the correct translation of update operations on relational views. ACM Trans. Database Syst. 8, 2 (Sept.), 381-416.
25. DEUTSCH, A., PAPAKONSTANTINOU, Y., AND XU, Y 2004a. Minimization and group-by detection for nested XQueries. In Proceedings of ICDE (Boston, MA). 839.
26. DEUTSCH, A., PAPAKONSTANTINOU, Y., AND XU, Y. 2004b. The NEXT framework for logical XQuery optimization. In Proceedings of VLDB (Toronto, Ont., Canada). 168-179.
27. DRAPER, D., FANKHAUSER, P., FERNNDEZ, M., MALHOTRA, A., ROSE, K., RYS, M., SIMON, J., AND WADLER, P. 2005. XQuery 1.0 and XPath 2.0 formal semantics. W3C Working Draft. Available online at www.w3.org.
28. EISENBERG, A. AND MELTON, J. 2002. SQL/XML is making good progress. SIGMOD Rec. 31, 2, 101-108.
29. FERNNDEZ, M., KADIYSKA, Y., SUCIU, D., MORISHIMA, A., AND TAN, W.-C. 2002. Silkroute: A framework for publishing relational data in XML. ACM Trans. Database Syst. 27, 4 (Dec.), 438-493.
30. GARCIA-MOLINA, H., PAPAKONSTANTINOU, Y., QUASS, D., RAJARAMAN, A., SAGIV, Y., ULLMAN, J., VASSALOS, V., AND WIDOM, J. 1997. The tsimmis approach to mediation: Data models and languages. J. Intell. Informat. Syst. 8, 2, 117-132.
31. INTELLIGENT SYSTEM RESEARCH. 2001. Odbc2xml: Merging ODBC data into xml documents. Available online at www.intsysr.com/odbc2xml.htm.
32. JAGADISH, H. V., AL-KHALIFA, S., CHAPMAN, A., LAKSHMANAN, L. V., NIERMAN, A., PAPARIZOS, S., PATEL, J. M., SRIVASTAVA, D., WIWATWATTANA, N., WU, Y., AND YU, C. 2002. TIMBER: A native XML database. VLDB J. 11, 4, 274-291.
33. KAY, M. 2001. Saxon XSLT and XQuery processor. Available online at http://sourceforge.net/projects/saxon.
34. KAY, M. 2005. XSL Transformations (XSLT) Version 2.0. W3C Working Draft. Available online at www.w3.org.
35. KELLER, A. M. 1985. Algorithms for translating view updates to database updates for views involving selections, projections, and joins. In Proceedings of PODS (Portland, OR.). 154-163.
36. KITTIVORAVITKUL, S. AND MCBRIEN, P. 2005. Integrating unnormalised semi-structured data sources. In Proceedings of CAiSE (Porto, Portugal). 460-474.
37. LAUX, A. AND MARTIN, L. 2000. XUpdate WD. XML: DB Working Draft. Available online at http://xmldb-org.sourceforge.net/xupdate/xupdate-wd.html.
38. LECHTENBÖRGER, J. 2003. The impact of the constant complement approach towards view updating. In Proceedings of PODS (San Diego, CA). 49-55.
39. MALHOTRA, A., MELTON, J., AND WALSH, N. 2005. XQuery 1.0 andXPath 2.0 functions and operators. W3C Working Draft. Available online at www.w3.org.
40. MAY, W. 1999. Information extraction and integration with florid: The Mondial case study. Tech. rep. 131. Institut für Informatik, Universität Freiburg, Freiburg, Germany. Available online at http://dbis.informatik.uni-goettingen.de/Mondial/.
41. MELLO, R. S. AND HEUSER, C. 2005. BInXS: A process for integration of XML Schemata. In Proceedings of CAiSE (Porto, Portugal). 151-166.
42. SCHÖNING, H. 2001. Tamino - a DBMS designed for XML. In Proceedings of ICDE. 149-154.
43. SHANMUGASUNDARAM, J., KIERNAN, J., SHEKITA, E., FAN, C., AND FUNDERBURK, J. 2001. Querying XML views of relational data. In Proceedings of VLDB (Rome, Italy).
44. SHANMUGASUNDARAM, J., SHEKITA, E. J., BARR, R., CAREY, M. J., LINDSAY, B. G., PIRAHESH, H., AND REINWALD, B. 2000. Efficiently publishing relational data as XML documents. In Proceedings of VLDB (Cairo, Egypt). 65-76.
45. SOFTWARE AG. 2002. Tamino XML server. Available online at www.softwareag.com/tamino/details.htm.
46. TATARINOV, I., IVES, Z., HALEVY, A., AND WELD, D. 2001. Updating XML. In Proceedings of SIGMOD (Santa Barbara, CA).
47. TATARINOV, I., VIGLAS, E., BEYER, K., SHANMUGASUNDARAM, J., AND SHEKITA, E. 2002. Storing and querying ordered XML using a relational database system. In Proceedings of SIGMOD (Madison, WI).
48. TUCHERMAN, L., FURTADO, A. L., AND CASANOVA, M. A. 1983. A pragmatic approach to structured database design. In Proceedings of VLDB (Florence, Italy). 219-231.
49. TURAU, V. 2001. Db2xml 1.4: Transforming relational databases into XML documents. Available online at www.informatik.fh-wiesbaden.de/~turau/DB2XML.
50. ULLMAN, J. D. AND WIDOM, J. 1997. A First Course in Database Systems. Prentice Hall, Englewood Cliffs, NJ.
51. WANG, L., MULCHANDANI, M., AND RUNDENSTEINER, E. A. 2003. Updating XQuery views published over relational data: A round-trip case study. In Proceedings of XML Database Symposium (Berlin, Germany).
52. WANG, L. AND RUNDENSTEINER, E. A. 2004. On the updatability of XML views published over relational data. In Proceedings of ER (Shanghai, China).