Sciweavers

735 search results - page 92 / 147
» Query Optimization In Compressed Database Systems
Sort
View
ICDE
2008
IEEE
121views Database» more  ICDE 2008»
14 years 10 months ago
Optimizing Hierarchical Access in OLAP Environment
In Online Analytic Processing (OLAP) deployments, different users, lines of businesses and business units often create adhoc aggregation hierarchies tailor-made for specific report...
Lipyeow Lim, Bishwaranjan Bhattacharjee
SIGMOD
2009
ACM
161views Database» more  SIGMOD 2009»
14 years 9 months ago
Automated SQL tuning through trial and (sometimes) error
SQL tuning--the attempt to improve a poorly-performing execution plan produced by the database query optimizer-is a critical aspect of database performance tuning. Ironically, as ...
Herodotos Herodotou, Shivnath Babu
ICDE
2005
IEEE
183views Database» more  ICDE 2005»
14 years 10 months ago
Adaptive Caching for Continuous Queries
We address the problem of executing continuous multiway join queries in unpredictable and volatile environments. Our query class captures windowed join queries in data stream syst...
Shivnath Babu, Kamesh Munagala, Jennifer Widom, Ra...
PODS
2008
ACM
123views Database» more  PODS 2008»
14 years 9 months ago
Evaluating rank joins with optimal cost
In the rank join problem, we are given a set of relations and a scoring function, and the goal is to return the join results with the top K scores. It is often the case in practic...
Karl Schnaitter, Neoklis Polyzotis
SIGMOD
2007
ACM
170views Database» more  SIGMOD 2007»
14 years 9 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...