Design patterns for data integration

Purpose – The application landscapes of major companies all have their own complex structure. Data have to be exchanged between or distributed to the various applications. Systemizing different data integration patterns on a conceptual level can help to avoid uncontrolled redundancy and support the design process of data integration solutions. Each pattern provides a solution for certain data integration requirements and makes the design process more effective by reusing approved solutions. Proposes identifying these patterns.Design/methodology/approach – After a broad literature review data were obtained from interviews and documentary sources. Ten semi‐structured interviews were conducted within four different companies operating in the financial service industry. EAI‐ and IT‐architects as well as project managers and CTOs were involved in these interviews.Findings – Five different data integration patterns were identified. Solutions for upcoming data integration requirements can be designed using these...

[1]  Bonnie Lee Appleton.  Patterns and Software: Essential Concepts and Terminology , 1997 .

[2]  Jonathan Adams,et al.  Patterns for e-Business: A Strategy for Reuse , 2001 .

[3]  Stephen A. Brobst.  Enterprise Application Integration and Active Data Warehousing , 2002 .

[4]  Alfred Büllesbach.  Datenschutz bei Data Warehouses und Data Mining , 2002 .

[5]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[6]  Murray Silverstein,et al.  A Pattern Language , 1977 .

[7]  Gustavo Rossi,et al.  Designing Computational Hypermedia Applications , 2006, J. Digit. Inf..

[8]  Arne Harren,et al.  Integration von Daten, Anwendungen und Prozessen am Beispiel des Telekommunikationsunternehmens EWE TEL , 2002, Wirtsch..

[9]  R. Yin.  Case Study Research: Design and Methods , 1984 .

[10]  Elmar J. Sinz,et al.  Kopplungsarchitekturen zur überbetrieblichen Integration von Anwendungssystemen und ihre Realisierung mit SAP R/3 , 2002, Wirtschaftsinf..

[11]  D. M. Germán.  Three Hypermedia Design Patterns , 1999 .

[12]  Wolffried Stucky,et al.  Die Integration von Informationsverarbeitungsressourcen im Rahmen von Mergers & Acquisitions , 2002, Wirtsch..

[13]  R. Nagarajan,et al.  Enterprise Integration , 1999 .

[14]  Alexander Schwinn,et al.  Modellierung von Applikationslandschaften und Applikationsbeziehungen auf konzeptioneller und logischer Ebene , 2003 .

[15]  David S. Linthicum,et al.  Enterprise Application Integration , 1999 .

[16]  Wilhelm Dangelmaier,et al.  Klassifikation von EAI-Systemen , 2002, HMD Prax. Wirtsch..

[17]  Ralph Johnson,et al.  design patterns elements of reusable object oriented software , 2019 .

[18]  Petra Vogler,et al.  Middleware: Infrastruktur für die Integration , 1996 .

[19]  Markus Helfert,et al.  A Strategy for Managing Data Quality in Data Warehouse Systems , 2001, IQ.

[20]  W. H. Inmon,et al.  Building the Operational Data Store , 1995 .

[21]  Joachim Schelp,et al.  Enterprise Portals und Enterprise Application Integration , 2004 .