Representing Multiple Mappings between XML and Relational Schemas for Bi-directional Query Translation

Authors:
Ya-Hui Chang;Chia-Zhen Lee
Affiliations:
Department of Computer Science, National Taiwan Ocean University,;Department of Computer Science, National Taiwan Ocean University,
Venue:
APWeb/WAIM '09 Proceedings of the Joint International Conferences on Advances in Data and Web Management
Year:
2009

Citing 8
Cited 1

XClust: clustering XML schemas for effective integration

Proceedings of the eleventh international conference on Information and knowledge management
A survey of approaches to automatic schema matching

The VLDB Journal — The International Journal on Very Large Data Bases
A comprehensive XQuery to SQL translation using dynamic interval encoding

Proceedings of the 2003 ACM SIGMOD international conference on Management of data
Recursive XML Schemas, Recursive XML Queries, and Relational Storage: XML-to-SQL Query Translation

ICDE '04 Proceedings of the 20th International Conference on Data Engineering
Automatic direct and indirect schema mapping: experiences and lessons learned

ACM SIGMOD Record
Query translation from XPATH to SQL in the presence of recursive DTDs

VLDB '05 Proceedings of the 31st international conference on Very large data bases
Efficient XML-to-SQL query translation: where to add the intelligence?

VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
XML-to-SQL query mapping in the presence of multi-valued schema mappings and recursive XML schemas

DEXA'07 Proceedings of the 18th international conference on Database and Expert Systems Applications

Integrating large and distributed life sciences resources for systems biology research: progress and new challenges

Transactions on large-scale data- and knowledge-centered systems III

Quantified Score

Hi-index	0.00

Visualization

Abstract

There is an increasing need to translate between SQL and XQuery. This task could be successfully performed only when the differences between the underlying schemas are properly resolved. In this paper, we propose to represent each schema by value, collection, and structure constructs, and design a set of mappings to represent their correspondence. The cases of multiple mappings are particularly considered. Based on the mapping information, queries could be transformed to each other and information could be therefore shared. We give a formal proof to validate the proposed approach, and also show some experimental results to demonstrate its performance.