The Application of Data Integration Patterns: Relational Data Mapping in Connection with Enterprise Integration Patterns

DOI: 10.5176/2251-2195_CSEIT19.144

Authors: Prof. Roland Petrasch

Abstract: Data Integration often plays a central part in Enterprise Data Management, e. g. during the migration from a legacy ERP software to a new system: Data models are not completely compatible, but the ERP data elements need to be transferred, so that complex data conversions, or transformations are necessary. This paper presents a practical example for the usage of Data Integration Patterns in order to demonstrate their advantages. An important aspect is the combination with Enterprise Integration Patterns that focus on messaging while Data Integration Patterns focus on data mappings and transformations. An example for the transformation of a relational to an object-oriented data model shows the approach on a practical level.

Keywords: data integration pattern, DIP, UML, UML profile, enterprise integration pattern, EIP, model mapping, model transformation, relational data model, objectoriented data model, enterprise data model, EDM