Deutsche Lufthansa AG Consolidates Data to Reduce System Downtime and Costs
 
 

Deutsche Lufthansa AG Consolidates Data to Reduce System Downtime and Costs

Deutsche Lufthansa AG is a global aviation group. The Group operates five business segments, each offering high quality mobility and services for the airline. The five segments—passage airline group, cargo, maintenance, repair, and operations (MRO), catering, and IT services—all play leading roles in the industries in which Deutsche Lufthansa AG operates.

 
 

 
 

Challenges

A word from Deutsche Lufthansa AG

  • "Operational stability is our number one goal. By migrating to Oracle Database 11g Enterprise Edition and consolidating our system into a cluster with a disaster recovery site, we shortened maintenance windows and increased data security. In addition, this new architecture enabled us to fulfill high availability demands and lower costs by 20%" – Dipl.-Ing. Thomas Kletschka, IT Product Management CMS Platform, Deutsche Lufthansa AG Consolidates Data to Reduce System Downtime and Costs

  • Reduce administration effort for the Lufthansa passage crew management database, which was high due to a mix of various servers, operating systems, and nine different productive database installations
  • Ensure optimal crew management system stability to support more than 25,000 members of Lufthansa passage, Lufthansa cargo, and other airline affiliates daily
  • Provide stringent security to protect personal and confidential data stored in 160 crew management applications
  • Eliminate maintenance bottlenecks for systems running around-the-clock

Solutions

  • Utilized Oracle Real Application Clusters 11g to consolidate hardware systems and installed a disaster recovery site using Oracle Recovery Manager to reduce costs by 20%, system maintenance time by 15%, and system administration by 10%
  • Leveraged Oracle Database Enterprise Edition 11g to implement a single, logically segmented central database containing all pertinent crew data—such as flight schedules, briefing material, vacation logs, training details, maternity leave, and retirement data
  • Realized IT security demands by centrally encrypting data streams
  • Used Oracle Real Application Clusters 11g to meet system availability demands and eliminate maintenance and update bottlenecks by cutting over to the disaster recovery site when needed, in just 30 seconds