Transcript WELCOME [www.dw.indianrail.gov.in]

Customer Case Study (HP Customer)
Passenger Reservation Systems and related
Websites
in
Indian Railways
By
Deepak Chhabra
Group General Manager (Webservices)
Email id :- [email protected]
7/7/2015
Centre for Railway Information Systems (Confidential)
1
GROWTH OF PASSENGER TRAFFIC
OVER YEARS (in Millions)
Year
1950-51
1960-61
1970-71
1980-81
1990-91
1995-96
2000-01
2001-02
2002-03
7/7/2015
Suburban
all classes
412
680
1219
2000
2259
2484
2861
2999
2934
Non Suburban
second class
847
899
1196
1602
1580
1507
1932
2053
2037
Centre for Railway Information Systems (Confidential)
Total
1284
1594
2431
3613
3858
4018
4833
5093
4971
2
Major Projects






Country Wide Network for Computerised
Enhanced Reservation (CONCERT)
Web Enabling of CONCERT
National Train Enquiry Services (NTES)
Web enabling of NTES
Season Ticketing
Data Warehousing
7/7/2015
Centre for Railway Information Systems (Confidential)
3
Projects handled by PRS Group









CONCERT Implementation on VAX Systems in 1998-99.
Porting of CONCERT in PRS/Sec’bad
– 22 Sept, 94
Porting of CONCERT in PRS/New Delhi
– 9 Sept, 96
PRS/NDLS and PRS/Sec’bad Networked
– 8 Oct, 97
Porting of CONCERT in PRS/Kolkata
– 15 June, 98
Networking between PRS/Kolkata,
PRS/NDLS and PRS/Sec’bad
– 19 July, 98
Porting of CONCERT in PRS/Mumbai
– 11 Jan, 99
Mumbai Networked with Delhi, Kolkata & Sec’bad
– 31 Jan, 99
Chennai Networked with Mumbai,
– 18 Apr, 99
Delhi, Kolkata & Sec’bad
7/7/2015
Centre for Railway Information Systems (Confidential)
4
Projects handled by PRS Group










NTES implementation on 1.8.1998 at Northern Railway.
Y2K Compliance Project for PRS Systems.
Website on internet enquiries launched in 1999-2000.
Season Ticketing Project launched in June’2001.
NTES Phase-II implemented in Aug-Sep, 2001 at all PRS sites.
Alpha Migration from VAX to ALPHA Systems on all sites in Sep-Oct, 2001.
RTR migration in March-June, 2002 at all PRS sites.
Implementation of E-Reservation from Oct 2001 to Aug., 2002 for IRCTC.
UTS implemented on NR at 10 stations on 15th August, 2002 and 13 more
stations of Northern Railway on 2nd October, 2002.
UTS implemented at Gorakhpur, Patna & Kolkata
7/7/2015
Centre for Railway Information Systems (Confidential)
5
CONCERT
(Country Wide Network of Computerised
Enhanced Reservation and Ticketing )





Integrates five Regional Reservation Centres
Judicious mix local autonomy with uniformity
of business rules.
Very complex Business transactions.
Less than 1 sec for local transaction and 3 sec
for network transaction.
Comprehensive functionality
7/7/2015
Centre for Railway Information Systems (Confidential)
6
CONCERT NETWORK TOPOLOGY
kolkata PRS
Delhi PRS
2 MBPS (x2) Leased
Line
Mumbai PRS
2 MBPS (x2) Leased
Line6
2 MBPS (x2) Leased
Line
Secunderabad PRS
2 MBPS Leased Line
Delhi
2 MBPS Leased Line
2 MBPS (X 2) Leased
Line
Calcutta
Mumbai
SecBad
7/7/2015
Chennai PRS
Centre for Railway Information Systems (Confidential)
Chennai
7
Hardware Used in CONCERT
Hardware
Delhi
Mumbai
Kolkatta
Chennai
S’Bad
1. ES 40
2
2
2
2
-
2. ES 45
1
1
1
1
1
3. DS 20E
2
2
1
1
3
4. RAID
1
1
1
1
1
CRIS has been selected as one of the top ten companies
by M/s. HP through an event organized by MIS –
Singapore based Magazine for issuing tickets to 1 million
passengers /day using minimal hardware
7/7/2015
Centre for Railway Information Systems (Confidential)
8
ENVIRONMENT






