Sciweavers

29 search results - page 1 / 6
» On Estimating the Cardinality of Aggregate Views
Sort
View
DMDW
2001
91views Management» more  DMDW 2001»
13 years 8 months ago
On Estimating the Cardinality of Aggregate Views
Accurately estimating the cardinality of aggregate views is crucial for logical and physical design of data warehouses. While the warehouse is under development and data are not a...
Paolo Ciaccia, Matteo Golfarelli, Stefano Rizzi
SIGMOD
2007
ACM
170views Database» more  SIGMOD 2007»
14 years 7 months ago
Cardinality estimation using sample views with quality assurance
Accurate cardinality estimation is critically important to high-quality query optimization. It is well known that conventional cardinality estimation based on histograms or simila...
Per-Åke Larson, Wolfgang Lehner, Jingren Zho...
SEBD
2001
87views Database» more  SEBD 2001»
13 years 8 months ago
Using Domain-Derived Constraints to Bound the Cardinality of Aggregate Views
Paolo Ciaccia, Matteo Golfarelli, Stefano Rizzi
SIGMOD
2007
ACM
150views Database» more  SIGMOD 2007»
14 years 7 months ago
Exploiting self-monitoring sample views for cardinality estimation
Good cardinality estimates are critical for generating good execution plans during query optimization. Complex predicates, correlations between columns, and user-defined functions...
Jingren Zhou, Per-Åke Larson, Peter Zabback,...
CIDR
2007
165views Algorithms» more  CIDR 2007»
13 years 8 months ago
A Black-Box Approach to Query Cardinality Estimation
We present a “black-box” approach to estimating query cardinality that has no knowledge of query execution plans and data distribution, yet provides accurate estimates. It doe...
Tanu Malik, Randal C. Burns, Nitesh V. Chawla