Containment of Conjunctive Queries on Annotated Relations

Loading...
Thumbnail Image
Penn collection
Database Research Group (CIS)
Degree type
Discipline
Subject
database theory
data provenance
query optimization
Databases and Information Systems
Funder
Grant number
License
Copyright date
Distributor
Related resources
Contributor
Abstract

We study containment and equivalence of (unions of) conjunctive queries on relations annotated with elements of a commutative semiring. Such relations and the semantics of positive relational queries on them were introduced in a recent paper as a generalization of set semantics, bag semantics, incomplete databases, and databases annotated with various kinds of provenance information. We obtain positive decidability results and complexity characterizations for databases with lineage, why-provenance, and provenance polynomial annotations, for both conjunctive queries and unions of conjunctive queries. At least one of these results is surprising given that provenance polynomial annotations seem “more expressive” than bag semantics and under the latter, containment of unions of conjunctive queries is known to be undecidable. The decision procedures rely on interesting variations on the notion of containment mappings. We also show that for any positive semiring (a very large class) and conjunctive queries without self-joins, equivalence is the same as isomorphism.

Advisor
Date of presentation
2009-03-23
Conference name
Database Research Group (CIS)
Conference dates
2023-05-17T03:21:50.000
Conference location
Date Range for Data Collection (Start Date)
Date Range for Data Collection (End Date)
Digital Object Identifier
Series name and number
Volume number
Issue number
Publisher
Publisher DOI
Journal Issue
Comments
Postprint version. Copyright ACM, 2009. This is the author's version of the work. It is posted here by permission of ACM for your personal use. Not for redistribution. The definitive version was published in: Containment of Conjunctive Queries on Annotated Relations. Todd Green. Proceedings of the 12th International Conference on Database Theory 2009 (ICDT 2009), March 23–25, 2009, Saint Petersburg, Russia. Publisher URL: http://www.math.spbu.ru/edbticdt/program/icdt/papers/N12148.html
Recommended citation
Collection