Abstract
The growth of application architectures in all areas (e.g., astrology, meteorology, E-commerce, social network, etc.) has resulted in an exponential increase in data volumes, now measured in Petabytes. Managing these volumes of data has become a problem that relational databases are no longer able to handle because of the acidity properties. In response to this scaling up, new concepts have emerged such as NoSQL. In this paper, we show how to design and apply transformation rules to migrate from an SQL relational database to a big data solution within NoSQL. For this, we use the model driven architecture (MDA) and the transformation languages like as MOF 2.0 QVT (Meta-Object Facility 2.0 Query-View-Transformation) and Acceleo which define the meta-models for the development of transformation model. The transformation rules defined in this work can generate, from the class diagram, a CQL code for creation column-oriented NoSQL database.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Chen, C.L.P., Zhang, C.: Data-intensive applications, challenges, techniques and technologies: a survey on big data. Inf. Sci. 275, 314–347 (2014)
Cattell, R.: Scalable SQL and NoSQL data stores. ACM SIGMOD Rec. 39(4), 12–27 (2011)
Gwendal, D., Gerson, S., Jordi, C.: UMLtoGraphDB: mapping conceptual schemas to graph databases. In: The 35th International Conference on Conceptual Modeling (ER) (2016)
Abello, A.: Big data design. In: Proc. of the ACM Eighteenth International Workshop on Data Warehousing and OLAP, Australia (2015)
Abdelhedi, F., Brahim,, A.A., Faten, A., Zurfluh, G.: MDA-based approach for NoSQL Databases Modelling, In: International Conference on Big Data Analytics and Knowledge Discovery (DaWaK 2017), Lyon, France, (28–31 Aug 2017)
OMG, XML Metadata Interchange (XMI), version 2.1.1, OMG (2007)
Chevalier,M., El Malki, M., Kopliku, A., Teste, O., Tournier, R. : Implementing multidimensional data warehouses into NoSQL. In: International Conference on Enterprise Information Systems (ICEIS 2015), Barcelona, Spain (2015)
Li, Y., Gu, P., Zhang, C.: Transforming UML Class Diagrams into HBase Based on Meta-model. Information Science, Electronics and Electrical Engineering (ISEEE) (2014)
Vajk, T., Feher, P., Fekete, K., Charaf, H.: Denormalizing data into schema-free databases. In: 4th International Conference CogInfoCom. pp. 747–752 (2013)
Abdelhedi, F., Brahim, A.A., Atigui, F., Zurfluh, G.: Big Data and knowledge management: how to implement conceptual models in NoSQL systems?. In: 8th International Conference on Knowledge Discovery, Knowledge Engineering and Knowledge Management (IC3K 2016), Porto, Portugal, (9–11 Nov 2016)
Gotti, S., Mbarki, S.: IFVM bridge: a model driven IFML execution. Int. J. Online Biomed. Eng. (iJOE). 15(4), 111–126 (2019)
Miller, J., Mukerji, J.: MDA Guide Version 1.0.1, OMG, (2003)
Papajorgjin, P., Pardalos, P.M.: Towards a model-centric approach for developing enterprise information systems. Enterprise Information Systems and Implementing It Infrastructures: Challenges and Issues. IGI Global; 1st edn. pp. 140–158 (2010)
Radoslava, S.K., , S.K., Nina, S., Petia, K., Nadejda, B.: Design and analysis of a relational database for behavioral experiments data processing. Int. J. Online Biomed. Eng. (iJOE). 14(02) (2018), 117–132 (2019)
Apache Cassandra, http://cassandra.apache.org/
Apache HBase, https://hbase.apache.org/
Oualid, B., Saida, F., Amine, A., Mohamed, B.: Applying a model driven architecture approach: transforming CIM to PIM using UML. Int. J. Online Biomed. Eng. (iJOE). 14(9), 170–181 (2018)
Arrhioui, K., Mbarki, S., Erramdani, M.: Applying CIM-to-PIM model transformation for development of emotional intelligence tests platform. Int. J. Online Biomed. Eng. (iJOE). 14(8), 160–168 (2018)
Abadi, D., Boncz, P., Harizopoulos, S.: The design and implementation of modern column-oriented database systems”. Found. Trends Databases 5(3), 197–280 (2012)
Angadi, A.B., Angadi, A.B., Gull, K.C.: Growth of New databases & analysis of NOSQL datastores. Int. J. Adv. Res. Comput. Sci. Softw. Eng. 3(6) (June 2013)
OMG, Meta Object Facility (MOF) 2.0 Query/View/Transformation, V1.1 (2011)
Acceleo, http://www.eclipse.org/acceleo
OMG, UML Infrastructure Final Adopted Specification, version 2.0, September 2003
OMG, Meta Object Facility (MOF), version 2.0, OMG (2006)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2022 The Author(s), under exclusive license to Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Belkadi, F., Esbai, R. (2022). Model-Driven Engineering: From SQL Relational Database to Column—Oriented Database in Big Data Context. In: Ben Ahmed, M., Teodorescu, HN.L., Mazri, T., Subashini, P., Boudhir, A.A. (eds) Networking, Intelligent Systems and Security. Smart Innovation, Systems and Technologies, vol 237. Springer, Singapore. https://doi.org/10.1007/978-981-16-3637-0_47
Download citation
DOI: https://doi.org/10.1007/978-981-16-3637-0_47
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-16-3636-3
Online ISBN: 978-981-16-3637-0
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)