Towards Automatic Generation of NoSQL Document-Oriented Models

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.

[1]  Max Chevalier,et al.  How Can We Implement a Multidimensional Data Warehouse Using NoSQL? , 2015, ICEIS.

[2]  Alberto Abelló,et al.  Big Data Design , 2015, DOLAP.

[3]  Chao Zhang,et al.  Transforming UML class diagrams into HBase based on meta-model , 2014, 2014 International Conference on Information Science, Electronics and Electrical Engineering.

[4]  Mark Rouncefield,et al.  Model-driven engineering practices in industry , 2011, 2011 33rd International Conference on Software Engineering (ICSE).

[5]  Alberto Abelló,et al.  NOSQL Design for Analytical Workloads: Variability Matters , 2016, ER.

[6]  Hassan Charaf,et al.  Denormalizing data into schema-free databases , 2013, 2013 IEEE 4th International Conference on Cognitive Infocommunications (CogInfoCom).

[7]  Jean Bézivin,et al.  Towards a precise definition of the OMG/MDA framework , 2001, Proceedings 16th Annual International Conference on Automated Software Engineering (ASE 2001).

[8]  Rakesh Kumar,et al.  Effective Way to Handling Big Data Problems using NoSQL Database (MongoDB) , 2015 .

[9]  Jordi Cabot,et al.  UMLtoGraphDB: Mapping Conceptual Schemas to Graph Databases , 2016, ER.

[10]  Chongxin Li,et al.  Transforming relational database into HBase: A case study , 2010, 2010 IEEE International Conference on Software Engineering and Service Sciences.

[11]  Nadia Kabachi,et al.  Using the column oriented NoSQL model for implementing big data warehouses , 2015 .

[12]  Fatma Abdelhédi,et al.  MDA-Based Approach for NoSQL Databases Modelling , 2017, DaWaK.