A member of the ASL Aviation Group, Europe Airpost is the world’s largest operator of Boeing 737-300 Quick Change (convertible airplanes that transport freight by night and passengers during the day). With 800,000 passengers and 65,000 tons of freight transported in 2011, it is also the second-largest French airline and the leading French regional charter company.
Europe Airpost first deployed a business intelligence (BI) environment to optimize managing transport activities. It hosted this critical and resource-intensive application with other transactional business applications, such as flight pricing, payroll, and customer billing, on a common Oracle Real Application Clusters 11g infrastructure.
To ease access to business applications, such as the systems used for flight schedule management and aircraft maintenance, the company deployed Oracle Database Appliance to create a new, highly resilient, and dedicated business intelligence infrastructure.
With Oracle Database Appliance, Europe Airpost consolidated all critical business intelligence data regarding flight operation, fuel management, and service quality, while ensuring high performance and the availability of data and applications to efficiently manage its air transport activities. Thanks to a dedicated database appliance, business intelligence data is refreshed every 15 minutes instead of each hour, as with the previous infrastructure. As a result, operations managers can access aircraft mass reporting half an hour before each take off to optimize and to better calculate airport taxes for transported loads. Using Oracle Database Appliance, Europe Airpost has also optimized loading and query data performance by approximately 30%.
“We found that Oracle Database Appliance was the leading solution on the market, offering the best quality and value,” said Francis Brisedoux, database administrator, Europe Airpost.
“The flexibility of the Oracle solution’s pay-as-you-grow model and its ability to easily upgrade hardware components—including central processing units and memory—enables us to efficiently respond to business requests for delivering new interfaces for tracking flight schedules, parts inventories, and airplane lifecycles.”
Europe Airpost worked with Oracle Support to optimize the roll out of Oracle Database Appliance and achieve performance gains on data loading and reporting processes. Thanks to this optimization, the company deployed Oracle Database Appliance in just one day, including connections, electrical power, and cabling operations.