Optimal implementation of conjunctive queries in relational data bases

AK Chandra, PM Merlin - Proceedings of the ninth annual ACM …, 1977 - dl.acm.org
We define the class of conjunctive queries in relational data bases, and the generalized join
operator on relations. The generalized join plays an important part in answering conjunctive …

Computable queries for relational data bases (preliminary report)

AK Chandra, D Harel - Proceedings of the eleventh annual ACM …, 1979 - dl.acm.org
The concept of a “reasonable” query in a relational data base is investigated. We provide an
abstract characterization of the class of queries which are computable, and define the …

Relational queries computable in polynomial time

N Immerman - Proceedings of the fourteenth annual ACM symposium …, 1982 - dl.acm.org
Query languages for relational databases have received considerable attention. In 1972
Codd [Cod72] showed that two natural mathematical languages for queries—one algebraic …

Answering conjunctive queries under updates

C Berkholz, J Keppeler, N Schweikardt - proceedings of the 36th ACM …, 2017 - dl.acm.org
We consider the task of enumerating and counting answers to k-ary conjunctive queries
against relational databases that may be updated by inserting or deleting tuples. We exhibit …

Conjunctive-query containment and constraint satisfaction

PG Kolaitis, MY Vardi - Proceedings of the seventeenth ACM SIGACT …, 1998 - dl.acm.org
Abstract 1 Introduction (! orajtlnrtinr-gaerll rontainment is recognized as a fundamonlnl
probhi in database query evaluation and optimization, At the mtx bitnc, constraint satisfaction …

The theory of joins in relational databases

AV Aho, C Beeri, JD Ullman - ACM Transactions on Database Systems …, 1979 - dl.acm.org
Answering queries in a relational database often requires that the natural join of two or more
relations be computed. However, the result of a join may not be what one expects. In this …

On the complexity of bounded-variable queries

MY Vardi - Proceedings of the Fourteenth ACM SIGACT-SIGMOD …, 1995 - dl.acm.org
It is known that the expression complexity and combined complexity of query evaluation in
relational databases are in general exponentially higher than the data complexity of query …

Programming primitives for database languages

AK Chandra - Proceedings of the 8th ACM SIGPLAN-SIGACT …, 1981 - dl.acm.org
This paper examines a number of programming primitives in query languages for relational
databases. The basic framework is a language based on relational algebra, whose …

Optimization properties for classes of conjunctive regular path queries

A Deutsch, V Tannen - International Workshop on Database Programming …, 2001 - Springer
We are interested in the theoretical foundations of the optimization of conjunctive regular
path queries (CRPQs). The basic problem here is deciding query containment both in the …

A recursive algebra and query optimization for nested relations

LS Colby - Proceedings of the 1989 ACM SIGMOD international …, 1989 - dl.acm.org
The nested relational model provides a better way to represent complex objects than the
(flat) relational model, by allowing relations to have relation-valued attributes. A recursive …