Zum Hauptinhalt springen Zur Suche springen Zur Hauptnavigation springen
Beschreibung
The performance of a query crucially depends on the ability of the query optimizer to choose a good execution plan from a large space of alternatives. With the discovery of algebraic transformation rules and the emergence of new application-specific contexts, extensibility has become a key requirement for query optimizers. This monograph describes extensible query optimizers in detail, focusing on the Volcano/Cascades framework used by several database systems including Microsoft SQL [...] authors explain the need for extensible query optimizer architectures and how the optimizer navigates the search space efficiently. Several important transformations that are commonly used in practice are then discussed. The cost estimation is described as an essential component that the optimizer relies upon to quantitatively compare alternative plans in the search space. The authors also discuss how database systems manage plans over their lifetime as data and workloads change. The monograph concludes with a few open challenges.
The performance of a query crucially depends on the ability of the query optimizer to choose a good execution plan from a large space of alternatives. With the discovery of algebraic transformation rules and the emergence of new application-specific contexts, extensibility has become a key requirement for query optimizers. This monograph describes extensible query optimizers in detail, focusing on the Volcano/Cascades framework used by several database systems including Microsoft SQL [...] authors explain the need for extensible query optimizer architectures and how the optimizer navigates the search space efficiently. Several important transformations that are commonly used in practice are then discussed. The cost estimation is described as an essential component that the optimizer relies upon to quantitatively compare alternative plans in the search space. The authors also discuss how database systems manage plans over their lifetime as data and workloads change. The monograph concludes with a few open challenges.
Details
Erscheinungsjahr: 2024
Genre: Importe, Informatik
Rubrik: Naturwissenschaften & Technik
Medium: Taschenbuch
ISBN-13: 9781638284529
ISBN-10: 1638284520
Sprache: Englisch
Einband: Kartoniert / Broschiert
Autor: Ding, Bailu
Narasayya, Vivek
Chaudhuri, Surajit
Hersteller: Now Publishers Inc
Verantwortliche Person für die EU: Libri GmbH, Europaallee 1, D-36244 Bad Hersfeld, gpsr@libri.de
Maße: 234 x 156 x 13 mm
Von/Mit: Bailu Ding (u. a.)
Erscheinungsdatum: 16.12.2024
Gewicht: 0,363 kg
Artikel-ID: 130808245

Ähnliche Produkte

Taschenbuch