Deliverable 5.1 : Description of Pilot Sites Specifications

Executive Summary

The project TITAN, supported by the European Union, concerns validation and further development of the European Reference data model for Public Transport ("Transmodel"). For this purpose, demonstrators are implemented in three pilot sites, aiming at the integration of different software applications by means of a relational database defined in accordance with the Transmodel principles and architecture. The companies implementing the demonstrators expect significant benefits from a re-organised information management and increased possibilities to exploit their information basis. During the implementation, possible improvements of Transmodel may be discovered, and practical experiences will be used to refine the reference data model. This implies the validation of its feasibility for realisations in different real world conditions.

This report summarises the results of the specification phase of the development process, based on the analysis and design work which has been largely finalised in the pilot sites. The information architecture of the demonstrators to be realised in the three sites forms the core of the presentations, as the main interest of the user community may be to learn how far the Transmodel structures and definitions are suitable for practical implementation work undertaken by public transport companies with different specific conditions and requirements.

A common framework of methods agreed on the consortium level was applied by the three sites for their development activities. This refers mainly to the data modelling methodology and the principles of documentation, and does also apply to the description of functional areas to be covered by the demonstrators in question. European standards were used as far as possible for these tasks.

The conceptual data models developed by the pilot sites as a starting point for their database definition are largely based on Transmodel as a reference. The main differences and modifications of the site-specific models in comparison to Transmodel are explained in the information architecture chapter of this deliverable, whereas the data models themselves are presented by diagrams, repository descriptions and a detailed comparison with Transmodel in separate appendixes.

The management architecture of the demonstrators refers to the guidelines for the development process and to the organisational concept for the integrated information systems to be realised. The organisation of the future system is of particular importance for the level of benefits to be gained from the integration process. In addition to the physical implementation of the central TITAN database in the pilot sites and of the software modules necessary to couple the public transport applications to the database, rules and guidelines for data administration, as well as for database administration and handling of the overall information system have to be defined as a precondition to keep the information management in working order, and to allow for an optimised utilisation of the database within the whole company.

Based on the information architecture and the management architecture, which determine the data needs and functional requirements to be met by the software modules to be implemented, specifications were elaborated to prepare the programming and database implementation phase. Logical data models were derived from the conceptual models by applying standard methods for generating normalised relational tables from the conceptual model. Some controlled and well-balanced modifications and optimisations of the logical models were carried out by all three sites in order to increase the performance of data retrieval and improve the efficiency of disk space usage, and to achieve a better adaptation to the needs of existing software packages in some cases.

The software specifications formulated as a basis for the implementation of interface programs, and of other modules to be realised as a part of the demonstration systems, reflect the genuine characteristics of the existing software packages and of the information management concepts applied by the pilot sites. This report only presents the general framework and basic principles of the specification work undertaken by the sites, which resulted in comprehensive internal documents formulated in the national languages, and which are not publicly available.

As a conclusion, all three sites would rate their efforts in favour of the implementation of a Transmodel-based integrated information system as successful, and are willing to continue their investments in the realisation of the demonstrators and in the TITAN project. Transmodel has proven to be a useful basis for the development, which largely contributed to an efficient analysis and design process, as well as to an improved understanding of the overall information basis of the company and to a better quality of data and the data management process in general.