Cardinality Estimation Techniques in Relational Database Systems / Nejlevnější knihy
Cardinality Estimation Techniques in Relational Database Systems

Kód: 06813782

Cardinality Estimation Techniques in Relational Database Systems

Autor Xiaohui Yu

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 ... celý popis

1769


Skladem u dodavatele
Odesíláme za 14-18 dnů
Přidat mezi přání

Mohlo by se vám také líbit

Dárkový poukaz: Radost zaručena

Objednat dárkový poukazVíce informací

Více informací o knize Cardinality Estimation Techniques in Relational Database Systems

Nákupem získáte 177 bodů

Anotace knihy

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.

Parametry knihy

Zařazení knihy Knihy v angličtině Computing & information technology Information technology: general issues

1769

Oblíbené z jiného soudku



Osobní odběr Praha, Brno a 12903 dalších

Copyright ©2008-24 nejlevnejsi-knihy.cz Všechna práva vyhrazenaSoukromíCookies


Můj účet: Přihlásit se
Všechny knihy světa na jednom místě. Navíc za skvělé ceny.

Nákupní košík ( prázdný )

Vyzvednutí v Zásilkovně
zdarma nad 1 499 Kč.

Nacházíte se: