Kniha Cardinality Estimation Techniques in Relational Database Systems Xiaohui Yu

Cardinality Estimation Techniques in Relational Database Systems

Autor: Xiaohui Yu
Jazyk: Angličtina
Vazba: Brožovaná
Dostupnost: Skladem u dodavatele
Odesíláme za 9-15 dnů
1 377
Accurate and efficient cardinality estimation is of critical importance to many database operations....

Informace o knize

Autor
Jazyk
Angličtina
Vazba
Kniha - Brožovaná
Vydáno
2008
Stránek
132
EAN
9783639041880
ISBN
3639041887
Enbook ID
06813782
Hmotnost
186
Rozměry
152 x 229 x 7

Kompletní popis

Accurate and efficient cardinality estimation is of critical importance to many database operations. In this book, we study three cardinality estimation problems in the contexts of query optimization and data cleaning, and propose a set of new techniques to address the challenges arising therein. §§We first consider the problem of estimating the number of distinct value combinations for a set of attributes. We propose an estimator that utilizes the knowledge of marginal distributions of individual attributes, and establish upper and lower bounds on the estimate. §§In the second part of the book, we propose HASE, a hybrid approach to selectivity estimation. We formulate cardinality estimation as a constrained optimization problem, making consistent use of two sources of information (synopsis-based and sampling-based) when they are available. We provide algorithms and reason about the quality of the estimate. §§Finally, we study the problem of cardinality estimation for approximate joins, which are fundamental operations in data cleaning tasks. We propose two sampling-based schemes for estimation, one based on sampling tuples, and the other on sampling tokens.

Mohlo by vás zajímat

Data Analytics

Edward Mize
347
503

Sacrament of Language

Giorgio Agamben
2 102
715

A Sense of Urgency

Doris Ijeoma Basil
391
400
2 763

Business Succession

David G. Komatz
431

Glorious Rivals

Jennifer Lynn Barnes
220

Cfin

Eugene Brigham
3 234

Zákaznicí kteří koupili tuto knihu koupili také

Er oder Ich

Sten Nadolny
256

Dietoterapia

OTILA HORNERO LADRON DE GUEVARA
1 622

CAHIER DE VOYAGE

ROBERTO VALDES MARTINEZ
415
791
1 140