Docstoc

Railway Reservation Project Information - PowerPoint

Document Sample
Railway Reservation Project Information - PowerPoint Powered By Docstoc
					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

 7/28/2011       Centre for Railway Information Systems (Confidential)   1
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




7/28/2011   Centre for Railway Information Systems (Confidential)           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/28/2011   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/28/2011    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/28/2011     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/28/2011   Centre for Railway Information Systems (Confidential)   6
  CONCERT NETWORK TOPOLOGY

                                                       Delhi PRS                             kolkata PRS
                             2 MBPS (x2) Leased            2 MBPS (x2) Leased
                             Line                          Line6




                         2 MBPS (x2) Leased
Mumbai PRS               Line




                                                            Secunderabad PRS
    2 MBPS Leased Line

                                 2 MBPS Leased Line                                      Delhi

                                                          2 MBPS (X 2) Leased                          Calcutta
                                                          Line

                                                                                Mumbai
                                                                                                 SecBad


                         Chennai PRS
           7/28/2011        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/28/2011      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/28/2011   Centre for Railway Information Systems (Confidential)   9
                        PREVIOUS SET UP AT PRS/DELHI
FDDI CONC

                                                                   SWITCH

VAX            VAX                VAX
                                  7610                              HUB
4705           4705



                                                              TS                    TS

                                                                                   MUX
       DSSI           CI
                                                   LD
                                                                                   MODEM

              Fiber                                  LD                            MODEM
              Ethernet
              Storage                                                                    MUX
                                                              T           RT
                                                     VT1300               VT1300




  7/28/2011       Centre for Railway Information Systems (Confidential)                    10
    CONCERT APPLICATION ARCHITECTURE
                                                                      Touch
                                                                      Screen
                                                          Press                         IVRS        Internet
                                                                                     Tele-Booking    Users
                                                                                          WEB
Reservation     Charting      IRCTC          Database         Enquiry                     Server

                                                                               Internet Client
                                                                                                 FireWall

                           CONCERT Interconnect Bus




               Delhi       Mumbai          Chennai           Sec’bd             Kolkata
              Servers      Servers         Servers          Servers             Servers




                  DB        DB               DB               DB                  DB
          7/28/2011          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 nation-
           wide for various classes
          Bookings for over 7,000 destinations
          4,262 reservation terminals
          Across about 1,171 locations.


    7/28/2011   Centre for Railway Information Systems (Confidential)   12
                       Load on PRS
S.No.   PRS Node    Trains     Terminals          Locations         Peak no.         Avg. no.
                                                                    of Psgns/        of Psgns/
                                                                    day              day
                                                                    (in lakhs)       (in lakhs)
 1.     Delhi        1020               1317                337               2.75        2.52

 2.     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

        TOTAL       2998             4262              1171            10.17            8.82

        7/28/2011     Centre for Railway Information Systems (Confidential)                 13
           Passenger Reservation Load
                   PASSENGER RESERVATION SYSTEM LOAD
                                                                     PEAK NO OF        AVERAGE NO OF
                                                                    PASSENGERS          PASSENGERS
PRS NODE           Trains         Locations        Terminals
                                                                     PER DAY (IN         PER DAY (IN
                                                                       LAKHS)              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/28/2011           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/28/2011           Centre for Railway Information Systems (Confidential)          15
REPORT OF RECEIPT/REFUND/NET EARNING SITEWISE
                                  JAN 2006

        PRS            TOTAL                   TOTAL REFUND             NET
                       RECEIPT                                          EARNING

     MUMBAI                232 Crores            62 Crores(26%)          170 Crores


     KOLKATA               164 Crores
                                                40 Crores(24%)
                                                                         124 Crores


       DELHI               234 Crores           50 Crores(21%)           184 Crores


      CHENNAI              128 Crores
                                                31 Crores(24%)           97 Crores

SECUNDERABAD               54 Crores             13 Crores(24%)          41 Crores
7/28/2011       Centre for Railway Information Systems (Confidential)                16
REPORT OF NUMBER OF PASSENGER BOOKED/ CANCELLED
SITEWISE
       PRS              %AGE TO TOTAL LOAD OF ALL
                                          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/28/2011           Centre for Railway Information Systems (Confidential)   17
           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




           7/28/2011             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/28/2011   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/28/2011   Centre for Railway Information Systems (Confidential)   20
 Meeting unique requirements
                               100% Availability
                                  Objective
% Availability                (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                                         69.9

      7/28/2011     Centre for Railway Information Systems (Confidential)               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/28/2011   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                     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
      7/28/2011   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/28/2011    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/28/2011     Centre for Railway Information Systems (Confidential)   25
Enquiries on Cell Phones
through SMS
           Train Schedule
           PNR Status
           Accommodation Availability
           Trains between stations
           Fare
           Available on Short code
              676747
              7886
              8888

7/28/2011    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/28/2011   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       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

       S eries1   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/28/2011                              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   270,683   350,456    485,478   434,524   580,365   628,573    504,354   516,061   634,249



                      7/28/2011                        Centre for Railway Information Systems (Confidential)                                                            29
PRS System Level Failures
handled

  Year          No. of Failures handled
   2000               23
   2001               20
   2002               38
   2003               28
   2004               40
   2005                8
  7/28/2011   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/28/2011   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/28/2011   Centre for Railway Information Systems (Confidential)   32
Technology used
    Hardware
           DS20 Alpha machines under Tru 64 Unix
            4.0 f
    Software
           C,RTR 3.2
           Sybase with Replication



7/28/2011      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/28/2011       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/28/2011   Centre for Railway Information Systems (Confidential)   35
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.
         7/28/2011   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/28/2011      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/28/2011   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/28/2011   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/28/2011                                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/28/2011   Centre for Railway Information Systems (Confidential)   41
                      Thanks

7/28/2011   Centre for Railway Information Systems (Confidential)   42

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:749
posted:7/28/2011
language:English
pages:42
Description: Railway Reservation Project Information document sample