 Project Summary
JetBlue Airways is a rapidly expanding airline and one of the fastest growing,
rising startups on the East coast. JetBlue’s project requirement was to produce a
web-based Intranet solution that would eliminate the time consuming and error
prone manual analysis of flight information from the FAA. This information was
keyed manually into an Excel spreadsheet that grew to over 4 MB each month and
distributed via email to JetBlue management. Additionally, large file sizes and
several daily distributions was a significant drain on their network. A web-based
solution allowed the total company’s 1,700 personnel to access in real time key
industry standard performance indicators.
The FAA provides hourly text feeds that are transmitted to a JetBlue Windows 2000
server. A VBS script is scheduled to run hourly and traverse this file and
strip/pre-process/log the information and load it into SQL Server 2000 tables.
The client side browser solution was developed using IE6, Javascript/DHTML
programming, CSS, HTML and XSLT.
The IIS server side processing is based on ASP scripts calling MTS COM components
written in VB6.
Inter-data exchange between components, client requests and output from SQL Server
is achieved using XML.
Custom search selections were developed using ASP and Crystal Reports 8.5 API for
reporting purposes.
|
