Skip to main content
SpringerLink
Log in

ETL for Aviation Maintenance and Operations as a Multi Objective Optimization Task

  • Conference paper
  • First Online:
Reliability and Statistics in Transportation and Communication (RelStat 2021)

Part of the book series: Lecture Notes in Networks and Systems ((LNNS,volume 410))

  • 736 Accesses

Abstract

In the process of organizing the Extraction, Transformation and Loading project, a significant problem arises associated with the need to optimize the limited resources spent on the project, considering the need to achieve a given level of quality of migrated data. This problem is certainly typical for all industries, but it is especially acute in the field of aviation maintenance and operation of aircraft, since the quality of data directly affects the safety of air transportation, and resources, primarily human resources, are extremely limited and expensive. Within the framework of this study, the problems of efficient resource allocation are defined as a multi-objective optimization task. The paper presents the definitions of the objective functions of the problems under consideration, including all the necessary restrictions.

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

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 229.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 299.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. El-Sappagh, S.H.A., Hendawi, A.M.A., El Bastawissy, A.H.: A proposed model for data warehouse ETL processes. J. King Saud Univ. - Comput. Inf. Sci. 23(2) (2011). https://doi.org/10.1016/j.jksuci.2011.05.005

  2. Faridi Masouleh, M., Afshar Kazemi, M.A., Alborzi, M., Toloie Eshlaghy, A.: Optimization of ETL process in data warehouse through a combination of parallelization and shared cache memory. Eng. Technol. Appl. Sci. Res. 6(6) (2016). https://doi.org/10.48084/etasr.849

  3. Simitsis, A., Wilkinson, K., Castellanos, M., Dayal, U.: QoX-driven ETL design: reducing the cost of ETL consulting engagements. In: Proceedings of the International Conference on Management of Data and 28th Symposium on Principles of Database Systems, SIGMOD-PODS 2009, pp. 953–960 (2009). https://doi.org/10.1145/1559845.1559954

  4. Zwikael, O., Meredith, J.: Evaluating the success of a project and the performance of its leaders. IEEE Trans. Eng. Manag. 68(6), 1745–1757 (2021). https://doi.org/10.1109/TEM.2019.2925057

  5. Shenhar, A., Holzmann, V.: The three secrets of megaproject success: clear strategic vision, total alignment, and adapting to complexity. Proj. Manag. J. 48(6) (2017). https://doi.org/10.1177/875697281704800604

  6. Rezvani, A., Khosravi, P., Ashkanasy, N.M.: Examining the interdependencies among emotional intelligence, trust, and performance in infrastructure projects: a multilevel study. Int. J. Proj. Manag. 36(8) (2018). https://doi.org/10.1016/j.ijproman.2018.08.002

  7. Müller, R., Martinsuo, M.: The impact of relational norms on information technology project success and its moderation through project governance. Int. J. Manag. Proj. Bus. 8(1) (2015). https://doi.org/10.1108/IJMPB-04-2014-0036

  8. Ullah, F., Thaheem, M.J., Siddiqui, S.Q., Khurshid, M.B.: Influence of Six Sigma on project success in construction industry of Pakistan. TQM J. 29(2) (2017). https://doi.org/10.1108/TQM-11-2015-0136

  9. Shenhar, A.J., Tishler, A., Dvir, D., Lipovetsky, S., Lechler, T.: Refining the search for project success factors: a multivariate, typological approach R D Manag. 32(2) (2002). https://doi.org/10.1111/1467-9310.00244

  10. Petter, S., Delone, W., McLean, E.R.: Information systems success: the quest for the independent variables. J. Manag. Inf. Syst. 29(4) (2013). https://doi.org/10.2753/MIS0742-1222290401

  11. Gil, N., Pinto, J.K.: Polycentric organizing and performance: a contingency model and evidence from megaproject planning in the UK. Res. Policy 47(4) (2018). https://doi.org/10.1016/j.respol.2018.02.001

  12. Zwikael, O., Smyrk, J.: A general framework for gauging the performance of initiatives to enhance organizational value. Br. J. Manag. 23(Suppl. 1) (2012). https://doi.org/10.1111/j.1467-8551.2012.00823.x

  13. KPMG: Project Management Survey Report. KPMG, New Zealand (2010)

    Google Scholar 

  14. KPMG: Project Management Survey Report. KPMG, New Zealand (2013)

    Google Scholar 

  15. KPMG: Project Management Survey Report. KPMG, New Zealand (2017)

    Google Scholar 

  16. KPMG, AIPM, and IPMA: Project management survey: the future of project management global outlook (2019)

    Google Scholar 

  17. Almeida, F., Santos, J.D., Monteiro, J.A.: The challenges and opportunities in the digitalization of companies in a post-COVID-19 world. IEEE Eng. Manag. Rev. 48(3), 97–103 (2020). https://doi.org/10.1109/EMR.2020.3013206

  18. Davis, K.: An empirical investigation into different stakeholder groups perception of project success. Int. J. Proj. Manag. 35(4), 604–617 (2017). https://doi.org/10.1016/j.ijproman.2017.02.004

  19. Cerpa, N., Verner, J.M.: Why did your project fail?. Commun. ACM 52(12) (2009). https://doi.org/10.1145/1610252.1610286

  20. McLeod, L., MacDonell, S.G.: Factors that affect software systems development project outcomes: a survey of research. ACM Comput. Surv. 43(4) (2011). https://doi.org/10.1145/1978802.1978803

  21. Wallace, L., Keil, M.: Software project risks and their effect on outcomes. Commun. ACM 47(4) (2004). https://doi.org/10.1145/975817.975819

  22. Lauesen, S.: IT project failures, causes and cures. IEEE Access 8, 72059–72067 (2020). https://doi.org/10.1109/ACCESS.2020.2986545

    Article  Google Scholar 

  23. Shahhosseini, V., Afshar, M.R., Amiri, O.: The root causes of construction project failure. Sci. Iran. 25(1), 93–108 (2018). https://doi.org/10.24200/sci.2017.4178

  24. Kappelman, L.A., McKeeman, R., Zhang, L.: Early warning signs of IT project failure: the dominant dozen. Inf. Syst. Manag. 23(4), 31–36 (2006). https://doi.org/10.1201/1078.10580530/46352.23.4.20060901/95110.4

  25. Boehm, B.W.: Software risk management: principles and practices. IEEE Softw. 8(1), 32–41 (1991). https://doi.org/10.1109/52.62930

    Article  Google Scholar 

  26. Turner, R., Zolin, R.: Forecasting success on large projects: developing reliable scales to predict multiple perspectives by multiple stakeholders over multiple time frames. Proj. Manag. J. 43(5) (2012). https://doi.org/10.1002/pmj.21289

  27. Freeman, R.E., Harrison, J.S., Wicks, A.C., Parmar, B., de Colle, S.: Stakeholder theory: the state of the art (2010)

    Google Scholar 

  28. Leisyte, L., Westerheijden, D.F.: Stakeholders and quality assurance in higher education. In: Drivers and Barriers to Achieving Quality in Higher Education (2014)

    Google Scholar 

  29. Pivovar, M., Rozhkova, L., Misnevs, B., Pticina, I.: Data quality indicators of ETL in the process of implementation of information systems for aircraft maintenance and operation. In: Kabashkin, I., Yatskiv, I., Prentkovskis, O. (eds.) RelStat 2020. LNNS, vol. 195, pp. 130–139. Springer, Cham (2021). https://doi.org/10.1007/978-3-030-68476-1_12

    Chapter  Google Scholar 

  30. Pivovar, M., Misnevs, B., Pticina, I.: Methodology for calculating ETL indicators in the process of implementation of aircraft maintenance information systems. In: Kabashkin, I., Yatskiv, I., Prentkovskis, O. (eds.) RelStat 2019. LNNS, vol. 117, pp. 44–53. Springer, Cham (2020). https://doi.org/10.1007/978-3-030-44610-9_5

    Chapter  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. S7 Technics, Domodedovo Airport Building 9, Moscow, Russia

    Maxim Pivovar

  2. Transport and Telecommunication Institute, 1 Lomonosova Street, Riga, Latvia

    Maxim Pivovar

Authors
  1. Maxim Pivovar
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Maxim Pivovar .

Editor information

Editors and Affiliations

  1. Transport and Telecommunication Institute, Riga, Latvia

    Igor Kabashkin

  2. Transport and Telecommunication Institute, Riga, Latvia

    Irina Yatskiv

  3. Vilnius Gediminas Technical University, Vilnius, Lithuania

    Olegas Prentkovskis

Rights and permissions

Reprints and permissions

Copyright information

© 2022 The Author(s), under exclusive license to Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Pivovar, M. (2022). ETL for Aviation Maintenance and Operations as a Multi Objective Optimization Task. In: Kabashkin, I., Yatskiv, I., Prentkovskis, O. (eds) Reliability and Statistics in Transportation and Communication. RelStat 2021. Lecture Notes in Networks and Systems, vol 410. Springer, Cham. https://doi.org/10.1007/978-3-030-96196-1_14

Download citation

Publish with us

Policies and ethics

Search

Navigation