Rakipten Ortaklığa: İlişkisel Veri Tabanları ve Blok Zinciri Arasında Birlikte Çalışabilirliğin Sağlanması

Abstract

Blok zinciri birlikte çalışabilirliği, genellikle çapraz zincir protokolleri, bulut hizmetleri veya Nesnelerin İnterneti (IoT) entegrasyonu bağlamında ele alınmış, ancak merkezi sistemlerle olan etkileşimi görece daha az ilgi görmüştür. Çoğu çalışma, ilişkisel veritabanları ve blok zincirini birbirine rakip teknolojiler olarak değerlendirmekte, bu da pratikte önemli bir boşluk bırakmaktadır. Bu makalede, MySQL ve Hyperledger Fabric'i birbirine bağlayan, şeffaf ve sistematik bir çapraz platform veri birlikte çalışabilirliğini destekleyen DECEN adlı kavramsal bir model sunulmaktadır. DECEN, sistemler arasındaki kayıtları MD5 hash ile oluşturulan benzersiz bir tanımlayıcı kullanarak birbirine bağlar. Bu basit bağlantı, iki platform arasında bilginin eşlenmesine, senkronize edilmesine, doğrulanmasına ve çapraz kontrolden geçirilmesine olanak tanır. Dolayısıyla blok zinciri, bir yedek olarak değil, ilişkisel veritabanlarının yanında tamamlayıcı bir ortak olarak işlev görür. Tüm veri kümelerini taşımak veya çoğaltmak yerine, blok zinciri ek bir doğrulama kaynağı olarak hizmet verebilen destekleyici bir katman olarak ele alınmaktadır. Böylece, veritabanının yerini almadan güvenilirliği ve güveni artırmak mümkün olabilmektedir. Bu yaklaşımın pratikte nasıl işlediğini göstermek için yükseköğretimdeki uygulamalara odaklanılmakta ve bir vaka çalışması olarak üniversite transkriptleri incelenmektedir. Yöntemin teknik olarak uygulanabilir olduğunu göstermek için bir prototip geliştirilmiş ve test edilmiş olup, kaynak kodu tekrarlanabilirlik, doğrulama ve ileri araştırmaları teşvik etmek amacıyla açık kaynak olarak paylaşılmıştır.

Keywords

• Blok Zinciri
• Birlikte Çalışabilirlik
• İlişkisel Veritabanı Yönetim Sistemleri
• Yükseköğretim Kurumları
• Veri Bütünleşmesi

From Rivals to Partners: Enabling Interoperability Between Relational Databases and Blockchain

Abstract

Blockchain interoperability has often been discussed in the context of cross-chain protocols, cloud services, or IoT integration, but much less attention has been paid to its interaction with centralized systems. Most studies treat relational databases and blockchains as competing technologies rather than complementary ones, leaving an important gap in practice. In this paper, we introduce DECEN, a conceptual model that connects MySQL and Hyperledger Fabric, supporting transparent and systematic cross-platform data interoperability. DECEN links records across systems by generating a unique identifier with an MD5 hash. This simple connection enables information to be mapped, synchronised, verified and cross-checked between the two platforms. Therefore, blockchain is not treated as a replacement but works alongside relational databases as a complementary partner. Rather than migrating or duplicating entire datasets, we treat the blockchain as a supporting layer that can serve as an extra source of verification. Such that, it can improve reliability and trust without replacing the database. To show how this works in practice, we look at applications in higher education and use university transcripts as a case study. A prototype was developed and tested to show that the approach is technically viable, and its source code has been openly shared to encourage repeatability, validation, and further research.

Keywords

• Blockchain
• interoperability
• relational database management systems
• higher education institutions
• data integration

References

