Semantic data mapping technology to solve semantic data problem on heterogeneity aspect

(1) * Arda Yunianta Mail (Faculty of Computing and Information Technology, King Abdul aziz University, Saudi Arabia)
(2) Omar Mohammed Barukab Mail (Faculty of Computing and Information Technology, King Abdul Aziz University, Saudi Arabia)
(3) Norazah Yusof Mail (Faculty of Computing and Information Technology, King Abdul Aziz University, Saudi Arabia)
(4) Nataniel Dengen Mail (Faculty of Computer Science and Information Technology, Mulawarman University, Indonesia)
(5) Haviluddin Haviluddin Mail (Faculty of Computer Science and Information Technology, Mulawarman University, Indonesia)
(6) Mohd Shahizan Othman Mail (Faculty of Computing, University Teknologi Malaysia, Malaysia)
*corresponding author


The diversity of applications developed with different programming languages, application/data architectures, database systems and representation of data/information leads to heterogeneity issues. One of the problem challenges in the problem of heterogeneity is about heterogeneity data in term of semantic aspect. The semantic aspect is about data that has the same name with different meaning or data that has a different name with the same meaning. The semantic data mapping process is the best solution in the current days to solve semantic data problem. There are many semantic data mapping technologies that have been used in recent years. This research aims to compare and analyze existing semantic data mapping technology using five criteria’s. After comparative and analytical process, this research provides recommendations of appropriate semantic data mapping technology based on several criteria’s. Furthermore, at the end of this research we apply the recommended semantic data mapping technology to be implemented with the real data in the specific application. The result of this research is the semantic data mapping file that contains all data structures in the application data source. This semantic data mapping file can be used to map, share and integrate with other semantic data mapping from other applications and can also be used to integrate with the ontology language.


Ontology; Education Domain; Semantic approach



Article metrics

Abstract views : 153 | PDF views : 62




Full Text



M. A. Kabir, J. Han, A. Colman, N. R. Aljohani, M. Basheri, Z. Xing, et al., "Engineering Socially-Aware Systems and Applications," in 2016 21st International Conference on Engineering of Complex Computer Systems (ICECCS), 2016, pp. 81-90.

M. Rani, R. Nayak, and O. P. Vyas, "An ontology-based adaptive personalized e-learning system, assisted by software agents on cloud storage," Knowledge-Based Systems, vol. 90, pp. 33-48, 12// 2015.

A. Yunianta, N. Yusof, A. Bramantoro, H. Haviluddin, M. S. Othman, and N. Dengen, "Data mapping process to handle semantic data problem on student grading system," International Journal of Advances in Intelligent Informatics, vol. 2, p. 157-166, 2016..

N. Arch-int and S. Arch-int, "Semantic Ontology Mapping for Interoperability of Learning Resource Systems using a rule-based reasoning approach," Expert Systems with Applications, vol. 40, pp. 7428-7443, 2013.

J. Bian, H. Zhang, and X. Peng, "The Research and Implementation of Heterogeneous Data Integration under Ontology Mapping Mechanism," presented at the International Conference on Web Information Systems and Mining, Verlag Berlin Heidelberg, 2011.

R. Shyamala, R. Sunitha, and G. Aghila, "Towards Learner Model Sharing Among Heterogeneous E-Learning Environments," International Journal of Engineering Science and Technology (IJEST), vol. 3, pp. 2034-2040, 2011.

A. Yunianta, M. S. Othman, N. Yusof, L. M. Yusuf, Juwairiah, and N. S. Selamat, "Solving the complexity of heterogeneity data on learning environment using ontology," Telkomnika (Telecommunication Computing Electronics and Control), vol. 13, pp. 341-348, 2015.

W. Kim and J. Seo, "Classifying schematic and data heterogeneity in multi database systems," IEEE Computer, vol. 24, pp. 12-18, 1991.

