advertisement

A Comparison of Five Probabilistic View-Size Estimation Techniques in OLAP

60 %
40 %
advertisement
Information about A Comparison of Five Probabilistic View-Size Estimation Techniques in OLAP
Technology

Published on November 11, 2008

Author: lemire

Source: slideshare.net

Description

A data warehouse cannot materialize all possible views, hence we must estimate quickly, accurately, and reliably the size of views to determine the best candidates for materialization. Many available techniques for view-size estimation make particular statistical assumptions and their error can be large. Comparatively, unassuming probabilistic techniques are slower, but they estimate accurately and reliability very large view sizes using little memory. We compare five unassuming hashing-based view-size estimation techniques including Stochastic Probabilistic Counting and LogLog Probabilistic Counting. Our experiments show that only Generalized Counting, Gibbons-Tirthapura, and Adaptive Counting provide universally tight estimates irrespective of the size of the view; of those, only Adaptive Counting remains constantly fast as we increase the memory budget.
advertisement

Add a comment

Related presentations

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

In this presentation we will describe our experience developing with a highly dyna...

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

Un recorrido por los cambios que nos generará el wearabletech en el futuro

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

Related pages

A Comparison of Five Probabilistic View-Size Estimation ...

A Comparison of Five Probabilistic View-Size Estimation Techniques in OLAP Kamel Aouiche and Daniel Lemire LICEF, Universite du Qu´ ebec´ a Montr` eal´
Read more

[cs/0703058] A Comparison of Five Probabilistic View-Size ...

... Probabilistic View-Size Estimation Techniques ... five unassuming hashing-based view-size estimation techniques including Stochastic ...
Read more

A Comparison of Five Probabilistic View-Size Estimation ...

A Comparison of Five Probabilistic View-Size Estimation Techniques in OLAP [r-libre/200]
Read more

A comparison of five probabilistic view-size estimation ...

... unassuming probabilistic techniques ... view-size estimation techniques in OLAP ... probabilistic view-size estimation techniques ...
Read more

A Comparison of Five Probabilistic View-Size Estimation ...

Title: A Comparison of Five Probabilistic View-Size Estimation Techniques in OLAP: Authors: Aouiche, Kamel; Lemire, Daniel: Publication: eprint arXiv:cs ...
Read more

A comparison of five probabilistic view-size estimation ...

A comparison of five probabilistic view-size ... Many available techniques for view-size estimation make particular ... Keywords OLAP, ...
Read more

A Comparison of Five Probabilistic View-Size Estimation ...

... unassuming probabilistic techniques ... We compare five unassuming hashing-based view-size ... Probabilistic View-Size Estimation Techniques ...
Read more

A comparison of five probabilistic view-size estimation ...

A comparison of five probabilistic view-size estimation techniques in OLAP. ... A comparison of five ... probabilistic view-size estimation techniques ...
Read more

Unassuming view-size estimation techniques (2007) - CiteSeerX

... Unassuming view-size estimation techniques. ... A comparison of five probabilistic view-size ... View-Size Estimation Techniques in OLAP ...
Read more