Towards Automatic Generation of NoSQL Document-Oriented Models

Fatma Abdelhedi (1) , Amal Aït Brahim (2) , Faten Atigui (3) , Gilles Zurfluh (2, 4)

1 Chercheur indépendant
2 IRIT-SIG - Systèmes d’Informations Généralisées
3 CEDRIC - Centre d'études et de recherche en informatique et communications
4 UT Capitole - Université Toulouse Capitole

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.

Mots clés: SQL relational database; NoSQL; MDA; Big Data; CQL; The transformation rules

Domaines: Base de données [cs.DB]

Fatma Abdelhedi, Amal Aït Brahim, Faten Atigui, Gilles Zurfluh. Towards Automatic Generation of NoSQL Document-Oriented Models. 24th International Conference on Parallel and Distributed Processing Techniques and Applications (PDPTA 2018), Jul 2018, Las Vegas, Nevada, United States. pp.47--53. ⟨hal-02295340⟩