УПОРЕДНА АНАЛИЗА ETL АЛАТА – СИСТЕМАТСКИ ПРЕГЛЕД ЛИТЕРАТУРЕ
Ključne reči:
складишта података, ETL алати, ЕТL, пословна интелигенција
Apstrakt
ETL (Extraction, Transform, Load) алати су изузетно битни софтверски производи зато што олакшавају и подржавају ефикасно и квалитетно спровођење ЕТL процеса, и посредно доприносе квалитету система складишта података. У овом раду је кроз систематски преглед литературе представљено стање на тржишту у покушају да се објасни позиција комерцијалних и бесплатних алата, и да се одговори на питање правилног избора ETL алата.
Reference
[1] H. S. Rose, P. Raibagkar, „A Comparative Study of ETL Tools“, IJSRD-International Journal for Scientific Research & Development, том 4, изд. 5, стр. 315–319, 2016.
[2] R. Kimball, J. Caserta, The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data, First. Wiley Publishing, 2004.
[3] A. Kabiri, D. Chiadmi, „Survey on ETL processes“, Journal of Theoretical and Applied Information Technology XX st Month, стр. 219–229, 2013.
[4] N. Biswas, A. Sarkar, K. C. Mondal, „Empirical Analysis of Programmable ETL Tools“, у Communications in Computer and Information Science, 2019, том 1031, стр. 267–277.
[5] T. A. Majchrzak, T. Jansen, H. Kuchen, „Efficiency evaluation of open source ETL tools“, у Proceedings of the 2011 ACM Symposium on Applied Computing - SAC ’11, 2011, стр. 287.
[6] J. P. A. Runtuwene, I. R. H. T. Tangkawarow, C. T. M. Manoppo, R. J. Salaki, „A Comparative Analysis of Extract, Transformation and Loading (ETL) Process“, у IOP Conference Series: Materials Science and Engineering, Феб. 2018, том 306, изд. 1.
[7] M. Souibgui, F. Atigui, S. Zammali, S. Cherfi, S. ben Yahia, „Data quality in ETL process: A preliminary study“, Procedia Comput Sci, том 159, стр. 676–687, 2019.
[8] D. Narandžić, S. Ristić, D. Stefanović, T. Lolić, „The Challenge of an Extraction-Transformation-Loading Tool Selection“, у XIV International Conference on Systems, Automatic Control and Measurements SAUM, Niš, 2018, стр. 42–45.
[9] V. M. Parra, A. Syed, A. Mohammad, M. N. Halgamuge, „Pentaho and Jaspersoft: A Comparative Study of Business Intelligence Open Source Tools Processing Big Data to Evaluate Performances“, 2016.
[10] M. L. Grecol, „Microsoft SSIS and Pentaho Kettle: A Comparative Study for Three-Tier Data Warehouses“, Statesboro, 2012.
[11] Akshay Dinesh Badgujar, Saurabh Shrikant Kadam, Manasi Mohan Zambare, Shubham Raghavendra Kulkarni, „A Comparative Study: Business Intelligence Tools“, International Journal of Research in Engineering, Science and Management, том 5, изд. 1, стр. 98–100, 2022.
[12] V. A. Kherdekar, P. S. Metkewar, „A technical comprehensive survey of ETL tools“, International Journal of Applied Engineering Research, том 11, изд. 4, стр. 2557–2559, Март 2016.
[13] M. Patel, D. B. Patel, „Progressive Growth of ETL Tools: A Literature Review of Past to Equip Future“, у Advances in Intelligent Systems and Computing, 2021, том 1187, стр. 389–398.
[14] R. Katragadda, S. S. Tirumala, D. Nandigam, „ETL tools for Data Warehousing: An empirical study of Open Source Talend Studio versus Microsoft SSIS“, 2015.
[15] J. Sreemathy, R. Brindha, M. Selva Nagalakshmi, N. Suvekha, N. Karthick Ragul, M. Praveennandha, „Overview of ETL Tools and Talend-Data Integration“, у 2021 7th International Conference on Advanced Computing and Communication Systems, ICACCS 2021, Март 2021, стр. 1650–1654.
[16] G. S, K. Rajesh Dhanani, P. Pankaj Doshi, „DATA ANALYSIS AND ETL TOOLS IN BUSINESS INTELLIGENCE“, International Research Journal of Computer Science, том 07, изд. 05, стр. 127–132, Мај 2020.
[17] N. Rodriguez, K. Lawson, E. Molina, J. Gutierrez, „Data Warehousing Tool Evaluation-ETL Focused“, Edinburg, 2011.
[18] I. I. Kholod, M. S. Efimova, S. Ya. Kulikov, „Using ETL Tools for Developing a Virtual Data Warehouse“, 2016.
[19] P. S. Diouf, A. Boly, S. Ndiaye, „Performance of the ETL processes in terms of volume and velocity in the cloud: State of the art“, у 2017 4th IEEE International Conference on Engineering Technologies and Applied Sciences (ICETAS), Нов. 2017, стр. 1–5.
[20] Md. Badiuzzaman Biplob, G. A. Sheraji, S. I. Khan, „Comparison of Different Extraction Transformation and Loading Tools for Data Warehousing“, у 2018 International Conference on Innovations in Science, Engineering and Technology (ICISET), Окт. 2018, стр. 262–267.
[21] M. N. Mali, M. Sachinbojewar, „A Survey of ETL Tools“, International Journal of Computer Techniques, том 2, изд. 5, стр. 20–26, 2015.
[22] R. Mukherjee, P. Kar, „A Comparative Review of Data Warehousing ETL Tools with New Trends and Industry Insight“, у 2017 IEEE 7th International Advance Computing Conference (IACC), Јан. 2017, стр. 943–948.
[23] S. Misra, S. K. Saha, C. Mazumdar, „Performance Comparison of Hadoop Based Tools with Commercial ETL Tools – A Case Study“, у LNCS, том 8302, 2013, стр. 176–184.
[24] N. Schmidt, M. Rosa, R. Garcia, E. Molina, R. Reyna, J. Gonzalez, „ETL Tool Evaluation-A Criteria Framework“, Edinburg, 2011.
[25] J. Singh, A. Singh, „A comparative Review of Extraction, Transformation and Loading Tools“, Database Systems Journal, том 4, изд. 2, стр. 42–51, 2013.
[26] „Hitachi Data Systems Completes Pentaho Acquisition“, Јуни 04, 2015. https://www.hitachivantara.com/en-us/news/in-the-press/2015/gl150604.html (приступљено у августу 2022).
[27] Н. Ковачевић, „Упоредна анализа ETL алата – систематски преглед литературе и студија случаја пројектовања и имплементације складишта података“, Факултет техничких наука, Нови Сад, 2022.
[28] B. A. Kitchenham, S. Charters, „Guidelines for performing Systematic Literature Reviews in Software Engineering“, Авг. 2007.
[2] R. Kimball, J. Caserta, The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data, First. Wiley Publishing, 2004.
[3] A. Kabiri, D. Chiadmi, „Survey on ETL processes“, Journal of Theoretical and Applied Information Technology XX st Month, стр. 219–229, 2013.
[4] N. Biswas, A. Sarkar, K. C. Mondal, „Empirical Analysis of Programmable ETL Tools“, у Communications in Computer and Information Science, 2019, том 1031, стр. 267–277.
[5] T. A. Majchrzak, T. Jansen, H. Kuchen, „Efficiency evaluation of open source ETL tools“, у Proceedings of the 2011 ACM Symposium on Applied Computing - SAC ’11, 2011, стр. 287.
[6] J. P. A. Runtuwene, I. R. H. T. Tangkawarow, C. T. M. Manoppo, R. J. Salaki, „A Comparative Analysis of Extract, Transformation and Loading (ETL) Process“, у IOP Conference Series: Materials Science and Engineering, Феб. 2018, том 306, изд. 1.
[7] M. Souibgui, F. Atigui, S. Zammali, S. Cherfi, S. ben Yahia, „Data quality in ETL process: A preliminary study“, Procedia Comput Sci, том 159, стр. 676–687, 2019.
[8] D. Narandžić, S. Ristić, D. Stefanović, T. Lolić, „The Challenge of an Extraction-Transformation-Loading Tool Selection“, у XIV International Conference on Systems, Automatic Control and Measurements SAUM, Niš, 2018, стр. 42–45.
[9] V. M. Parra, A. Syed, A. Mohammad, M. N. Halgamuge, „Pentaho and Jaspersoft: A Comparative Study of Business Intelligence Open Source Tools Processing Big Data to Evaluate Performances“, 2016.
[10] M. L. Grecol, „Microsoft SSIS and Pentaho Kettle: A Comparative Study for Three-Tier Data Warehouses“, Statesboro, 2012.
[11] Akshay Dinesh Badgujar, Saurabh Shrikant Kadam, Manasi Mohan Zambare, Shubham Raghavendra Kulkarni, „A Comparative Study: Business Intelligence Tools“, International Journal of Research in Engineering, Science and Management, том 5, изд. 1, стр. 98–100, 2022.
[12] V. A. Kherdekar, P. S. Metkewar, „A technical comprehensive survey of ETL tools“, International Journal of Applied Engineering Research, том 11, изд. 4, стр. 2557–2559, Март 2016.
[13] M. Patel, D. B. Patel, „Progressive Growth of ETL Tools: A Literature Review of Past to Equip Future“, у Advances in Intelligent Systems and Computing, 2021, том 1187, стр. 389–398.
[14] R. Katragadda, S. S. Tirumala, D. Nandigam, „ETL tools for Data Warehousing: An empirical study of Open Source Talend Studio versus Microsoft SSIS“, 2015.
[15] J. Sreemathy, R. Brindha, M. Selva Nagalakshmi, N. Suvekha, N. Karthick Ragul, M. Praveennandha, „Overview of ETL Tools and Talend-Data Integration“, у 2021 7th International Conference on Advanced Computing and Communication Systems, ICACCS 2021, Март 2021, стр. 1650–1654.
[16] G. S, K. Rajesh Dhanani, P. Pankaj Doshi, „DATA ANALYSIS AND ETL TOOLS IN BUSINESS INTELLIGENCE“, International Research Journal of Computer Science, том 07, изд. 05, стр. 127–132, Мај 2020.
[17] N. Rodriguez, K. Lawson, E. Molina, J. Gutierrez, „Data Warehousing Tool Evaluation-ETL Focused“, Edinburg, 2011.
[18] I. I. Kholod, M. S. Efimova, S. Ya. Kulikov, „Using ETL Tools for Developing a Virtual Data Warehouse“, 2016.
[19] P. S. Diouf, A. Boly, S. Ndiaye, „Performance of the ETL processes in terms of volume and velocity in the cloud: State of the art“, у 2017 4th IEEE International Conference on Engineering Technologies and Applied Sciences (ICETAS), Нов. 2017, стр. 1–5.
[20] Md. Badiuzzaman Biplob, G. A. Sheraji, S. I. Khan, „Comparison of Different Extraction Transformation and Loading Tools for Data Warehousing“, у 2018 International Conference on Innovations in Science, Engineering and Technology (ICISET), Окт. 2018, стр. 262–267.
[21] M. N. Mali, M. Sachinbojewar, „A Survey of ETL Tools“, International Journal of Computer Techniques, том 2, изд. 5, стр. 20–26, 2015.
[22] R. Mukherjee, P. Kar, „A Comparative Review of Data Warehousing ETL Tools with New Trends and Industry Insight“, у 2017 IEEE 7th International Advance Computing Conference (IACC), Јан. 2017, стр. 943–948.
[23] S. Misra, S. K. Saha, C. Mazumdar, „Performance Comparison of Hadoop Based Tools with Commercial ETL Tools – A Case Study“, у LNCS, том 8302, 2013, стр. 176–184.
[24] N. Schmidt, M. Rosa, R. Garcia, E. Molina, R. Reyna, J. Gonzalez, „ETL Tool Evaluation-A Criteria Framework“, Edinburg, 2011.
[25] J. Singh, A. Singh, „A comparative Review of Extraction, Transformation and Loading Tools“, Database Systems Journal, том 4, изд. 2, стр. 42–51, 2013.
[26] „Hitachi Data Systems Completes Pentaho Acquisition“, Јуни 04, 2015. https://www.hitachivantara.com/en-us/news/in-the-press/2015/gl150604.html (приступљено у августу 2022).
[27] Н. Ковачевић, „Упоредна анализа ETL алата – систематски преглед литературе и студија случаја пројектовања и имплементације складишта података“, Факултет техничких наука, Нови Сад, 2022.
[28] B. A. Kitchenham, S. Charters, „Guidelines for performing Systematic Literature Reviews in Software Engineering“, Авг. 2007.
Objavljeno
2023-02-04
Sekcija
Industrijsko inženjerstvo i inženjerski menadžment
