journal article·2021-09-06Open access

Data Harmonization for Heterogeneous Datasets: A Systematic Literature Review

Ganesh Kumar, Shuib Basri, Abdullahi Abubakar Imam, Sunder Ali Khowaja, Luiz Fernando Capretz, Abdullateef Oluwagbemiga Balogun

Applied Sciences· Volume 11· Issue 17

Abstract

As data size increases drastically, its variety also increases. Investigating such heterogeneous data is one of the most challenging tasks in information management and data analytics. The heterogeneity and decentralization of data sources affect data visualization and prediction, thereby influencing analytical results accordingly. Data harmonization (DH) corresponds to a field that unifies the representation of such a disparate nature of data. Over the years, multiple solutions have been developed to minimize the heterogeneity aspects and disparity in formats of big-data types. In this study, a systematic review of the literature was conducted to assess the state-of-the-art DH techniques. This study aimed to understand the issues faced due to heterogeneity, the need for DH and the techniques that deal with substantial heterogeneous textual datasets. The process produced 1355 articles, but among them, only 70 articles were found to be relevant through inclusion and exclusion criteria methods. The result shows that the heterogeneity of structured, semi-structured, and unstructured (SSU) data can be managed by using DH and its core techniques, such as text preprocessing, Natural Language Preprocessing (NLP), machine learning (ML), and deep learning (DL). These techniques are applied to many real-world applications centered on the information-retrieval domain. Several assessment criteria were implemented to measure the efficiency of these techniques, such as precision, recall, F-1, accuracy, and time. A detailed explanation of each research question, common techniques, and performance measures is also discussed. Lastly, we present readers with a detailed discussion of the existing work, contributions, and managerial and academic implications, along with the conclusion, limitations, and future research directions.
Source: crossref · Quality: baseline

Research context

OpenAlex topics: Big Data and Business Intelligence · Data Quality and Management · Data Stream Mining Techniques

SciVX discovery tags are terminology-based. OpenAlex topics are source-provided classifications.

Affiliations

Computer and Information Science Department, Universiti Teknologi PETRONAS, Bandar Seri Iskandar 32610, Perak, Malaysia

Department of Computer Science, Ahmadu Bello University, Zaria 1044, Nigeria

Department of Telecommunication Engineering, Faculty of Engineering and Technology, University of Sindh, Jamshoro 76090, Pakistan

Department of Electrical and Computer Engineering, Western University, London, ON N6A 5B9, Canada

Department of Computer Science, University of Ilorin, Ilorin 1515, Nigeria

References (100+)

Show source-provided references
1. Software architectures for big data: A systematic literature review10.1186/s41044-020-00045-1 ↗
2. Bhadani, A.K., and Jothimani, D. (2016). Big data: Challenges, opportunities, and realities. Effective Big Data Management and Opportunities for Implementation, IGI Global.10.4018/978-1-5225-0182-4.ch001 ↗
3. Arora, Y., and Goyal, D. (2019). Review of data analysis framework for variety of big data. Emerging Trends in Expert Applications and Security, Springer.10.1007/978-981-13-2285-3_7 ↗
4. Overview of Big Data And Its Issues
5. Handling Complex Heterogeneous Healthcare Big Data
6. Challenges and recommended technologies for the industrial internet of things: A comprehensive review10.1016/j.measurement.2019.107198 ↗
7. Use of Big Data Tools and Industrial Internet of Things: An Overview
8. Jaidka, H., Sharma, N., and Singh, R. Evolution of iot to iiot: Applications & challenges. Proceedings of the International Conference on Innovative Computing & Communications (ICICC), Available online: https://ssrn.com/abstract=3603739.
9. Ralph, B., and Stockinger, M. (2020, January 21–25). Digitalization and digital transformation in metal forming: Key technologies, challenges and current developments of industry 4.0 applications. Proceedings of the XXXIX, Colloquium on Metal Forming, Leoben, Austria.
10. Big data and precision medicine: Challenges and strategies with healthcare data10.1007/s41060-018-0095-0 ↗
11. Cohort Harmonization and Integrative Analysis from a Biomedical Engineering Perspective10.1109/RBME.2018.2855055 ↗
12. A Survey on the Internet of Things (IoT) Forensics: Challenges, Approaches, and Open Issues10.1109/COMST.2019.2962586 ↗
13. Efficient and Privacy-Preserving Authentication Protocol for Heterogeneous Systems in IIoT10.1109/JIOT.2020.2999510 ↗
14. A Review on the Research Growth of Industry 4.0: IIoT Business Architectures Benchmarking
15. Khan, M., Wu, X., Xu, X., and Dou, W. (2017, January 21–25). Big data challenges and opportunities in the hype of Industry 4.0. Proceedings of the 2017 IEEE International Conference on Communications (ICC), Paris, France.10.1109/ICC.2017.7996801 ↗
16. The Challenges of Integrating Industry 4.0 in Cyber Security—A Perspective
17. Data science applications for predictive maintenance and materials science in context to Industry 4.010.1016/j.matpr.2021.01.357 ↗
18. Jagtap, S., Bader, F., Garcia-Garcia, G., Trollman, H., Fadiji, T., and Salonitis, K. (2020). Food Logistics 4.0: Opportunities and Challenges. Logistics, 5.10.3390/logistics5010002 ↗
19. Sedkaoui, S., and Khelfaoui, M. (2020, January 6–7). Industry 4.0 and knowledge management practices. Volto Já–Senior Exchange Program: From Idea To Implementation. Proceedings of the International Conference on Management Technology and Tourism, ICOMTT, Santarém, Portugal.
20. IoT in Supply Chain Management: Opportunities and Challenges for Businesses in Early Industry 4.0 Context
21. Multistage implementation framework for smart supply chain management under industry 4.010.1016/j.techfore.2020.120354 ↗
22. Andrade, T., and Bastos, D. (2019, January 12–14). Extended reality in iot scenarios: Concepts, applications and future trends. Proceedings of the 2019 5th Experiment International Conference (Exp. at’19), Funchal, Portugal.10.1109/EXPAT.2019.8876559 ↗
23. Chuah, S.H.-W. (2021, August 28). Why and who will adopt extended reality technology? Literature review, synthesis, and future research agenda. Literature Review, Synthesis, and Future Research Agenda (13 December 2018), 2018. Available online: https://ssrn.com/abstract=3300469 or http://dx.doi.org/10.2139/ssrn.3300469.10.2139/ssrn.3300469 ↗
24. A Framework for Extended Reality System Development in Manufacturing10.1109/ACCESS.2021.3056752 ↗
25. Multimodal Machine Learning: A Survey and Taxonomy10.1109/TPAMI.2018.2798607 ↗
26. A review of affective computing: From unimodal analysis to multimodal fusion10.1016/j.inffus.2017.02.003 ↗
27. Multimodal big data affective analytics: A comprehensive survey using text, audio, visual and physiological signals10.1016/j.jnca.2019.102447 ↗
28. Keele, S. (2007). Guidelines for Performing Systematic Literature Reviews in Software Engineering, EBSE. Technical Report, Ver. 2.3 EBSE Technical Report.
29. Wang, D., Miwa, T., and Morikawa, T. (2020). Big Trajectory Data Mining: A Survey of Methods, Applications, and Services. Sensors, 20.10.3390/s20164571 ↗
30. Preliminary Guidelines for Empirical Research in Software Engineering10.1109/TSE.2002.1027796 ↗
31. Big Health Data and Cardiovascular Diseases: A Challenge for Research, an Opportunity for Clinical Care10.3389/fmed.2019.00036 ↗
32. Big data analytics: Challenges and applications for text, audio, video, and social media data
33. Ali, N., Neagu, D., and Trundle, P. (2018, January 5–7). Classification of Heterogeneous Data Based on Data Type Impact on Similarity. Proceedings of the UK Workshop on Computational Intelligence, Nottingham, UK.10.1007/978-3-319-97982-3_21 ↗
34. Critical analysis of Big Data challenges and analytical methods10.1016/j.jbusres.2016.08.001 ↗
35. Jaybal, Y., Ramanathan, C., and Rajagopalan, S. (2018, January 11–13). Hdsanalytics: A data analytics framework for heterogeneous data sources. Proceedings of the ACM India Joint International Conference on Data Science and Management of Data, Goa, India.10.1145/3152494.3152516 ↗
36. Deep EHR: A Survey of Recent Advances in Deep Learning Techniques for Electronic Health Record (EHR) Analysis10.1109/JBHI.2017.2767063 ↗
37. A Survey on Deep Learning in Big Data
38. Kalra, M., and Lal, N. (2016, January 18–19). Data mining of heterogeneous data with research challenges. Proceedings of the 2016 Symposium on Colossal Data Analysis and Networking (CDAN), Indore, India.10.1109/CDAN.2016.7570899 ↗
39. Emergence of Unstructured Data and Scope of Big Data in Indian Education
40. Ismail, A., Shehab, A., and El-Henawy, I.M. (2019). Healthcare Analysis in Smart Big Data Analytics: Reviews, Challenges and Recommendations. Security in Smart Cities: Models, Applications, and Challenges, Springer.10.1007/978-3-030-01560-2_2 ↗
41. Heterogeneous Model Integration for Multi-Source Urban Infrastructure Data
42. Semantic-based Approach for Solving the Heterogeneity of Clinical Data
43. Danyaro, K.U., and Liew, M.S. (2017). A Proposed Methodology for Integrating Oil and Gas Data Using Semantic Big Data Technology. International Conference of Reliable Information and Communication Technology, Springer.10.1007/978-3-319-59427-9_4 ↗
44. Sambrekar, K., Rajpurohit, V.S., and Joshi, J. (2018, January 16–18). A Proposed Technique for Conversion of Unstructured Agro-Data to Semi-Structured or Structured Data. Proceedings of the 2018 Fourth International Conference on Computing Communication Control and Automation (ICCUBEA), Pune, India.10.1109/ICCUBEA.2018.8697432 ↗
45. A survey towards an integration of big data analytics to big insights for value-creation10.1016/j.ipm.2018.01.010 ↗
46. Li, C., Chai, W., and Chen, L. (2015, January 15–16). An Integration Model of Multi-Source Heterogeneous Audit Data. Proceedings of the 2015 International Conference on Electronic Science and Automation Control, Zhengzhou, China.10.2991/esac-15.2015.64 ↗
47. An Interactive Visualization Tool for HL7 FHIR Specification Browsing and Profiling10.1007/s41666-018-0043-8 ↗
48. Lopes, P., Bastiao, L., and Oliveira, J.L. (2015, January 19–21). i2x: An Automated Real-Time Integration and Interoperability Platform (Short Paper). Proceedings of the 2015 IEEE 8th International Conference on Service-Oriented Computing and Applications (SOCA), Rome, Italy.10.1109/SOCA.2015.16 ↗
49. Autism spectrum disorder detection from semi-structured and unstructured medical data10.1186/s13637-017-0057-1 ↗
50. Big Data and data science: A critical review of issues for educational research10.1111/bjet.12595 ↗
51. Big data for online learning systems10.1007/s10639-018-9741-3 ↗
52. Big Data Harmonization–Challenges and Applications
53. Alguliyev, R.M., Aliguliyev, R.M., and Hajirahimova, M. (2016, January 12–14). Big data integration architectural concepts for oil and gas industry. Proceedings of the 2016 IEEE 10th International Conference on Application of Information and Communication Technologies (AICT), Baku, Azerbaijan.10.1109/ICAICT.2016.7991832 ↗
54. Big Data Analytics for Disparate Data
55. Souza, A., Pereira, J., Oliveira, J., Trindade, C., Cavalcante, E., Cacho, N., Batista, T., and Lopes, F. (2017, January 14–17). A data integration approach for smart cities: The case of natal. Proceedings of the 2017 International Smart Cities Conference (ISC2), Wuxi, China.10.1109/ISC2.2017.8090820 ↗
56. Data integration of structured and unstructured sources for assigning clinical codes to patient stays10.1093/jamia/ocv115 ↗
57. A data integration platform for patient-centered e-healthcare and clinical decision support10.1016/j.future.2018.07.061 ↗
58. Developing a FHIR-based EHR phenotyping framework: A case study for identification of patients with obesity and multiple comorbidities from discharge summaries10.1016/j.jbi.2019.103310 ↗
59. A computational framework for converting textual clinical diagnostic criteria into the quality data model10.1016/j.jbi.2016.07.016 ↗
60. Integrating Structured and Unstructured EHR Data Using an FHIR-based Type System: A Case Study with Medication Data
61. Chen, Z., Zhong, F., Yuan, X., and Hu, Y. (2016, January 12–14). Framework of integrated big data: A review. Proceedings of the 2016 IEEE International Conference on Big Data Analysis (ICBDA), Hangzhou, China.10.1109/ICBDA.2016.7509815 ↗
62. Generation of open biomedical datasets through ontology-driven transformation and integration processes10.1186/s13326-016-0075-z ↗
63. Implementation of Big Data in Health Information Systems: Sample Approaches in Saudi Hospital
64. Developing a scalable FHIR-based clinical data normalization pipeline for standardizing and integrating unstructured and structured electronic health record data10.1093/jamiaopen/ooz056 ↗
65. Chondrogiannis, E., Andronikou, V., Karanastasis, E., and Varvarigou, T. (March, January 27). A Novel Approach for Clinical Data Harmonization. Proceedings of the 2019 IEEE International Conference on Big Data and Smart Computing (BigComp), Kyoto, Japan.10.1109/BIGCOMP.2019.8679239 ↗
66. An Overview on XML Semantic Disambiguation from Unstructured Text to Semi-Structured Data: Background, Applications, and Ongoing Challenges10.1109/TKDE.2016.2525768 ↗
67. Sanyal, M.K., Bhadra, S.K., and Das, S. (2016). A Conceptual Framework for Big Data Implementation to Handle Large Volume of Complex Data. Information Systems Design and Intelligent Applications, Springer.10.1007/978-81-322-2755-7_47 ↗
68. Adduru, V., Hasan, S.A., Liu, J., Ling, Y., Datla, V.V., Qadir, A., and Farri, O. (2021, August 28). Towards dataset creation and establishing baselines for sentence-level neural clinical paraphrase generation and simplification. In KHD@ IJCAI. Available online: https://www.semanticscholar.org/paper/Towards-Dataset-Creation-And-Establishing-Baselines-Adduru-Hasan/469b714845898aa23c53485ca91bd41aecbe8de3.
69. Clinical text classification research trends: Systematic literature review and open issues10.1016/j.eswa.2018.09.034 ↗
70. MedSTS: A resource for clinical semantic textual similarity10.1007/s10579-018-9431-1 ↗
71. Disease Prediction by Machine Learning Over Big Data from Healthcare Communities10.1109/ACCESS.2017.2694446 ↗
72. Pathak, B., and Lal, N. (2017, January 1–2). Information retrieval from heterogeneous data sets using moderated IDF-cosine similarity in vector space model. Proceedings of the 2017 International Conference on Energy, Communication, Data Analytics and Soft Computing (ICECDS), Chennai, India.10.1109/ICECDS.2017.8390174 ↗
73. Torfi, A., Shirvani, R.A., Keneshloo, Y., Tavvaf, N., and Fox, E.A. (2020). Natural Language Processing Advancements by Deep Learning: A Survey. arXiv.
74. Phrase2Vec: Phrase embedding based on parsing10.1016/j.ins.2019.12.031 ↗
75. Moscatelli, M., Manconi, A., Pessina, M., Fellegara, G., Rampoldi, S., Milanesi, L., Casasco, A., and Gnocchi, M. (2018). An infrastructure for precision medicine through analysis of big data. BMC Bioinform., 19.10.1186/s12859-018-2300-5 ↗
76. Chen, Q., Du, J., Kim, S., Wilbur, W.J., and Lu, Z. (2021, August 28). Combining rich features and deep learning for finding similar sentences in electronic medical records. In Proceedings of the BioCreative/OHNLP Challenge. Available online: https://www.researchgate.net/publication/327402060_Combining_rich_features_and_deep_learning_for_finding_similar_sentences_in_electronic_medical_records.
77. Mahlawi, A.Q., and Sasi, S. (2017, January 20–22). Structured data extraction from emails. Proceedings of the 2017 International Conference on Networks & Advances in Computational Technologies (NetACT), Thiruvananthapuram, India.10.1109/NETACT.2017.8076789 ↗
78. Sarcasm identification in textual data: Systematic review, research challenges and open directions10.1007/s10462-019-09791-8 ↗
79. Allahyari, M., Pouriyeh, S., Assefi, M., Safaei, S., Trippe, E.D., Gutierrez, J.B., and Kochut, K. (2017). A brief survey of text mining: Classification, clustering and extraction techniques. arXiv.
80. Big data preprocessing: Methods and prospects10.1186/s41044-016-0014-0 ↗
81. A comprehensive survey on Indian regional language processing10.1007/s42452-020-2983-x ↗
82. Yin, W., Kann, K., Yu, M., and Schütze, H. (2017). Comparative study of cnn and rnn for natural language processing. arXiv.
83. Exploring n-gram character presentation in bidirectional RNN-CRF for chinese clinical named entity recognition
84. Lopez, M.M., and Kalita, J. (2017). Deep Learning applied to NLP. arXiv.
85. Chai, J., and Li, A. (2019, January 7–10). Deep Learning in Natural Language Processing: A State-of-the-Art Survey. Proceedings of the 2019 International Conference on Machine Learning and Cybernetics (ICMLC), Kobe, Japan.10.1109/ICMLC48188.2019.8949185 ↗
86. Oshikawa, R., Qian, J., and Wang, W.Y. (2018). A survey on natural language processing for fake news detection. arXiv.
87. Recent Trends in Deep Learning Based Natural Language Processing10.1109/MCI.2018.2840738 ↗
88. Natural language processing and recurrent network models for identifying genomic mutation-associated cancer treatment change from patient progress notes10.1093/jamiaopen/ooy061 ↗
89. Jing, K., and Xu, J. (2019). A survey on neural network language models. arXiv.
90. Deep Leaning Architectures and its Applications: A Survey
91. Data science in education: Big data and learning analytics10.1002/cae.21844 ↗
92. Zhang, L., Xie, Y., Xidao, L., and Zhang, X. (2018, January 26–28). Multi-source heterogeneous data fusion. Proceedings of the 2018 International Conference on Artificial Intelligence and Big Data (ICAIBD), Chengdu, China.10.1109/ICAIBD.2018.8396165 ↗
93. The performance of text similarity algorithms
94. Ngiam, J., Khosla, A., Kim, M., Nam, J., Lee, H., and Ng, A.Y. (July, January 28). Multimodal deep learning. Proceedings of the International Conference on Machine Learning (ICML), Bellevue, WA, USA.
95. New Analysis Framework Incorporating Mixed Mutual Information and Scalable Bayesian Networks for Multimodal High Dimensional Genomic and Epigenomic Cancer Data10.3389/fgene.2020.00648 ↗
96. Shirzad, A., Zare, H., and Teimouri, M. (2020, January 29–30). Deep Learning approach for text, image, and GIF multimodal sentiment analysis. Proceedings of the 2020 10th International Conference on Computer and Knowledge Engineering (ICCKE), Mashhad, Iran.10.1109/ICCKE50421.2020.9303676 ↗
97. Sunkara, M., Ronanki, S., Bekal, D., Bodapati, S., and Kirchhoff, K. (2020). Multimodal Semi-Supervised Learning Framework for Punctuation Prediction in Conversational Speech. arXiv.10.21437/Interspeech.2020-3074 ↗
98. Sentiment analysis of social images via hierarchical deep fusion of content and links10.1016/j.asoc.2019.04.010 ↗
99. Multimodal sentiment analysis using hierarchical fusion with context modeling10.1016/j.knosys.2018.07.041 ↗
100. Singhal, S., Shah, R.R., Chakraborty, T., Kumaraguru, P., and Satoh, S. (2019, January 11–13). SpotFake: A Multi-modal Framework for Fake News Detection. Proceedings of the 2019 IEEE Fifth International Conference on Multimedia Big Data (BigMM), Singapore.10.1109/BigMM.2019.00-44 ↗