Model-Driven Architecture Approach for SQL Generation using Acceleo: A Case Study on MySQL Database

Model-Driven Architecture Approach for SQL Generation using Acceleo: A Case Study on MySQL Database
  IJETT-book-cover           
  
© 2023 by IJETT Journal
Volume-71 Issue-10
Year of Publication : 2023
Author : Hamza Natek, Aziz Srai, Fatima Guerouate
DOI : 10.14445/22315381/IJETT-V71I10P203

How to Cite?

Hamza Natek, Aziz Srai, Fatima Guerouate, "Model-Driven Architecture Approach for SQL Generation using Acceleo: A Case Study on MySQL Database," International Journal of Engineering Trends and Technology, vol. 71, no. 10, pp. 20-28, 2023. Crossref, https://doi.org/10.14445/22315381/IJETT-V71I10P203

Abstract
The MDA approach aims to improve software development efficiency by utilizing models as the primary means of specifying, constructing, and implementing software systems. Software systems development often requires Converting high-level design models into resilient and coherent databases. Manual translation of UML models to SQL databases is prone to errors and can be time-consuming, hindering the development process. To overcome this problem, Proposing an automated approach that harnesses the capabilities of MDA and Acceleo, The main goal is to convert UML models into comprehensive SQL files effortlessly. The proposed approach significantly reduces the time and effort required to create SQL databases manually. In the first step, an e-commerce model is employed as a high-level representation of the database structure, consisting of essential tables such as Product, Order, Customer, OrderDetail, Administrator, User, and ShippingInfo. Through the application of transformation rules and mapping specifications, the UML model is seamlessly converted into a set of SQL statements that define tables, relationships, and constraints; this automated approach not only accelerates the development process but also enables easy updates and modifications to the database structure as the system evolves.

Keywords
Model-Driven Architecture, UML, SQL, Acceleo, MySQL.

References
[1] J. Bezivin et al., “Applying MDA Approach for Web Service Platform,” Proceedings Eighth IEEE International Enterprise Distributed Object Computing Conference, pp. 58-70, 2004.
[CrossRef] [Google Scholar] [Publisher Link]
[2] Julia N. Korongo, Samuel T. Mbugua, and Samuel M. Mbuguah, “A Review Paper on Application of Model-Driven Architecture in Use-Case Driven Pervasive Software Development,” International Journal of Computer Trends and Technology, vol. 70, no. 3, pp. 19-26, 2022.
[CrossRef] [Google Scholar] [Publisher Link]
[3] Deniz Akdur, Vahid Garousi, and Onur Demirörs, “A Survey on Modeling and Model-Driven Engineering Practices in the Embedded Software Industry,” Journal of Systems Architecture, vol. 91, pp. 62-82, 2018.
[CrossRef] [Google Scholar] [Publisher Link]
[4] Lenin Erazo-Garzón et al., “Models@runtime and Internet of Things: A Systematic Literature Review,” 2021 Second International Conference on Information Systems and Software Technologies (ICI2ST), pp. 128-134, 2021.
[CrossRef] [Google Scholar] [Publisher Link]
[5] Mantas Jurgelaitis et al., “Smart Contract Code Generation from Platform Specific Model for Hyperledger Go,” Trends and Applications in Information Systems and Technologies, vol. 1368, pp. 63-73, 2021.
[CrossRef] [Google Scholar] [Publisher Link]
[6] Moneeb Abbas et al., “A Model-Driven Framework for Security Labs Using Blockchain Methodology,” 2021 IEEE International Systems Conference (SysCon), pp. 1-7, 2021.
[CrossRef] [Google Scholar] [Publisher Link]
[7] Phu H. Nguyen et al., “An Extensive Systematic Review on the Model-Driven Development of Secure Systems,” Information and Software Technology, vol. 68, pp. 62-81, 2015.
[CrossRef] [Google Scholar] [Publisher Link]
[8] Santiago Moral-García et al., “Enterprise Security Pattern: A Model-Driven Architecture Instance,” Computer Standards and Interfaces, vol. 36, no. 4, pp. 748-758, 2014.
[CrossRef] [Google Scholar] [Publisher Link]
[9] Nour Moadad, Issam Damaj, and Islam El Kabani, “A Generic MDA-IoT Architecture for Connected Vehicles in Smart Cities,” 2022 IEEE Global Conference on Artificial Intelligence and Internet of Things (GCAIoT), pp. 122-129, 2022.
[CrossRef] [Google Scholar] [Publisher Link]
[10] Manal Bouacha, and Hanae Sbai, “Business-IT Alignment in Cloud Environment Proposed Framework,” ITM Web of Conferences, vol. 52, 2023.
[CrossRef] [Google Scholar] [Publisher Link]
[11] Sarra Roubi, Mohammed Erramdani, and Samir Mbark, “Model Driven Architecture as an Approach for Modeling and Generating Graphical User Interface,” Proceedings of the Mediterranean Conference on Information & Communication Technologies, vol. 381, pp. 651-656, 2016.
[CrossRef] [Google Scholar] [Publisher Link]
[12] Francisco J. Pereda, and Arturo Molina, “Model Driven Architecture for Engineering Design and Manufacturing,” IFAC Proceedings Volumes, vol. 46, no. 24, pp. 400-407, 2013.
[CrossRef] [Google Scholar] [Publisher Link]
[13] Mohammad Ali Kadampur, and Sulaiman Al Riyaee, “Skin Cancer Detection: Applying a Deep Learning Based Model Driven Architecture in the Cloud for Classifying Dermal Cell Images,” Informatics in Medicine Unlocked, vol. 18, 2020.
[CrossRef] [Google Scholar] [Publisher Link]
[14] M'hamed Rahmouni, Chaymae Talbi, and Soumia Ziti, “Model-Driven Architecture: Generating Models from Symfony Framework,” Indonesian Journal of Electrical Engineering and Computer Science, vol. 30, no. 3, pp. 1659-1668, 2023.
[CrossRef] [Google Scholar] [Publisher Link]
[15] Hanane Benouda et al., “Modeling and Code Generation of Android Applications Using Acceleo,” International Journal of Software Engineering and Its Applications, vol. 10, no. 3, pp. 83-94, 2016.
[Google Scholar] [Publisher Link]
[16] M'hamed Rahmouni, and Samir Mbarki, “Model-Driven Generation of MVC2 Web Applications: From Models to Code,” International Journal of Engineering and Applied Computer Science, vol. 2, no. 7, pp. 217-231, 2017.
[CrossRef] [Google Scholar] [Publisher Link]
[17] Hatice Koç et al., “UML Diagrams in Software Engineering Research: A Systematic Literature Review,” Proceedings, vol. 74, no. 1, p. 13, 2021.
[CrossRef] [Google Scholar] [Publisher Link]