Optimality and Scalability in Lattice Histogram Construction

Summary: Dynamic-programming to construct an optimal lattice histogram (LH) under a max-error bound. A scalable greedy method delivers near-optimal accuracy with far lower time/space, applicable to space-bounded problems; experiments on real data show strong performance. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h6779816168783469
Venue: VLDB
Year: 2009
Pagerank: 5.1843659e-05
Overall Rank: 9,396 | 36.85%
DOI: 10.14778/1687627.1687703

Incoming Non-self Citations Over Time

Authors

1. Panagiotis Karras (National University of Singapore)

BibTeX Citation

@article{karras_vldb09,
        title = {{Optimality and Scalability in Lattice Histogram Construction}},
        author = {Karras, Panagiotis},
        journal = {PVLDB},
        series = {{VLDB} '09},
        doi = {10.14778/1687627.1687703},
        url = {https://doi.org/10.14778/1687627.1687703},
        year = {2009}
}

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
12,261	Efficient Haar+ Synopsis Construction for the Maximum Absolute Error Measure	2018	VLDB	4.9769913e-05

Outgoing Citations (Sorted by Pagerank)

Showing 19 of 19 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
37	Improved Histograms for Selectivity Estimation of Range Predicates	1996	SIGMOD	0.0004772731
103	Selectivity Estimation Without the Attribute Value Independence Assumption	1997	VLDB	0.00033884854
119	Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries	1988	SIGMOD	0.0003136296
138	Join Synopses for Approximate Query Answering	1999	SIGMOD	0.00029618887
169	Wavelet-Based Histograms for Selectivity Estimation	1998	SIGMOD	0.00027126333
194	Locally Adaptive Dimensionality Reduction for Indexing Large Time Series Databases	2001	SIGMOD	0.00025637823
222	Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets	1999	SIGMOD	0.00024210103
255	The History of Histograms (abridged)	2003	VLDB	0.00022974524
275	Optimal Histograms with Quality Guarantees	1998	VLDB	0.00022404363
284	Balancing Histogram Optimality and Practicality for Query Result Size Estimation	1995	SIGMOD	0.00022205848
309	Approximate Query Processing Using Wavelets	2000	VLDB	0.00021376597
371	STHoles: A Multidimensional Workload-Aware Histogram	2001	SIGMOD	0.00019822444
448	Histogram-Based Approximation of Set-Valued Query Answers	1999	VLDB	0.00018121533
454	Self-tuning Histograms: Building Histograms Without Looking at Data	1999	SIGMOD	0.00017955913
806	Universality of Serial Histograms	1993	VLDB	0.00013786471
1,743	Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation	1999	VLDB	9.7342409e-05
3,164	REHIST: Relative Error Histogram Construction Algorithms	2004	VLDB	7.5756378e-05
4,272	One-Pass Wavelet Synopses for Maximum-Error Metrics	2005	VLDB	6.6896372e-05
7,517	Compact Histograms for Hierarchical Identifiers	2006	VLDB	5.5025167e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	4,933	Space efficiency in Synopsis construction algorithms	2005	VLDB
2	11,945	Data-Independent Space Partitionings for Summaries	2021	PODS
3	4,463	DigitHist: a Histogram-Based Data Summary with Tight Error Bounds	2017	VLDB
4	3,646	Optimal Histograms for Hierarchical Range Queries (Extended Abstract)	2000	PODS
5	9,997	Multiscale Histograms: Summarizing Topological Relations in Large Spatial Datasets	2003	VLDB
6	743	Dynamic Multidimensional Histograms	2002	SIGMOD
7	275	Optimal Histograms with Quality Guarantees	1998	VLDB
8	1,687	Global Optimization of Histograms	2001	SIGMOD
9	5,535	Fast and Near–Optimal Algorithms for Approximating Distributions by Histograms	2015	PODS
10	5,007	Fast Algorithms For Hierarchical Range Histogram Construction	2002	PODS