Automatic Lexical Alignment between Relational Database and Heterogeneous Big Data Based on NOSQL Systems


  • IBN BATOUTA Zouhair
  • HAJOUI Omar
  • TALEA Mohamed





Automatic Matching, Big Data, Columnar Store, Document Store, Generative automatic matching, Heterogeneous Meta-models, hybrid meta-heuristic, Key value Store, NoSql, Quality mathematical measurements.Relational,


In the absence of a universal consensus governing the use of models, the IDM has led to the creation of a large number of heterogeneous (distinct) meta-model systems with similar or complementary uses and objectives. To solve this problem of increasing heterogeneity of meta-models, we proposed an approach that we named generative automatic matching GAM. In this approach, we have dealt with the problem of the heterogeneity of meta-models in a new way that uses automatic matching, the alignments found are then took into profit to facilitate generation between source and target models which are conform to the linked meta-models.


This article presents an application of our GAM approach on a case study composed of heterogeneous meta-models of relational databases and big data, we specially treat the application of lexical automatic matching based on hybrid meta-heuristic. We have selected three types of databases and big data based on NoSql: Key Store, Document Store and Columnar Store; at the end of our article we present an evaluation of the results found based on quality mathematical measurements.




[1] Ibn Batouta, Z., Dehbi, R., Talea, M., & Hajoui, O. Automation in code generation: Tertiary and systematic mapping review. In Information Science and Technology (CiSt), 2017 4th IEEE International Colloquium on (pp. 200-205). IEEE.â€

[2] Ibn Batouta, Z., Dehbi, R., Talea, M., & Hajoui, O. Multi-criteria analysis and advanced comparative study between automatic generation approaches in software engineering. Journal of Theoretical and Applied Information Technology, 2016, 81.3: 609.â€

[3] Ibn Batouta, Z., Dehbi, R., Talea, M., & Hajoui, O, Generative automatic matching between heterogeneous meta-model’ systems Journal of Engineering and Applied Sciences 2017 (In press).

[4] Ibn Batouta, Z., Dehbi, R., Talea, ‘’Generative matching between heterogeneous meta-model’ systems based on hybrid heuristic’’ Journal of Information Technology Research, IGI Global 2018 (In Press).

[5] Morin, Brice, et al. "A generic weaver for supporting product lines." Proceedings of the 13th international workshop on Early Aspects. ACM, 2008.â€

[6] Schmidt, Maik, and Tilman Gloetzner. "Constructing difference tools for models using the SiDiff framework." Companion of the 30th international conference on Software engineering. ACM, 2008.â€

[7] Toulmé, Antoine, and I. Inc. "Presentation of EMF compare utility." Eclipse Modeling Symposium. 2006.â€

[8] Melnik, Sergey, Hector Garcia-Molina, and Erhard Rahm. "Similarity flooding: A versatile graph matching algorithm and its application to schema matching." Data Engineering, 2002. Proceedings. 18th International Conference on. IEEE, 2002.â€

[9] Lin, Yuehua, Jeff Gray, and Frédéric Jouault. "DSMDiff: a differentiation tool for domain-specific models." European Journal of Information Systems 16.4 (2007): 349-361.â€â€

[10] Xing, Zhenchang, and Eleni Stroulia. "UMLDiff: an algorithm for object-oriented design differencing." Proceedings of the 20th IEEE/ACM international Conference on Automated software engineering. ACM, 2005.â€

[11] Nejati, Shiva, et al. "Matching and merging of statecharts specifications." Software Engineering, 2007. ICSE 2007. 29th International Conference on. IEEE, 2007.â€

[12] Kolovos, Dimitrios S. "Establishing Correspondences between Models with the Epsilon Comparison Language." ECMDA-FA 9 (2009): 146-157.â€

[13] Hajoui, O., Dehbi, R., Talea, M., & Batouta, Z. I. An advanced comparative study of the most promising nosql and newsql databases with a multi-criteria analysis method. Journal of Theoretical and Applied Information Technology, 81(3), 579 2015.

Hajoui, O ; R Dehbi ; M Talea ; Z Ibn Batouta , ‘’A Survey on Big Data Interoperability’’, 5th International Conference on Multimedia Computing and Systems (ICMCS'16) – IEEE Conference 29 September – 1 October 2016

View Full Article: