Consistent Queries over Databases with Integrity Constraints
Luciano Caroprese (DEIS Universitá della Calabria, Italy), Cristian Molinaro (DEIS Universitá della Calabria, Italy), Irina Trubitsyna (DEIS Universitá della Calabria, Italy) and Ester Zumpano (DEIS Universitá della Calabria, Italy)
Copyright: © 2009
Integrating data from different sources consists of two main steps, the first in which the various relations are merged together, and the second in which some tuples are removed (or inserted) from the resulting database in order to satisfy integrity constraints. There are several ways to integrate databases or possibly distributed information sources, but whatever integration architecture we choose, the heterogeneity of the sources to be integrated causes subtle problems. In particular, the database obtained from the integration process may be inconsistent with respect to integrity constraints, that is, one or more integrity constraints are not satisfied. Integrity constraints represent an important source of information about the real world. They are usually used to define constraints on data (functional dependencies, inclusion dependencies, etc.) and have, nowadays, a wide applicability in several contexts such as semantic query optimization, cooperative query answering, database integration, and view update.