Thursday, May 31, 2007

Comments on the general framework about Enterprise system Integration outlined by Hasselbring

The integration of systems which have been developed and evolved independently is one of today's major challenges in computer science. In a large spectrum of application areas the necessity of integrating pre-existing software systems is present and demands for applicable solutions. Problems of coupling and integrating heterogeneous database and information systems are for instance investigated in the database area. Building multi-database systems or federated database systems incorporating legacy systems is a big challenge. On the other hand, systems integration is an important challenge for the area of software engineering as well. Traditionally, the integration of heterogeneous information systems proceeds in a bottom-up process. Information stored in existing legacy systems is analyzed with respect to potential overlaps. The overlapping areas of related information sources are subsequently integrated. The integration of these isolated information systems is usually realized by means of mediators, federated database systems or such-like system architectures. Typical goals for the integration of existing information systems are the development of global applications that access the data from multiple sources as well as consistency management of information that is stored in related systems. From my research on the internet, I learnt that the process of integrating the heterogeneous information systems is being done through different viewpoints. I would like to share these viewpoints with the class..
  • The process in which heterogeneous information systems are traditionally integrated in a bottom-up way, had some problems with this approach.
  • The process in which heterogeneous information systems could ideally be integrated in a top-down way, to achieve more usable and scalable systems.
  • A combined yo-yo approach to exploit the benefits of both strategies and to serve as a migration path from the traditional bottom-up approach towards an ideal top-down approach.

Semantic interoperability is necessary in this context to ensure that exchange of information makes sense - that the provider and requester of information have a common understanding of the "meaning" of the requested services and data.
Organizations face the challenging task of integrating their distributed organizational units, information systems, and business processes for improved operation and attainment of organizational goals. There is the difficulty of dealing with heterogeneous applications that use different formats (syntax) and apply different meanings (semantics) to the data. There is the difficulty of coordinating the workflow so as the disparate organizational units act as a harmonious whole. The broad scope of the enterprise integration problem precludes approaches that tackle the entire problem but rather requires approaches that address a limited but useful integration type. The various information integration types and how they are related to each other is poorly defined. The article presents an enterprise information integration framework that aims to coalesce parallel approaches towards integration so that the information integration problem can be better understood as a whole. The enterprise information integration framework defines four levels of the enterprise system to identify the obstacles and to define the information integration types encountered at each level. The framework is used to analyse the currently used technologies and promising technologies toward enterprise information integration. The analysis identifies general trends and gaps for further research.

6 comments:

Yun Wan said...

Nice observations and summary. I thought companies did integration in a bottom-up approach was not their preference but they have to. Even for today, there are many legacy systems and it is impossible to replace them altogether. So instead of replace them, we put an additional layer on top of them to provide a more smooth interface with other systems.

Syed Sikandar said...

Would this theory apply to the companies that have been in the business for less than 5 - 10 years? I would imagine that it might be hard for companies to migrate all the data from one system to another that existed for a long time.

Vinod said...

Sikander,

Many organizations take a tactical approach when dealing with data integration, that is – address a specific challenge at the time when it is encountered. This is now changing as companies are taking more of a strategic view with the purpose of putting in place the right infrastructure that can address current and future initiatives as well as business and IT trends. A favorable approach is to address tactical challenges strategically, that is – solve the most immediate pain while using a foundation that can be applied and extended to other initiatives over time.
The reason that data and application integration needs to be viewed strategically is evident when one looks at the number of initiatives and projects that require integration including initiatives that:
1. Provide business users with greater visibility to improve operations, productivity and control
2. Automate and streamline business processes
3. Integrate enterprise data for integrity and efficiency

Paul Sturgis said...

I agree that a strategic view of integration is required. The short-sighted "just make it work" approach to integration without regard to architectural design, as with programming, leads to the same result--fragile solutions which are difficult and costly to maintain.

Paul Sturgis said...

I may have misread the syllabus, but it seems to indicate that our personal blogs are for the weekly write up (on our research topic this week) whereas the discussion topic comments are to be posted as comments on Dr. Wan's blog.

It's a bit confusing, this first week outside of my WebCT comfort zone. Maybe Dr. Wan will clarify his expectations.

avinashLingaloo said...

Hi Vinod,
I am a student of Computer Science and right now I have a project entitled "ERP interfacing with other system".

I would like to have more information about how to interface an ERP with other system, integration methodologies and things like that.

Grateful if you could please show me some way.
Avinash