470 likes | 763 Vues
Customer Case Study (HP Customer) Passenger Reservation Systems and related Websites in Indian Railways By Deepak Chhabra Group General Manager (Webservices) Email id :- dchhabra@cris.org.in. GROWTH OF PASSENGER TRAFFIC OVER YEARS (in Millions). Year Suburban Non Suburban Total
E N D
Customer Case Study (HP Customer) Passenger Reservation Systems and related Websites in Indian Railways By Deepak Chhabra Group General Manager (Webservices) Email id :- dchhabra@cris.org.in Centre for Railway Information Systems (Confidential)
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 3613 1990-91 2259 1580 3858 1995-96 2484 1507 4018 2000-01 2861 1932 4833 2001-02 2999 2053 5093 2002-03 2934 2037 4971 Centre for Railway Information Systems (Confidential)
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 Centre for Railway Information Systems (Confidential)
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 Centre for Railway Information Systems (Confidential)
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 Centre for Railway Information Systems (Confidential)
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 Centre for Railway Information Systems (Confidential)
CONCERT NETWORK TOPOLOGY kolkata PRS Delhi PRS 2 MBPS (x2) Leased Line 2 MBPS (x2) Leased Line6 Mumbai PRS 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 Chennai PRS Centre for Railway Information Systems (Confidential) Chennai
Hardware Used in CONCERT • Hardware Delhi Mumbai Kolkatta Chennai S’Bad • ES 40 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 1CRIS 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 Centre for Railway Information Systems (Confidential)
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. Centre for Railway Information Systems (Confidential)
PREVIOUS SET UP AT PRS/DELHI FDDI CONC SWITCH VAX 7610 VAX 4705 VAX 4705 HUB TS TS MUX CI DSSI LD MODEM Fiber Ethernet Storage LD MODEM MUX T RT Centre for Railway Information Systems (Confidential)
CONCERT APPLICATION ARCHITECTURE Touch Screen Press IVRS Tele-Booking Internet Users WEB Server Reservation Charting IRCTC Database Enquiry InternetClient FireWall CONCERT Interconnect Bus Delhi Servers Mumbai Servers Chennai Servers Sec’bd Servers Kolkata Servers DB DB DB DB DB Centre for Railway Information Systems (Confidential)
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 nation-wide for various classes Bookings for over 7,000 destinations 4,262 reservation terminals Across about 1,171 locations. FEATURES OF CONCERT Centre for Railway Information Systems (Confidential)
Load on PRS Centre for Railway Information Systems (Confidential)
Passenger Reservation Load Centre for Railway Information Systems (Confidential)
REPORT OF TOTAL NO OF TERMINALS/ LOCATIONS ATALL PRS (Jan 2006) Centre for Railway Information Systems (Confidential)
REPORTOF RECEIPT/REFUND/NET EARNING SITEWISE JAN 2006 Centre for Railway Information Systems (Confidential)
REPORT OF NUMBER OF PASSENGER BOOKED/ CANCELLED SITEWISE Centre for Railway Information Systems (Confidential)
PERCENTAGE OF NETWORK LOAD OF EACH PRS (JAN ‘06) 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 Centre for Railway Information Systems (Confidential)
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 Centre for Railway Information Systems (Confidential)
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 Centre for Railway Information Systems (Confidential)
Meeting unique requirements 100% Availability Objective (Application Level) % Availability Hours Lost/Year P/Sysplex, Himalaya 2.2 99.99% Single Mainframe 8.7 99.9% AS/400, OpenVMS, HP3000 17.5 99.8% Solaris, HP-UX, Tru64, AIX 35.0 99.6% NT and Microsoft Cluster Server 69.9 99.2% Centre for Railway Information Systems (Confidential) 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 Centre for Railway Information Systems (Confidential)
PRS Website ENVIRONMENT Computers (Hardware) – DS20s and DS10s Operating System – TruUnix 64 and Open VMS version 7.3.2 Middleware – Digital’s Reliable Transaction Router (RTR 4.2) 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 Centre for Railway Information Systems (Confidential)
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. Centre for Railway Information Systems (Confidential)
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 Centre for Railway Information Systems (Confidential)
Enquiries on Cell Phones through SMS • Train Schedule • PNR Status • Accommodation Availability • Trains between stations • Fare • Available on Short code • 676747 • 7886 • 8888 Centre for Railway Information Systems (Confidential)
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 AvailablityTA <train number > <starting city> <ending city> <journey date > Centre for Railway Information Systems (Confidential)
PRS System Level Failures handled Year No. of Failures handled • 2000 23 • 2001 20 • 2002 38 • 2003 28 • 2004 40 • 2005 8 Centre for Railway Information Systems (Confidential) 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. Centre for Railway Information Systems (Confidential)
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. Centre for Railway Information Systems (Confidential)
Technology used • Hardware • DS20 Alpha machines under Tru 64 Unix 4.0 f • Software • C,RTR 3.2 • Sybase with Replication Centre for Railway Information Systems (Confidential)
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) Centre for Railway Information Systems (Confidential)
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 Centre for Railway Information Systems (Confidential)
Enquiries on NTES Website • Spot Your Train • Gives the running status along with the delay marked for a train at a station • Find your Train • Trains between two stations • Arrivals/Departures • Trains arriving/Departing at a given station in next few hrs • Train Time Table • Schedule Arrival/Schedule Departure • Passing Through Trains • Shows a list of trains passing through a station. Centre for Railway Information Systems (Confidential)
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. Centre for Railway Information Systems (Confidential)
New challenges • Maintenance by remote login by vpn • By HP engineers in US or Bangalore • Regular proactive patch updation Centre for Railway Information Systems (Confidential)
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 Centre for Railway Information Systems (Confidential)
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. 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. Centre for Railway Information Systems (Confidential)
Thanks Centre for Railway Information Systems (Confidential)