Skip to main content

Perceiving Airline Passenger Booking Lifecycle with the Utilization of Data Warehouse

  • Conference paper
  • First Online:
Big Data Intelligence and Computing (DataCom 2022)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 13864))

Included in the following conference series:

  • 903 Accesses

Abstract

Today, expansive ventures depend on database frameworks to oversee their information and data. These databases are valuable for conducting day-by-day trade exchanges but do not provide information that could be used for analysis to make a strategic decision. A data warehouse also known as an informational database act as a central repository that accumulates historical data from various sources and multiple systems across the company, the analysis of which fosters strategic decisions. Data mining techniques and algorithms in conjunction with business intelligence tools were utilized to analyze, predict, forecast and make logical sense of the integrated data. The applicability of data warehouse was across various functional areas and different types of business. For instance, some domains of use cases with the likes of Health, Retail, Finance, Service, Manufacturing and so forth. This paper examined various implementations of data warehouses in the aviation industry and proposes a data warehouse design. The plan was clarified with a meticulous case study on comprehending airline passenger booking at various stages of its lifecycle through a data warehouse design utilizing the four-step dimensional modelling methodology enabling smart revenue management for airlines. The primary beneficiaries of this article are academics, data warehouse and database administrators, data scientists (data mining and Business intelligence specialist), airline operators, management team, and functional silos across the business who would need passenger-booking intakes to make strategic decisions.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Similar content being viewed by others

