Modulcode:	WI13
Englische Bezeichnung:	Information Systems Integration, Migration and Evolution
Modulverantwortliche(r):	Prof. Dr. Bernhard Thalheim
Turnus:	unregelmäßig (SS13)
Präsenzzeiten:	2V 2Ü 1PÜ
ECTS:	4
Workload:	120 Std.
Dauer:	ein Semester
Modulkategorien:	WI (Sonstige)
Lehrsprache:	Englisch
Voraussetzungen:

Kurzfassung:

Most IKT infrastructures are currently based on information systems that are backed by a farm of database systems. These database and information systems constantly evolve due to changes in the applications and to evolution of IKT. Moreover, systems are merged or integrated into or split to new systems.

This lecture provides a deep insight into methods for data, model and functional integration of information systems. It shows how to develop migration architectures and pathes in evolving worlds.

Lernziele:

The student is able to prepare information systems for their integration at the data level, at the structural level and at the functionality level. The student knows how to analyse existing systems and how to prepare these systems for migration and evolution. The student are able to use conversion guides and specific migration programs and to adapt them to the needs of of an organisation. The students have an insight into how to make an information system fit for evolution.

Lehrinhalte:

Integration aims at developing a unified state of multiple components into one whole, complex system and is based on the process of unifying multiple components into one complex system. It ranges from customer data integration and master data management, from enterprise application and enterprise information integration, from service-oriented integration, and from model management to functional integration.

Data integration is the planned and controlled transformation and flow of data across databases, for operational and/or analytical use. Data needs to be accessed and extracted, moved, validated and cleansed, standardized, transformed and loaded. It is based on data integration architecture, i.e., on master plan for how data transformation and flow across databases. The data integration architecture is an important part of enterprise data architecture. Data integration is typically based on extract-transform-load (ETL) approaches to data integration from multiple source databases to integrated target databases (operational data stores, data warehouses or data marts).

Model integration, model management and configuration management for database systems is based on model suites or in the simplest case on model ensembles. Model ensembles consist of a master set of data models and design approaches identifying the strategic data requirements and the components of data management solutions, usually at an enterprise level. Enterprise data architecture typically consists of (1) an enterprise data model (contextual/subject area, conceptual or logical), (2) state transition diagrams depicting the lifecycle of major entities, (3) a robust information value chain analysis identifying data stakeholder roles, organizations, processes and applications, and (4) data integration architecture identifying how data will flow between applications and databases. The data integration architecture may be divided into database architecture, master data management architecture, data warehouse / business intelligence architecture, and meta data architecture. Additionally it also includes (5) lists of controlled domain values (code sets), and (6) the responsibility assignments of data stewards to subject areas, entities and code sets. The enterprise data architecture is an important part of the larger enterprise architecture that includes business, process and technology architecture.

Enterprise application integration aims at a technology that allows data sharing between unrelated systems in the organization, providing a single point of interface to which all applications and databases connect, resolving differences between systems, triggering processes and delivering data in the proper format to the proper destination. Enterprise information integration provides custom views into multiple databases transparently to enable applications to more easily provide integrated real-time read and write access across databases. Service-oriented integration performs enterprise application integration using service-based technology.

Migration is the process of moving from the use of one database or information systems environment to another environment that is, in most cases, is thought to be a better one. Migration also can involve moving to new hardware, new software, or both. Migration can be small-scale, such as migrating a single system, or large-scale, involving many systems, new applications, or a redesigned network. One can migrate data from one kind of database to another kind of database. This usually requires converting the data into some common format that can be output from the old database and input into the new database. Since the new database may be organized differently, it may be necessary to write a program that can process the migrating files.

Migration is supported for most database products and by the migration technology initiative.

Information systems evolution aims in developing new theoretical methods, algorithms, and implementations of systems with a higher level of flexibility and autonomy. These systems have to be able to evolve their structure and knowledge on the environment. To address the problems of modelling, control, prediction, classification and data processing in a dynamically changing and evolving environment, a system must be able to fully adapt its structure and adjust its parameters, rather than use a pre-trained and a fixed structure. That is, the system must be able to evolve, to self-develop, to self-organize, to self-evaluate and to self-improve. An evolution strategy assumes a natural evolutionary path for organizational and systems improvement.

Outline:

I. Information system integration

I.1. Linguistic integration

I.2. Structural integration and schema translation

I.3. Data conversion, integration and proliferation

I.4. Functional integration and database program translation

I.5. Structural and functional integration pattern

II. Information systems migration

II.1. Chicken little, cold turkey and butterfly migration strategies

II.2. Platform-driven migration

II.2. Structural and functional migration

II.4. Migration pattern

II.5. Data migration

III. Information systems evolution

III.1. Evolution of database and information systems technology

III.2. Evolution strategies: Mutation, reassembling, selection etc.

III.3. Evolution aspects: Niches settlements, Baldwin effect, coevolution

III.4. Intelligent, autonomic tuning and adapting information systems

Weitere Voraussetzungen:

Knowledge in database management systems technology, software engineering, database programming is essential. A background in distributed (information) systems would be beneficial.

Prüfungsleistung:

Integration and migration project in collaboration with partners in Schleswig-Holstein and Hamburg.

Lehr- und Lernmethoden:

Lecturing is the main method when introducing and explaining new concepts and when adding insight and expand on previously presented material. Main methods used during lecturing are: audio-visual presentation, problem-solving activities, presentation, synthesis, experimenting with software tools, development of solutions to tasks given by people from practice, buzz sessions, independent practice, modelling, simulation, debriefing, projects, skill practice and guided practice. Main methods used for seminars are: development of solutions to problems, discussion of difficulties and problems in solution development, development of prototypical solutions and presentation of results.

Verwendbarkeit:

Accent course within the specialisation Information Systems Development and Management''

Literatur:

Joseph Fong. Information Systems Reengineering and integration. Springer 2006

Ulf Leser, Felix Naumann. Informationsintegration. dpunkt.verlag, 2006

Michael L. Brodie, Michael Stonebraker. Migrating legacy systems - Gateways, interfaces and the incremental approach. Morgan Kaufman, 1995

Phil A. Bernstein, Erhard Rahm. A Survey of Approaches to Automatic Schema Matching. VLDB Journal, 2001, 10, 334-350.

Stefan Conrad. Föderierte Datenbanksysteme.

Verweise:

Kommentar: