hp(le meridian)-17feb2006 (1)

8/8/2019 hp(Le Meridian)-17Feb2006 (1)

http://slidepdf.com/reader/full/hple-meridian-17feb2006-1 1/42

10/18/2010 Centre for Railway Information Systems (Confidential) 1

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]




GROWTH OF PASSENGER TRAFFIC

OVER YEARS (in Millions) Year Suburban Non Suburban Total

all classes second class

1950-51 412 847 1284

1960-61 680 899 1594

1970-71 1219 1196 2431

1980-81 2000 1602 36131990-91 2259 1580 3858

1995-96 2484 1507 4018

2000-01 2861 1932 4833

2001-02 2999 2053 5093

2002-03 2934 2037 4971




Major Projects

Country Wide Network for ComputerisedEnhanced Reservation (CONCERT)

Web Enabling of CONCERT

National Train Enquiry Services (NTES) Web enabling of NTES

Season Ticketing

Data Warehousing




Projects handled by PRS Group

CONCERT Implementation on VAX Systems in 1998-99.

Porting of CONCERT in PRS /Secbad 22 Sept, 94

Porting of CONCERT in PRS /New Delhi 9 Sept, 96

PRS

/NDLS and

PRS

/Secbad Networked

8Oct,

97

Porting of CONCERT in PRS /K olkata 15 June, 98

Networking between PRS /K olkata,PRS /NDLS and PRS /Secbad 19 July, 98

Porting of CONCERT in PRS /Mumbai 11 Jan, 99

Mumbai Networked with Delhi, K olkata & Secbad 31 Jan, 99

Chennai Networked with Mumbai, 18 Apr, 99Delhi, K olkata & Secbad




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 ALPH A 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 & K olkata




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




CONCERT NETWORK TOPOLOG YCONCERT NETWORK TOPOLOG Y

Delhi PRS

Mumbai PRS

Chennai PRS

kolkata PRS

Secunderabad PRS

2 MBPS (x2) Leased

Line

2 MBPS (x2) Leased

Line6

2 MBPS Leased Line

2 MBPS (X 2) Leased

Line

2 MBPS Leased Line

2 MBPS (x2) Leased

Line

Delhi

SecBad

Calcutta

Mumbai

Chennai




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 companiesby M/s. HP through an event organized by MIS ±

Singapore based Magazine for issuing tick ets to 1 million

passengers /day using minimal hardware




ENVIRONMENTy Operating System Open VMS version 7.3-2

Database In-house CRIS proprietary

y Middleware Digitals Reliable TransactionRouter (RTR 4.2)

y Networking protocol DECNET

y Front End VAX Forms, C and FORTRAN asdevelopment tools

y Communication Systems CISCO routersand 2 Mbps BSNL lines

y Network Topology partially connected meshtopology.




PREVIOUS SET UP AT PRS/DELHIPREVIOUS SET UP AT PRS/DELHIFDDI CONC

VT1300

SWITCH

TS

VT1300

DSSICI

LD

LD

MODEM

MODEM

TS

HUBVAX

4705

VAX

4705

VAX

7610

T RT

MUX

MUX

Fiber

Ethernet

Storage




CONCERT Interconnect Bus

R eservation Charting DatabaseIRCTC Enquiry

Delhi

Servers

DB

Mumbai

Servers

DB

Chennai

Servers

DB

Sec¶bd

Servers

DB

Kolkata

Servers

DB

IVRSTele-Booking

Touch

ScreenPress

CONCERT APPLICATION ARCHITECTURE

Internet Client

FireWall

WEBServer

Internet

Users




Performs reservations for over8,82,000 seats and berths (duringpeak rush it goes to as high as10

,17

,000

) per day Available on over 2,998 trains nation-

wide for various classes

Bookings for over 7,000 destinations

4,262 reservation terminals

Across about 1,171 locations.

FEATURES OF CONCERT




S.No. PRS Node Trains Terminals Locations Peak no.

of Psgns/day

(in lakhs)

Avg. no.

of Psgns/day

(in lakhs)

1. Delhi 1020 1317 337 2.75 2.52

2. Mumbai

686 957 236 3.14 2.42

3. K olkata 630 927 314 1.81 1.70

4. Chennai 370 618 147 1.65 1.46

5. Secbad 292 443 85 0.81 0.72

TOTAL 2998 4262 1171 10.17 8.82

Load on PRSLoad on PRS




Passenger Reservation Load

PRS NODE

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

PEAK NO OF

PASSENGERS

PER DAY (IN

LAKHS)

AVERAGE NO OF

PASSENGERS

PER DAY (IN

LAKHS)

PASSENGER RESERVATION SYSTEM LOAD

Trains Locations Terminals




REPORT OF TOTAL NO OF TERMINALS/

LOCATIONS AT ALL PRS (Jan 2006)

SITE NO.OF LOCATIONS TERMINALS

MUMBAI 234 1008

K OLK ATA 392 1175

DELHI 339 1455

CHENNAI 186 662

SECUNDERABAD 83 495

TOTAL 1234 4795




REPORT OF RECEIPT/REFUND/NET EARNING SITEWISE

JAN 2006

PRS TOTALRECEIPT

TOTAL REFUND NETEARNING

MUMBAI

232 Crores 62 Crores(26%) 170 Crores

K OLK ATA 164 Crores40 Crores(24%)

124 Crores

DELHI 234 Crores 50 Crores(21%) 184 Crores

CHENNAI 128 Crores31 Crores(24%) 97 Crores

SECUNDERABAD54 Crores 13 Crores(24%) 41 Crores




REPORT OF NUMBER OF P ASSENGER BOOK ED / CANCELLED

SITEWISEPRS %AGE TO TOTAL LOAD OF ALL

PRS

SECUNDERABAD 7.96/8.36

K OLK ATA 25.93/ 22.56

DELHI 18.39/ 19.26

CHENNAI19.94/ 19.73

MUMBAI 27.81/ 30.11

TOTAL 100.00/100.00




PRS FOR SEC FOR DLI FOR MAS FOR HWH FOR BB

SEC 61.47/ 56.63 5.60/ 6.11 15.29/ 18.10 9.17/ 10.03 8.50/ 9.16

DLI 0.90/ 0.98 81.06/ 78.00 2.71/ 3.38 8.15/ 8.69 7.19/ 8.97

MAS 2.93/ 2.71 3.93/ 3.93 85.22/ 84.22 2.10/ 2.28 5.84/ 6.88

HWH 2.14/ 2.25 12.21/ 11.96 4.81/ 6.06 74.62/ 72.27 6.24/ 7.49

BB 2.36/ 2.27 15.64/ 16.01 5.84/ 6.61 5.30/ 5.69 70.88/ 69.44

Total 6.75/ 6.60 28.96/ 26.04 20.17/ 21.68 19.58/ 19.21 24.57/ 26.50

PERCENTAGE OF NETWORK

LOAD OF EACH PRS (JAN 06)




Benefits of PRS to thePassengers

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




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




100% AvailabilityObjective

(Application Level)% Availability Hours Lost/Year

99.99%

99.9%

99.8%

99.6%

99.2%

2.2

8.7

17.5

35.0

69.9

P /Sysplex, Him

alayaP /Sysplex, Him

alayaSingle MainframeSingle Mainframe

AS/400, OpenVMS, HP3000AS/400, OpenVMS, HP3000

Solar is, HPSolar is, HP--UX, Tru64, AIXUX, Tru64, AIX

NT and Microsoft Cluster Ser ver NT and Microsoft Cluster Ser ver

Meeting unique requirements

Gartner Group, 2001




PRS Websitewww.indianrail.gov.in CRIS has implemented and hosts Indian Railways

own web-site, namely www.indianrail.gov.in andoffers 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 havebeen recorded




PRS Website ENVIRONMENTy

Computers (Hardware) DS20s and DS10sy Operating System TruUnix 64 and Open VMS

version 7.3.2

y Middleware Digitals Reliable TransactionRouter (RTR 4.2)

y Networking Protocol DECNET and TCP/IP

y Firewall Raptor EC version 4.1

y Communication Systems CISCO routers using2 Mbps and 64kbps DOT lines

y Web Server - Apache 7.3.27




Enquiries onwww.indianrail.gov.in Trains between a pair of stations

This enquiry gives all the trains between the selected sourceand destination station

Accommodation availability

This enquiry gives the latest seat availability position of thechosen class, date, train and route.

PNR status enquiryThis enquiry gives the latest updated status of the passenger

Train ScheduleThis enquiry gives the complete path information of aparticular train with the arrival and departure time at astation.




a c n orma on onwww.indianrail.gov.in

RulesReservation Rules, Refund Rules, Break Journey Rules, Luggage Rule,Change in Name

General Information

Season Tickets, Circular Journey, Booking Locations, Concession Formsfor Blind, Orthopaedically handicapped, Mentally retarded and Deaf &Dumb persons, General Reservation Form, Tele Booking, TatkalBooking

Tourist Information

International tourists information, Travel Agents

Special TrainsPalace on Wheels, Royal Orient Express, Hill Trains, ShivalikDeluxe /Palace Trains, Holiday Specials, Tatkal Trains, Rajdhani Trains,Shatabadi Trains




Enquiries on Cell Phones

through SMS Train Schedule PNR Status Accommodation Availability Trains between stations Fare Available on Short code

676747 7886

8888




FORM AT / K E Y 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 >




PRS Website (www.indianrail.gov.in)

Number of Hits per month

0

10,000,000

20,000,000

30,000,000

40,000,000

50,000,000

60,000,000

70,000,000

80,000,000

90,000,000

100,000,000

Series1 5 3, 93 3, 411 5 3, 212 ,6 13 6 1, 23 4, 32 1 8 7, 03 6, 36 6 9 2, 79 5, 54 3 9 4, 75 6, 43 2 5 9, 18 0, 97 1 6 6, 75 5, 85 6 6 7, 47 7, 37 0 7 8, 99 6, 43 5 7 7, 77 3, 34 6 6 6, 68 5, 50 7 4 8, 011, 68 8 4 0, 57 9, 78 4 4 6, 29 2, 69 0 6 0, 37 2, 82 1

J an.' 03 Feb.' 03 Mar.' 03 Apr.' 03 May' 03 J une ' 03 J uly ' 03 August ' 03 S ept ' 03 Oc t ' 03 Nov' 03 Dec.'03 J an.' 04 Feb. 04 Mar.04 Apr.'04




PRS Website (www.indianrail.gov.in)

Number of SMS Hits per month

0

100,000

200,000

300,000

400,000

500,000

600,000

700,000

Series1 314,042 365,770 355,441 509,737 519,022 515,175 319,062 270,683 350,456 485,478 434,524 580,365 628,573 504,354 516,061 634,249

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




PRS System Level Failureshandled

Year No. of Failures handled

2000 23

2001 20

2002 38

2003 28

2004 40

2005 8




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) formajor tourist locations

Dynamic Enquiries in Hindi

Providing dynamic enquiries for 24 hours.




National Train Enquiry System(NTES)

National Train Enquiry System is anationwide integrated on-line

information system for monitoringrunning of passenger trains andproviding reliable updatedinformation regarding arrival and

departure of trains to passengers.




Technology used Hardware

DS20 Alpha machines under Tru 64 Unix4.0 f

Software

C,RTR 3.2

Sybase with Replication




National Train Enquiry System(NTES)

Real Time Information of Train arrival / departuredisseminated through :

Display Boards

Interactive Voice Response System (IVRS)

Automatic Announcement System

Face to Face Enquiry counters

Internet (web site launched at www.trainenquiry.com)

NTES W b it




NTES Websitewww.trainenquiry.com

National Train Enquiry System is madeavailable through Internet onwww.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




Enquiries on NTES Website

Spot Y our Train

Gives the running status along with the delay marked fora train at a station

Find your Train

Trains between two stations Arrivals /Departures

Trains arriving /Departing at a given station in next fewhrs

Train Time Table Schedule Arrival /Schedule Departure

Passing Through Trains

Shows a list of trains passing through a station.




E-RESERVATION PROJECT FORIRCTC

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.




New challenges Maintenance by remote login by vpn

By HP engineers in US or Bangalore

Regular proactive patch updation




SCOPE Passenger Coaching Refunds System

(PCRS) meant for Tickets issued withreservations refund can be given throughPRS for the cases

Reporting before 12 hrs after departure of thetrain

Who are reported after 12 hrs of the departureof the train




Frequent Rail Travellers Scheme

FRTC club opened, Registration Fees is Rs.

500 per year valid for three years andRenewal Fees is Rs. 300.

Off peak Period 15 January 31 March

and15

July 15

September.

Points awarded for 10% of the totalamount and in peak period 2% .

Scheme applicable for all classes except 3

AC in Rajdhani, Shatabdi & Jan ShatabdiTrains.

PRS Software to be modified to store Card

number and Journey details.




Data Warehousing

Data warehouse onPRS is a collection of passengerinformation from 5 PRS sites intended for management

reporting and decision making. It will facilitate themanagement to analyse the following:-

Earnings

Passenger Traffic Wait List Analysis

On daily weekly, monthly and yearly basis for premiumtrain types, classes and pair of stations.

Extraction /Transformation /Loading layers of processing isdeveloped in house.




Thanks

hp(le meridian)-17feb2006 (1)

Documents