A comprehensive solution to the XML-to-relational mapping problem

Proceedings of the Interntational Workshop on Web Information and Data Management

Volumn , Issue , 2004, Pages 31-38

  Amer Yahia, Sihem ^a   Du, Fang ^b   Freire, Juliana ^b,c  

^a AT AND T LABS RESEARCH   (United States)

^b OREGON HEALTH AND SCIENCE UNIVERSITY   (United States)

^c Department of Electrical and Computer Engineering   (United States)

Author keywords

Mapping techniques; Relational Databases; XML Shredding; XML Storage

Indexed keywords

COMPUTER PROGRAMMING LANGUAGES; DATA STORAGE EQUIPMENT; MAPPING; QUERY LANGUAGES; WEBSITES; XML;

MAPPING TECHNIQUES; RELATIONAL TABLES; XML SHREDDING; XML STORAGE;

RELATIONAL DATABASE SYSTEMS;

EID: 18744377500     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1031453.1031461     Document Type: Conference Paper

References (26)

1. S. Amer-Yahia, F. Du, and J. Freire. A generic and flexible framework for mapping XML documents into relations. Technical report, OGI/OHSU, 2004.
2. D. Barbosa, J. Freire, and A. Mendelzon. Information preservation in XML-to-relational mappings. In Proceedings of the International XML Database Symposium (XSym), pages 66-81, 2004.
3. S. Boag, D. Chamberlin, M. Fernández, D. Florescu, J. Robie, and J. Siméon. XQuery 1.0: An XML query language. W3C Working Draft, July 2004.
4. P. Bohannon, J. Freire, P. Roy, and J. Siméon. From XML schema to relations: A cost-based approach to XML storage. In Proceedings of the International Conference on Data Engineering (ICDE), pages 64-75, 2002.
5. Y. Chen, S. Davidson, C. Hara, and Y. Zheng. RRXS: Redundancy reducing XML storage in relations. In Proceedings of the International Conference on Very Large Data Bases (VLDB), 2003.
6. Y. Chen, S. B. Davidson, and Y. Zheng. Constraints preserving schema mapping from XML to relations. In Proceedings of the Workshop on Web and Databases (WebDB), pages 7-12, 2002.
7. S. Davidson, W. Fan, C. Hara, and J. Qin. Propagating XML constraints to relations. In Proceedings of the International Conference on Data Engineering (ICDE), 2003.
8. D. DeHaan, D. Toman, M. P. Consens, and M. T. Ozsu. A comprehensive XQuery to SQL translation using dynamic interval coding. In Proceedings of the ACM SIGMOD International Conference on Management of Data, 2003.
9. A. Deutsch, M. Fernandez, and D. Suciu. Storing semi-structured data with STORED. In Proceedings of the ACM SIGMOD International Conference on Management of Data, pages 431-442, 1999.
10. The Dewey Decimal Classification system. http://www.oclc.org/dewey.
11. F. Du, S. Amer-Yahia, and J. Freire. ShreX: Managing XML documents in relational databases. In Proceedings of the International Conference on Very Large Data Bases (VLDB), 2004.
12. D. Florescu and D. Kossman. Storing and querying XML data using an RDMBS. IEEE Data Engineering Bulletin, 22(3):27-34, 1999.
13. IBM DB2 XML Extender, http://www4.ibm.com/software/data/db2/extenders/ xmlext.html.
14. M. Klettke and H. Meyer. XML and object-relational database systems - enhancing structural mappings based on statistics. In Proceedings of the Workshop on Web and Databases (WebDB), pages 63-68, 2000.
15. R. Krishnamurthy, R. Kaushik, and J. F. Naughton. XML-SQL query translation literature: The state of the art and open problems. In Proceedings of the International XML Database Symposium (XSym), 2003.
16. D. Lee and W. W. Chu. Constraints-preserving transformation from XML document type definition to relational schema. In International Conference on Conceptual Modeling (ER), 2000.
17. Microsoft support for XML. http://msdn.microsoft.com/sqlxml.
18. M. Ramanath, J. Freire, J. Haritsa, and P. Roy. Searching for efficient XML-to-relational mappings. In Proceedings of the International XML Database Symposium (XSym), 2003.
19. K. Runapongsa and J. M. Patel. Storing and querying XML data in object-relational DBMSs. In Proceedings of the International Conference on Extending Database Technology (EDBT), 2002.
20. A. Schmidt, M. Kersten, M. Windhouwer, and F. Waas. Efficient relational storage and retrieval of XML documents. In Proceedings of the Workshop on Web and Databases (WebDB), pages 47-52, 2000.
21. J. Shanmugasundaram, K. Tufte, G. He, C. Zhang, D. DeWitt, and J. Naughton. Relational databases for querying XML documents: Limitations and opportunities. In Proceedings of the International Conference on Very Large Data Bases (VLDB), pages 302-314, 1999.
22. I. Tatarinov, S. Viglas, K. Beyer, J. S. m, E. Shekita, and C. Zhang. Storing and querying ordered XML using a relational database system. In Proceedings of the ACM SIGMOD International Conference on Management of Data, pages 204-215, 2002.
23. Xerces Java parser 1.4.3. http://xml.apache.org/xerces-j.
24. XSL transformations (XSLT). http://www.w3.org/TR/xslt.
25. B. B. Yao, M. T. Özsu, and N. Khandelwal. XBench benchmark and performance testing of XML DBMSs. In Proceedings of the International Conference on Data Engineering (ICDE), pages 621-632, 2004.
26. M. Yoshikawa, T. Amagasa, T. Shimura, and S. Uemura. XRel: a path-based approach to storage and retrieval of XML documents using relational databases. In ACM Transactions on Internet Technology, pages 110-141, 2001.