Schema exchange: Generic mappings for transforming data and metadata

Data and Knowledge Engineering

Volumn 68, Issue 7, 2009, Pages 665-682

  Papotti, Paolo ^a   Torlone, Riccardo ^a  

^a ROMA TRE UNIVERSITY   (Italy)

Author keywords

Data exchange; Dependencies; Schema exchange; Schema mappings; Schema templates; Universal solutions

Indexed keywords

DATA EXCHANGE; DEPENDENCIES; SCHEMA EXCHANGE; SCHEMA MAPPINGS; SCHEMA TEMPLATES; UNIVERSAL SOLUTIONS;

INFORMATION THEORY;

METADATA;

EID: 67349153774     PISSN: 0169023X     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.datak.2009.02.005     Document Type: Article

References (30)

1. P. Atzeni, P. Cappellari, P.A. Bernstein, Model-independent schema and data translation, in: International Conference on Extending Database Technology (EDBT), 2006, pp. 368-385.
2. Beeri C., and Vardi M.Y. A proof procedure for data dependencies. Journal of ACM 31 4 (1984) 718-741
3. P.A. Bernstein, Applying model management to classical meta data problems, in: Conference on Innovative Data Systems Research (CIDR), 2003, pp. 209-220.
4. P.A. Bernstein, S. Melnik, Model Management 2.0: Manipulating Richer Mappings, in: SIGMOD Conference, 2007, pp. 1-12.
5. Bernstein P.A., Levy A.Y., and Pottinger R.A. A vision for management of complex models. SIGMOD Record 29 4 (2000) 55-63
6. P.A. Bernstein, E. Rahm, Data warehouse scenarios for model management, in: International Conference on Conceptual Modeling (ER), 2000, pp. 1-15.
7. D. Bhagwat, L. Chiticariu, W.C. Tan, G. Vijayvargiya, An annotation management system for relational databases, in: International Conference on Very Large Data Bases (VLDB), 2004, pp. 900-911.
8. S. Bowers, L.M.L. Delcambre, The uni-level description: a uniform framework for representing information in multiple data models, in: International Conference on Conceptual Modeling (ER), 2003, pp. 45-58.
9. P. Buneman, S. Khanna, W.C. Tan, Why and where: a characterization of data provenance, in: International Conference on Database Theory (ICDT), 2001, pp. 316-330.
10. P. Buneman, S. Khanna, W.C. Tan, On propagation of deletion and annotations through views, in: Symposium on Principles of Database Systems (PODS), 2002, pp. 150-158.
11. L. Chiticariu, W.C. Tan, Debugging schema mappings with routes, in: International Conference on Very Large Data Bases (VLDB), 2006, pp. 79-90.
12. Fagin R., Kolaitis P.G., and Popa L. Data exchange: getting to the core. ACM Transaction on Database Systems 30 1 (2005) 174-210
13. A. Fuxman, M.A. Hernández, H. Ho, R.J. Miller, P. Papotti, L. Popa, Nested mappings: schema mapping reloaded, in: International Conference on Very Large Data Bases (VLDB), 2006, pp. 67-78.
14. Fagin R., Kolaitis P.G., Miller R.J., and Popa L. Data exchange: semantics and query answering. Theoretical Computer Science 336 1 (2005) 89-124
15. F. Geerts, A. Kementsietsidis, D. Milano, MONDRIAN: annotating and querying databases through colors and blocks, in: International Conference on Data Engineering (ICDE), 2006, pp. 82-93.
16. G.Gottlob, A. Nash, Data exchange: computing cores in polynomial time, in: Symposium on Principles of Database Systems (PODS), 2006, pp. 40-49.
17. Hernández M.A., Papotti P., and Tan W.C. Data exchange with data-metadata translations. Proceedings of the VLDB Endowment 1 1 (2008) 260-273
18. Lakshmanan L.V.S., Sadri F., and Subramanian S.N. SchemaSQL: an extension to SQL for multidatabase interoperability. ACM Transaction on Database Systems 26 4 (2001) 476-519
19. P. McBrien, A. Poulovassilis, Data integration by bi-directional schema transformation rules, in: International Conference on Data Engineering (ICDE), 2003, pp. 227-238.
20. G. Mihaila, L. Raschid, M.-E. Vidal, Querying "quality of data" metadata, in: IEEE Meta-Data Conference, 1999.
21. P. Mork, P.A. Bernstein, S. Melnik, Teaching a schema translator to produce O/R views, in: International Conference on Conceptual Modeling (ER), 2007, pp. 102-119.
22. OMG Model Driven Architecture, Internet document, 2001. .
23. OASIS XRI Data Interchange (XDI), Internet document, 2008. .
24. Papotti P., and Torlone R. Heterogeneous data translation through XML conversion. Journal of Web Engineering 4 3 (2005) 189-204
25. P. Papotti, R. Torlone, Automatic generation of model translations, in: International Conference on Advanced Information Systems Engineering (CAiSE), 2007, pp. 36-50.
26. P. Papotti, R. Torlone, Schema exchange: a template-based approach to data and metadata translation, in: International Conference on Conceptual Modeling (ER), 2007, pp. 323-337.
27. L. Popa, Y. Velegrakis, R.J. Miller, M.A. Hernández, R. Fagin, Translating web data, in: International Conference on Very Large Data Bases (VLDB), 2002, pp. 598-609.
28. S. Purao, V. Storey, A. Sengupta, M. Moore, Reconciling and cleansing: an approach to inducing domain models, in: International Workshop on Information Systems and Technologies (WITS), 2000, pp. 61-66.
29. Wyss C.M., and Robertson E. Relational languages for metadata integration. ACM Transaction on Database Systems 30 2 (2005) 624-660
30. Rahm E., and Bernstein P.A. A survey of approaches to automatic schema matching. VLDB Journal 10 4 (2001) 334-350