A UML Profile for Modeling Schema Mappings

  • Stefan Kurz
  • Michael Guppenberger
  • Burkhard Freitag
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4231)


When trying to obtain semantical interoperability between different information systems, the integration of heterogeneous information sources is a fundamental task. An important step within this process is the formulation of an integration mapping which specifies how to select, integrate and transform the data stored in the heterogeneous local information sources into a global data store. This integration mapping can then be used to perform the data integration itself.

In this paper, we present a UML-based approach to define integration mappings. To this end, we introduce a UML profile which can be used to map local information schemata onto one global schema thus eliminating schema conflicts. We claim that this is the first time that the integration mapping can be specified within the UML model of the application and that this model can be used to generate a working implementation of the schema mappings using MDA-transformations.


Data Integration Schema Mapping Model Driven Architecture (MDA) UML Profiles 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Batini, C., Lenzerini, M., Navathe, S.B.: A Comparative Analysis of Methodologies for Database Schema Integration. ACM Computing Surveys 18(4), 323–364 (1986)CrossRefGoogle Scholar
  2. 2.
    The Object Management Group. UML 1.4.2 Specification, (last access: 05/2006)
  3. 3.
    AndroMDA: Schema2XMI Generator, (last access: 05/2006)
  4. 4.
    Wiederhold, G.: Mediators in the Architecture of Future Information Systems. Computer 25(3), 38–49 (1992)CrossRefGoogle Scholar
  5. 5.
    Roth, M.T., Schwarz, P.M.: Don’t Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources. In: Proceedings of the 23rd International Conference on Very Large Data Bases, pp. 266–275 (1997)Google Scholar
  6. 6.
    Chawathe, S., Hammer, J., Ireland, K., Papakonstantinou, Y., Ullman, J.D., Widom, J., García-Molina, H.: The TSIMMIS Project: Integration of Heterogeneous Information Sources. In: 16th Meeting of the Information Processing Society of Japan, pp. 7–18 (1994)Google Scholar
  7. 7.
    Haas, L.M., Miller, R.J., Niswonger, B., Roth, M.T., Schwarz, P.M., Wimmers, E.L.: Transforming Heterogeneous Data with Database Middleware: Beyond Integration. IEEE Data Engineering Bulletin 22(1), 31–36 (1999)Google Scholar
  8. 8.
    Berler, M., Eastman, J., Jordan, D., Russell, C., Schadow, O., Stanienda, T., Velez, F.: The Object Data Standard: ODMG 3.0. Morgan Kaufmann, San Francisco (2000)Google Scholar
  9. 9.
    Bergamaschi, S., Castano, S., Vincini, M., Beneventano, D.: Semantic Integration of Heterogeneous Information Sources. Data & Knowl. Eng. 36(3), 215–249 (2001)zbMATHCrossRefGoogle Scholar
  10. 10.
    Miller, R.J., Hernández, M.A., Haas, L.M., Yan, L., Ho, C.T.H., Fagin, R., Popa, L.: The Clio Project: Managing Heterogeneity. SIGMOD Record (ACM Special Interest Group on Management of Data) 30(1), 78–83 (2001)Google Scholar
  11. 11.
    Oracle: Integrated ETL and Modeling. White Paper (2003),
  12. 12.
    Altova: Data Integration: Opportunities, challenges, and MapForce. White Paper, (last access: 05/2006)
  13. 13.
    Rahm, E., Bernstein, P.A.: A Survey of Approaches to Automatic Schema Matching. VLDB Journal: Very Large Data Bases 10(4), 334–350 (2001)zbMATHCrossRefGoogle Scholar
  14. 14.
    Kleppe, A., Warmer, J., Bast, W.: MDA Explained. In: The Model Driven Architecture: Practice and Promise. Addison-Wesley Longman, Amsterdam (2003)Google Scholar
  15. 15.
    Kurz, S.: Entwicklung einer Architektur zur Integration heterogener Datenbestände. Diploma thesis, University of Passau (2006) (in German)Google Scholar
  16. 16.
    AndroMDA: Model Driven Architecture Framework, (last access: 05/2006)
  17. 17.
    Guppenberger, M., Freitag, B.: Intelligent Creation of Notification Events in Information Systems - Concept, Implementation and Evaluation. In: Chowdhury, A., et al. (eds.) Proceedings of the 14th ACM International Conference on Information and Knowledge Management (CIKM). ACM, pp. 52–59. ACM Press, New York (2005)CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Stefan Kurz
    • 1
  • Michael Guppenberger
    • 1
  • Burkhard Freitag
    • 1
  1. 1.Institute for Information Systems and Software Technology (IFIS)University of PassauGermany

Personalised recommendations