Abstract
Many application settings involve the need to exchange information between heterogeneous frameworks. In the database world, we often use different systems to handle data, following different models, and we therefore need to translate data and their description from one to another. The problem has been considered for decades in our field, but definitive solutions are not yet available. The problem is relevant at the schema level (for example, every designer works with a conceptual model, such as ER or UML, and then translates the conceptual schema into a logical model, usually relational), and at the data level, when we have databases, and we want to translate them into some other system, which may be similar (for example, with a slightly different version of the relational model) or completely different (for example, XML documents).
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Andritsos, P., Fagin, R., Fuxman, A., Haas, L.M., Hernández, M.A., Ho, C.T.H., Kementsietsidis, A., Miller, R.J., Naumann, F., Popa, L., Velegrakis, Y., Vilarem, C., Yan, L.-L.: Schema Management. IEEE Data Eng. Bull. 25(3), 32–38 (2002)
Atzeni, P., Cappellari, P., Bernstein, P.A.: ModelGen: Model independent schema translation. In: ICDE, Tokyo. IEEE Computer Society, Los Alamitos (2005)
Atzeni, P., Torlone, R.: Management of Multiple Models in an Extensible Database Design Tool. In: EDBT 1996, pp. 79–95 (1996)
Bernstein, P.A.: Applying Model Management to Classical Meta Data Problems. In: Conference on Innovative Data Systems Research, Asilomar, CA, USA, January 5-8 (2003)
Bernstein, P.A., Halevy, A.Y., Pottinger, R.: A Vision of Management of Complex Models. SIGMOD Record 29(4), 55–63 (2000)
Hull, R.: Managing Semantic Heterogeneity in Databases: A Theoretical Perspective. In: PODS 1997, pp. 51–61 (1997)
Hull, R., King, R.: Semantic Database Modeling: Survey, Applications, and Research Issues. ACM Computing Surveys 19(3), 201–260 (1987)
Miller, R.J., Ioannidis, Y.E., Ramakrishnan, R.: Schema equivalence in heterogeneous systems: bridging theory and practice. Inf. Syst. 19(1), 3–31 (1994)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2005 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Atzeni, P. (2005). Tutorial 5: Schema and Data Translation. In: Akoka, J., et al. Perspectives in Conceptual Modeling. ER 2005. Lecture Notes in Computer Science, vol 3770. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11568346_52
Download citation
DOI: https://doi.org/10.1007/11568346_52
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-29395-8
Online ISBN: 978-3-540-32239-9
eBook Packages: Computer ScienceComputer Science (R0)