Two Proposed Models for Securing Data Management for Enterprise Resource Planning Systems Using Blockchain Technology

Full Text (PDF, 294KB), PP.18-29

Views: 0 Downloads: 0


Nafiz Ahmed 1,* Anik Kumar Saha 1 Mustafa Ahmad Arabi 1 Sheikh Talha Jubayer Rahman 1 Dip Nandi 1

1. Department of Computer Science and Engineering, American International University-Bangladesh, Dhaka-1229, Bangladesh

2. Faculty Of Science and Technology, American International University-Bangladesh, Dhaka-1229, Bangladesh

* Corresponding author.


Received: 15 Jun. 2023 / Revised: 4 Jul. 2023 / Accepted: 23 Aug. 2023 / Published: 8 Dec. 2023

Index Terms

Blockchain Technology, Enterprise Resource Planning, ERP, Ralph Kimball, Dimensional Modelling, Database Sharding


An Enterprise Resource Planning (ERP) system is a software application that serves as a centralized platform to streamline and automate organizational functions and share real-time data, facilitating efficient communication and collaboration. It provides an all-inclusive approach to managing and optimizing business processes, boosting efficiency, fostering cooperation, and giving an overall picture of how the organization is operating. However, the traditional centralized databases in ERP systems pose security concerns. Blockchain Technology can be an appealing alternative as it comes with immutable and decentralized data as well as enhanced security. This study focuses on two methods of securing data management in ERP systems: Organizing the distributed information using The Ralph Kimball data model and optimizing an individual block using Database Sharding. This study does an extensive examination to determine the effectiveness of both suggested strategies, comprising a detailed evaluation that highlights the benefits and limitations of both techniques. This paper intends to patch the security holes in ERP systems to safeguard sensitive data and mitigate risks.

Cite This Paper

Nafiz Ahmed, Anik Kumar Saha, Mustafa Ahmad Arabi, Sheikh Talha Jubayer Rahman, Dip Nandi, "Two Proposed Models for Securing Data Management for Enterprise Resource Planning Systems Using Blockchain Technology", International Journal of Information Engineering and Electronic Business(IJIEEB), Vol.15, No.6, pp. 18-29, 2023. DOI:10.5815/ijieeb.2023.06.02


[1] El Amrani, R.; Rowe, F.; Geffroy, B. The effects of enterprise resource planning implementation strategy on cross-functionality. Inf. Syst. J. 2006, 16, 79–104. [CrossRef]
[2] Somers, T.; Nelson, K. The impact of critical success factors across the stages of enterprise resource planning implementations. In Proceedings of the 34th Hawaii International Conference on System Sciences, Maui, HI, USA, 6 January 2001.
[3] Kitsantas, T.; Vazakidis, A.; Chytis, E. A Review of Blockchain Technology and Its Applications in the Business Environment. In Proceedings of the 16th International Conference on Enterprise, Systems, Accounting. Logistics and Management, Chania, Greece, 1–3 July 2019; Volume 16, pp. 166–178.
[4] Mougayar, W.; Buterin, V. The Business Blockchain: Promise, Practice, and Application of the Next Internet Technology, 1st ed.; John Wiley & Sons, Inc.: Hoboken, NJ, USA, 2016.
[5] Hader, M.; Elmhamedi, A.; Abouabdellah, A. Blockchain Integrated ERP For a Better Supply Chain Management. In Proceedings of the 2020 IEEE 7th International Conference on Industrial Engineering and Applications (ICIEA), Bangkok, Thailand, 16–21 April 2020, 139-143.
[6] Tapscott, D.; Tapscott, A. The impact of the blockchain goes beyond financial services. Harv. Bus. Rev. 2016, 10, 7.
[7] Lansiti, M.; Lakhani, K. The truth about blockchain. Harv. Bus. Rev. 2017, 95, 118–127.
[8] Korpela, K.; Hallikas, J.; Dahlberg, T. Digital supply chain transformation toward blockchain integration. In Proceedings of the 50th Hawaii International Conference on System Sciences, Hilton Waikoloa Village, HI, USA, 4–7 January 2017; pp. 1–10.
[9] Perboli, G.; Musso, S.; Rosano, M. Blockchain in logistics and supply chain: A lean approach for designing real-world use cases. IEEE Access 2018, 6, 62018–62028.
[10] Niranjanamurthy, M.; Nithya, B.; Jagannatha, S. Analysis of blockchain technology: Pros, cons and SWOT. Clust. Comput. 2019, 22, 14743–14757.
[11] Manupati, V.K.; Schoenherr, T.; Ramkumar, M.; Wagner, S.M. A blockchain-based approach for a multi-echelon sustainable supply chain. Int. J. Prod. Res. 2020, 58, 2222–2241.
[12] Moosavi, J.; Naeni, L.M.; Fathollahi-Fard, A.M.; Fiore, U. Blockchain in supply chain management: A review, bibliometric, and network analysis. Environ. Sci. Pollut. Res. 2021, 23, 1–15.
[13] Carolyne Kimani, James I. Obuhuma, Emily Roche, "Multi-Factor Authentication for Improved Enterprise Resource Planning Systems Security", International Journal of Information Technology and Computer Science, Vol.15, No.3, pp.42-54, 2023.
[14] Holsapple, C.W.; Sena, M. ERP plans and decision-support benefits. Decis. Support Syst. 2005, 38, 75–590. [CrossRef]
[15] Mabert, V.; Soni, A.; Venkataraman, N. Enterprise resource planning survey of U.S. manufacturing firms. Prod. Inventory Manag. J. 2000, 41, 52–58.
[16] Davenport, T. Putting the enterprise into the enterprise system. Harv. Bus. Rev. 1998, 76, 121–131.
[17] Hunton, J. Blending Information and Communication Technology with Accounting Research. Account. Horiz. 2002, 16, 55–67. [CrossRef]
[18] Olhager, J.; Selldin, E. Enterprise resource planning survey of Swedish manufacturing firms. Eur. J. Oper. Res. 2003, 146, 365–373. [CrossRef]
[19] Khanfar, A.A.; Iranmanesh, M.; Ghobakloo, M.; Senali, M.G.; Fathi, M. Applications of blockchain technology in sustainable manufacturing and supply management: A systematic review. Sustainability 2021, 13, 7870. [CrossRef]
[20] Leng, J.; Ruan, G.; Jiang, P.; Xu, K.; Liu, Q.; Zhou, X.; Liu, C. Blockchain-empowered sustainable manufacturing and product lifecycle management in industry 4.0: A survey. Renew. Sustain. Energy Rev. 2020, 132, 110–112. [CrossRef]
[21] Bjelland, E.; Haddara, M. Evolution of ERP systems in the cloud: A study on system updates. Systems 2018, 6, 22. [CrossRef]
[22] Stark, C. The History of Cloud Computing; Cetrom Information Technology, Inc.: Vienna, VA, USA, 2012.
[23] Leng, J.; Ye, S.; Zhou, M.; Zhao, J.; Liu, Q.; Guo, W.; Cao, W.; Fu, L. Blockchain-secured smart manufacturing in industry 4.0: A survey. IEEE Trans. Syst. Man Cybern. Syst. 2021, 51, 237–252. [CrossRef]
[24] Oishi Chowdhury, Md Al Samiul Amin Rishat, Md. Al-Amin, Md. Hanif Bin Azam, " The Decentralized Shariah-Based Banking System in Bangladesh Using Block-chain Technology", International Journal of Information Engineering and Electronic Business, Vol.15, No.3, pp. 12-28, 2023.
[25] Nakamoto, S. Bitcoin: A peer-to-peer electronic cash system. Decentralized Bus. Rev. 2008, 4, 21260.
[26] Bogart, S.; Rice, K. The Blockchain Report: Welcome to the Internet of Value. Needham Insights 2015, 5, 1–10.
[27] Mutambaie, M. Blockchain Technology—The Next Computing Paradigm Shift; University of Johannesburg: Johannesburg, South Africa, 2018.
[28] Khan, M.; Salah, K. LoT security: Review, blockchain solutions, and open challenges. Future Gener. Comput. Syst. 2018, 82, 395–411. [CrossRef]
[29] Dai, J.; Vasarhelyi, M. Toward blockchain-based accounting and assurance. J. Inf. Syst. 2017, 31, 5–21. [CrossRef]
[30] Parikh, T. The ERP of the Future: Blockchain of Things. Int. J. Sci. Res. Sci. Eng. Technol. 2018, 4, 1341–1348.
[31] Haddara, M.; Norveel, J.; Langseth, M. Enterprise Systems and Blockchain Technology: The Dormant Potentials. Procedia Comput. Sci. 2021, 181, 562–571. [CrossRef]
[32] Gartner Identifies the Top 10 Strategic Technology Trends for 2019. Gartner, 15 October 2018.
[33] Xu, C.; Fang, Y.; Ma, Y. Integrated Application of Blockchain in the Electric Information Management System. Procedia Computer. Sci. 2019, 62, 88–93. [CrossRef]
[34] Banerjee, A. Blockchain Technology: Supply Chain Insights from ERP. Adv. Comput. 2018, 111, 69–98.
[35] Faccia, A.; Mosteanu, N. Accounting and blockchain technology: From double-entry to triple-entry. Bus. Manag. Rev. 2019, 10, 108–116.
[36] Reascos, I., Carvalho, J.A. (2018). “A Conceptual Framework for the Implantation of Enterprise Applications in Small and Medium Enterprises (SMEs).” In: Rocha, Á., Guarda, T. (eds) Proceedings of the International Conference on Information Technology & Systems (ICITS 2018). ICITS 2018. Advances in Intelligent Systems and Computing, vol 721. Springer, Cham. DOI:
[37] Evren Coşkun, Bahar Gezici, Murat Aydos, Ayça Kolukısa Tarhan, Vahid Garousi, “ERP failure: A systematic mapping of the literature”, Data & Knowledge Engineering, Volume 142, 2022, 102090, ISSN 0169-023X. DOI:
[38] 2022 ERP project report – Software Path.
[39] What Is The Cost of A Typical ERP Implementation?.
[40] Panorama Consulting Group (2009), Panorama Consulting Group 2008 ERP Report, Denver. Available at:
[41] Mahmood, Faisal & Khan, Abdul & Bokhari, Rahat. (2019). ERP issues and challenges: a research synthesis. Kubernetes. ahead-of-print. DOI:
[42] Marc N. Haines (2009) Understanding Enterprise System Customization: An Exploration of Implementation Realities and the Key Influence Factors, Information Systems Management, 26:2, 182-198, DOI:
[43] Pan, K., Baptista Nunes, M. and Chao Peng, G. (2011), “Risks affecting ERP post-implementation: Insights from a large Chinese manufacturing group”, Journal of Manufacturing Technology Management, Vol. 22 No. 1, pp. 107-130. DOI:
[44] Hale, Z. (2019), “What factors determine the cost of ERP software?”. Available at: (accessed 3 March 2023).
[45] David Gefen, Nurturing clients’ trust to encourage engagement success during the customization of ERP systems. 2002.
[46-26] Negin Banaeianjahromi, Tommi Kähkönen, Aki Alanne, Kari Smolander, Integration Obstacles During ERP Development. 2016.
[47] Isabel Alcivar, Andres G. Abad, "Design and evaluation of a gamified system for ERP training, Computers in Human Behavior," Volume 58, 2016, Pages 109-118, ISSN 0747-5632.
[48] Wei She & Bhavani Thuraisingham, Security for Enterprise Resource Planning Systems. 2007.
[49] Hrischev, R. (2020) “ERP systems and Data Security,” IOP Conference Series: Materials Science and Engineering, 878(1), p. 012009. Available at:
[50] Fauscette, M. (2013). ERP in the Cloud and the Modern Business. [online] Available at: [Accessed 14 Feb. 2023].
[51] Saa, P., Costales, A. C., Moscoso-Zea, O., & Lujan-Mora, S. (2017). Moving ERP Systems to the Cloud - Data Security Issues. Journal of Information Systems Engineering and Management, 2(4), 21.
[52] Cristina Lopez, Jose L. Salmeron, Dynamic risks modelling in ERP maintenance projects with FCM. 2012.
[53] Thomas Kitsantas, Exploring Blockchain Technology and Enterprise Resource Planning System: Business and Technical Aspects, Current Problems, and Future Perspectives. 2022.