Finding a way to quickly and efficiently query American Airlines Data Warehouse

American Airlines, the world's largest carrier, needed to increase revenue by reducing fraudulent ticket processing. That meant finding a way to quickly and efficiently query their data warehouse. That meant Sybase. American Airlines now has the data warehouse it needs to detect fraudulent ticket-processing, track ticket sales properly and ensure proper revenue is flowing into the company.

Along with its regional carriers American Eagle and American Connection, American Airlines serves more than 250 cities in 41 countries with 1,100 airplanes and about 4,400 daily flights. The airline processes about 125 million transportation documents on an annual basis.

With the amount of data created by all these ticket documents, American Airlines needed a more efficient system that would help ensure proper amounts of earned revenue on ticket sales. But because of the complexity of the airline industry and the amount of data involved in ticket transactions, accomplishing this would be no small task.

“Our business analysts have the expertise to spot fraud and other incidents of incorrect revenue flow, but they also need a system that makes it easy for them to quickly query and sort through large amounts of data,” said John Hagen, senior systems analyst and project manager for American Airlines.