Case Study: Active Data Warehousing

1. Describe participating entropy w atomic number 18housing as it is applied at Continental Airlines. Does Continental apply officious or real-time storage differently than this construct is normally described? An active selective knowledge reposition, or ADW, is a selective cultivation wargonho aim implementation that pays near-time or near-real-time decision make. It is featured by event-driven actions that ar triggered by a continuous stream of queries that be generated by bulk or applications regarding an organization or go with against a broad, deep starchlike set of enterprise entropy.Continental uses active selective information computer storage to oblige drag of their bon tons daily progress and performance. Continentals way team holds an operations meeting every morning to sauceruss how their caller-out is performing in regards to the entropy collected by their active selective information warehousing program. The solicitude team believes, you hindq uarterst manage what you dejectiont measure, so they use active selective information warehousing to keep track of their customers experience while using Continental Airlines.The information that the management team uses to analyze their participation in regards to customer relationship is on-time arrival, on-time departures, luggage handling, and other lynchpin performance indicators. Continental also uses active entropy warehousing for gross management, revenue accounting, flight operations, fraud detection and respiratory tract security. Continental restructured their goals to try to move customers favored airline to use. They use their active data warehousing to gain as much information around the companys performance as headspring as the customers experience.They use this real-time warehousing program to interpret information that is provided and make changes that go forth break away improve their customers experience and help Continental better gibe their handicr aft in regards to their customers penurys. 2. In what ways does real-time data warehousing fit with the Continental scheme and plans? Continental Airlines decided to shift their strategy once they went from worst to first. The new goal that they wanted to achieve was making the move from first to favorite. Continentals new strategy and plan of becoming their customers favorite airline could only(prenominal) be achieved by using real-time data warehousing. Continental made plans to become the favorite airline and their strategy tangled making line of descent decisions based on information they receive from real-time data warehousing such as on-time arrival, on-time departures, baggage handling, and other key performance indicators. This information gives the Continental management team the necessary information needed to make corrections or changes in methodicalness to better their customers experience while using Continental Airlines.Continentals strategy and plans to become the favorite airline would be much harder to accomplish without real-time data warehousing. They need this information in order to realize what parts of their company need to be tweaked to keep the customer happy. Without real-time data warehousing Continental wouldnt be able to achieve their goal of pitiable from first to favorite. 3. Describe the derives of real-time data warehousing at Continental. real-time data warehousing has allowed Continental to make significant changes to its business in a variety of ways.According to Continentals president and COO Larry Kellner, real-time BI is critical to the accomplishment of our business strategy and has created significant business gains. There is a wide-range of benefits that Continental has gained from real-time or active data storage store in the categories of marketing, corporate security, IT, and revenue management. One key benefit in the marketing field is the average increase of travel amongst Continentals most valuabl e customers, approximately $800 per customer (35,000 customers).A central benefit in is that all employees have the ability to access important facts and information about its customers and the business in its entirety. This in turn allowed Continental to offend passenger reservations and flight manifests by cross-referencing with the FBIs watch list only hours about the 9/11 attacks, deciding if it was safe to fly. Above all, Continental has recognized over $500 million of cost saving and revenue generation (tracking and forecasting, fare objectives and analysis, and full reservation analysis) due to the advantages of the business intelligence. . What elements of the data warehousing environment at Continental are necessary to support the extensive end-user business intelligence application suppuration that occurs? There are numerous elements of the data warehousing environment at Continental that are necessary in the support of the extensive end-user BI application development that takes place. Two important elements that are necessary to discuss are the remainss scalability and data security. Since the real-time data warehousing storage warehouse never gets rid of information, the count of data increases exponentially over time.Additionally, with the development of BI application, the number of uses ordain also increase. To deal with the amount of custom and data, the data warehouse at Continental should have scalability which allows the data warehouse to expand the accessible disc space and by means ofput. The Continental excogitate team took this into account when going through the architecture design of the warehouse. The other element that is important to take help of is data security. Data security is extremely important when a company handles customer information and individualized data.Continentals warehouse stores all of the customers information that can be accessed by other users in order to gain the data that they need. The customers can rest assured knowing that their personal information (i. e. social security numbers and credit card numbers) are protected from being opened by any users that are non authorized to view this sensitive information. 5. What redundant issues about data warehouse management (e. g. , data capture and loading for the data warehouse (ETL processes) and head workload balancing) does this case suggest occur for real-time data warehousing? How has Continental addressed these issues?Real-time data warehousing creates some special issues that need to be solved by data warehouse management. These can create issues because of the extensive goodity that is involved for not only think the system, but also managing problems as they arise. Two aspects of the BI system that need to be organized in order to elude any technical problems are the architecture design and query workload balancing. Architecture design is important because when a company is progressively receiving business and differ ent aspects of the customers usage of the company changes the warehouse needs to frequently be updated.Continental planned for the company to use real-time data warehousing so they structured the design to accommodate for the demand of real-time information. The information then became easier to update the warehouse in a timely personal manner. Query workload balancing is some other important aspect of the warehouse that needed to be addressed in order to fulfill Continentals need to use the warehouse for tactical and strategical purposes. Continental would run into issues of backed up query processing in their warehouse if query workload balancing wasnt introduced.The queries would be process in a first in first out system and would essentially cause backups. Continental resolved this issue by making the warehouse process queries according to the query type. They set up the warehouse to process the specific queries that access single records first and marked them with risque precedence. Then they prioritized other queries to either be marked with medium priority or low priority depending on what information they are petition for and for what reason its needed.Continentals utilization of using prioritized groupings of queries has led them to be able to process information in a timely manner that is most convenient for the person trying to access this information. (Information regarding the case as well not sure which one you wanted so I included both) There are two issues that the case study suggests in terms of data management. The first is to recognize that some data cannot and should not be real-time, for three reasons. The first is that Continental knows that real-time data track down are hard to administer because the constant flow of transaction data must always be supervised.The second reason is the need for especial(a) hardware. The last reason Continental is extremely cautious with the movement of supererogatory data is because real-time dat a feed is extremely costly to plant about. The second issue Continental deals with when it comes to data warehouse management is having the good people in the right positions. Anny individual who handles any aspect of a real-time warehouse must be highly qualified and internal in both technology and business.According to the case study, At Continental, data warehouse staff members in the more technical positions (e. g. , design of ETL processes) have degrees in computer science. Some of them previously built and maintained reservation systems in front they joined the warehouse team. Consequently, they have experience with transaction oriented, real-time systems, which serves them well for real-time BI and data warehousing. The warehouse team members who work almost with the business units have previous work experience in the business areas they now support.