Sept. 4, 2006 to Sept. 8, 2006
Andrea Cali , Free University of Bozen-Bolzano, Italy
Diego Calvanese , Free University of Bozen-Bolzano, Italy
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/DEXA.2006.109
Relational data may have access limitations, i.e., relations may require certain attributes to be selected when they are accessed; this happens, for instance, while querying web data sources (wrapped in relational form) or legacy databases. It is known that the evaluation of a conjunctive query under access limitations requires a recursive algorithm that is encoded into a Datalog program. In this paper we consider the problem of optimising query answering in this setting, where the query language is that of conjunctive queries. We review some optimisation techniques for this problem, that aim to reduce the number of accesses to the data in the query plan. Then we argue that checking query containment is necessary in this case for achieving effective query optimisation. Checking containment in the presence of access limitations would amount to check containment of recursive Datalog programs, which is undecidable in general. We show however that, due to the specific form of the Datalog programs resulting from encoding access limitations, the containment problem is indeed decidable. We present a decision procedure, first presented in a paper by the authors and based on chase techniques, and we analyse its computational complexity.
Andrea Cali, Diego Calvanese, "Optimising Query Answering in the Presence of Access Limitations (Position Paper)", DEXA, 2006, 2012 23rd International Workshop on Database and Expert Systems Applications, 2012 23rd International Workshop on Database and Expert Systems Applications 2006, pp. 547-552, doi:10.1109/DEXA.2006.109