V. Kashyap and A. Sheth, "Semantic heterogeneity in global information systems: The role of metedata, context and ontologies.," in Cooperative information systems, M. P. Papazoglou and G. Schlageter, Eds., ed San Diego: Academic Press, 1997, pp. 139–178.

H. Dong-mei, D. Yan-ling, Z. Ming-hua, and Z. Chi, "Application of ontology-based automatic ETL in marine data integration," in Electrical & Electronics Engineering (EEESYM), 2012 IEEE Symposium on, 2012, pp. 11-13.

"Semantic integration," in Information Sharing on the Semantic Web, ed Berlin, Heidelberg: Springer Berlin Heidelberg, 2005, pp. 3-23.

H. Stuckenschmidt and F. v. Harmelen, "Semantic integration," in Information Sharing on the Semantic Web, H. Stuckenschmidt and F. van Harmelen, Eds., ed Berlin, Heidelberg: Springer Berlin Heidelberg, 2005, pp. 3-23.

P. Sandborn, J. Terpenny, R. Rai, R. Nelson, L. Zheng, and C. Schafer, "Knowledge representation and design for managing product obsolescence," in Proceedings of NSF civil, mechanical and manufacturing innovation grantees conference, Atlanta, Georgia, 2011.

L. Zheng and J. Terpenny, "A hybrid ontology approach for integration of obsolescence information," Computers & Industrial Engineering, vol. 65, pp. 485–499, 2013.

F. J. Ekaputra, E. Serrai, D. Winkler, and S. Biffl, "A semantic framework for data integration and communication in project consortia," in Data and Software Engineering (ICODSE), 2014 International Conference on, 2014, pp. 1-6.

A. Yunianta, N. Yusof, M. S. Othman, A. Aziz, N. Dengen, M. Ugiarto, et al., "Semantic data mapping on E-learning usage index tool to handle heterogeneity of data representation," Jurnal Teknologi (Sciences and Engineering), vol. 69, pp. 1-6, 2014.

A. Yunianta, N. Yusof, M. S. Othman, A. Aziz, and N. Dengen, "Analysis and Identification of Data Heterogeneity on Learning Environment Using Ontology Knowledge," in International Conference on Electrical Engineering, Computer Science and Informatics (EECSI 2014), Yogyakarta, Indonesia, 2014, pp. 154-160.

A. Yunianta, N. Yusof, H. Jayadianti, M. Othman, and S. Suhaimi, "Ontology Development to Handle Semantic Relationship between Moodle E-learning and Question Bank System," in Recent Advances on Soft Computing and Data Mining. vol. 287, T. Herawan, R. Ghazali, and M. M. Deris, Eds., ed: Springer International Publishing, 2014, pp. 691-701.

T. Bittner, M. Donnelly, and S. Winter, "Ontology and Semantic Interoperability," in Large-scale 3D Data Integration: Challenges and Opportunities, D. Prosperi and S. Zlatanova, Eds., ed: CRCpress (Tailor & Francis), 2005, pp. 139-160.

J. M. Alcaraz Calero, J. M. Marín Pérez, J. Bernal Bernabé, F. J. Garcia Clemente, G. Martínez Pérez, and A. F. Gómez Skarmeta, "Detection of semantic conflicts in ontology and rule-based information systems," Data & Knowledge Engineering, vol. 69, pp. 1117-1137, 11// 2010.

S. Schulz and C. Martínez-Costa, "How Ontologies Can Improve Semantic Interoperability in Health Care," in Process Support and Knowledge Representation in Health Care. vol. 8268, D. Riaño, R. Lenz, S. Miksch, M. Peleg, M. Reichert, and A. ten Teije, Eds., ed: Springer International Publishing, 2013, pp. 1-10.

S. Sonsilphong and N. Arch-int, "Semantic Interoperability for Data Integration Framework using Semantic Web Services and Rule-based Inference: A case study in healthcare domain," Journal of Convergence Information Technology(JCIT), vol. 8, 2013.

R. Cyganiak, C. Bizer, J. Garbers, O. Maresch, and C. Becker. (2012, 2). The D2RQ Mapping Language (v0.8 – 2012-03-12 ed.).

