A Classification of Schema Mappings and Analysis of Mapping Tools

作者: Felix Naumann , Frank Legler

DOI:

关键词:

摘要: Schema mapping techniques for data exchange have become popular and useful tools both in research industry. A schema relates a source with target via correspondences, which are specified by domain expert possibly supported automated matching algorithms. The set of correspon- dences, i.e., the mapping, is interpreted as transformation usually expressed query. These queries transform from to conform tar- get schema. They can be used materialize at or views virtually integrated system. We present classification situations that occur when between two relational nested (XML) schemata. Our takes into con- sideration 1:1 n:m attribute-level higher-level mappings, special constructs, such choice constraints, cardinality types. Based on this classification, we developed general suite schemata, data, correspondences test ability cope different situations. evaluated several commercial support def- inition mappings interpret transformation. found no tool performs well all many pro- duce incorrect transformations. serve benchmark future improvements developments tools.

参考文章(10)
Renée J. Miller, Laura M. Haas, Mauricio A. Hernández, Schema Mapping as Query Discovery very large data bases. pp. 77- 88 ,(2000)
W. Kim, J. Seo, Classifying schematic and data heterogeneity in multidatabase systems IEEE Computer. ,vol. 24, pp. 12- 18 ,(1991) , 10.1109/2.116884
Amit P. Sheth, James A. Larson, Federated database systems for managing distributed, heterogeneous, and autonomous databases ACM Computing Surveys. ,vol. 22, pp. 183- 236 ,(1990) , 10.1145/96602.96604
Stefano Spaccapietra, Christine Parent, Yann Dupont, Model independent assertions for integration of heterogeneous schemas very large data bases. ,vol. 1, pp. 81- 126 ,(1992) , 10.1007/BF01228708
Sergey Melnik, Erhard Rahm, Philip A. Bernstein, Rondo: a programming platform for generic model management international conference on management of data. pp. 193- 204 ,(2003) , 10.1145/872757.872782
C. Batini, M. Lenzerini, S. B. Navathe, A comparative analysis of methodologies for database schema integration ACM Computing Surveys. ,vol. 18, pp. 323- 364 ,(1986) , 10.1145/27633.27634
Sergey Melnik, Philip A. Bernstein, Alon Halevy, Erhard Rahm, Supporting executable mappings in model management Proceedings of the 2005 ACM SIGMOD international conference on Management of data - SIGMOD '05. pp. 167- 178 ,(2005) , 10.1145/1066157.1066177
Marcelo Arenas, Leonid Libkin, XML data exchange: consistency and query answering symposium on principles of database systems. pp. 13- 24 ,(2005) , 10.1145/1065167.1065171
Ronald Fagin, Phokion G. Kolaitis, Lucian Popa, Data exchange: getting to the core symposium on principles of database systems. ,vol. 30, pp. 90- 101 ,(2003) , 10.1145/1061318.1061323
Lucian Popa, Yannis Velegrakis, Renée J. Miller, Mauricio A. Hernández, Ronald Fagin, Translating web data very large data bases. pp. 598- 609 ,(2002) , 10.1016/B978-155860869-6/50059-7