Operating System – Open VMS version 7.3-2
Database – In-house CRIS proprietary
Middleware – Digital’s Reliable Transaction
Router (RTR 4.2)
Networking protocol – DECNET
Front End – VAX Forms, C and FORTRAN as
development tools
Communication Systems – CISCO routers
and 2 Mbps BSNL lines
Network Topology – partially connected mesh
topology.
7/7/2015
Centre for Railway Information Systems (Confidential)
9
PREVIOUS SET UP AT PRS/DELHI
FDDI CONC
SWITCH
VAX
4705
VAX
VAX
4705
7610
HUB
TS
TS
MUX
CI
DSSI
LD
Fiber
MODEM
LD
MODEM
Ethernet
Storage
T
VT1300
7/7/2015
Centre for Railway Information Systems (Confidential)
RT
MUX
VT1300
10
CONCERT APPLICATION ARCHITECTURE
Press
Touch
Screen
IVRS
Tele-Booking
Internet
Users
WEB
Reservation
Charting
IRCTC
Database
Enquiry
Server
Internet Client
FireWall
CONCERT Interconnect Bus
Delhi
Servers
DB
7/7/2015
Mumbai
Chennai
Sec’bd
Kolkata
Servers
Servers
Servers
Servers
DB
DB
DB
DB
Centre for Railway Information Systems (Confidential)
11
FEATURES OF CONCERT

Performs
reservations
for
over
8,82,000 seats and berths (during
peak rush it goes to as high as
10,17,000) per day




