Case Study: Active Data Warehousing

1. draw in wide awake info storage as it is applied at Continental Airlines. Does Continental apply combat-ready or real time wargonhousing former(a) than than this concept is normally described? An active info w atomic number 18housing, or ADW, is a entropy w atomic number 18ho use up implementation that supports near-time or near-real time decision making. It is featured by event-driven actions that are triggered by a continuous stream of queries that are generated by people or occupations regarding an organization or comp any against a broad, ample granular set of enterprise selective information.Continental uses active info warehousing to hear place track of their companys daily progress and performance. Continentals recognizement team holds an operations meeting every morning to question how their company is performing in regards to the selective information collected by their active data warehousing program. The perplexity team believes, you cant manage what yo u cant measure, so they use active data warehousing to keep track of their guests experience while using Continental Airlines.The learning that the management team uses to analyze their company in regards to customer race is on-time arrival, on-time departures, baggage handling, and other anchor performance indicators. Continental also uses active data warehousing for revenue management, revenue accounting, flight operations, fraud staining and airline security. Continental re incorporated their oddments to try to become customers favorite airline to use. They use their active data warehousing to gain as much info ab protrude the companys performance as well as the customers experience.They use this real-time warehousing program to interpret information that is provided and clear changes that will erupt improve their customers experience and help Continental better suit their transmission line in regards to their customers holds. 2. In what ways does real-time data wareh ousing fit with the Continental schema and plans? Continental Airlines decided to keel their clay once they went from worst to first. The new goal that they wanted to come through was making the move from first to favorite. Continentals new strategy and plan of fit their customers favorite airline could lonesome(prenominal) be achieved by using real-time data warehousing. Continental made plans to become the favorite airline and their strategy involved making furrow decisions based on information they adjoin 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 inevitable information needed to make corrections or changes in wander 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. The y need this information in order to realize what move 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 moving from first to favorite. 3. Describe the benefits of real-time data warehousing at Continental. Real-time data warehousing has allowed Continental to make master(prenominal) 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 benefits. on that point is a wide-range of benefits that Continental has gained from real-time or active data storage 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 travelling amongst Continentals most valuable customers, approximately $800 per customer (35,000 customers).A telephone exchange benefit in is that all employees restrain the ability to access important facts and information about its customers and the business in its entirety. This in turn allowed Continental to check passenger engagements and flight manifests by cross-referencing with the FBIs watch angle of dip only hours about the 9/11 attacks, deciding if it was safe to fly. to a higher place all, Continental has recognized over $500 million of cost providence and revenue generation (tracking and forecasting, fare designs 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 development 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 importa nt elements that are necessary to discuss are the systems scalability and data security. Since the real-time data warehousing warehouse never gets justify of information, the amount of data increases exponentially over time.Additionally, with the development of BI application, the reckon of uses will also increase. To deal with the amount of usage and data, the data warehouse at Continental should have scalability which allows the data warehouse to expand the neighborly disc space and throughput. The Continental design team took this into account when qualifying through the architecture design of the warehouse. The other element that is important to take care of is data security. Data security is extremely important when a company handles customer information and personal 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 lettered that their personal info rmation (i. e. social security numbers and credit twit numbers) are protected from being opened by any users that are not authorized to view this sensitive information. 5. What special issues about data warehouse management (e. g. , data capture and loading for the data warehouse (ETL processes) and query exitload match) does this content suggest occur for real-time data warehousing? How has Continental intercommunicate these issues?Real-time data warehousing creates nigh special issues that need to be solved by data warehouse management. These can create issues because of the extensive technicality that is involved for not only planning the system, but also managing problems as they arise. Two cheeks of the BI system that need to be organized in order to elude any technical problems are the architecture design and query workload balancing. computer architecture design is important because when a company is progressively receiving business and several(predicate) aspects of t he customers usage of the company changes the warehouse needs to frequently be updated.Continental mean 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 apropos manner. Query workload balancing is another important aspect of the warehouse that needed to be addressed in order to fulfill Continentals need to use the warehouse for tactical and strategic purposes. Continental would run into issues of backed up query impact in their warehouse if query workload balancing wasnt introduced.The queries would be processed 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 high priority. Then they prioritized other queries to either be marked with strong suit priority or low priority depending on what information they are asking for and for what reason its needed.Continentals utilization of using prioritized groupings of queries has light-emitting diode 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 analyse 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 feed are hard to administer because the constant flow of achievement data must always be supervised.The second reason is the need for extra hardware. The last reason Continental is extremely cautious with the strawman of additional data is because real-time data feed is extremely pricey to bri ng about. The second issue Continental deals with when it comes to data warehouse management is having the right people in the right positions. Anny individual who handles any aspect of a real-time warehouse must be highly suitable and knowledgeable 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 before 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 closely with the business units have previous work experience in the business areas they now support.