Keywords: data migration, information integration
Astract: Due to economical and technological progress, it is necessary to build not only iso-lated systems, but systems of systems, e.g., when companies merge. Most of these systems are based on digital information resources such as relational databases. In order to build successful systems of systems, ways have to be found to ensure the reliability and the efficient development of such systems.
One major topic in building systems of systems is concerned with the integration of data, which is getting more and more important in most business areas. For example companies, which have to integrate other companies because of a takeover or just because of a cooperation, and platforms, which make their business by providing consistent information from different resources, which may have different structures and formats, have to deal with a wide and sophisticated range of integration and migration problems.
In this thesis, the topic of information integration in general and especially of data migration is examined. By this, problem areas are discovered and the state-of-the-art migration technology and process is pointed out. The state-of-the-art data migration process is then applied on a practical example to gather experience and to demon-strate the applicability of this process.
An important aspect of data migration is the reliability and the correctness of such a solution. In order to ensure these properties, a new process which uses a test-driven approach by extending the state-of-the-art process is presented. The crucial point of test-driven approaches is the creation of significant test cases which are a prerequisite for the success of the migration solution. Therefore, a framework called TeCa-4-DaMi (Test Cases for Data Migration) is developed which especially focuses on the systematic development of test cases.

Keywords:
Astract: Today not only the world but also the requirements for computer-based applications change permanently. In addition to these requirements, the development of technologies and tools also continues. Modern and object-oriented technologies, such as UML and Java meet today's high standards.
Distributed systems and web applications respectively represent a wide field in software development. In relation to UML, an excellent way to develop such systems is the object-oriented programming language Java, or more precisely the Java Enterprise Edition. This topic, however, has been thoroughly discussed in [Soko07].
Further tools of today's projects are integrated development environments. When we think of Java software development we can find the project "eclipse" [Ecli08] being a very popular and freely accessible development environment. The advantage of this particular development environment is a distinctive plugin management which allows the project to be easily upgraded.
This thesis evaluates projects and plugins respectively for the development environment "eclipse" which support UML 2.0 and therefore assist in the development.
Furthermore, this thesis assesses whether the tested plugins allow an automated code generation by exemplifying an application.
Finally, this thesis shall also find cost-efficient alternatives to the development environments by IBM (IBM Rational Application Developer [IBM08]) and Omondo (Eclipse Uml [Omon08]).

Keywords: Web applications, Web modeling, Model, Metamodel, Transformation, WebML, OO-H, UWE, ATL
Astract: Web applications changed enormously over the last decades. The first generation provided information retrieval by means of static Web sites. Already the second generation opened a new dimension, where Web applications are not only seen as medium for representing information, but also provide multifaceted services. This change, though, requires technical improvement, such that the static Web sites may be supported through dynamic software systems. The increase in the development effort of Web applications created the need of supporting the development by using model-based development methods and specific Web modeling languages. Model-based software development has gained considerable importance by means of the Model Driven Architecture (MDA) initiative. In general, MDA tends to standardize the modeling languages from different fields for establishing interoperability among different modeling tools. Currently, however, MDA is seen as a vision, since the required basis for its realization is not available yet. Also the Web Engineering field is affected by MDA, because the existing Web modeling methods are not completely model driven in terms of MDA. Metamodels for the Web modeling languages and the model transformations are missing for assuring model exchange among Web modeling tools.
This work aims at implementing a first solution for the interoperability problem among the different Web modeling tools. The central research question is: Is an information loss free exchange of models between the Web modeling tools feasible?

Keywords: Schema Mapping, Information Integration, Schema Heterogeneity, Schema Matching, Machine Learning, Self-Tuning System
Astract: Information integration has a long history in computer science.
It has started with the integration of database schemas in the early eighties. With the rise of the semantic web and the emerging abundance of ontologies, the need for an automatic information integration increased further.
Information integration in general and automatic information integration in particular is a huge and challenging research area. One of the main problems is handling semantic heterogeneity and schema heterogeneity.
Manually finding the semantically overlapping parts of schemas is a tedious problem. Furthermore, writing integration code is a labor intensive, error-prone, and cumbersome task. A lot of approaches have already been developed to automate this work. Nevertheless, not all integration problems have been solved so far.
Matching tools are used to automatically find similarities between schemas. The results of these tools are simple correspondences. Based on these correspondences, one is able to write integration code. However, the simple correspondences are just suggestions and must be verified manually. Hence, the completeness and correctness of the resulting correspondences may not be assured. Furthermore, it is not possible to automatically derive transformation code for all found simple correspondences.
In order to write transformation code, different kinds of transformation languages have been developed. The produced code is too customized for a specific type of schema to be easily reused for other integration problems. Hence, to the best of our knowledge, there exists no transformation language to develop reusable transformation patterns for different kinds of heterogeneity problems.
This thesis addresses the heterogeneity problems, as well as the lack of reusable transformation code, and the need for establishing correct and complete correspondences between schemas.
The first two problems are tackled by developing an executable declarative mapping language, which is able to cope with the core of schema heterogeneity problems. In contrast to simple correspondences, this mapping language is able to express more constraints. Based on these more expressive mappings, the execution code is automatically derived.
The third problem is tackled by a self-tuning, iterative matching approach. This approach is based on the developed mapping language.
Mapping strategies are responsible for the application of mapping operators. Based on the executable mapping suggestion, completeness and correctness are achieved for a provided set of instance models by a test-driven approach. These instance models are used to evaluate the produced mapping model. The prototype of this self-tuning approach is called SmartMatcher.

Keywords: Health Level 7, Clinical Document Architecture, XML Schema, Schematron, XQuery, Constraint Checking, Didactics
Astract: There are a variety of different sources where electronic healthcare information may be produced, such as equipment measuring parameters of the human body or personnel entering patient information into a healthcare information application.
Representing healthcare information electronically allows to exchange information quickly utilizing all of information technology's advantages. One of the keys for electronic healthcare information exchange is a common format to represent information, such as it is specified through healthcare standards.
Regardless of the source of information, there are different possibilities where healthcare information may result into erroneous or faulty information.
The source of erroneous information may be physical equipment producing wrong results, as well as a human entering wrong information into an information system.
Having healthcare information available electronically, and moreover represented in a common format such as it is specified through healthcare standards, allows the processing of information using healthcare information applications.
Therefore, one of the goals of this thesis is to identify different sources in healthcare information processing where erroneous information may occur. Based on these findings, notations are identified that may be used to define constraints. The purpose of constraints is to allow the definition of rules, which may then be applied to healthcare information, in order to discover inconsistent and erroneous parts thereof. Furthermore, different technologies, including hardware and software, are described which may be used to apply constraints.
With the necessary theoretical background and technology, a fictional scenario is described. The purpose of the scenario is to illustrate different approaches to define and apply constraints to evaluate the quality and consistency of healthcare information. In particular, three different approaches are implemented and illustrated. It is then shown how constraint notations and the technology to apply constraints may support didactics in the healthcare area. The results found during the implementation and illustration of three different approaches are then evaluated, compared, and described. The findings include characteristics, advantages and disadvantages of each of the approaches taken. It is found that not all constraint notations and technologies are capable to define and apply constraints in order to discover erroneous healthcare information. However, even though certain technologies show limits, they have other advantages such as the configuration of a hardware device instead of creating an entire software application.
Finally, the conclusion of this thesis points to further areas where exploratory work is needed, but which has been beyond the scope of this thesis.