Simplification of Integrity Constraints for Data Integration

Repairing and Querying Databases with Integrity Constraints

Encyclopedia of Database Technologies and Applications ◽

10.4018/978-1-59140-560-3.ch089 ◽

2005 ◽

pp. 536-541

Author(s):

Sergio Greco ◽

Ester Zumpano

Keyword(s):

Data Integration ◽

Information Sources ◽

Integrity Constraints ◽

Heterogeneous Information ◽

Heterogeneous Information Sources

Data integration aims at providing a uniform integrated access to multiple heterogeneous information sources, which were designed independently for autonomous applications and whose contents are strictly related.

Download Full-text

Data integration under integrity constraints

Information Systems ◽

10.1016/s0306-4379(03)00050-4 ◽

2004 ◽

Vol 29 (2) ◽

pp. 147-163 ◽

Cited By ~ 69

Author(s):

Andrea Calı̀ ◽

Diego Calvanese ◽

Giuseppe De Giacomo ◽

Maurizio Lenzerini

Keyword(s):

Data Integration ◽

Integrity Constraints

Download Full-text

Consistent Queries Over Databases with Integrity Constraints

Encyclopedia of Information Science and Technology, First Edition ◽

10.4018/978-1-59140-553-5.ch093 ◽

2005 ◽

pp. 529-534

Author(s):

Sergio Greco ◽

Ester Zumpano

Keyword(s):

Data Integration ◽

Information Sources ◽

Integrity Constraints ◽

Heterogeneous Information ◽

Heterogeneous Information Sources

The aim of data integration is to provide a uniform integrated access to multiple heterogeneous information sources, which were designed independently for autonomous applications and whose contents are strictly related.

Download Full-text

DIS@DIS: a system for semantic data integration under integrity constraints

Proceedings of the Fourth International Conference on Web Information Systems Engineering, 2003. WISE 2003. ◽

10.1109/wise.2003.1254506 ◽

2004 ◽

Author(s):

A. Cali ◽

S. De Nigris ◽

D. Lembo ◽

G. Messineo ◽

R. Rosati ◽

...

Keyword(s):

Data Integration ◽

Integrity Constraints ◽

Semantic Data ◽

Semantic Data Integration

Download Full-text

Merging, Repairing, and Querying Inconsistent Databases

Handbook of Research on Innovations in Database Technologies and Applications ◽

10.4018/978-1-60566-242-8.ch039 ◽

2009 ◽

pp. 358-364

Author(s):

Luciano Caroprese ◽

Ester Zumpano

Keyword(s):

Data Integration ◽

Information Sources ◽

Proper Subset ◽

Data Sources ◽

Integrity Constraints ◽

Heterogeneous Information ◽

Inconsistent Databases ◽

Integration Strategy ◽

Heterogeneous Information Sources ◽

Inconsistent Database

Data integration aims to provide a uniform integrated access to multiple heterogeneous information sources designed independently and having strictly related contents. However, the integrated view, constructed by integrating the information provided by the different data sources by means of a specified integration strategy could potentially contain inconsistent data; that is, it can violate some of the constraints defined on the data. In the presence of an inconsistent integrated database, in other words, a database that does not satisfy some integrity constraints, two possible solutions have been investigated in the literature (Agarwal, Keller, Wiederhold, & Saraswat, 1995; Bry, 1997; Calì, Calvanese, De Giacomo, & Lenzerini, 2002; Dung, 1996; Grant & Subrahmanian, 1995; S. Greco & Zumpano, 2000; Lin & Mendelzon, 1999): repairing the database or computing consistent answers over the inconsistent database. Intuitively, a repair of the database consists of deleting or inserting a minimal number of tuples so that the resulting database is consistent, whereas the computation of the consistent answer consists of selecting the set of certain tuples (i.e., those belonging to all repaired databases) and the set of uncertain tuples (i.e., those belonging to a proper subset of repaired databases).

Download Full-text