Optimization of Nested Queries Using the NF2 Algebra

Zitieren

Dateien zu dieser Ressource

Prüfsumme: MD5:ea358385ab4bebd0a871c3155758c95b

HÖLSCH, Jürgen, Michael GROSSNIKLAUS, Marc H. SCHOLL, 2016. Optimization of Nested Queries Using the NF2 Algebra. 2016 ACM SIGMOD/PODS Conference : International Conference on Management of Data. San Francisco, CA, USA, 26. Jun 2016 - 1. Jul 2016. In: 2016 ACM SIGMOD/PODS Conference. 2016 ACM SIGMOD/PODS Conference : International Conference on Management of Data. San Francisco, CA, USA, 26. Jun 2016 - 1. Jul 2016. New York, NY, USA:ACM

@inproceedings{Holsch2016Optim-33583, title={Optimization of Nested Queries Using the NF2 Algebra}, year={2016}, doi={10.1145/2882903.2915241}, address={New York, NY, USA}, publisher={ACM}, booktitle={2016 ACM SIGMOD/PODS Conference}, author={Hölsch, Jürgen and Grossniklaus, Michael and Scholl, Marc H.} }

Grossniklaus, Michael Scholl, Marc H. A key promise of SQL is that the optimizer will find the most efficient execution plan, regardless of how the query is formulated. In general, query optimizers of modern database systems are able to keep this promise, with the notable exception of nested queries. While several optimization techniques for nested queries have been proposed, their adoption in practice has been limited. In this paper, we argue that the NF<sup>2</sup> (non-first normal form) algebra, which was originally designed to process nested tables, is a better approach to nested query optimization as it fulfills two key requirements. First, the NF<sup>2</sup> algebra can represent all types of nested queries as well as both existing and novel optimization techniques based on its equivalences. Second, performance benefits can be achieved with little changes to existing transformation-based query optimizers as the NF<sup>2</sup> algebra is an extension of the relational algebra. 2016-04-15T06:39:55Z Grossniklaus, Michael Hölsch, Jürgen Hölsch, Jürgen 2016 Scholl, Marc H. 2016-04-15T06:39:55Z Optimization of Nested Queries Using the NF<sup>2</sup> Algebra eng

Dateiabrufe seit 15.04.2016 (Informationen über die Zugriffsstatistik)

Hoelsch_0-326767.pdf 301

Das Dokument erscheint in:

KOPS Suche


Stöbern

Mein Benutzerkonto