Ontologies and functional dependencies for data integration and reconciliation

Authors:
Abdelghani Bakhtouchi;Ladjel Bellatreche;Yamine Ait-Ameur
Affiliations:
National High School for Computer Science, Algiers, Algeria;National High School for Computer Science, Algiers, Algeria;LISI/ENSMA, Poitiers University, Futuroscope, France
Venue:
ER'11 Proceedings of the 30th international conference on Advances in conceptual modeling: recent developments and new directions
Year:
2011

Citing 15
Cited 0

Context interchange: new features and formalisms for the intelligent integration of information

ACM Transactions on Information Systems (TOIS)
Foundations of Databases: The Logical Level

Foundations of Databases: The Logical Level
Global Schema Generation Using Formal Ontologies

ER '02 Proceedings of the 21st International Conference on Conceptual Modeling
OBSERVER: An Approach for Query Processing in Global Information Systems based on Interoperation across Pre-existing Ontologies

COOPIS '96 Proceedings of the First IFCIS International Conference on Cooperative Information Systems
Enterprise information integration: successes, challenges and controversies

Proceedings of the 2005 ACM SIGMOD international conference on Management of data
Contribution of ontology-based data modeling to automatic integration of electronic catalogues within engineering databases

Computers in Industry - Special issue: Collaborative environments for concurrent engineering
On Keys and Functional Dependencies as First-Class Citizens in Description Logics

Journal of Automated Reasoning
Dependencies revisited for improving data quality

Proceedings of the twenty-seventh ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Data fusion

ACM Computing Surveys (CSUR)
Combining a Logical and a Numerical Method for Data Reconciliation

Journal on Data Semantics XII
Identification constraints and functional dependencies in description logics

IJCAI'01 Proceedings of the 17th international joint conference on Artificial intelligence - Volume 1
Discovering functional dependencies for multidimensional design

Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
Data fusion: resolving data conflicts for integration

Proceedings of the VLDB Endowment
OntoDB: an ontology-based database for data intensive applications

DASFAA'07 Proceedings of the 12th international conference on Database systems for advanced applications
Answering queries using views in the presence of functional dependencies

BNCOD'05 Proceedings of the 22nd British National conference on Databases: enterprise, Skills and Innovation

Quantified Score

Hi-index	0.00

Visualization

Abstract

Integrating data sources is the key success of business intelligence systems. The exponential growth of autonomous data sources over the Internet and enterprise intranets makes the development of integration solutions more complex. This is due to two main factors: (i) the management of the source heterogeneity and (ii) the reconciliation of query results. To deal with the first factor, several research efforts proposed the use of ontologies to explicit semantic of each source. Two main trends are used to reconcile the query results: (i) the supposition that different entities of sources representing the same concept have the same key - a strong hypothesis that violates the autonomy of sources. (ii) The use of statistical methods which are not usually suitable for sensitive-applications. In this paper, we propose a methodology integrating sources referencing shared domain ontology enriched with functional dependencies (FD) in a mediation architecture. The presence of FD gives more autonomy of sources in choosing their primary keys and facilitates the result reconciliation. Our methodology is validated using dataset of Lehigh University Benchmark.