European rail vehicle and infrastructure databases study
Mick Haynes, Project Director, and the Atos consultancy team
European rail vehicle and infrastructure databases study - - PowerPoint PPT Presentation
European rail vehicle and infrastructure databases study Presentation of final report Mick Haynes, Project Director, and the Atos consultancy team NMBS/SNCB HQ Brussels 5th October 2011 Agenda 1. Welcome 2. Introduction and background
Mick Haynes, Project Director, and the Atos consultancy team
2
▶ 1. Welcome ▶ 2. Introduction and background ▶ 3. Overview of the study ▶ 4. Results of the questionnaires and interviews ▶ 5. Presentation of the main ‘gaps’ ▶ LUNCH ▶ 6. Introduction to the solution – principles ▶ 7. Impact on the existing architecture – 7.1 Databases – 7.2 Interfaces – 7.3 Pointers ▶ 8. Technical feasibility ▶ 9. The way forward – Phasing – Costs and benefits – Governance ▶ 10. Summary and discussion
3
4
“Before taking any decision on the technical aspect of a real-time data exchange system, there is a need for a detailed overview on data requirements which arise from the European Railway Regulatory Framework, including Safety and Interoperability Directives (and the related secondary legislation e.g. technical specifications for interoperability), on market needs for real time data exchange, and on existing IT applications in operation or being developed in Europe. The study will determine if these applications make it possible to fulfil the
from the technical, governance and financial aspects. Finally, the study will examine the technical and economic feasibility of it.”
5
6
7
8
9
10
11
▶ Difficulty with integrating a new system with other existing systems.
▶ Many existing systems have been in operation for many years, some are decades old, with obsolete platforms and various other incompatibilities.
▶ Difficulties with data quality, especially from external parties.
▶ This can force the need for costly data checking and manual correction processes negating the system benefits. On the other hand, other organisations reported improvements in data quality
▶ Benefits for processes that had previously relied on paper documents, and low tech office tools like fax and e-mail.
▶ Benefits were reported by most organisations from the various systems they had implemented
▶ Benefits due to system making data available to organisations not directly involved.
▶ Example given was engineering being able to use vehicle movement information to improve maintenance and reduce costs
12
13
▶ however stakeholders pointed to a substantial measure of compliance and to developments that would increase the level of compliance.
▶ In particular proprietary databases should not be mandated, for example
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
No Description TAF (or other) Message/interface Solution changes 1 Maintenance Data/Wagon restrictions/Performance As described in the Conventional Freight TSI, the RU will require maintenance/restriction data to assure themselves of the vehicles fitness to run. Additionally the RU should provide performance data back to ECM/keeper to allow for future maintenance planning 2006/861/EC – Section 4.2.8.1.2 None suitable RU will request maintenance/restriction data (see also flows 3, 5) from the relevant keeper database (RSRD). The relevant RSRD will be identified by initial querying of the pointer file and the data may be retained in the RU traffic database as a date series to ensure it is up to date and as accurate as possible Additional messages required : 1. From RU to pointer file to update RU using the vehicle number obtained from HERMES interchange message 2. From RU to pointer file to identify keeper database and reply
for a vehicle and reply
and reply
system
maintenance/performance data/stop-release. W e propose the HERMES “Goethe” message to be considered as a possible model for provision of wagon use/performance information by RUs to keepers
Data exchange required Existing defined message Proposed solution
34
35
36
– Gap solutions – Data groups – Principles – Technical data – Performance data – Journey data – Traffic data – Pointer files – Messages
37
▶ GAP ▶ RUs access to vehicle technical data ▶ Vehicle performance data to keepers ▶ Incident data to customers ▶ Improvements to wagon order ▶ Vehicle & intermodal search ▶ Keeper access to certain vehicle info ▶ Handover / interchange standardise ▶ Access to infrastructure data ▶ Train composition ▶ Missing train ID ▶ SOLUTION ▶ Distributed RSRD with pointer, H30 in the interim ▶ Revised messages between RUs & keepers to distributed RSRD ▶ Uses H30 which already includes incident messages from RU to keepers ▶ Wagon order enhanced to include the data each RU needs according to its role ▶ New enquiry messages. Intermodal identity to be referenced ▶ LRU to provide data via new message ▶ Agree solution and valid variances on standard interchange message. Include driver advisory notice ▶ Resolve process and message structures ▶ Provide two versions and mandate use ▶ New message flows to resolve
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
▶ GAP ▶ RUs access to vehicle technical data ▶ Vehicle performance data to keepers ▶ Incident data to customers ▶ Improvements to wagon order ▶ Vehicle intermodal search ▶ Keeper access to certain vehicle info ▶ Handover / interchange standardise ▶ Access to infrastructure data ▶ PRIORITY / PHASE ▶ Priority 1 via H30 ▶ Priority 2 ▶ Priority 1 via H30 ▶ Priority 2 ▶ Priority 1 for wagons, 2 for intermodal ▶ Priority 2 ▶ Priority 1 for interchange, 2 electronic ▶ Priority 3
61
62
63
64
– RI type RUs will need to modify their systems to support new interfaces and modified fields. They will probably already be using RAILDATA so they can fast track development and implementation using their TSI support. They will already support international freight messaging.
– R2 type RUs will need to enhance their systems to support new functions and interfaces and new and modified fields. Some will already be using RAILDATA so can fast track using their TSI support. Already support international freight messaging.
– R3 type RUs will need to modify their national procedures to support the TSI processes messages and interfaces applicable to them. This will need to be done in conjunction with their IM as it impacts traffic messages.
– R4 type RUs will need a small system to support the three basic functions of train composition, path request and train running. This should form the minimum package.
– R5 type RUs should only need to support the HERMES interchange message as they would use online access to the IMs traffic system for traffic purposes.
65
▶ Category I1 - Large IMs with sophisticated IT and multiple RUs as customers ▶ Category I2 - Small to medium sized IMs with less sophisticated IT and only a few RUs as customers.
▶ Category K1 - Large RUs with their own fleet for which they act as wagon keepers. ▶ They will already hold a wagon database which will require small enhancements to meet the RSRD requirements. ▶ Category K2 - Independent wagon owners and operator belonging to the UIP. ▶ They will use the new RSRD2 ▶ Category K3 - Small RUs without a wagon database suitable for RSRD and small wagon keepers not members of the UIP
▶ Category E1 - RUs responsible for their own maintenance and maintenance staff. ▶ They will need to ensure maintenance and defect data is recorded and interfaced in accordance with the TSI ▶ Category E2 - Independent maintainers. ▶ These are maintainers who do not have an RU safety certificate and do not operate trains. They maintain rolling stock under contract with the keeper.
66
67
Type of development On modern web based technology On mainframe technology On bespoke small computers (SMEs) New simple interface 4335 5202 3685 New complex interface 8160 9792 6936 Modified simple interface 3655 4386 3107 Modified complex interface 5610 6732 4768 New RS database 29155 34986 24782 New Ops Database 37740 45288 32079 New INF database 24225 29070 20591 Modified RS database 15342 73644 13041 Modified Ops Database 20995 100776 17846 Modified INF database
68
69
70
Overall benefit calculation Category Estimated No of each Benefits from lower staffing costs each Benefits from lower IT costs each Total benefits
R1 20 1150000 904428 41088560 R2 40 500000 753690 50147600 R3 75 250000 599021 63676537 R4 10 25000 60710 857104 R5 100 60710 6071040 I1 25 675000 55598 18264960 I2 35 175000 46332 7746620 K1 60 250000 67932 19075920 K2 70 175000 56610 16212700 K3 45 175000 48119 10040333 E1 50 262500 13125000 E2 100 87500 8750000 Overall total 142,000,000 113,056,374 255,056,374
71
72
73
▶ User driven – Driven by the industry to further rail interests ▶ Impartiality – Interests balanced between roles, railway undertakings, infrastructure managers, keepers etc. large and small ▶ Common tasks – Sets standards – Manages users – Manages changes ▶ Efficiency – Inspired by the conviction that the objective is to run an effective service
74
75
76
– Databases
– Interfaces
– Phasing
TIS and Raildata ISR – Benefits of the recommendations
implementations
can be expected