Architecture for Integration and Migration of Information Systems by Using SOA Services across Heterogeneous System Boundaries

The objective of this chapter is to describe how it is possible to integrate and/or migrate information system where local heterogeneous databases are involved. ERP (Enterprise Resource Planning) systems are very complex standardized information systems, and they are often vital for the companies that use them. Therefore, the authors use integration and migration of ERP systems as an example. Normally, ERP systems are migrated/converted overnight as it normally is not possible to integrate different ERP modules from different ERP suppliers. This is very risky as many types of industries cannot function without a running ERP system. The main focus of this chapter is to illustrate how it is possible to migrate/ convert an ERP system module by module and thus minimizing the risk of staying without a functioning ERP system. In central databases, the consistency of data is normally implemented by using the ACID (Atomicity, Consistency, Isolation and Durability) properties of a DBMS (Data Base Management System). This is not possible if heterogeneous databases are involved and the availability of data also has to be optimized. Therefore, in this chapter, the authors use so called relaxed ACID properties across different database systems or ERP modules. The objective of designing relaxed ACID properties across different database systems is that the users can trust the data they use even if the involved database temporarily are inconsistent.

[1]  Computer Staff,et al.  Transaction processing , 1994 .

[2]  Harry G. Barkema,et al.  How Do Firms Learn to Make Acquisitions? A Review of Past Research and an Agenda for the Future , 2008 .

[3]  Jim Gray,et al.  A critique of ANSI SQL isolation levels , 1995, SIGMOD '95.

[4]  Stefan Henningsson,et al.  Mastering the Integration Chaos Following Frequent M&As: IS Integration with SOA Technology , 2007, 2007 40th Annual Hawaii International Conference on System Sciences (HICSS'07).

[5]  Hüseyin Tanriverdi,et al.  Cross-Business Information Technology Integration and Acquirer Value Creation in Corporate Mergers and Acquisitions , 2011, Inf. Syst. Res..

[6]  Karl Kurbel,et al.  Architecture for Multi-Channel Enterprise Resource Planning System , 2005, MOBIS.

[7]  Lars Frank.  Architecture for ERP System Integration with Heterogeneous E-Government Modules , 2012 .

[8]  Haibin Zhu,et al.  Building reusable components with service-oriented architectures , 2005, IRI -2005 IEEE International Conference on Information Reuse and Integration, Conf, 2005..

[9]  Nicolas Guelfi,et al.  SETER: Towards Architecture-Model Based Security Engineering , 2012, Int. J. Secur. Softw. Eng..

[10]  Bharat K. Bhargava,et al.  Ensuring relaxed atomicity for flexible transactions in multidatabase systems , 1994, SIGMOD '94.

[11]  Jeffrey Parsons,et al.  Dimensions of UML Diagram Use: A Survey of Practitioners , 2008, J. Database Manag..

[12]  Barbara Pernici,et al.  Information systems integration in mergers and acquisitions: A normative model , 1997, Inf. Manag..

[13]  Jrg Rech,et al.  Emerging Technologies for the Evolution and Maintenance of Software Models , 2011 .

[14]  Lars Frank,et al.  Architecture for integration of distributed ERP systems and e-commerce systems , 2004, Ind. Manag. Data Syst..

[15]  M. A. Rashid.  The Evolution of ERP Systems: A Historical Perspective , 2002 .

[16]  L. N. Higgins,et al.  IS integration: Your most critical M&A challenge? , 2002 .

[17]  Lars Frank,et al.  Semantic ACID properties in multidatabases using remote procedure calls and update propagations , 1998 .

[18]  Lars Frank.  Architecture for Integrating Heterogeneous Distributed Databases Using Supplier Integrated E-Commerce Systems as an Example , 2011, 2011 International Conference on Computer and Management (CAMAN).

[19]  Rudy Hirschheim,et al.  Strategic Alignment In Mergers And Acquisitions: Theorizing IS Integration Decision making , 2007, J. Assoc. Inf. Syst..

[20]  Izzat Alsmadi.  Advanced Automated Software Testing: Frameworks for Refined Practice , 2012 .

[21]  Miguel Felder,et al.  A Framework for Analyzing Mobile Transaction Models , 2001, J. Database Manag..

[22]  Rajeev Rastogi,et al.  A transaction model for multidatabase systems , 1992, [1992] Proceedings of the 12th International Conference on Distributed Computing Systems.

[23]  Heinz Stockinger,et al.  Data Replication in Distributed Database Systems , 1999 .

[24]  Antonis C. Stylianou,et al.  Post-merger systems integration: the impact on IS capabilities , 1999, Inf. Manag..

[25]  M. Cruz-cunha,et al.  The Use of Customer Relationship Management Software in Meta-enterprises for Virtual Enterprise Integration , 2012 .

[26]  Hector Garcia-Molina,et al.  Overview of multidatabase transaction management , 2005, The VLDB Journal.

[27]  Mikel Sorli,et al.  Interoperable Process Engineering System for Collaborative Optimization of Product Life-Cycle , 2014 .

[28]  Allen S. Lee.  Retrospect and prospect: information systems research in the last and next 25 years , 2010, J. Inf. Technol..

[29]  Mario Piattini,et al.  Model-Driven Reengineering , 2012 .

[30]  Rasmus Ulslev Pedersen.  TinyOS Education with LEGO MINDSTORMS NXT , 2007 .

[31]  Valentina Plekhanova.  Intelligent Agent Software Engineering , 2002 .

[32]  Ton Spil,et al.  Post-merger IT integration strategies: An IT alignment perspective , 2006, J. Strateg. Inf. Syst..

[33]  Lars Frank.  Smooth and Flexible ERP Migration between both Homogeneous and Heterogeneous ERP Systems/ERP Modules , 2008 .

[34]  Mason A. Carpenter,et al.  Taking Stock of What We Know About Mergers and Acquisitions: A Review and Research Agenda , 2008 .