Continental Airlines: Flying High with Its Data Warehouse

The respiratory tract industry is a competitive market in which some air passages are profitable temporary hookup others are non. During the latish 1990s, most airlines were lucrative because fuel costs were relatively low and travel was at an all time high amongst flyers. Recently, the airline industry has taken a severe hit payable to the change magnitude rate of oil, the 9/11 attacks, and anti-traffic control system to name a few. However, Continental Airlines remains one of the largest airlines in the United States holding its localize in fourth place amongst other airline companies.Initially, Continental Airlines was not highly regarded because of its information technology (IT) and organizational culture. Unlike other airline companies, Continental Airlines has taken extreme measures by adopting new strategies to overhaul its IT incision altogether. The information systems Continental had in place was old and outdated because it did not provide information of its most valuable customers. The Transaction Processing rapidness (TPF) was the old IBM mainframe system Continentals IT team had during the late 1990s. The system was not intentional for customer service of process.In order for Continental to follow out its goals, the IT team realized the need to replace its old mainframe. The IT team find it needed to integrate into one system by consolidating the airlines disparate customer management relationship (CRM) systems. As a result, Continental joined forces with Teraselective information to build an enterprisingness selective information warehouse comprised of 25 enterprise systems. The warehouses consist of schedules, reservations, customer profiles and demographics, airline maintenance records and schedules, employee and crew payroll, and customer complaint (Rainer & Turban, 2008, p.132).Additionally, executives of Continental Airlines were able to develop the Customer Value Metric (CVM), which enables them to desexualize how much mone y customers spend with its airlines and the costs of flying the customer as well. The data warehouse is a repository of historical data that helper with line of credit operations to include data mining, decision support, and querying applications (Rainer & Turban, 2008, p. 117). Many components realise up the data warehouse such(prenominal) as business dimensions in which data is organized by customers, vendors, product, price level, and region.The data in unlike databases are encoded differently and kept historically for many years. Once data enters the warehouse it is not updated. Databases use online transaction processing (OLTP), in which business transactions are processed online as they occur. Typically, data warehouses are designed to support decision makers by using online analytical processing (OLAP) for the abstract of mass data by end users. Data is stored in a multidimensional structure as well. All data in the data warehouse comes from Continental Airlines operatio nal databases which can be relational databases as well.These components enable users access to corporate data for analyzing. Special software such as extract, transform, and load (ETL) are used to process data to subsequently store in a data warehouse. However, only a epitome of data is transferred to the warehouse. This data is organized in a form that is weak for end users when accessing. The reason why Continental Airlines remains successful is due to their strategies for improving and enhancing prime(prenominal) customer service with many functions implemented by their IT team.Continental Airlines main focus is increasing customer rewards and incentives of frequent flyers that are allegiant customers, time gaining new customers that are profitable too. Continental Airlines contributes its success to the quality customer service and customer satisfaction it provides by expanding its routes and serving meals on every flight. Some airline companies have gone bankrupt while o thers simply choose not to improve their quality of customer service. As a result, customers have become irritated due to the lack of intelligent rates, delays, and strict rules of other airline companies.In closing, information technology is essential for airline companies. Some airline companies may choose to stick with basic airline technology. However, an airline partnership can enhance its level of customer service and profitability based on the type of changes it needs to make. Executives of an airline company can look to its IT department to strategize ways to utilize information systems that stovepipe fits its goals, business practices, mission statement, customer service, and customer satisfaction.