Available on over 2,998 trains nationwide for various classes
Bookings for over 7,000 destinations
4,262 reservation terminals
Across about 1,171 locations.
7/7/2015
Centre for Railway Information Systems (Confidential)
12
Load on PRS
S.No.
PRS Node
1.
Delhi
2.
Trains
Terminals
Locations
Peak no.
of Psgns/
day
(in lakhs)
Avg. no.
of Psgns/
day
(in lakhs)
1020
1317
337
2.75
2.52
Mumbai
686
957
236
3.14
2.42
3.
Kolkata
630
927
314
1.81
1.70
4.
Chennai
370
618
147
1.65
1.46
5.
Sec’bad
292
443
85
0.81
0.72
2998
4262
1171
10.17
8.82
TOTAL
7/7/2015
Centre for Railway Information Systems (Confidential)
13
Passenger Reservation Load
PASSENGER RESERVATION SYSTEM LOAD
PRS NODE
Trains
Locations
Terminals
PEAK NO OF
PASSENGERS
PER DAY (IN
LAKHS)
AVERAGE NO OF
PASSENGERS
PER DAY (IN
LAKHS)
2001
2005
2001
2005
2001
2005
2001
2005
2001
2005
Delhi
781
1099
153
338
886
1417
2.31
3.03
1.83
2.52
Mumbai
532
686
100
233
640
998
2.01
4.1
1.41
3.12
Calcutta
365
630
102
374
425
1066
1.22
2.73
1.01
1.81
Chennai
271
372
76
186
310
639
1.35
2.31
1.1
1.78
Secunderbad
279
293
59
101
250
499
0.56
0.83
0.4
0.72
Total
2228
3080
490
1232
2511
4619
7.45
13
5.75
9.95
7/7/2015
Centre for Railway Information Systems (Confidential)
14
REPORT OF TOTAL NO OF TERMINALS/
LOCATIONS AT ALL PRS (Jan 2006)
SITE
NO.OF LOCATIONS
TERMINALS
MUMBAI
234
1008
KOLKATA
392
1175
DELHI
339
1455
CHENNAI
186
662
SECUNDERABAD
83
495
TOTAL
1234
4795
7/7/2015
Centre for Railway Information Systems (Confidential)
15
REPORT OF RECEIPT/REFUND/NET EARNING SITEWISE
JAN 2006
PRS
TOTAL
RECEIPT
MUMBAI
232 Crores
KOLKATA
164 Crores
DELHI
234 Crores
CHENNAI
128 Crores
SECUNDERABAD
54 Crores
7/7/2015
TOTAL REFUND
62 Crores(26%)
40 Crores(24%)
NET
EARNING
170 Crores
124 Crores
50 Crores(21%)
184 Crores
31 Crores(24%)
97 Crores
13 Crores(24%)
41 Crores
Centre for Railway Information Systems (Confidential)
16
REPORT OF NUMBER OF PASSENGER BOOKED/ CANCELLED
SITEWISE
%AGE TO TOTAL LOAD OF ALL
PRS
PRS
SECUNDERABAD
7.96/8.36
KOLKATA
25.93/ 22.56
DELHI
18.39/ 19.26
CHENNAI
19.94/ 19.73
MUMBAI
27.81/ 30.11
TOTAL
100.00/100.00
7/7/2015
Centre for Railway Information Systems (Confidential)
17
PERCENTAGE OF NETWORK
LOAD OF EACH PRS (JAN ‘06)
PRS
SEC
FOR SEC
FOR DLI
61.47/ 56.63
5.60/
FOR MAS
6.11
15.29/ 18.10
8.50/
9.16
3.38
8.15/
8.69
7.19/
8.97
85.22/ 84.22
2.10/
2.28
5.84/
6.88
74.62/ 72.27
6.24/
7.49
0.90/
0.98
MAS
2.93/
2.71
HWH
2.14/
2.25
12.21/ 11.96
4.81/
6.06
BB
2.36/
2.27
15.64/ 16.01
5.84/
6.61
6.75/
6.60
7/7/2015
3.93/
3.93
28.96/ 26.04
FOR BB
9.17/ 10.03
DLI
Total
81.06/ 78.00
FOR HWH
2.71/
20.17/ 21.68
5.30/
5.69
19.58/ 19.21
70.88/ 69.44
24.57/ 26.50
Centre for Railway Information Systems (Confidential)
18
Benefits of PRS to the
Passengers







Transparency
Universal counters for booking
Instant update of status
Instantaneous enquiry
Reduced waiting time
Reservation available at a number of
locations in the country
Customer satisfaction
7/7/2015
Centre for Railway Information Systems (Confidential)
19
Benefits of PRS to the Railways








Increased efficiency
Optimal utilisation of berths
Real time availability of Accounting Reports
Planning through MIS reports
Analysis of traffic pattern for better overall
planning
Reduction in Revenue losses
Saving on Manpower
Eliminate possibilities of fraud
7/7/2015
Centre for Railway Information Systems (Confidential)
20
Meeting unique requirements
% Availability
100% Availability
Objective
(Application Level)
Hours Lost/Year
99.99%
P/Sysplex, Himalaya
2.2
99.9%
Single Mainframe
8.7
99.8%
AS/400, OpenVMS, HP3000
17.5
99.6%
Solaris, HP-UX, Tru64, AIX
35.0
99.2% NT and Microsoft Cluster Server
7/7/2015
Centre for Railway Information Systems (Confidential)
69.9
21
Gartner Group, 2001
PRS – Website
www.indianrail.gov.in


CRIS has implemented and hosts Indian Railway’s
own web-site, namely www.indianrail.gov.in and
offers PRS enquiries on the internet namely

Trains between a pair of Stations

Accommodation Availability

PNR Status Enquiry

Train Schedule/Fares

Station Code Enquiry

Short Messaging Service (SMS) on Mobile
A maximum of 35 lakh hits per day have been
recorded
7/7/2015
Centre for Railway Information Systems (Confidential)
22
PRS Website ENVIRONMENT



