|
Galileo and SMS Integration
|
Time-period
|
1999 - 2002 |
|
Man-hours
|
10,000 |
|
Users
|
NA |
|
People Affected
|
NA |
Front-End
Back-End
|
Perl, J2EE
MySQL, Oracle
|
|
Role
|
Development, Setup, Optimisation, Support |
|
Challenge
|
Real-time update of flight information and ticket prices from the Galileo system was sought.
Galileo is a manual Tele Type Terminal based system and provides no API or any automated method whatsoever to access the central data.
The challenge facing us was not only to read the input stream, but if possible, even write to the output stream.
After analysing the hardware of the Galileo CRS, it was deciphered that Galileo used the X.25 protocol to transfer data.
This data stream was reverse engineered after understanding the internals of the X.25 protocol and a data translation, resident utility was made, using Assembly language and VC++, to act as an interface to TCP/IP We were successfully able to check the status of, and book tickets from the html front-end using Galileo as a back-end CRS
The same was also integrated with an SMS based system to send out and collect passenger and booking details via SMS. |
|
|
