Complexity of Answering Queries Using Materialized Views

Serge Abiteboul (1) , Olivier Duschka (2)

1 LSV - Laboratoire Spécification et Vérification [Cachan]
2 Stanford University

We study the complexity of the problem of answering queries using materialized views. This problem has attracted a lot of attention recently because of its relevance in data integration. Previous work considered only conjunctive view definitions. We examine the consequences of allowing more expressive view definition languages. The languages we consider for view definitions and user queries are: conjunctive queries with inequality, positive queries, datalog, and first-order logic. We show that the complexity of the problem depends on whether views are assumed to store all the tuples that satisfy the view definition, or only a subset of it. Finally, we apply the results to the view consistency and view self-maintainability problems which arise in data warehousing.

Domaines: Base de données [cs.DB]

Serge Abiteboul, Olivier Duschka. Complexity of Answering Queries Using Materialized Views. 2013. ⟨hal-00802873⟩