1. D. L. Fekete and A. Kiss, “Toward building smart contract-based higher education systems using zero-knowledge Ethereum Virtual Machine,” Electronics, 12(3), 1–39, 2023.
2. H. A. Alsobhi, R. A. Alakhtar, A. Ubaid, O. K. Hussain, and F. K. Hussain, “Blockchain-based micro-credentialing system in higher education institutions: Systematic literature review,” Knowl.-Based Syst., 265, 110238, 2023.
3. A. Battah, K. Salah, R. Jayaraman, I. Yaqoob, and A. Khalil, “Using blockchain for enabling transparent, traceable, and trusted university ranking systems,” IEEE Access, 11, 23792–23807, 2023.
4. C. R. dos S. Ramos and M. M. Queiroz, “Blockchain in education: The influence of trust on adoption and implementation,” RAUSP Manag. J., 57(3), 316–331, 2022.
5. C. Delgado-Von-Eitzen, L. Anido-Rifón, and M. J. Fernández-Iglesias, “Blockchain applications in education: A systematic literature review,” Appl. Sci., 11(24), 11811, 2021.
6. F. Loukil, M. Abed, and K. Boukadi, “Blockchain adoption in education: A systematic literature review,” Educ. Inf. Technol., 26(5), 5779–5797, 2021.
7. P. Sharma, R. Jindal, and M. D. Borah, “A review of smart contract-based platforms, applications, and challenges,” Cluster Comput., 26(1), 395–421, 2023.
8. J. Kalajdjieski, M. Raikwar, N. Arsov, G. Velinov, and D. Gligoroski, “Databases fit for blockchain technology: A complete overview,” Blockchain Res. Appl., 4(1), 100116, 2023.

9. A. O. J. Kwok and H. Treiblmaier, “No one left behind in education: Blockchain-based transformation and its potential for social inclusion,” Asia Pac. Educ. Rev., 23(3), 445–455, 2022.
10. A. Mohammad and S. Vargas, “Challenges of using blockchain in the education sector: A literature review,” Appl. Sci., 12(13), 1–27, 2022.
11. A. Saxena and B. H. Chiu, “BOFUS and CLARITY: Streamlining blockchain architecture and assessment for advanced standardization and interoperability in distributed ledger technologies,” Front. Blockchain, 6, 1235088, 2023.
12. R. Song, B. Xiao, Y. Song, S. Guo, and Y. Yang, “A survey of blockchain-based schemes for data sharing and exchange,” IEEE Trans. Big Data, 9(6), 1477–1495, 2023.
13. S. S. Kushwaha, S. Joshi, D. Singh, M. Kaur, and H. N. Lee, “Systematic review of security vulnerabilities in Ethereum blockchain smart contract,” IEEE Access, 10, 6605–6621, 2022.
14. A. Vacca, A. Di Sorbo, C. A. Visaggio, and G. Canfora, “A systematic literature review of blockchain and smart contract development: Techniques, tools, and open challenges,” J. Syst. Softw., 174, 110891, 2021.
15. X. Li et al., “Blockchain security threats and collaborative defense: A literature review,” Comput. Mater. Contin., 76(3), 2597–2629, 2023.
16. D. C. G. Valadares, A. Perkusich, A. F. Martins, M. B. M. Kamel, and C. Seline, “Privacy-preserving blockchain technologies,” Sensors, 23(16), 7172, 2023.
17. M. Shohidul Islam et al., “Blockchain-enabled cybersecurity provision for scalable heterogeneous network: A comprehensive survey,” Comput. Model. Eng. Sci., 138(1), 43–123, 2024.
18. A. Aldoubaee, N. H. Hassan, and F. A. Rahim, “A systematic review on blockchain scalability,” Int. J. Adv. Comput. Sci. Appl., 14(9), 774–784, 2023.
19. A. Mohammad and S. Vargas, “Barriers affecting higher education institutions’ adoption of blockchain technology: A qualitative study,” Informatics, 9(3), 64, 2022.
20. A. Khanna et al., “Blockchain–cloud integration: A survey,” Sensors, 22(14), 5238 2022.
21. K. S. Alshudukhi, M. A. Khemakhem, F. E. Eassa, K. M. Jambi, “An interoperable blockchain security framework based on microservices and smart contract in IoT environment,” Electronics, 12(3), 776, 2023.
22. R. Yin, Z. Yan, X. Liang, H. Xie, and Z. Wan, “A survey on privacy preservation techniques for blockchain interoperability,” J. Syst. Archit., 140, 102892, 2023.
23. A. Lohachab et al., “Towards interconnected blockchains: A comprehensive review of the role of interoperability among disparate blockchains,” ACM Comput. Surv., 54(7), 1-39, 2021.
24. B. Pillai, K. Biswas, and V. Muthukkumarasamy, “Cross-chain interoperability among blockchain-based systems using transactions,” Knowl. Eng. Rev., 35, e23, 2020.
25. I. C. A. Pilares et al., “Addressing the challenges of electronic health records using blockchain and IPFS,” Sensors, 22(11), 4032, 2022.
26. A. A. Monrat, O. Schelén, and K. Andersson, “A survey of blockchain from the perspectives of applications, challenges, and opportunities,” IEEE Access, 7, 117134–117151, 2019.
27. S. D. Kotey et al., “Blockchain interoperability: The state of heterogeneous blockchain-to-blockchain communication,” IET Commun., 17( 8), 891–914, 2023.
28. G. Wang, Q. Wang, and S. Chen, “Exploring blockchains interoperability: A systematic survey,” ACM Comput. Surv., 55(13), 1-38, 2023.
29. R. Belchior, A. Vasconcelos, S. Guerreiro, and M. Correia, “A survey on blockchain interoperability: Past, present, and future trends,” ACM Comput. Surv., 54(8), 1-41, 2022.
30. M. Madine et al., “AppxChain: Application-level interoperability for blockchain networks,” IEEE Access, 9, 87777–87791, 2021.
31. P. Bellavista et al., “Interoperable blockchains for highly-integrated supply chains in collaborative manufacturing,” Sensors, 21(15), 4955, 2021.
32. P. Lafourcade and M. Lombard-Platet, “About blockchain interoperability,” Inf. Process. Lett., 161, 105976, 2020.
33. E. Safak, A. Furkan, and T. Erol, “Hybrid database design combination of blockchain and central database,” in Proc. 3rd Int. Symp. Multidiscip. Stud. Innov. Technol. (ISMSIT), Ankara, Turkey, 2019.
34. A. Garg et al., “Blockchain-based online education content ranking,” Educ. Inf. Technol., 27(4), 4793–4815, 2022.
35. H. Sun, X. Wang, and X. Wang, “Application of blockchain technology in online education,” Int. J. Emerg. Technol. Learn., 13(10), 252–259, 2018.
36. C. Delgado-Von-Eitzen, L. Anido-Rifón, and M. J. Fernández-Iglesias, “Application of blockchain in education: GDPR-compliant and scalable certification and verification of academic information,” Appl. Sci., 11(10), 4537, 2021.
37. A. H. Lone and R. Naaz, “Forgery protection of academic certificates through integrity preservation at scale using Ethereum smart contract,” Scalable Comput., 21(4), 673–688, 2020.
38. H. A. M. Deenmahomed, M. M. Didier, and R. K. Sungkur, “The future of university education: Examination, transcript, and certificate system using blockchain,” Comput. Appl. Eng. Educ., 29(5), 1234–1256, 2021.
39. J. Guo, C. Li, G. Zhang, Y. Sun, and R. Bie, “Blockchain-enabled digital rights management for multimedia resources of online education,” Multimed. Tools Appl., 79(15), 9735-9755, 2020.
40. A. Cheriguene, T. Kabache, A. Adnane, C. A. Kerrache, and F. Ahmad, “On the use of blockchain technology for education during pandemics,” IT Prof., 24(2), 52–61, 2022.
41. Blockcerts, “Blockcerts,” 2023. [Online]. Accessed: Aug. 7, 2023. URL: https://www.blockcerts.org/
42. EduCTX, “EduCTX,” 2023. [Online]. Accessed: Aug. 7, 2023. URL: https://eductx.org/
43. E. Birol, K. T. İskender, T. Ozkul, and A. Topallı, “VOTEMAT: A Blockchain Based Voting System,” Duzce University Journal of Science and Technology, 12(4), 2016–2032, 2024.
44. R. Q. Castro and M. Au-Yong-Oliveira, “Blockchain and higher education diplomas,” Eur. J. Investig. Health Psychol. Educ., 11(1), 154–167, 2021.
45. C. Reis-Marques, R. Figueiredo, and M. de C. Neto, “Applications of blockchain technology to higher education arena: A bibliometric analysis,” Eur. J. Investig. Health Psychol. Educ., 11(4), 1406–1421, 2021.
46. A. A. Khan et al., “Educational blockchain: A secure degree attestation and verification traceability architecture for higher education commission,” Appl. Sci., 11(22), 10917, 2021.
47. R. Raimundo and A. Rosário, “Blockchain system in the higher education,” Eur. J. Investig. Health Psychol. Educ., 11(1), 276–293, 2021.
48. M. Kataev and L. Bulysheva, “Blockchain system in the higher education: Storing academical students’ records and achievements accumulated in the educational process,” Syst. Res. Behav. Sci., 39(3), 589–596, 2022.
49. K. O. Asamoah et al., “A blockchain-based crowdsourcing loan platform for funding higher education in developing countries,” IEEE Access, 11, 24162–24174, 2023.
50. S. Son-Turan, “Fostering equality in education: The blockchain business model for higher education (BBM-HE),” Sustainability, 14(5), 2955, 2022.
51. R. Manoj et al., “Blockchain ecosystem for credit transfer in education,” Math. Probl. Eng., 2021(1), 8526456, 2021.
52. S. Ouyang and X. Huang, “Education evaluation management based on blockchain technology,” Mobile Inf. Syst., 2022(1), 7513365, 2022.
53. C. Atienza-Mendez and D. G. Bayyou, “Blockchain technology applications in education,” IJCAT—Int. J. Comput. Technol., 6(11), 68–74, 2019.
54. S. M. Abd Ali, M. N. Yusoff, and H. F. Hasan, “Redactable blockchain: Comprehensive review, mechanisms, challenges, open issues and future research directions,” Future Internet, 15(1), 35, 2023.
55. G. Zhu, D. He, H. An, M. Luo, and C. Peng, “The governance technology for blockchain systems: A survey,” Front. Comput. Sci., 18(2), 182813, 2024.
56. H. Alshahrani et al., “Sustainability in blockchain: A systematic literature review on scalability and power consumption issues,” Energies, 16(3), 1510, 2023.
57. M. Nouman, K. Ullah, and M. Azam, “Secure digital transactions in the education sector using blockchain,” EAI Endorsed Trans. Scalable Inf. Syst., 9(35), e9, 2022.
58. Linux Foundation, “Hyperledger Fabric: What is Hyperledger Fabric,” 2023. [Online]. Accessed: Jul. 1, 2023. URL: https://hyperledger-fabric.readthedocs.io/en/latest/whatis.html
59. Google, “Go programming language—Downloads,” 2023. [Online]. Accessed: Jul. 1, 2023. URL: https://go.dev/dl/
60. Oracle, “MySQL Installer—Downloads,” 2023. [Online]. Accessed: Jul. 1, 2023. URL: https://dev.mysql.com/downloads/installer/
61. O. Selvi, “Source codes of the DECEN model,” 2024. [Online]. Accessed: Feb. 1, 2024. URL: https://github.com/OsmanSelvi84/DECEN/tree/master