Computers (Hardware) – DS20s and DS10s
Operating System – TruUnix 64 and Open VMS
version 7.3.2
Middleware – Digital’s
Router (RTR 4.2)
Reliable
Transaction

Networking Protocol – DECNET and TCP/IP

Firewall – Raptor EC version 4.1


Communication Systems – CISCO routers using
2 Mbps and 64kbps DOT lines
Web Server - Apache 7.3.27
7/7/2015
Centre for Railway Information Systems (Confidential)
23
Enquiries on
www.indianrail.gov.in

Trains between a pair of stations
This enquiry gives all the trains between the selected source
and destination station

Accommodation availability
This enquiry gives the latest seat availability position of the
chosen class, date, train and route.

PNR status enquiry
This enquiry gives the latest updated status of the passenger

Train Schedule
This enquiry gives the complete path information of a
particular train with the arrival and departure time at a
station.
7/7/2015
Centre for Railway Information Systems (Confidential)
24
Static Information on
www.indianrail.gov.in




Rules
Reservation Rules, Refund Rules, Break Journey Rules, Luggage Rule,
Change in Name
General Information
Season Tickets, Circular Journey, Booking Locations, Concession Forms
for Blind, Orthopaedically handicapped, Mentally retarded and Deaf &
Dumb persons, General Reservation Form, Tele Booking, Tatkal
Booking
Tourist Information
International tourists information, Travel Agents
Special Trains
Palace on Wheels, Royal Orient Express, Hill Trains, Shivalik
Deluxe/Palace Trains, Holiday Specials, Tatkal Trains, Rajdhani Trains,
Shatabadi Trains
7/7/2015
Centre for Railway Information Systems (Confidential)
25
Enquiries on Cell Phones
through SMS






7/7/2015
Train Schedule
PNR Status
Accommodation Availability
Trains between stations
Fare
Available on Short code

676747

7886

8888
Centre for Railway Information Systems (Confidential)
26
FORMAT/ KEY to send SMS

Access No.: 676747 (IDEA, AIRTEL, BPL, BSNL)

To get your Ticket Status
PNR <PNR No.>

Checking for Trains running between two stations

TL < starting city > < ending city>

Checking for Ticket Availablity
TA <train number > <starting city> <ending city>
<journey date >
7/7/2015
Centre for Railway Information Systems (Confidential)
27
PRS Website (www.indianrail.gov.in)
Number of Hits per month
100,000,000
90,000,000
80,000,000
70,000,000
60,000,000
50,000,000
40,000,000
30,000,000
20,000,000
10,000,000
0
S eries1
J an.' 03
Feb.' 03
Mar.' 03
Apr.' 03
May' 03
J une' 03
J uly '03
August ' 03
S ept ' 03
Oct ' 03
Nov' 03
Dec.'03
J an.' 04
Feb. 04
Mar.04
Apr.'04
53,933,411
53,212,613
61,234,321
87,036,366
92,795,543
94,756,432
59,180,971
66,755,856
67,477,370
78,996,435
77,773,346
66,685,507
48,011,688
40,579,784
46,292,690
60,372,821
7/7/2015
Centre for Railway Information Systems (Confidential)
28
PRS Website (www.indianrail.gov.in)
Number of SMS Hits per month
700,000
600,000
500,000
400,000
300,000
200,000
100,000
0
Jan.' 03
Feb.' 03
Mar.' 03
Apr.' 03
May' 03
June' 03
July '03 August' 03 Sept' 03
Oct' 03
Nov' 03
Dec.'03
Jan.' 04
Feb. 04
Mar.04
Apr.'04
Series1 314,042
365,770
355,441
509,737
519,022
515,175
319,062
485,478
434,524
580,365
628,573
504,354
516,061
634,249
7/7/2015
270,683
350,456
Centre for Railway Information Systems (Confidential)
29
PRS System Level Failures
handled
Year
 2000
 2001
 2002
 2003
 2004
 2005
7/7/2015
No. of Failures handled
23
20
38
28
40
8
Centre for Railway Information Systems (Confidential)
30 30
Future Enhancements on
www.indianrail.gov.in