C. Bizer and R. Cyganiak. (2007, June). D2RQ — Lessons Learned. Available:

C. Bizer and A. Seaborne, "D2RQ - Treating Non-RDF Databases as Virtual RDF Graphs," presented at the ISWC2004 (posters), 2004.

R. Kienast and C. Baumgartner, "Semantic Data Integration on Biomedical Data Using Semantic Web Technologies," in Bioinformatics - Trends and Methodologies, D. M. A. Mahdavi, Ed., ed: InTech, 2011.

M. Melik-Merkumians, A. Zoitl, and T. Moser, "Ontology-based fault diagnosis for industrial control applications," in Emerging Technologies and Factory Automation (ETFA), 2010 IEEE Conference on, 2010, pp. 1-4.

O. Kovalenko and T. Moser, "Using explicit and machine-understandable engineering knowledge for defect detection in automation systems engineering," in International Doctoral Symposium on Software Engineering and Advanced Applications (IDoSEAA), Oulu, Finland, 2011, pp. 1-5.

V. Jirkovsky, P. Kadera, M. Obitko, and P. Vrba, "Diagnostics of distributed intelligent control systems: Reasoning using ontologies and hidden markov models," in the 14th IFAC Symposium on Information Control Problems in Manufacturing (INCOM), 2012, pp. 1315-1320.

J. Barrasa Rodríguez, O. Corcho, and A. Gómez-Pérez, "R2O, an extensible and semantically based database-to-ontology mapping language," in Proceedings of the Second Workshop on Semantic Web and Databases, SWDB 2004. vol. 3372, ed Berlín, Alemania: Springer-Verlag, 2004, pp. 1069-1070.

M. Svihla and I. Jelinek, "Two layer mapping from database to RDF," in Proceed-ings of the Sixth International Scientific Conference Electronic Computers and Informatics, ECI 2004, 2004, pp. 270-275.

Z. Wu, H. Chen, C. Changhuang, G. Zheng, and J. Xu, "DartGrid: Semantic-Based Database Grid," in Computational Science - ICCS 2004: 4th International Conference, Kraków, Poland, June 6-9, 2004, Proceedings, Part I, M. Bubak, G. D. van Albada, P. M. A. Sloot, and J. Dongarra, Eds., ed Berlin, Heidelberg: Springer Berlin Heidelberg, 2004, pp. 59-66.

H. Chen and Z. Wu, "DartGrid III: A Semantic Grid Toolkit for Data Integration," in 2005 First International Conference on Semantics, Knowledge and Grid, 2005, pp. 12-12.

E. Prud’hommeaux. (2005, May). Sparql: SPARQL support in MySQL. Available:

W. Zhaohui, D. Shuiguang, W. Jian, C. Huajun, T. Shuming, and G. Haijun, "DartGrid II: a semantic grid platform for ITS," IEEE Intelligent Systems, vol. 20, pp. 12-15, 2005.

J. B. Rodriguez and A. Gómez-Pérez, "Upgrading relational legacy data to the semantic web," presented at the Proceedings of the 15th international conference on World Wide Web, Edinburgh, Scotland, 2006.

N. Cullot, R. Ghawi, and K. Yétongnon, "DB2OWL: A Tool for Automatic Database-to-Ontology Mapping," in 15th Italian Symposium on Advanced Database Systems, Torre Canne, 2007, pp. 491-494.

M. Šeleng, M. Laclavík, Z. Balogh, and L. Hluchý, "RDB2Onto: Approach for creating semantic metadata from relational database data," 2007.

M. Svihla and I. Jelinek, "Benchmarking RDF Production Tools," in Database and Expert Systems Applications: 18th International Conference, DEXA 2007, Regensburg, Germany, September 3-7, 2007. Proceedings, R. Wagner, N. Revell, and G. Pernul, Eds., ed Berlin, Heidelberg: Springer Berlin Heidelberg, 2007, pp. 700-709.

