Contact
Hoe winkelen bij ons werkt
Bezorging
Winkelgids
Histogram Techniques for Cost Estimation in Query Optimization
A Study in Relational Database Systems
Engels
145 b
Retourneren binnen 30 dagen
Klanten kochten ook
/
Gebonden (harde band)
33.64
€
/
Gebonden (paperback)
40.02
€
Query optimization is an important task of Relational Database Management Systems. A typical query optimizer estimates the cost of various execution plans for a given query, and selects the one with the lowest cost. The accuracy of cost estimation is crucial in that it directly affects the quality of the decisions made by query optimizers. Seletivity estimation is an important part of cost estimation. Many commercial DBMSs maintain histograms to summarize the contents of relations in order to perform efficient selectivity estimations. In this book, we review the various existing histogram techniques, and propose two new types of histograms: the piecewise linear histogram and the A- Optimal histogram. Experiements show that they perform better than existing histogram in many cases. We also consider the problem of building global histograms. By adaptively allocate the given storage space to individual histograms according to their skewness, we can reduce the overall estimation error. Finally, we address the dynamic maintenance of histograms, and propose an efficient maintenance method for the piecewise linear histogram based on the probabilistic counting technique.
Informatie over het boek
Engels
Geef dit boek vandaag nog cadeau
Dat gaat heel eenvoudig
1 Voeg het boek toe aan je winkelwagentje en selecteer Als cadeau bezorgen 2 Je krijgt van ons per omgaand een voucher 3 Het boek wordt bezorgd op het adres van de ontvangerDit vind je misschien ook interessant
/
Gebonden (harde band)
175.93
€
/
Gebonden (paperback)
49.95
€
/
Gebonden (paperback)
24.41
€
/
Gebonden (harde band)
135.08
€
/
Gebonden (paperback)
10.33
€
/
Gebonden (paperback)
24.11
€
Hoi! Ik ben Libroamiko, je boekadviseur.
Hoe kan ik je helpen?