Improvements in the response time in the
Dynamic (PNR and Seat availability) enquiries.
Other transport information (Road/Air/Water) for
major tourist locations

Dynamic Enquiries in Hindi

Providing dynamic enquiries for 24 hours.
7/7/2015
Centre for Railway Information Systems (Confidential)
31
National Train Enquiry System
(NTES)

National Train Enquiry System is a
nationwide
integrated
on-line
information system for monitoring
running of passenger trains and
providing
reliable
updated
information regarding arrival and
departure of trains to passengers.
7/7/2015
Centre for Railway Information Systems (Confidential)
32
Technology used

Hardware


DS20 Alpha machines under Tru 64 Unix
4.0 f
Software


7/7/2015
C,RTR 3.2
Sybase with Replication
Centre for Railway Information Systems (Confidential)
33
National Train Enquiry System
(NTES)
Real Time Information of Train arrival / departure
disseminated through :

Display Boards

Interactive Voice Response System (IVRS)

Automatic Announcement System

Face to Face Enquiry counters

Internet (web site launched at www.trainenquiry.com)
7/7/2015
Centre for Railway Information Systems (Confidential)
34
NTES Website
www.trainenquiry.com
National Train Enquiry System is made
available through Internet on
www.trainenquiry.com
 Site provides the following Information






Running Status of Trains
Trains between two Stations
Spot your Train
Train Arrival
Tourist Information
Passenger Amenities at Station
7/7/2015
Centre for Railway Information Systems (Confidential)
35
Enquiries on NTES Website

Spot Your Train


Find your Train


Trains arriving/Departing at a given station in next few
hrs
Train Time Table


Trains between two stations
Arrivals/Departures


Gives the running status along with the delay marked for
a train at a station
Schedule Arrival/Schedule Departure
Passing Through Trains

Shows a list of trains passing through a station.
7/7/2015
Centre for Railway Information Systems (Confidential)
36
E-RESERVATION PROJECT FOR
IRCTC


The e-reservation website http://www.irctc.co.in was
inaugurated on 3rd August 2002.
The software developed by CRIS consists of:





Complete interface software between the IRCTC front-end
server and the back end Alpha server.
Complete e-reservation and enquiries back end servers.
Ticket printing and reset facilities in existing client.
Accounting reports for the IRCTC transactions.
Combination of HP and Intel.
7/7/2015
Centre for Railway Information Systems (Confidential)
37
New challenges



Maintenance by remote login by vpn
By HP engineers in US or Bangalore
Regular proactive patch updation
7/7/2015
Centre for Railway Information Systems (Confidential)
38
SCOPE

Passenger Coaching Refunds System
(PCRS) meant for Tickets issued with
reservations refund can be given through
PRS for the cases


Reporting before 12 hrs after departure of the
train
Who are reported after 12 hrs of the departure
of the train
7/7/2015
Centre for Railway Information Systems (Confidential)
39
Frequent Rail Traveller’s Scheme





FRTC club opened, Registration Fees is Rs.
500 per year valid for three years and
Renewal Fees is Rs. 300.
Off peak Period – 15 January – 31 March
and 15 July – 15 September.
Points awarded for 10% of the total
amount and in peak period 2% .
Scheme applicable for all classes except 3
AC in Rajdhani, Shatabdi & Jan Shatabdi
Trains.
PRS Software to be modified to store Card
number
and Journey details.
7/7/2015
40
Centre for Railway Information Systems (Confidential)
Data Warehousing



Data warehouse on PRS is a collection of passenger
information from 5 PRS sites intended for management
reporting and decision making. It will facilitate the
management to analyse the following:
Earnings

Passenger Traffic

Wait List Analysis
On daily weekly, monthly and yearly basis for premium
train types, classes and pair of stations.
Extraction/Transformation/Loading layers of processing is
developed in house.
7/7/2015
Centre for Railway Information Systems (Confidential)
41
Thanks
7/7/2015
Centre for Railway Information Systems (Confidential)
42