Model-Driven Development of Complex and Data-Intensive Integration Processes

  • Matthias Böhm
  • Dirk Habich
  • Wolfgang Lehner
  • Uwe Wloka
Conference paper
Part of the Communications in Computer and Information Science book series (CCIS, volume 8)

Abstract

Due to the changing scope of data management from centrally stored data towards the management of distributed and heterogeneous systems, the integration takes place on different levels. The lack of standards for information integration as well as application integration resulted in a large number of different integration models and proprietary solutions. With the aim of a high degree of portability and the reduction of development efforts, the model-driven development—following the Model-Driven Architecture (MDA)—is advantageous in this context as well. Hence, in the GCIP project (Generation of Complex Integration Processes), we focus on the model-driven generation and optimization of integration tasks using a process-based approach. In this paper, we contribute detailed generation aspects and finally discuss open issues and further challenges.

Keywords

Model-Driven Architecture Integration Processes GCIP Federated DBMS Enterprise Application Integration Extraction Transformation Loading 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Kleppe, A., Warmer, J., Bast, W.: MDA Explained. The Model Driven Architecture: Practice and Promise. Addison-Wesley, Reading (2003)Google Scholar
  2. 2.
    Thomas, D., Barry, B.M.: Model driven development: the case for domain oriented programming. In: OOPSLA (2003)Google Scholar
  3. 3.
    OMG: Meta-Object Facility (MOF), Version 2.0 (2003)Google Scholar
  4. 4.
    OMG: Unified Modeling Language (UML), Version 2.0 (2003)Google Scholar
  5. 5.
    Königs, A.: Model transformation with triple graph grammars. In: MODELS (2005)Google Scholar
  6. 6.
    Czarnecki, K., Helsen, S.: Feature-based survey of model transformation approaches. IBM Syst. J. 45(3) (2006)Google Scholar
  7. 7.
    Habich, D., Richly, S., Lehner, W.: Gignomda - exploiting cross-layer optimization for complex database applications. In: VLDB (2006)Google Scholar
  8. 8.
    Richly, S., Habich, D., Lehner, W.: Gignomda - generation of complex database applications. In: Grundlagen von Datenbanken (2006)Google Scholar
  9. 9.
    OMG: Common Warehouse Metamodel (CWM), Version 1.0 (2001)Google Scholar
  10. 10.
    OASIS: Web Services Business Process Execution Language Version 2.0 (2006)Google Scholar
  11. 11.
    BMI: Business Process Modelling Notation, Version 1.0 (2006)Google Scholar
  12. 12.
    W3C: Web Service Choreography Description Language, Version 1.0 (2005)Google Scholar
  13. 13.
    WfMC: Process Definition Interface - XML Process Definition Language 2.0 (2005)Google Scholar
  14. 14.
    OASIS: ebXML Business Process Specification Schema, Version 2.0.1. (2005)Google Scholar
  15. 15.
    Dorda, C., Heinkel, U., Mitschang, B.: Improving application integration with model-driven engineering. In: ICITM (2007)Google Scholar
  16. 16.
    Simitsis, A., Vassiliadis, P.: A methodology for the conceptual modeling of ETL processes. In: CAiSE workshops (2003)Google Scholar
  17. 17.
    Trujillo, J., Luján-Mora, S.: A UML Based Approach for Modeling ETL Processes in Data Warehouses. In: Song, I.-Y., Liddle, S.W., Ling, T.-W., Scheuermann, P. (eds.) ER 2003. LNCS, vol. 2813, pp. 307–320. Springer, Heidelberg (2003)Google Scholar
  18. 18.
    Vassiliadis, P., Simitsis, A., Skiadopoulos, S.: Conceptual modeling for ETL processes. In: DOLAP (2002)Google Scholar
  19. 19.
    Hahn, K., Sapia, C., Blaschka, M.: Automatically generating OLAP schemata from conceptual graphical models. In: DOLAP (2000)Google Scholar
  20. 20.
    Mazón, J.N., Trujillo, J., Serrano, M., Piattini, M.: Applying mda to the development of data warehouses. In: DOLAP (2005)Google Scholar
  21. 21.
    Simitsis, A.: Mapping conceptual to logical models for ETL processes. In: DOLAP (2005)Google Scholar
  22. 22.
    Dessloch, S., Hernandez, M.A., Wisnesky, R., Radwan, A., Zhou, J.: Orchid: Integrating schema mapping and ETL. In: ICDE (2008)Google Scholar
  23. 23.
    Melnik, S., Rahm, E., Bernstein, P.A.: Rondo: A programming platform for generic model management. In: SIGMOD (2003)Google Scholar
  24. 24.
    Göres, J., Dessloch, S.: Towards an integrated model for data, metadata, and operations. In: BTW (2007)Google Scholar
  25. 25.
    Böhm, M., Habich, D., Wloka, U., Bittner, J., Lehner, W.: Towards self-optimization of message transformation processes. In: ADBIS (2007)Google Scholar
  26. 26.
    Böhm, M., Habich, D., Lehner, W., Wloka, U.: Dipbench: An independent benchmark for data intensive integration processes. In: IIMAS (2008)Google Scholar
  27. 27.
    Böhm, M., Habich, D., Lehner, W., Wloka, U.: Dipbench toolsuite: A framework for benchmarking integration systems. In: ICDE (2008)Google Scholar
  28. 28.
    Rahm, E., Do, H.H.: Data cleaning: Problems and current approaches. IEEE Data Eng. Bull. (2000)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2008

Authors and Affiliations

  • Matthias Böhm
    • 1
  • Dirk Habich
    • 2
  • Wolfgang Lehner
    • 2
  • Uwe Wloka
    • 1
  1. 1.Database GroupDresden University of Applied Sciences 
  2. 2.Database Technology GroupDresden University of Technology 

Personalised recommendations