2 Abstract Agile development practices have become widely adopted in the past decade. They are increasingly used in industry and have been subject to a wide range of research. The promises of agile development practices range from customer satisfaction and adaptivity to changing requirements to developer motivation and reliable software through iterative development and customer involvement. However, what has received little attention so far is the effect of agile development practices on the development of information systems where the static nature of databases conflicts with the agility of the development approach. One feature of agile projects is the iterative development approach by which users may start using the software as soon as minimal functionality is available. In the case of information systems, this results in the creation of databases with possibly valuable data. Together with the agile principle of frequent release of software updates, this leads to a need for frequent database evolution of customer databases which results in increased development effort. At the same time, the tight coupling of the incremental application development with application usage gives rise to new opportunities for exploiting the agile principles in favour of an improved development process. In this thesis, we explore various effects of agile development practices on the development of information systems and investigate new ways in which information system development can benefit from agile practices. We start with a case study of a large software development project of the European Space Agency (ESA) in which the author was involved. The project developed an information system for operating the ESA Herschel Space Observatory and processing observation data. The information system was developed using an agile approach involving development teams located in several different countries and research institutions. The development approach of the project was such that users used the system from early on in the development period while creating significant amounts of data and databases that needed to be continuously evolved in order to be compatible with the evolving data model and to be available later when the software became operational. This led to roughly bi-monthly database evolution being necessary for hundreds of databases throughout six years of development. Based on this case study, we highlight several issues and concepts related to the agile development of information systems and explore solutions and ways to benefit from agile development practices. For example, we discuss the suitability of object databases for agile development due to their approach of avoiding separate logical and conceptual data models with their associated mappings, thereby reducing the effort of evolving the data model. This tight coupling of application data model and database also has the advantage that it allows the tracking of navigation between objects and classes. This adds a dimension to profiling data that permits profiling on the level of the conceptual model and which is more difficult to obtain from relational databases. We visualise this profiling data i

3 ii on the level of the conceptual model and use profiling analysis to recommend and, if desired, execute model refactorings to improve the model. This profiling analysis and refactoring is mainly aimed at improving database performance, but it can also be used to identify access patterns and thus yield semantic information about database usage. Database profiling on the conceptual level can therefore indicate inconsistencies in the information system if they are caused by semantic discrepancies between data model, queries and the user s idea of how the application should be used. Another concept that is suitable for the agile development of information systems is that of model-driven development. It has been argued that the visual approach to model editing is appreciated by model designers and that the concept of code generation from a data model facilitates application evolution by reducing the amount of manual code refactoring required. However, next to the aspect of application code generation, the concept of generating database evolution code from data models has received far less attention. In this thesis, we present an approach to generating and optimising database evolution code with respect to performance, maintainability and ordering for the insertion of data evolution functions. Building on model-driven development, we also present the concept of adaptive code generation. This concept discusses the idea that the modelling language used by the model designer may contain semantically rich constructs, such as multiple inheritance or multiple instantiation which are not available in the object model of the targeted programming language. While such constructs are very useful, the mapping layers required to implement such constructs in a programming language tend to affect application performance and database space requirements. Moreover the need for such rich constructs may increase during the development phase as the data model grows from a simple model to a complex model towards the end of the project. To support growing models and handle the trade-off between performance and features, we propose a solution that provides different mapping layers which support the different constructs in a modular way. This choice gives the model designer fine-grained control and is complemented by a model analyser that recommends a mapping layer depending on the characteristics of the data model. To evaluate our ideas, we developed the AgileIS framework, an integrated development environment for the agile model-driven development of information systems. The framework aims to resolving some of the issues observed during the case study and at finding novel ways of exploiting agile practices to further information system development. The features of the framework include model editors for multiple modelling languages, a model versioning system, application code generators with modular mapping layers for different DBMS, database evolution code generators for different DBMS and a tool for visualising profiling data including recommendations and execution of performance related refactorings. To demonstrate the validity of the approach, we integrated support for profiling features into the open source object database ZooDB. These features go well beyond the profiling support available in current object databases.

Diss. ETH No. 12075 Group and Session Management for Collaborative Applications A dissertation submitted to the SWISS FEDERAL INSTITUTE OF TECHNOLOGY ZÜRICH for the degree of Doctor of Technical Seiences

This press release is approved for publication. Press Release Chemnitz, February 6 th, 2014 Customer-specific software for autonomous driving and driver assistance (ADAS) With the new product line Baselabs

