Skip to main content
SpringerLink
Log in

A UML Profile for Modeling Schema Mappings

  • Conference paper
Advances in Conceptual Modeling - Theory and Practice (ER 2006)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 4231))

Included in the following conference series:

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  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)

    Article  Google Scholar 

  2. The Object Management Group. UML 1.4.2 Specification, http://www.omg.org/cgi-bin/doc?formal/04-07-02 (last access: 05/2006)

  3. AndroMDA: Schema2XMI Generator, http://team.andromda.org/docs/andromda-schema2xmi/ (last access: 05/2006)

  4. Wiederhold, G.: Mediators in the Architecture of Future Information Systems. Computer 25(3), 38–49 (1992)

    Article  Google Scholar 

  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. 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. 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. 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. Bergamaschi, S., Castano, S., Vincini, M., Beneventano, D.: Semantic Integration of Heterogeneous Information Sources. Data & Knowl. Eng. 36(3), 215–249 (2001)

    Article  MATH  Google Scholar 

  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. Oracle: Integrated ETL and Modeling. White Paper (2003), http://www.oracle.com/technology/products/warehouse/pdf/OWB_WhitePaper.pdf

  12. Altova: Data Integration: Opportunities, challenges, and MapForce. White Paper, http://www.altova.com/whitepapers/mapforce.pdf (last access: 05/2006)

  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)

    Article  MATH  Google Scholar 

  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. Kurz, S.: Entwicklung einer Architektur zur Integration heterogener Datenbestände. Diploma thesis, University of Passau (2006) (in German)

    Google Scholar 

  16. AndroMDA: Model Driven Architecture Framework, http://www.andromda.org/ (last access: 05/2006)

  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)

    Chapter  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Institute for Information Systems and Software Technology (IFIS), University of Passau, Germany

    Stefan Kurz, Michael Guppenberger & Burkhard Freitag

Authors
  1. Stefan Kurz
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Michael Guppenberger
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Burkhard Freitag
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Flinders University, Adelaide, Australia

    John F. Roddick

  2. iSOCO, Spain

    V. Richard Benjamins

  3. CEDRIC-CNAM, France

    Samira Si-said Cherfi

  4. University of Cincinnati, USA

    Roger Chiang

  5. Naval Academy Research Institute, Brest Naval, France

    Christophe Claramunt

  6. Department of Computer Science and Engineering, The University of Texas at Arlington, USA

    Ramez A. Elmasri

  7. Dipartimento di Elettronica, Informatica e Sistemistica, Alma Mater Studiorum – Università di Bologna, Italy

    Fabio Grandi

  8. Drexel University, USA

    Hyoil Han

  9. E-Business and Web Science Research Group, Bundeswehr University Munich, Germany

    Martin Hepp

  10. University of Patras, Argolidos 40-42, 153-44, Gerakas Attikis, Greece

    Miltiadis D. Lytras

  11. University of Manitoba, Canada

    Vojislav B. Mišić

  12. Ghent University, Belgium

    Geert Poels

  13. College of Information Science and Technology, Drexel University, USA

    Il-Yeol Song

  14. Department of Software and Computing Systems, University of Alicante, Spain

    Juan Trujillo

  15. EPFL, Switzerland

    Christelle Vangenot

Rights and permissions

Reprints and permissions

Copyright information

© 2006 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Kurz, S., Guppenberger, M., Freitag, B. (2006). A UML Profile for Modeling Schema Mappings. In: Roddick, J.F., et al. Advances in Conceptual Modeling - Theory and Practice. ER 2006. Lecture Notes in Computer Science, vol 4231. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11908883_8

Download citation

  • DOI: https://doi.org/10.1007/11908883_8

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-47703-7

  • Online ISBN: 978-3-540-47704-4

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation