ConQuer

Efficient Management of Inconsistent Databases

Description:
Although integrity constraints have long been used to maintain data consistency, there are situations in which they may not be enforced or satisfied. ConQuer is a system for efficient and scalable answering of SQL queries on databases that may violate a set of constraints. ConQuer permits users to postulate a set of key constraints together with their
queries. The system rewrites the queries to retrieve all (and only) data that is consistent with respect to the constraints. The rewriting is into SQL, so the rewritten queries can be efficiently optimized and executed by commercial database systems.
People:

Renée J. Miller  (University of Toronto)
Ariel Fuxman  (University of Toronto)
Elham Fazli (University of Toronto)
Diego Fuxman (Universidad Nacional del Sur, Argentina)
Periklis Andritsos  (University of Trento, Italy)

Publications:
  • Ariel Fuxman, Renée J. Miller: Towards Inconsistency Management in Data Integration Systems. Workshop on Information Integration on the Web (IIWeb 2003)
Demos:
We recently showcased the system at the VLDB conference in Trondheim, Norway.
We will demo the system again at IBM CASCON in Toronto from October 17 to October 20.