K. N. Vavliakis, A. L. Symeonidis, G. T. Karagiannis, and P. A. Mitkas, "Eikonomia-An Integrated Semantically Aware Tool for Description and Retrieval of Byzantine Art Information," in 19th IEEE International Conference on Tools with Artificial Intelligence(ICTAI 2007), 2007, pp. 279-282.

M. Fisher, M. Dean, and G. Joiner, "Use of OWL and SWRL for semantic relational database translation," presented at the OWLED 2008: OWL Experiences and Directions, Gaithersburg, MD, USA, 2008.

S. Auer, S. Dietzold, J. Lehmann, S. Hellmann, and D. Aumueller, "Triplify: light-weight linked data publication from relational databases," presented at the Proceedings of the 18th international conference on World wide web, Madrid, Spain, 2009.

C. Bizer, J. Lehmann, G. Kobilarov, #246, r. Auer, C. Becker, et al., "DBpedia - A crystallization point for the Web of Data," Web Semant., vol. 7, pp. 154-165, 2009.

O. Erling and I. Mikhailov, "RDF Support in the Virtuoso DBMS," in Networked Knowledge - Networked Media: Integrating Knowledge Management, New Media Technologies and Semantic Systems, T. Pellegrini, S. Auer, K. Tochtermann, and S. Schaffert, Eds., ed Berlin, Heidelberg: Springer Berlin Heidelberg, 2009, pp. 7-24.

S. S. Sahoo, W. Halb, S. Hellmann, K. Idehen, T. T. Jr, S. Auer, et al., "A Survey of Current Approaches for Mapping of Relational Databases to RDF," ed, 2009.

J. F. Sequeda, R. Depena, and D. P. Miranker, "Ultrawrap: Using SQL Views for RDB2RDF," in 8th International Semantic Web Conference (ISWC2009), Washington DC, USA, 2009.

D. M. T. Al-Sudairy and T. G. K. Vasista, "Semantic Data Integration Approaches for E-Governance," International Journal of Web & Semantic Technology, 2011.

K. N. Vavliakis, A. L. Symeonidis, G. T. Karagiannis, and P. A. Mitkas, "An integrated framework for enhancing the semantic transformation, editing and querying of relational databases," Expert Syst. Appl., vol. 38, pp. 3844-3856, 2011.

K. N. Vavliakis, T. K. Grollios, and P. A. Mitkas, "RDOTE – Publishing Relational Databases into the Semantic Web," Journal of Systems and Software, vol. 86, pp. 89-99, 2013.

D. Haase, U. Germing, J. Schanz, M. Pfeilstöcker, T. Nösslinger, B. Hildebrandt, et al., "New insights into the prognostic impact of the karyotype in MDS and correlation with subtypes: evidence from a core dataset of 2124 patients," Blood, vol. 110, pp. 4385-4395, 2007.

J. F. Sequeda and D. P. Miranker, "Ultrawrap: SPARQL execution on relational data," Web Semantics: Science, Services and Agents on the World Wide Web, vol. 22, pp. 19-39, 2013/10/01/ 2013.

S. Bowers, J. S. Madin, and M. P. Schildhauer, "Owlifier: Creating OWL-DL ontologies from simple spreadsheet-based knowledge descriptions," Ecological Informatics, vol. 5, pp. 19-25, 2010.

K. N. Vavliakis, T. K. Grollios, and P. A. Mitkas. RDOTE - Transforming Relational Databases into Semantic Web Data, 2010.

Copyright (c) 2017 International Journal of Advances in Intelligent Informatics

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

International Journal of Advances in Intelligent Informatics
(pISSN: 2442-6571 | eISSN: 2548-3161 )
Organized by Informatics Department - Universitas Ahmad Dahlan , and UTM Big Data Centre - Universiti Teknologi Malaysia
Published by Universitas Ahmad Dahlan
W :
E :, (paper handling issues), (publication issues)

View IJAIN Stats

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0