A classification of semantic conflicts in heterogeneous database systems

Naiman, Channah F.; Ouksel, Aris M.

doi:10.1080/10919399509540248

Cited by 47 publications

(40 citation statements)

References 14 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…Hence the various heterogeneous data sources from which a data integration system fetches data cannot be expected to contain unified schema [13]. Traditionally, semantic conflicts are considered to contain the simplest resolution schemes, provided all of the component database schemas and metadata are available.…”

Section: Semantic Conflictsmentioning

confidence: 99%

Conflict Identification and Resolution in Heterogeneous Datasets: A Comprehensive Survey

Carol¹,

Kumar²

2015

IJCA

View full text Add to dashboard Cite

Data Integration has become the vital necessities of today's interconnected world. Information is scattered everywhere and to retain the strategic advantage, it becomes mandatory for organizations to obtain as much information as possible. Hence combining the scattered data sources to obtain information becomes the only solution. Data integration is posed by several challenges including the basic nature (heterogeneity) of the data. This paper describes the basic elements of a data integration system and emphasizes on the data fusion phase which forms the core functionality of the architecture. The problems occurring during data fusion (conflicts) are discussed and it also provides a comprehensive survey of the techniques used to resolve conflicts. Functionalities lacking in the current system and future research directions are discussed in detail.

show abstract

Section: Semantic Conflictsmentioning

confidence: 99%

Conflict Identification and Resolution in Heterogeneous Datasets: A Comprehensive Survey

Carol¹,

Kumar²

2015

IJCA

View full text Add to dashboard Cite

show abstract

“…There have been a number of studies that identify and catalog various semantic heterogeneities [3,11,16,17]. A subset of the heterogeneities are related to data quality that we address in this paper and can be categorized into two main groups: (1) representational heterogeneity and (2) ontological heterogeneity.…”

Section: Heterogeneous Data Semanticsmentioning

confidence: 99%

Addressing the Challenges of Aggregational and Temporal Ontological Heterogeneity

Zhu

Madnick

2005

SSRN Journal

View full text Add to dashboard Cite

-In this paper, we first identify semantic heterogeneities that, when not resolved, often cause serious data quality problems. We discuss the especially challenging problems of temporal and aggregational ontological heterogeneity, which concerns how complex entities and their relationships are aggregated and reinterpreted over time. Then we illustrate how the COntext INterchange (COIN) technology can be used to capture data semantics and reconcile semantic heterogeneities in a scalable manner, thereby improving data quality.Index Terms -Data Semantics, Semantic Heterogeneity, Aggregation, Temporal, Ontology, Context. I. INTRODUCTIONN our research, we have discovered that many problems arise due to confusion regarding data semantics. To illustrate how complex this can become, consider Fig. 1. This data summarizes the P/E ratio for DaimlerChrysler obtained from four different financial information sources -all obtained on the same day within minutes of each other. Note that the four sources gave radically different values for P/E ratio. are all correct! The issue is, what do you really mean by "P/E ratio" 1 . The answer lies in the multiple interpretations and uses of the term "P/E ratio" in financial circles. The earnings are for the entire year in some sources but in one source are only for the last quarter. Even when earnings are for a full year, are they:-the last 12 months? -the last calendar year? -the last fiscal year? or -the last three historical quarters and the estimated current quarter -a popular usage? Such information, which we call context, is often not explicitly captured in a form that can be used by the query answering system to reconcile semantic differences in data from different sources. Serious consequences can result from not being aware of the differences in contexts and data semantics. Consider a financial trader that used DBC to get P/E ratio information yesterday and got 19.19. Today he used Bloomberg and got 5.57 (low P/E's usually indicate good bargains) -thinking that something wonderful had happened he might decide to buy many shares of DaimlerChrysler today. In fact, nothing had actually changed, except for changing the source that he used. It would be natural for this trader (after possibly losing a significant amount of money due to this decision) to feel that he had encountered a data quality problem.We would argue that what appeared to be a data quality problem is actually a data misinterpretation problem. The data source did not have any "error," the data that it provided was exactly the data that it intended to provideit just did not have the meaning that the receiver expected. In other words, the issue is not what is right or wrong, it is about how data in one context can be used in a different context.Before going any further, it should be noted that if all sources and all receivers of data always had the exact same meanings, this problem would not occur. This is a desirable goal -one frequently sought through 1 Some of these sites even provide a glossary which give...

show abstract

“…Although there are several publications that classify structural heterogeneity into various types of conflicts [5,6,10,11], this paper focuses on four main kinds of such conflicts, as described below.…”

Section: B Structural Heterogeneitymentioning

confidence: 99%

“…Semantic heterogeneity occurs when there is a disagreement about the meaning, interpretation, or intended use of the same or related data [10,11]. Semantic heterogeneity is classified into three types: naming conflicts, scaling conflicts, and property value conflicts.…”

Section: A Semantic Heterogeneitymentioning

confidence: 99%

Ontology Mapping and Rule-Based Inference for Learning Resource Integration

Jetinai¹,

Arch-int²,

Arch-int³

2016

Journal of information and communication convergence engineerin

View full text Add to dashboard Cite

With the increasing demand for interoperability among existing learning resource systems in order to enable the sharing of learning resources, such resources need to be annotated with ontologies that use different metadata standards. These different ontologies must be reconciled through ontology mediation, so as to cope with information heterogeneity problems, such as semantic and structural conflicts. In this paper, we propose an ontology-mapping technique using Semantic Web Rule Language (SWRL) to generate semantic mapping rules that integrate learning resources from different systems and that cope with semantic and structural conflicts. Reasoning rules are defined to support a semantic search for heterogeneous learning resources, which are deduced by rule-based inference. Experimental results demonstrate that the proposed approach enables the integration of learning resources originating from multiple sources and helps users to search across heterogeneous learning resource systems.

show abstract

A classification of semantic conflicts in heterogeneous database systems

Cited by 47 publications

References 14 publications

Conflict Identification and Resolution in Heterogeneous Datasets: A Comprehensive Survey

Conflict Identification and Resolution in Heterogeneous Datasets: A Comprehensive Survey

Addressing the Challenges of Aggregational and Temporal Ontological Heterogeneity

Ontology Mapping and Rule-Based Inference for Learning Resource Integration

Contact Info

Product

Resources

About