References

  1. Iata.org (2022). https://www.iata.org/en/iata-repository/publications/economic-reports/fiji-value-of-aviation/. Accessed 04 July 2022

  2. The Data Warehouse: From the Past to the Present – DATAVERSITY. DATAVERSITY (2022). https://www.dataversity.net/data-warehouse-past-present/. Accessed 04 July 2022

  3. Dou,X.: Big data and smart aviation information management system. Cogent Bus. Manage. 7(1), 1766736 (2020). https://doi.org/10.1080/23311975.2020.1766736. Accessed 3 July 2022

  4. Nenadović, A.: Data warehouse for global air transport development. In: Symorg 2016, pp. 180–187 (2016). http://symorg.fon.bg.ac.rs/proceedings/2016/papers/DATA%20SCIENCE%20AND%20BUSINESS%20INTELEGENCE.pdf#page=3. Accessed 16 Apr 2022

  5. Yilma, G., Kumar, D., Kemal, M., Debele, G.: Leveraging big data analytics for airlines: personalization and smart pricing (2018). https://www.researchgate.net/publication/335444692_Leveraging_Big_Data_Analytics_for_Airlines_Personalization_and_Smart_Pricing. Accessed 16 Apr 2022

  6. Girsang, A., Isa, S., Puspita, A., Putri, F., Hutagaol, N.: Business intelligence for evaluation e-voucher airline report. Int. J. Mech. Eng. Technol. (IJMET) 10(2), 213–220 (2019). https://iaeme.com/MasterAdmin/Journal_uploads/IJMET/VOLUME_10_ISSUE_2/IJMET_10_02_024.pdf. Accessed 16 Apr 2022

  7. Karam, Z.: A Study on applying data mining in airline industry for demand forecasting by predicting item criticality (2018). https://bspace.buid.ac.ae/bitstream/handle/1234/1248/2015128179.pdf?sequence=1. Accessed 16 Apr 2022

  8. Chung, P., Chung, S.: On data integration and data mining for developing business intelligence. In: 2013 IEEE Long Island Systems, Applications and Technology Conference (LISAT) (2013). https://doi.org/10.1109/lisat.2013.6578235. Accessed 16 Apr 2022

  9. Watson, H., Wixom, B., Hoffer, J.: Continental airlines flies sky high with business intelligence (2004). https://www.academia.edu/26484864/Continental_Airlines_Flies_Sky_High_with_Business_Intelligence. Accessed 16 Apr 2022

  10. Watson, H., Wixom, B., Hoffer, J., Anderson-Lehman, R., Reynolds, A.: Real-time business intelligence: best practices at continental airlines. EDPACS 40(6), 1–16 (2009). https://doi.org/10.1080/07366980903484935. Accessed 16 Apr 2022

  11. Oliveira, Â., Mendes, A., Gomes, L.: Big data in SATA airline finding new solutions for old problems. Int. J. Comput. Sci. Inf. Secur. (IJCSIS) 14(6) (2016). https://repositorioaberto.uab.pt/bitstream/10400.2/7650/1/Big_Data_in_SATA_Airline_finding_new_sol.pdf. Accessed 16 Apr 2022

  12. Singh, S., Singh, N.: Big data analytics. In: 2012 International Conference on Communication, Information & Computing Technology (ICCICT) (2012). https://doi.org/10.1109/iccict.2012.6398180. Accessed 4 July 2022

  13. Acito, F., Khatri, V.: Business analytics: why now and what next? Bus. Horiz. 57(5), 565–570 (2014). https://doi.org/10.1016/j.bushor.2014.06.001. Accessed 4 July 2022

  14. Larsen, T.: Cross-platform aviation analytics using big-data methods. In: 2013 Integrated Communications, Navigation and Surveillance Conference (ICNS), pp. 1–9 (2013). https://doi.org/10.1109/ICNSurv.2013.6548579

  15. Ayhan, S., Pesce, J., Comitz, P., Sweet, D., Bliesner, S., Gerberick, G.: Predictive analytics with aviation big data. In: 2013 Integrated Communications, Navigation and Surveillance Conference (ICNS), pp. 1–13 (2013). https://doi.org/10.1109/ICNSurv.2013.6548556

  16. Junqué de Fortuny, E., Martens, D., Provost, F.: Predictive modeling with big data: is bigger really better? Big Data 1(4), 215–226 (2013). https://doi.org/10.1089/big.2013.0037. Accessed 4 July 2022

  17. Höpken, W., Fuchs, M., Höll, G., Keil, D., Lexhagen, M.: Multi-dimensional data modelling for a tourism destination data warehouse. In: Cantoni, L., Xiang, Z. (eds.) Information and Communication Technologies in Tourism 2013, pp. 157–169. Springer, Heidelberg (2013). https://doi.org/10.1007/978-3-642-36309-2_14. Accessed 16 Apr 2022

  18. Alfredo, Y., Girsang, A., Isa, S., Fajar, A.: Data warehouse development for flight reservation system. In: 2018 Indonesian Association for Pattern Recognition International Conference (INAPR) (2018). https://doi.org/10.1109/inapr.2018.8627015. Accessed 16 Apr 2022

  19. Donnelly, I.: Correlation of airline flight delays with weather conditions (2018). http://norma.ncirl.ie/3450/1/iandonnelly.pdf. Accessed 16 Apr 2022

  20. Hopfgartner, E., Schuetz, C., Schrefl, M.: A case study of success factors for data warehouse implementation and adoption in sales planning. In: AMCIS 2017 (2017). https://www.semanticscholar.org/paper/A-Case-Study-of-Success-Factors-for-Data-Warehouse-Hopfgartner-Sch%C3%BCtz/426e1293a2c471902d3f235b137f82684d9b608a. Accessed 16 Apr 2022

  21. Jayashree, G., Priya, D.: Design of visibility for order lifecycle using datawarehouse. Int. J. Eng. Adv. Technol. 8(6), 4700–4707 (2019). https://doi.org/10.35940/ijeat.f9171.088619. Accessed 16 Apr 2022

  22. Balasingham, R., Subash, R.: Designing a data warehouse system for sales and distribution company (2021). https://www.researchgate.net/publication/349098830_Designing_a_Data_Warehouse_System_for_Sales_and_Distribution_Company. Accessed 16 Apr 2022

  23. Girsang, A., Arisandi, G., Elysisa, C., Saragih, M.: Decision support system using data warehouse for retail system. J. Phys. Conf. Ser. 1367(1), 012007 (2019). https://doi.org/10.1088/1742-6596/1367/1/012007. Accessed 16 Apr 2022

  24. Jian-bo, W., Chong-jun, F.: Research on airport data warehouse architecture. Int. J. Bus. Humanit. Technol. 2(4) (2012). https://www.ijbhtnet.com/journals/Vol_2_No_4_June_2012/12.pdf. Accessed 16 Apr 2022

  25. Bahadir, C., Karahoca, A.: Airline revenue management via data mining. Glob. J. Inf. Technol. Emerg. Technol. 7(3), 128–148 (2017). https://doi.org/10.18844/gjit.v7i3.2834 Accessed 16 Apr 2022

  26. Arcondara, J., Himmi, K., Guan, P., Zhou, W.: Value oriented big data strategy: analysis & case study. Hdl.handle.net (2022). http://hdl.handle.net/10125/41277. Accessed 16 Apr 2022

  27. Hueglin, C., Vannotti, F.: Data mining techniques to improve forecast accuracy in airline business. In: Proceedings of the Seventh ACM SIGKDD International Conference on Knowledge Discovery and Data Mining - KDD 2001 (2001). https://doi.org/10.1145/502512.502578. Accessed 16 Apr 2022

  28. Jiang, D., Yu, D., Li, D., Qian, D.: Airline customer-centric E-business (CCEB) system meta model and data warehouse. In: Proceedings of 7th International We-B (Working For E-Business) Conference 2006 e-Business: how far have we come? (2006). https://researchbank.swinburne.edu.au/file/573ca290-d506-42d0-aca7-b8333851210f/1/PDF%20%28Published%20version%29.pdf. Accessed 16 Apr 2022

  29. Sidi, E., El, M., Amin, E.: Star schema advantages on data warehouse: using bitmap index and partitioned fact tables. Int. J. Comput. Appl. 134(13), 11–13 (2016). https://doi.org/10.5120/ijca2016908108

  30. Nazeri, Z.: Application of aviation safety data mining workbench at american airlines. The MITRE Corporation (2022). https://www.mitre.org/publications/technical-papers/application-of-aviation-safety-data-mining-workbench-at-american-airlines. Accessed 04 July 2022

  31. American Airlines flies its data warehouse to the cloud. SearchDataManagement (2022). https://www.techtarget.com/searchdatamanagement/news/252509924/American-Airlines-flies-its-data-warehouse-to-the-cloud. Accessed 04 July 2022

  32. Oracle.com (2022). https://www.oracle.com/technetwork/database/options/airlines-data-model/airlines-data-model-bus-overview-1451727.pdf. Accessed 04 July 2022

  33. Cloud Data Warehouse – Amazon Redshift – Amazon Web Services. Amazon Web Services, Inc. (2022). https://aws.amazon.com/redshift/. Accessed 04 July 2022

  34. Anderson-Lehman, R., Watson, H., Wixom, B., Hoffer, J.: Continental airlines flies high with real-time business intelligence. MIS Q. Execut. 3, 163–176 (2004)

    Google Scholar 

  35. Mendes, A., Guerra, H., Gomes, L., Oliveira, Â., Cavique, L.: Big data in SATA airline: finding new solutions for old problems. Hdl.handle.net (2022). http://hdl.handle.net/10400.3/4080. Accessed 03 July 2022

  36. Asharaff, M.: Study of data warehouse architecture. Glob. Sci. J. 10(2) (2022). https://www.globalscientificjournal.com/researchpaper/Study_of_Data_Warehouse_Architecture.pdf. Accessed 4 July 2022

  37. Four-Step Dimensional Design Process. Kimball Group (2022). https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/four-4-step-design-process/. Accessed 04 July 2022

  38. Iqbal, M., Mustafa, G., Sarwar, N., Wajid, S., Nasir, J., Siddque, S.: A review of star schema and snowflakes schema. In: Bajwa, I., Sibalija, T., Jawawi, D. (eds.) INTAP 2019. Communications in Computer and Information Science, vol. 1198, pp. 129–140. Springer, Singapore (2020). https://doi.org/10.1007/978-981-15-5232-8_12

  39. McKelvey, N., Curran, K., Toland, L.: The challenges of data cleansing with data warehouses. In: Effective Big Data Management and Opportunities for Implementation, pp. 77–82 (2016). https://doi.org/10.4018/978-1-5225-0182-4.ch005. Accessed 3 July 2022

  40. Bellatreche, L., Chakravarthy, S.: A special issue in extending data warehouses to big data analytics. Distrib. Parallel Databases 37(3), 323–327 (2019). https://doi.org/10.1007/s10619-019-07262-1

    Article  Google Scholar 

  41. Wu, L., Yuan, L., You, J.: Survey of large-scale data management systems for big data applications. J. Comput. Sci. Technol. 30(1), 163–183 (2015). https://doi.org/10.1007/s11390-015-1511-8. Accessed 4 July 2022

  42. https://joinup.ec.europa.eu/sites/default/files/document/2018-05/SC508DI07171%20D05.02%20Big%20Data%20Interoperability%20Analysis_v1.00.pdf

  43. Risks and challenges of data access and sharing. Oecd-ilibrary.org (2022). https://www.oecd-ilibrary.org/sites/15c62f9c-en/index.html?itemId=/content/component/15c62f9c-en. Accessed 04 July 2022

  44. Venkatraman, S., Venkatraman, R.: Communities of practice approach for knowledge management systems. Systems 6(4), 36 (2018). https://doi.org/10.3390/systems6040036. Accessed 4 July 2022

  45. Chen, E.T.: Implementation issues of enterprise data warehousing and business intelligence in the healthcare industry. Commun. IIMA 12(2), Article 3 (2012). https://scholarworks.lib.csusb.edu/ciima/vol12/iss2/3

  46. Andiyappillai, N.: Factors influencing the successful implementation of the warehouse management system (WMS). Int. J. Comput. Appl. 177(32), 21–25 (2020). https://doi.org/10.5120/ijca2020919787. Accessed 4 July 2022

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Kunal Kumar .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2023 The Author(s), under exclusive license to Springer Nature Singapore Pte Ltd.

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Gounder, P., Kumar, K. (2023). Perceiving Airline Passenger Booking Lifecycle with the Utilization of Data Warehouse. In: Hsu, CH., Xu, M., Cao, H., Baghban, H., Shawkat Ali, A.B.M. (eds) Big Data Intelligence and Computing. DataCom 2022. Lecture Notes in Computer Science, vol 13864. Springer, Singapore. https://doi.org/10.1007/978-981-99-2233-8_18

Download citation

  • DOI: https://doi.org/10.1007/978-981-99-2233-8_18

  • Published:

  • Publisher Name: Springer, Singapore

  • Print ISBN: 978-981-99-2232-1

  • Online ISBN: 978-981-99-2233-8

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics