Frontier Takes Off With Massively Parallel Flight Management System - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Software // Enterprise Applications
News
5/30/2006
10:12 PM
Connect Directly
Twitter
RSS
E-Mail
50%
50%

Frontier Takes Off With Massively Parallel Flight Management System

To stay competitive, Frontier has adopted Greenplum's Bizgres MPP business intelligence tools, which act on data in a PostgreSQL open source database.

Frontier Airlines has turned to a low-cost business intelligence option to give itself the tools that will help it remain competitive in a cut-throat business, supplying the lowest cost flights. It's another case of airlines turning to advanced IT technology to keep themselves in business. Frontier is second only to United Airlines at the new Denver International Airport, an major hub that occupies a site that is twice the size of Manhattan. To stay competitive amidst all the contenders that surround it, Frontier has adopted Greenplum's Bizgres MPP business intelligence tools, which act on data in a PostgreSQL open source database. Bizgres is also an open source project at Bizgres.org.

The MPP stands for massively parallel processing, an approach to looking up information that is used by Google and other search engines. It is based on multiple databases on multiple servers, each holding a portion of the total database. A query is subdivided to execute on each of the appropriate servers and then the results combined, speeding up the systems ability to come up with answers to complex queries from masses of data. Another example is the Navy parallel processing system Kraken.

Frontier CIO Robert Rapp says the airline's yield management process runs on Bizgres MPP. The system predicts the yield or profit that Frontier will receive on various flight combinations and ticket prices. The system helps Frontier determine where to offer seats at bargain prices and where to avoid what might turn out to be a competitive bloodletting, with no one profiting, says Rapp, the former CIO of Southwest Airlines, a pioneer of low-priced flights.

"Greenplum allowed us a very economical solution for a mid-sized airline. There are large amounts of parallelism in the system," says Rapp. A comparable but higher end commercial system used by retailers such as Wal-Mart comes from Teradata, a unit of NCR Corp. "Greenplum was available at 20-30 times less" than such a system."It was available at a very nice price point for us," adds Rapp.

Frontier used the system for 5-6 months before actually putting it into production in February. The 2.0 version of Bizgres MPP came out at the end of 2005. The actual coding of the yield management system was done by a private business analytics consulting firm, Daxpy LLC, in partnership with Greenplum, which will be offering the yield management system as an application that can be added onto its Bizgres MPP tools and the PostgreSQL database.

The system runs on 4 Dell 2850 servers, including a controller server and three database servers, says Dave Croiter, leader of the Frontier project. The system can be upgraded by adding more Dell hardware or new dual-core hardware. Ticket purchasing information is constantly available to the system in an updated fashion. A query that must access 800 million records will return a result "in a few seconds or, at most, 15 seconds, not 20 minutes," giving business analysts at Frontier the ability to respond rapidly to competitors' offerings, Croiter says. Various alerts are built into the system to spot regions where sales are not living up to predicted levels so business analysts can wade into the data to try to determine why. "In the past, we discovered the why when it was already too late and the revenue was lost," he says.

Sometimes airlines sell distressed inventory when they have too many seats and too few passengers. Yet, sometimes it doesn't make sense to match cuts made by a competitor and lose money. "If a competitor takes drastic action, an analyst knows whether to add matching fares, add flights to Frontier's schedule, or do nothing." he said.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
Slideshows
9 Steps Toward Ethical AI
Cynthia Harvey, Freelance Journalist, InformationWeek,  5/15/2019
Commentary
How to Assess Digital Transformation Efforts
Lisa Morgan, Freelance Writer,  5/14/2019
Commentary
Is AutoML the Answer to the Data Science Skills Shortage?
Guest Commentary, Guest Commentary,  5/10/2019
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
A New World of IT Management in 2019
This IT Trend Report highlights how several years of developments in technology and business strategies have led to a subsequent wave of changes in the role of an IT organization, how CIOs and other IT leaders approach management, in addition to the jobs of many IT professionals up and down the org chart.
Slideshows
Flash Poll