Scalar aggregation in inconsistent databases

Authors:
Marcelo Arenas;Leopoldo Bertossi;Jan Chomicki;Xin He;Vijay Raghavan;Jeremy Spinrad
Affiliations:
Department of Computer Science, University of Toronto, Toronto, Ont., Canada;School of Computer Science, Carleton University, Ottawa, Ont., Canada;Department of Computer Science and Engineering, 201 Bell Hall, University at Buffalo, Buffalo, NY;Department of Computer Science and Engineering, 201 Bell Hall, University at Buffalo, Buffalo, NY;EECS Department, Vanderbilt University;EECS Department, Vanderbilt University
Venue:
Theoretical Computer Science - Database theory
Year:
2003

Citing 19
Cited 47

Incomplete Information in Relational Databases

Journal of the ACM (JACM)
Incomplete object—a data model for design and planning applications

SIGMOD '91 Proceedings of the 1991 ACM SIGMOD international conference on Management of data
Approximating covering and packing problems: set cover, vertex cover, independent set, and related problems

Approximation algorithms for NP-hard problems
Foundations of aggregation constraints

Theoretical Computer Science
Logical approaches to incomplete information: a survey

Logics for databases and information systems
Consistent query answers in inconsistent databases

PODS '99 Proceedings of the eighteenth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Rewriting aggregate queries using views

PODS '99 Proceedings of the eighteenth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Foundations of Databases: The Logical Level

Foundations of Databases: The Logical Level
Computers and Intractability: A Guide to the Theory of NP-Completeness

Computers and Intractability: A Guide to the Theory of NP-Completeness
Programming with non-determinism in deductive databases

Annals of Mathematics and Artificial Intelligence
Evaluating Aggregate Operations Over Imprecise Data

IEEE Transactions on Knowledge and Data Engineering
Flexible Relation: An Approach for Integrating Data from Multiple, Possibly Inconsistent Databases

ICDE '95 Proceedings of the Eleventh International Conference on Data Engineering
DATALOG Queries with Stratified Negation and Choice: from P to DP

ICDT '95 Proceedings of the 5th International Conference on Database Theory
A Logic Programming Approach to the Integration, Repairing and Querying of Inconsistent Databases

Proceedings of the 17th International Conference on Logic Programming
Answering Queries with Aggregation Using Views

VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
Query Answering in Information Systems with Integrity Constraints

Proceedings of the IFIP TC11 Working Group 11.5, First Working Conference on Integrity and Internal Control in Information Systems: Increasing the confidence in Information Systems
Reasoning with Aggregation Constraints

EDBT '96 Proceedings of the 5th International Conference on Extending Database Technology: Advances in Database Technology
Integrating data from possibly inconsistent databases

COOPIS '96 Proceedings of the First IFCIS International Conference on Cooperative Information Systems
The complexity of relational query languages (Extended Abstract)

STOC '82 Proceedings of the fourteenth annual ACM symposium on Theory of computing

Computing consistent query answers using conflict hypergraphs

Proceedings of the thirteenth ACM international conference on Information and knowledge management
Minimal-change integrity maintenance using tuple deletions

Information and Computation
OLAP over uncertain and imprecise data

VLDB '05 Proceedings of the 31st international conference on Very large data bases
Database repairing using updates

ACM Transactions on Database Systems (TODS)
Consistent query answering in databases

ACM SIGMOD Record
OLAP over uncertain and imprecise data

The VLDB Journal — The International Journal on Very Large Data Bases
Efficient aggregation algorithms for probabilistic data

SODA '07 Proceedings of the eighteenth annual ACM-SIAM symposium on Discrete algorithms
OLAP over imprecise data with domain constraints

VLDB '07 Proceedings of the 33rd international conference on Very large data bases
A three-valued semantics for querying and repairing inconsistent databases

Annals of Mathematics and Artificial Intelligence
The complexity and approximation of fixing numerical attributes in databases under integrity constraints

Information Systems
Answering aggregate queries in data exchange

Proceedings of the twenty-seventh ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Dependencies revisited for improving data quality

Proceedings of the twenty-seventh ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Preferred Database Repairs Under Aggregate Constraints

SUM '07 Proceedings of the 1st international conference on Scalable Uncertainty Management
Consistent Query Answering: The First Ten Years

SUM '08 Proceedings of the 2nd international conference on Scalable Uncertainty Management
Estimating and bounding aggregations in databases with referential integrity errors

Proceedings of the ACM 11th international workshop on Data warehousing and OLAP
Aggregate queries over ontologies

Proceedings of the 2nd international workshop on Ontologies and information systems for the semantic web
On approximating optimum repairs for functional dependency violations

Proceedings of the 12th International Conference on Database Theory
Incorporating cardinality constraints and synonym rules into conditional functional dependencies

Information Processing Letters
Consistent query answers in the presence of universal constraints

Information Systems
The trichotomy of HAVING queries on a probabilistic database

The VLDB Journal — The International Journal on Very Large Data Bases
Extended aggregations for databases with referential integrity issues

Data & Knowledge Engineering
Normalization and optimization of schema mappings

Proceedings of the VLDB Endowment
Minimal-change integrity maintenance using tuple deletions

Information and Computation
Querying and repairing inconsistent numerical databases

ACM Transactions on Database Systems (TODS)
Efficient evaluation of HAVING queries on a probabilistic database

DBPL'07 Proceedings of the 11th international conference on Database programming languages
Exploiting conflict structures in inconsistent databases

ADBIS'10 Proceedings of the 14th east European conference on Advances in databases and information systems
Consistent answers to boolean aggregate queries under aggregate constraints

DEXA'10 Proceedings of the 21st international conference on Database and expert systems applications: Part II
Range-consistent answers of aggregate queries under aggregate constraints

SUM'10 Proceedings of the 4th international conference on Scalable uncertainty management
Data cleaning and query answering with matching dependencies and matching functions

Proceedings of the 14th International Conference on Database Theory
On counting database repairs

Proceedings of the 4th International Workshop on Logic in Databases
Normalization and optimization of schema mappings

The VLDB Journal — The International Journal on Very Large Data Bases
Consistent query answering: five easy pieces

ICDT'07 Proceedings of the 11th international conference on Database Theory
Complexity of consistent query answering in databases under cardinality-based and incremental repair semantics

ICDT'07 Proceedings of the 11th international conference on Database Theory
Complexity and approximation of fixing numerical attributes in databases under integrity constraints

DBPL'05 Proceedings of the 10th international conference on Database Programming Languages
Consistent query answers on numerical databases under aggregate constraints

DBPL'05 Proceedings of the 10th international conference on Database Programming Languages
A dichotomy in the complexity of consistent query answering for queries with two atoms

Information Processing Letters
On the computational complexity of minimal-change integrity maintenance in relational databases

Inconsistency Tolerance
Handling inconsistencies in data warehouses

EDBT'04 Proceedings of the 2004 international conference on Current Trends in Database Technology
OLAP query reformulation in peer-to-peer data warehousing

Information Systems
DART: a data acquisition and repairing tool

EDBT'06 Proceedings of the 2006 international conference on Current Trends in Database Technology
Preference-driven querying of inconsistent relational databases

EDBT'06 Proceedings of the 2006 international conference on Current Trends in Database Technology
Uncertainty that counts

FQAS'11 Proceedings of the 9th international conference on Flexible Query Answering Systems
Repair-oriented relational schemas for multidimensional databases

Proceedings of the 15th International Conference on Extending Database Technology
Prioritized repairing and consistent query answering in relational databases

Annals of Mathematics and Artificial Intelligence
A dichotomy in the complexity of counting database repairs

Journal of Computer and System Sciences
Efficient querying of inconsistent databases with binary integer programming

Proceedings of the VLDB Endowment
Policy-based inconsistency management in relational databases

International Journal of Approximate Reasoning

Quantified Score

Hi-index	0.00

Visualization

Abstract

We consider here scalar aggregation queries in databases that may violate a given set of functional dependencies. We define consistent answers to such queries to be greatest-lowest/least-upper bounds on the value of the scalar function across all (minimal) repairs of the database. We show how to compute such answers. We provide a complete characterization of the computational complexity of this problem. We also show how tractability can be improved in several special cases (one involves a novel application of Boyce-Codd Normal Form) and present a practical hybrid query evaluation method.