Skip to content

Opening book details…

Can I read Proceedings of the twenty-fifth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems - PODS '06 - The containment problem for Real conjunctive queries with inequalities on EtoBox?

Proceedings of the twenty-fifth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems - PODS '06 - The containment problem for Real conjunctive queries with inequalities by Jayram, T. S.; Kolaitis, Phokion G.; Vee, Erik is a scholarly article available to read on EtoBox.

What is Proceedings of the twenty-fifth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems - PODS '06 - The containment problem for Real conjunctive queries with inequalities about?

Query containment is a fundamental algorithmic problem in database query processing and optimization. Under set semantics, the query-containment problem for conjunctive queries has long been known to be NP-complete. In real database systems, however, queries are usually evaluated under bag semantics, not set semantics. In particular, SQL queries are evaluated under bag semantics and return multisets as answers, since duplicates are not eliminated unless explicitly requested. The exact complexity of the query-containment problem for conjunctive queries under bag semantics has been an open problem for more than a decade; in fact, it is not even known whether this problem is decidable.Here, we investigate, under bag semantics, the query-containment problem for conjunctive queries with inequalities. It has been previously shown that, under set semantics, this problem is complete for the second level of the polynomial hierarchy. Our main result asserts that, under bag semantics, the query-containment problem for conjunctive queries with inequalities is undecidable. Actually, we establish the stronger result that this problem is undecidable even if the following two restrictions hold at

Author
Jayram, T. S.; Kolaitis, Phokion G.; Vee, Erik
Publisher
ACM Press
Published
2006
Language
EN

More by Jayram, T. S.; Kolaitis, Phokion G.; Vee, Erik

Browse all works by Jayram, T. S.; Kolaitis, Phokion G.; Vee, Erik