Coping with Data Inconsistencies in the Integration of Heterogenous Data Sources

1
Joshua Edem Agomor
Joshua Edem Agomor
2
Meda Saawah Appiah
Meda Saawah Appiah

Send Message

To: Author

Coping with Data Inconsistencies in the Integration of Heterogenous Data Sources

Article Fingerprint

ReserarchID

D48AE

Coping with Data Inconsistencies in the Integration of Heterogenous Data Sources Banner
  • English
  • Afrikaans
  • Albanian
  • Amharic
  • Arabic
  • Armenian
  • Azerbaijani
  • Basque
  • Belarusian
  • Bengali
  • Bosnian
  • Bulgarian
  • Catalan
  • Cebuano
  • Chichewa
  • Chinese (Simplified)
  • Chinese (Traditional)
  • Corsican
  • Croatian
  • Czech
  • Danish
  • Dutch
  • Esperanto
  • Estonian
  • Filipino
  • Finnish
  • French
  • Frisian
  • Galician
  • Georgian
  • German
  • Greek
  • Gujarati
  • Haitian Creole
  • Hausa
  • Hawaiian
  • Hebrew
  • Hindi
  • Hmong
  • Hungarian
  • Icelandic
  • Igbo
  • Indonesian
  • Irish
  • Italian
  • Japanese
  • Javanese
  • Kannada
  • Kazakh
  • Khmer
  • Korean
  • Kurdish (Kurmanji)
  • Kyrgyz
  • Lao
  • Latin
  • Latvian
  • Lithuanian
  • Luxembourgish
  • Macedonian
  • Malagasy
  • Malay
  • Malayalam
  • Maltese
  • Maori
  • Marathi
  • Mongolian
  • Myanmar (Burmese)
  • Nepali
  • Norwegian
  • Pashto
  • Persian
  • Polish
  • Portuguese
  • Punjabi
  • Romanian
  • Russian
  • Samoan
  • Scots Gaelic
  • Serbian
  • Sesotho
  • Shona
  • Sindhi
  • Sinhala
  • Slovak
  • Slovenian
  • Somali
  • Spanish
  • Sundanese
  • Swahili
  • Swedish
  • Tajik
  • Tamil
  • Telugu
  • Thai
  • Turkish
  • Ukrainian
  • Urdu
  • Uzbek
  • Vietnamese
  • Welsh
  • Xhosa
  • Yiddish
  • Yoruba
  • Zulu

Abstract

This research examines the problem of inconsistent data when integrating information from multiple sources into a unified view. Data inconsistencies undermine the ability to provide meaningful query responses based on the integrated data. The study reviews current techniques for handling inconsistent data including domain-specific data cleaning and declarative methods that provide answers despite integrity violations. A key challenge identified is modeling data consistency and ensuring clean integrated data. Data integration systems based on a global schema must carefully map heterogeneous sources to that schema. However, dependencies in the integrated data can prevent attaining consistency due to issues like conflicting facts from different sources. The research summarizes various proposed approaches for resolving inconsistencies through data cleaning, integrity constraints, and dependency mapping techniques. However, outstanding challenges remain regarding accuracy, availability, timeliness, and other data quality restrictions of autonomous sources.

14 Cites in Articles

References

  1. Pedro Coelho,Aleš Popovič,Jurij Jaklič (2010). The Role of Business Knowledge in Improving Information Quality Provided by Business Intelligence Systems.
  2. J Debattista,C Lange,S Scerri,S Auer (2015). Linked "Big" Data: Towards a Manifold Increase in Big Data Value and Veracity.
  3. Xin Dong,Alon Halevy,Cong Yu (2009). Data integration with uncertainty.
  4. L Haas,E Lin,M Roth (2002). Data integration through database federation.
  5. E Ioannou,S Staworko (2013). Management of Inconsistencies in Data Integration.
  6. Maurizio Lenzerini (2002). Data integration.
  7. Maurizio Lenzerini,V Salaria,I Roma (2014). Data integration.
  8. Mai Pham,Andrijana Rajić,Judy Greig,Jan Sargeant,Andrew Papadopoulos,Scott Mcewen (2014). A scoping review of scoping reviews: advancing the approach and enhancing the consistency.
  9. Bruno Sena,Ana Allian,Elisa Nakagawa (2017). Characterizing big data software architectures.
  10. D Strong,Y Lee,R Wang (1997). Data quality in context.
  11. P Angeles,L Mackinnon,(n.D Detection and Resolution of Data Inconsistencies, and Data Integration using Data Quality Criteria.
  12. Min Chen,David Ebert,Hans Hagen,Robert Laramee,Robert Van Liere,Kwan-Liu Ma,William Ribarsky,Gerik Scheuermann,Deborah Silver (2009). Data, Information, and Knowledge in Visualization.
  13. Y Chen,P Avitabile,J Dodson (2020). Data Consistency Assessment Function (DCAF).
  14. Pedro Coelho,Aleš Popovič,Jurij Jaklič (2010). The Role of Business Knowledge in Improving Information Quality Provided by Business Intelligence Systems.

Funding

No external funding was declared for this work.

Conflict of Interest

The authors declare no conflict of interest.

Ethical Approval

No ethics committee approval was required for this article type.

Data Availability

Not applicable for this article.

How to Cite This Article

Joshua Edem Agomor. 2026. \u201cCoping with Data Inconsistencies in the Integration of Heterogenous Data Sources\u201d. Global Journal of Computer Science and Technology - G: Interdisciplinary GJCST-G Volume 23 (GJCST Volume 23 Issue G2): .

Download Citation

Alt text: A digital illustration depicting data analysis with interconnected data points and graphs.
Journal Specifications

Crossref Journal DOI 10.17406/gjcst

Print ISSN 0975-4350

e-ISSN 0975-4172

Keywords
Classification
GJCST-G Classification: FOR Code: 0806
Version of record

v1.2

Issue date

October 7, 2023

Language

English

Experiance in AR

Explore published articles in an immersive Augmented Reality environment. Our platform converts research papers into interactive 3D books, allowing readers to view and interact with content using AR and VR compatible devices.

Read in 3D

Your published article is automatically converted into a realistic 3D book. Flip through pages and read research papers in a more engaging and interactive format.

Article Matrices
Total Views: 2041
Total Downloads: 18
2026 Trends
Related Research

Published Article

This research examines the problem of inconsistent data when integrating information from multiple sources into a unified view. Data inconsistencies undermine the ability to provide meaningful query responses based on the integrated data. The study reviews current techniques for handling inconsistent data including domain-specific data cleaning and declarative methods that provide answers despite integrity violations. A key challenge identified is modeling data consistency and ensuring clean integrated data. Data integration systems based on a global schema must carefully map heterogeneous sources to that schema. However, dependencies in the integrated data can prevent attaining consistency due to issues like conflicting facts from different sources. The research summarizes various proposed approaches for resolving inconsistencies through data cleaning, integrity constraints, and dependency mapping techniques. However, outstanding challenges remain regarding accuracy, availability, timeliness, and other data quality restrictions of autonomous sources.

Our website is actively being updated, and changes may occur frequently. Please clear your browser cache if needed. For feedback or error reporting, please email [email protected]
×

This Page is Under Development

We are currently updating this article page for a better experience.

Request Access

Please fill out the form below to request access to this research paper. Your request will be reviewed by the editorial or author team.
X

Quote and Order Details

Contact Person

Invoice Address

Notes or Comments

This is the heading

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

High-quality academic research articles on global topics and journals.

Coping with Data Inconsistencies in the Integration of Heterogenous Data Sources

Joshua Edem Agomor
Joshua Edem Agomor
Meda Saawah Appiah
Meda Saawah Appiah

Research Journals