loading
Documents

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Luciano Caroprese ; Sergio Greco and Ester Zumpano

Affiliation: DEIS, Università della Calabria, Italy

ISBN: 978-972-8865-41-2

ISSN: 2184-4992

Keyword(s): Data Integration, Inconsistent Databases, Consistent Query Answers.

Related Ontology Subjects/Areas/Topics: Coupling and Integrating Heterogeneous Data Sources ; Databases and Information Systems Integration ; Enterprise Information Systems

Abstract: In this paper a framework for merging, repairing and querying inconsistent databases is presented. The framework, considers integrity constraints defining primary keys, foreign keys and general functional dependencies. The approach consists of three steps: i) merge of the source databases by means of integration operators or general SQL queries, to reduce the set of tuples coming from the source databases which are inconsistent with respect to the constraints defined by the primary keys, ii) repair of the integrated database by completing and/or cleaning the set of tuples which are inconsistent with respect to the inclusion dependencies (e.g. foreign keys), and iii) compute consistent answers over repaired databases which could be still inconsistent with respect to the functional dependencies. The complexity of merging, repairing and computing consistent answers will be show to be polynomial and a prototype of a system integrating databases and computing queries over possible inconsis tent databases will be presented. (More)

PDF ImageFull Text

Download
CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 3.215.182.81

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
Caroprese L.; Greco S.; Zumpano E. and (2006). MERGING, REPAIRING AND QUERYING INCONSISTENT DATABASES WITH FUNCTIONAL AND INCLUSION DEPENDENCIES.In Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 4: ICEIS, ISBN 978-972-8865-41-2, pages 38-45. DOI: 10.5220/0002458900380045

@conference{iceis06,
author={Luciano Caroprese and Sergio Greco and Ester Zumpano},
title={MERGING, REPAIRING AND QUERYING INCONSISTENT DATABASES WITH FUNCTIONAL AND INCLUSION DEPENDENCIES},
booktitle={Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 4: ICEIS,},
year={2006},
pages={38-45},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002458900380045},
isbn={978-972-8865-41-2},
}

TY - CONF

JO - Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 4: ICEIS,
TI - MERGING, REPAIRING AND QUERYING INCONSISTENT DATABASES WITH FUNCTIONAL AND INCLUSION DEPENDENCIES
SN - 978-972-8865-41-2
AU - Caroprese, L.
AU - Greco, S.
AU - Zumpano, E.
PY - 2006
SP - 38
EP - 45
DO - 10.5220/0002458900380045

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.