DISS. ETH NO. 18143 Strategies for Random Contract-Based Testing A dissertation submitted to ETH ZURICH for the degree of Doctor of Sciences presented by ILINCA CIUPA Dipl. Eng., Technical University of

DISS. ETH NO. 20770 A Requirement-Oriented Data Quality Model and Framework of a Food Composition Database System A dissertation submitted to ETH ZURICH for the degree of Doctor of Sciences presented by

DISS. ETH N O 18072 Contract-based tests in the software process and environment A dissertation submitted to the ETH Zurich for the degree of Doctor of Sciences presented by Andreas Leitner Diplom Ingenieur,

Abstract The thesis on hand deals with customer satisfaction at the example of a building subcontractor. Due to the problems in the building branch, it is nowadays necessary to act customer oriented. Customer

Exercise (Part II) Notes: The exercise is based on Microsoft Dynamics CRM Online. For all screenshots: Copyright Microsoft Corporation. The sign ## is you personal number to be used in all exercises. All

Service Design Dirk Hemmerden - Appseleration GmbH An increasing number of customers is tied in a mobile eco-system Hardware Advertising Software Devices Operating System Apps and App Stores Payment and

Labour law and Consumer protection principles usage in non-state pension system by Prof. Dr. Heinz-Dietrich Steinmeyer General Remarks In private non state pensions systems usually three actors Employer

First European i2b2 Academic User Meeting IDRT: Unlocking Research Data Sources with ETL for use in a Structured Research Database The IDRT Team (in alphabetical order): Christian Bauer (presenter), Benjamin

Diss. ETH No. 16766 Maintaining Consistency in Collaboration over Hierarchical Documents A dissertation submitted to the SWISS FEDERAL INSTITUTE OF TECHNOLOGY ZURICH for the degree of Doctor of Sciences

Possible Solutions for Development of Multilevel Pension System in the Republic of Azerbaijan by Prof. Dr. Heinz-Dietrich Steinmeyer Introduction Multi-level pension systems Different approaches Different

Long-term archiving of medical data new certified cloud-based solution offers high security and legally approved data management The European Centre of Expertise for the Health Care Industry Langzeitarchivierung

Support Technologies based on Bi-Modal Network Analysis H. Agenda 1. Network analysis short introduction 2. Supporting the development of virtual organizations 3. Supporting the development of compentences

Inequality Utilitarian and Capabilities Perspectives (and what they may imply for public health) 1 Utilitarian Perspectives on Inequality 2 Inequalities matter most in terms of their impact onthelivesthatpeopleseektoliveandthethings,

Micro compact car smart gmbh smart forfour series w454 Visualization Embeded into the design team of MCC Smart our team was responsible for Class-A surface modelling and for setup of the visible interior

UNIVERSITÄT JOHANNES KEPLER LINZ JKU Technisch-Naturwissenschaftliche Fakultät Working Sets for the Principle of Least Privilege in Role Based Access Control (RBAC) and Desktop Operating Systems DISSERTATION

p^db=`oj===pìééçêíáåñçêã~íáçå= Error: "Could not connect to the SQL Server Instance" or "Failed to open a connection to the database." When you attempt to launch ACT! by Sage or ACT by Sage Premium for

International Week 2015 The poetry of school. The pedagogy of transfers and transitions at the Lower Austrian University College of Teacher Education(PH NÖ) Andreas Bieringer In M. Bernard s class, school

Delivering services in a user-focussed way - The new DFN-CERT Portal - 29th TF-CSIRT Meeting in Hamburg 25. January 2010 Marcus Pattloch (cert@dfn.de) How do we deal with the ever growing workload? 29th

SAP PPM Enhanced Field and Tab Control A PPM Consulting Solution Public Enhanced Field and Tab Control Enhanced Field and Tab Control gives you the opportunity to control your fields of items and decision

Exercise (Part XI) Notes: The exercise is based on Microsoft Dynamics CRM Online. For all screenshots: Copyright Microsoft Corporation. The sign ## is you personal number to be used in all exercises. All

USBASIC SAFETY IN NUMBERS #1.Current Normalisation Ropes Courses and Ropes Course Elements can conform to one or more of the following European Norms: -EN 362 Carabiner Norm -EN 795B Connector Norm -EN

DISS. ETH NO. 18787 Application-level System and Tool Support for Auto-ID Application Development A dissertation submitted to the ETH ZURICH for the degree of Doctor of Sciences presented by Matthias Lampe

English Version 1 UNIGRAZONLINE With UNIGRAZonline you can organise your studies at Graz University. Please go to the following link: https://online.uni-graz.at You can choose between a German and an English